Rebel Dog Coffee Rebel Dog Coffee Rebel Dog Coffee

Balance Sheet $(000\text{'}$s$)$ Year $1$ Year $2$ Year $3$ Year $4$ Year $5$ Fcst Year $6$ Fcst Income Statement $(000\text{'}$s$)$ Year $1$ Year $2$ Year $3$ Year $4$ Year $5$ Fcst Year $6$ Fcst Ratio Analysis Year $1$ Year $2$ Year $3$ Year $4$ Year $5$ Fcst Year $6$ Fcst

Assets Quick Ratio

$($Current Assets$-$Inventory$)/$Current Liabilities $0\mathrm{.}580\mathrm{.}650\mathrm{.}550\mathrm{.}560\mathrm{.}590\mathrm{.}53$

Current Assets

Cash $125,000120,000105,00095,00097,00097,000$ Sales $275,000288,750308,963339,859373,845411,229$

Accounts Receivable $($Net$)10,5009,4008,00020,0005,00010,000$ Cost of Goods Sold $(192,500)(187,688)(169,929)(186,922)(205,615)(226,176)$ Debt to Equity Ratio

Inventory $25,00028,00020,00038,00040,00038,000$ Gross Profit $82,500101,063139,033152,936168,230185,053$ Total Liabilities$/$Shareholders$\text{'}$ Equity $1\mathrm{.}521\mathrm{.}361\mathrm{.}501\mathrm{.}381\mathrm{.}431\mathrm{.}78$

Prepaid Expenses $15,00012,00010,00017,00025,00015,000$

Total Current Assets $175,500169,400143,000170,000167,000160,000$

Working Capital Ratio

Property, Plant, and Equipment Current Assets$/$Current Liabilities $0\mathrm{.}630\mathrm{.}740\mathrm{.}620\mathrm{.}720\mathrm{.}780\mathrm{.}70$

Land $100,000100,000100,000100,000100,000100,000$ Sales and Marketing Expenses $(37,500)(60,062)(105,533)(97,936)(97,936)(97,936)$

Buildings $250,000250,000250,000250,000250,000250,000$ R&D $(15,000)(20,000)(25,000)(45,000)(45,000)(45,000)$

Machinery $125,000125,000125,000125,000125,000125,000$ Depreciation $(28,910)(28,910)(28,910)11,090(28,910)(28,910)$ Gross Profit Margin

Subtotal $475,000475,000475,000475,000475,000475,000$ Total Expenses $(81,410)(108,972)(159,443)(131,846)(171,846)(171,846)$ Gross Profit$/$Sales $32\mathrm{.}0\%34\mathrm{.}0\%45\mathrm{.}0\%45\mathrm{.}0\%45\mathrm{.}0\%45\mathrm{.}0\%$

Less: Accumulated Depreciation $-$ Land $(10,000)(20,000)(45,000)(18,000)--$ Net Income $1,090(7,910)(20,410)21,090(3,616)13,207$

Less: Accumulated Depreciation $-$ Buildings $(19,230)(25,640)(32,050)(38,460)(44,870)(51,280)$ Earnings per Share $218\mathrm{.}0(1,581\mathrm{.}9)(4,082\mathrm{.}0)4,218\mathrm{.}1(516\mathrm{.}6)1,886\mathrm{.}7$

Less: Accumulated Depreciation $-$ Machinery $(37,500)(50,000)(62,500)(75,000)(86,000)(98,500)$ Net Income$/$Outstanding Shares

Net Property, Plant, and Equipment $408,270379,360335,450343,540344,130325,220$

Leases $-$ Right of Use Asset $----5,000$ Return on Equity Ratio $0\mathrm{.}005(0\mathrm{.}035)(0\mathrm{.}100)0\mathrm{.}094(0\mathrm{.}018)0\mathrm{.}070$

$($Earnings$-$Dividends$)/$Shareholders$\text{'}$ Equity

Total Assets $583,770548,760478,450513,540511,130485,220$ Rebel Dog Coffee

Statement of Cash Flows $-$ Indirect Year $1$ Year $2$ Year $3$ Year $4$ Year $5$ Fcst Year $6$ Fcst

Liabilities and Shareholders' Equity

Operating Activities

Current Liabilities Reconciliation of Net Income to Cash Flow from Operating Activities:

Accounts Payable