help!!! please show work

The accountant for Nelly's Dress Shop prepared the fourth quarter 2017 cash budget below. Nelly's has a policy to maintain a minimum cash balance of $14,000 before the interest payment at the end of each month. The shop borrows and repays funds on the first day of the month. The interest rate is 2 percent per month. $14,000 2% Required Complete the spreadsheet below. Be sure to use formulas where possible so that any changes to the estimates will be automatically reflected in the spreadsheet. Note: Negative amounts or amounts to be deducted should be input and displayed as negative values. All other answers should be input and displayed as positive values. Spreadsheet Tips 1. Rows 21,25,27,28,30 to 32 , and 34 should be based on formulas. 2. Cells C16, D16, C19, and D19 should be based on formulas also. For example, cell C16 should be =B34. 3. Explore the power of formulas by copying cells B13:D34 into the scratchpad area below. There you will be able to modify the Desired cash cushion and Interest rate per month (currently in cells B13:B14) and see the resulting changes in the cash budget. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ Desired cash cushion } \\ \hline Interest rate per month & V & & \\ \hline \multirow[t]{2}{*}{ Beginning loan balance } & 72,806 & \multicolumn{2}{|c|}{r} \\ \hline & October & November & December \\ \hline Beginning cash balance & 12,454 & & \\ \hline Add cash receipts & 164,000 & 192,000 & 230,000 \\ \hline \multicolumn{4}{|c|}{ Cash available before current financing activity (a) } \\ \hline \multicolumn{4}{|l|}{ Less disbursements } \\ \hline For inventory purchases & 150,800 & 139,000 & 162,800 \\ \hline For selling \& administrative expenses & 42,000 & 56,400 & 58,400 \\ \hline \multicolumn{4}{|l|}{ Total budgeted disbursements (b) } \\ \hline \multicolumn{4}{|l|}{ Payments minus receipts } \\ \hline Suplus (shortage) & r & & \\ \hline Needed cash cushion & r & & \\ \hline \multicolumn{4}{|l|}{ Financing activity } \\ \hline Borrowing (repayment) (c) & & & \\ \hline Interest expense (d) & r & & \\ \hline \multicolumn{4}{|l|}{ Ending cash balance (ab+cd)} \\ \hline Loan balance & & & \\ \hline \end{tabular}