You collact $\backslash (40\backslash \%\backslash )$ of sales in the quartar of the sale, and the memainder in the noxt quarter.

You expoct to alwayas spend $\backslash (30\backslash \%\backslash )$ of the curment quartar's sales on purcheses of components from suppliars. You pay $\backslash (80\backslash \%\backslash )$ of purchases in the quarter of the purchase, and the ramainder in the neat quarter.

Wages and other expenses add up to $40$ ss of each quartar's salos.

You have to pay $\backslash (\backslash$$ $6\backslash )$ milion in interest and dividends each quarter. You start the yoar wifh $\backslash (\backslash$$ $5\backslash )$ million in cash.

Part $1$

Add a warksheet "Collections" to the spreadsheet and same rows showing sales $(04$ to $(04),$ beginning moselvabla balances, cumont saics collectod and total osah colactod for O $1$ to $\backslash (\backslash$mathrm$\{$O$4\}\backslash ).$ What is your expectad total cash collection in $($ubure$)$ O$4($in $\backslash (\backslash$$ $\backslash )$ milion$)?$ Corract $\backslash (\backslash$sqrt$\{\}\backslash )$

Tatal cash collected in $\backslash (\backslash$mathrm$\{$O$4\}\backslash )$ will be $\backslash (\backslash$$ $82\mathrm{.}18\backslash )($million$).$

Part $2$

Add a warksheet "Disbursaments" and some rows showing sales $($D$1)$ to Q$1).$ purchases $(\backslash (\backslash$mathbf$\{$D $4\}\backslash )$ to $\backslash (\backslash$mathbf$\{$Q $4\}\backslash )),$ boginning payabis balancos, curment purchases paid, wages is other expenses, intorest and cividends, ospital exponciture and total cash disbursaments for $\backslash (\backslash$mathrm$\{$O$1\}\backslash )$ to $\backslash (\backslash$mathrm$\{$O$4\}\backslash ).$ What is your aupactod total cash disbursamert in $($hiturs$)$ Q $4($in $\backslash (\backslash$$ $\backslash )$ milion$)?$

Part $3$

Add another warkshent to your sproadshost and label it "Cash busgot". Add rows for boginning cosah balance, cosh colloctions, cash disbursaments and anding cash balance for Q$1$ to O$4.$ What is your expectod cash balance at the end of O$4($in $\backslash (\backslash$$ $\backslash )$ millon$)?$