Scenario Summary
R and HR and LB and HB and L
Changing Cells:$C$8
RRBB
$C$9
HLHL
Result Cells:$D$12
$73,660$96,052$56,216$73,738
$D$13
$158,634$189,562$132,531$157,605
$D$14
$69,936$89,015$53,545$68,152
$D$15
$157,537$184,496$132,071$153,573Notes: Current Values column represents values of changing cells atme Scenario Summary Report was created. Changing cells for eachscenario are highlighted in gray.
 
Scenario Summary
R and HR and LB and HB and L
Changing Cells:$C$8
RRBB
$C$9
HLHL
Result Cells:$D$12
$73,660$96,052$56,216$73,738
$D$13
$158,634$189,562$132,531$157,605
$D$14
$69,936$89,015$53,545$68,152
$D$15
$157,537$184,496$132,071$153,573Notes: Current Values column represents values of changing cells atme Scenario Summary Report was created. Changing cells for eachscenario are highlighted in gray.
 
utorial Exercise-Collegetown Thrift Sho
Constants201420152016
Tax RateNA33%35%Loan Amount for Store NA$100,000NA
Inputs201420152016
Economic Outlook (R=NARNAInaon Outlook (H=HiNAHNA
Summary of Key Resu201320142015
Net Income aer Taxes NA$69,974$73,660End-of-year cash on haNA$84,974$158,634Net Income aer TaxesNA$72,601$69,936End-of-year cash on haNA$87,601$157,537
Calculaons (Expansi201420152016
Total Sales Dollars$350,000$455,000$591,500Cost of Goods Sold$245,000$337,610$465,227Cost of Goods Sold (as 70%74%79%Interest Rate for Busin0.05NANA
Calculaons (No Expa201420152016
Total Sales Dollars$350,000$420,000$504,000Cost of Goods Sold$245,000$311,640$396,406Cost of Goods Sold (as 70%74%79%
Income and Cash Flow St
201420152016
Beginning-of-year cashNA$15,000$84,974Sales (Revenue)NA$455,000$591,500Cost of Goods SoldNA$337,610$465,227Business Loan PaymNA-$12,950-$12,950Income before taxesNA$104,440$113,323Income Tax ExpenseNA$34,465$39,663Net Income aer TaNA$69,974$73,660End-of-year Cash on Ha$15,000$84,974$158,634
Income and Cash Flow St
201420152016
Beginning-of-year cashNA$15,000$87,601Sales (Revenue)NA$420,000$504,000Cost of Goods SoldNA$311,640$396,406Income before taxesNA$108,360$107,594Income Tax ExpenseNA$35,759$37,658Net Income aer TaNA$72,601$69,936End-of-year Cash on Ha$15,000$87,601$157,537
A B C D123456789101112131415161718192021222324252627282930313233343536373839404142434445
 
RH
A B C D123456789101112131415161718192021222324252627282930313233343536373839404142434445
of 7