$8$ HW

Help

Save $\backslash$& Exit

Subi

$\backslash$begin$\{$tabular$\}\{$lrrrr$\}$

& $1$st Quarter & $2$nd Quarter & $3$rd Quarter & $4$th Quarter $\backslash \backslash$

Total cash receipts & $\backslash (\backslash$$ $320,000\backslash )$ & $\backslash (\backslash$$ $440,000\backslash )$ & $\backslash (\backslash$$ $370,000\backslash )$ & $\backslash (\backslash$$ $390,000\backslash )\backslash \backslash$

Total cash disbursements & $\backslash (\backslash$$ $372,000\backslash )$ & $\backslash (\backslash$$ $342,000\backslash )$ & $\backslash (\backslash$$ $332,000\backslash )$ & $\backslash (\backslash$$ $352,000\backslash )$

$\backslash$end$\{$tabular$\}$

The company's beginning cash balance for next year will be $\backslash (\backslash$$ $27,000\backslash ).$ The company requires a minimum cash balance of $\backslash (\backslash$$ $10,000\backslash )$ and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly interest rate of $\backslash (3\backslash \%\backslash ),$ are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded.

Book Required:

Hint

Print

erences

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{10\}\{|$c$|\}\{$Garden Depot$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{10\}\{|$c$|\}\{$Cash Budget$\}\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{2\}\{|$r$|\}\{1$st Quarter$\}$ & $\backslash$multicolumn$\{2\}\{|$r$|\}\{2$nd Quarter$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{3$rd Quarter$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{4$th Quarter$\}$ & Year $\backslash \backslash$

$\backslash$hline Beginning cash balance & $\backslash$$ & $27,000$ & $\backslash$$ & $10,000$ & $\backslash$$ & $10,000$ & $\backslash$$ & $10,000$ & $\backslash \backslash$

$\backslash$hline Total cash receipts & & $320,000$ & & $440,000$ & & $370,000$ & & $390,000$ & $\backslash \backslash$

$\backslash$hline Total cash available & & $347,000$ & & $450,000$ & & $380,000$ & & $400,000$ & $\backslash \backslash$

$\backslash$hline Total cash disbursements & & $372,000$ & & $342,000$ & & $332,000$ & & $352,000$ & $\backslash \backslash$

$\backslash$hline Excess $($deficiency$)$ of cash available over disbursements & & $\backslash ((25,000)\backslash )$ & & $108,000$ & & $48,000$ & & $48,000$ & $\backslash \backslash$

$\backslash$hline Financing: & & & & & & & & & $\backslash \backslash$

$\backslash$hline Borrowings & & $1,050$ & & $1,050$ & & $0$ & & $0$ & $\backslash \backslash$

$\backslash$hline Repayments & & $35,000$ & & $0$ & & $0$ & & $0$ & $\backslash \backslash$

$\backslash$hline Interest & & $0$ & & $35,000$ & & $0$ & & $0$ & $\backslash \backslash$

$\backslash$hline Total financing & & $36,050$ & & $36,050$ & & $0$ & & $0$ & $\backslash \backslash$

$\backslash$hline Ending cash balance & $\backslash$$ & $11,050$ & $\backslash$$ & $144,050$ & $\backslash$$ & $48,000$ & $\backslash$$ & $48,000$ & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$