Steps for...

Constants

Tax Rate

Number of Business Days

Inputs

Economic Outlook $(O=$Optimistic,$P=$ Pessimistic$)$

Purchase Price Outlook $(U=Up,D=$Down $)$

Summary of Key Results

Net Income After Taxes

End$-$of$-$Year Cash On Hand

Calculations

Number of units sold in a day

Selling price per unit

Cost of goods sold per unit

Number of units sold in a year

Income Statement and

Cash Flow Statement

Beginning$-$of$-$year cash on hand

Sales $($Revenue$)$

Cost of goods sold

Income before taxes

Income tax expense

Net income after taxes

End$-$of$-$year cash on hand

$\backslash$table$[[$Year $1,$Year $2],[1000,],[$$$7\mathrm{.}00,],[$$$3\mathrm{.}00,],[$NA$,]]$

$\backslash$table$[[$Year $1],[$NA$],[$NA$],[$NA$],[$NA$],[$NA$],[$NA$],[$$$10,000$