Checks Y$1$ Y$2$ Y$3$ Y$4$

C$1$: NI$-$Dividends$-$Change in RE $=00\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}00$

C$2$: NCF $-$ Change in cash $=00\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}00$

C$3$: A$-($L$+$E$)=0-208\mathrm{.}00-546\mathrm{.}00-1033\mathrm{.}50-1591\mathrm{.}20$

Inputs Y$1$ Y$2$ Y$3$ Y$4$

Sales $78\mathrm{.}00175\mathrm{.}50292\mathrm{.}50343\mathrm{.}20$

Capital expenditures $130\mathrm{.}00162\mathrm{.}50195\mathrm{.}00214\mathrm{.}50$

Depreciation of Year n capex Year n Year n$+1$ Year n$+2$

Book depreciation as $\%$ of Year n capex $33\mathrm{.}33\%33\mathrm{.}33\%33\mathrm{.}34\%$

Tax depreciation as $\%$ of Year n capex $60\mathrm{.}00\%30\mathrm{.}00\%10\mathrm{.}00\%$

Tax rate $25\mathrm{.}00\%25\mathrm{.}00\%25\mathrm{.}00\%25\mathrm{.}00\%25\mathrm{.}00\%$

Income Statement Y$1$ Y$2$ Y$3$ Y$4$

Sales $78\mathrm{.}00175\mathrm{.}50292\mathrm{.}50343\mathrm{.}20$

Depreciation

$=$ EBT $78\mathrm{.}00175\mathrm{.}50292\mathrm{.}50343\mathrm{.}20$

Current tax expense

Deferred tax expense

$=$ Total tax expense $0\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}00$

$=$Net income $78\mathrm{.}00175\mathrm{.}50292\mathrm{.}50343\mathrm{.}20$

Tax Returns Y$1$ Y$2$ Y$3$ Y$4$

Taxable revenues $78\mathrm{.}00175\mathrm{.}50292\mathrm{.}50343\mathrm{.}20$

Tax depreciation

$=$ Taxable income on tax return $78\mathrm{.}00175\mathrm{.}50292\mathrm{.}50343\mathrm{.}20$

Tax bill $19\mathrm{.}5043\mathrm{.}8873\mathrm{.}1385\mathrm{.}80$

Tax basis of the PP&E

Ending Balance Sheet Y$1$ Y$2$ Y$3$ Y$4$

Cash $-208\mathrm{.}00-546\mathrm{.}00-1033\mathrm{.}50-1591\mathrm{.}20$

PP&E$,$ net

Deferred tax liability

Paid$-$in capital $-78\mathrm{.}00-253\mathrm{.}50-546\mathrm{.}00-889\mathrm{.}20$

Retained earnings $78\mathrm{.}00253\mathrm{.}50546\mathrm{.}00889\mathrm{.}20$

Cash$-$Flow Statement Y$1$ Y$2$ Y$3$ Y$4$

$=$ Operating cash flows $0\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}00$

$($Capital expenditures$)-130\mathrm{.}00-162\mathrm{.}50-195\mathrm{.}00-214\mathrm{.}50$

$=$ Investing cash flows $-130\mathrm{.}00-162\mathrm{.}50-195\mathrm{.}00-214\mathrm{.}50$

Contributions $($distributions$)-78\mathrm{.}00-175\mathrm{.}50-292\mathrm{.}50-343\mathrm{.}20$

$=$ Financing cash flow $-78\mathrm{.}00-175\mathrm{.}50-292\mathrm{.}50-343\mathrm{.}20$

$=$ Net cash flow $-208\mathrm{.}00-338\mathrm{.}00-487\mathrm{.}50-557\mathrm{.}70$

Funding computations Y$1$ Y$2$ Y$3$ Y$4$

Assets needed $0\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}00$

Less: Liabilities available $0\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}00$

Less: Retained earnings available $78\mathrm{.}00253\mathrm{.}50546\mathrm{.}00889\mathrm{.}20$

$=$ Paid$-$in capital needed $-78\mathrm{.}00-253\mathrm{.}50-546\mathrm{.}00-889\mathrm{.}20$

Ratios relating to taxes Y$1$ Y$2$ Y$3$ Y$4$

Current tax rate $0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%$

Effective tax rate $0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%$

DTE$/$Total tax expense #DIV$/0!$ #DIV$/0!$ #DIV$/0!$ #DIV$/0!$

DTE$/$Sales $0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%$

DTE$/$Capex $0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%$

DTL$/$Sales $0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%$

DTL$/$Capex $0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%$

DTL$/$Pre$-$tax book income $0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%0\mathrm{.}00\%$

DTL$/$Current tax expense #DIV$/0!$ #DIV$/0!$ #DIV$/0!$ #DIV$/0!$

DTL$/$Book basis of PPE #DIV$/0!$ #DIV$/0!$ #DIV$/0!$ #DIV$/0!$

Tax payable Y$1$ Y$2$ Y$3$ Y$4$

$=$ Ending balance $0\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}00$

B $+$ CTE $-$ Tax paid $=$ E

Tax paid $=$ CTE $-($E $-$ B$)$

Deferred tax liabilities Y$1$ Y$2$ Y$3$ Y$4$

B $+$ DTE $=$ E

DTE $=$ E $-$ B

Looking to solve for the following: For Year $1$

Year $4($FOUR$)$

Income Statement

Depreciation expense

Current tax expense

Deferred tax expense

Tax returns

Tax depreciation

Tax basis

Ending Balance Sheet

PP&E

Deferred tax liabilities

Cash Flow Statement

Operating cash flow