fill in the empty spots and show the formulas you used to get the answer for each yellow space

G20 A B C D E F G 1 2 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% 3 4 Required 5 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 7 negative values. All other answers should be input and displayed as positive values. 8 Spreadsheet Tips 9 1. Rows 21, 25, 27, 28, 30 to 32, and 34 should be based on formulas. 10 2. Cells C16, D16, C19, and D19 should be based on formulas also. For example, cell C16 should be =834. 3. Explore the power of formulas by copying cells B13:D34 into the scratchpad area below. There you will 11 be able to modify the Desired cash cushion and Interest rate per month (currently in cells B13:814) and see the resulting changes in the cash budget. 12 13 Desired cash cushion 14 Interest rate per month 15 16 Beginning loan balance 17 18 19 Beginning cash balance 20 Add cash receipts 21 Cash available before current financing activity (a) 22 Less disbursements 23 For inventory purchases 24 For selling & administrative expenses 25 Total budgeted disbursements (b) 26 Payments minus receipts 27 Suplus (shortage) Graded Worksheet Statics $ 14,000 2% $ 72,806 October November December $ 12,454 164,000 192,000 230,000 176,454 192,000 230,000 150,800 139,000 162,800 42,000 56,400 58,400 192,800 195,400 221,200