Need help using excel formula to work this problem! please show math.

Open recovered workbooks? Your recent changes were saved. Do you want to continue wo C3 XV fx A B D E D E 1,500 1,000 1,600 1,400 1,500 1,200 Cash $8,000 107,800 52,800 130,000 3 4 MASTER Student Name => 5 Section Number >> 6 7 A B 8 9 6 Data Section: 10 7 11 8 Actual and Budgeted Unit Sales: 12 9 April 13 10 May 14 11 June 15 12 July 16 13 August 17 14 September 18 15 19 16 Balance Sheet, May 31, 1985 20 17 21 18 Accounts receivable 22 19 Merchandise inventory 23 20 Fixed assets (net) 24 21 25 22 Total assets 26 23 27 24 Accounts payable (merchandise) 28 25 Owner's equity 29 26 30 27 Total liabilities & equity 31 28 32 29 33 30 Average selling price 34 31 Average purchase cost per unit 35 32 Desired ending inventory 36 33 (% of next month's unit sales) 37 34 Collections from customers: 38 35 Collected in month of sale 39 36 Collected in month after sale 40 37 Collected two months after sale 41 38 Projected cash payments: 42 39 Variable expenses 40 Fixed expenses (per month) 44 41 Depreciation per month 45 42 46 43 47 44 Answer Section: 48 45 Sales Budget 49 46 SO 47 $298,600 EEEEEEEE $74,800 223,800 $298,600 SEESEE $98 $55 60% 20% 60% 20% 30% of sales $10,000 $1,000 June July August MASTER + Ready June July August FORMULA1 FORMULAZ Oo 8 50 OUR June July August FORMULA FORMULA OO OO 0 - FORMULAS FORMULAG OO FORMULA 0 0 EEEEEEE FORMULAR $0 $0 EEEEEEE 46 43 47 44 Answer Section: 48 45 Sales Budget 49 46 SO 47 51 48 52 49 Units 53 Dollars 54 51 55 52 Unit Purchases Budget 56 53 57 54 58 55 59 56 Desired ending inventory 60 57 Current month's unit sales 61 58 62 59 Total units needed 63 60 Beginning inventory 64 61 65 62 Purchases (units) 66 63 62 64 Purchases (dollars) 68 65 69 66 70 67 Cash Budget 71 68 72 69 73 70 74 71 Cash balance, beginning 75 72 Cash receipts: 76 73 Collections from customers: 77 74 From April sales 78 75 From May sales 79 76 From June sales 80 77 From July sales 81 78 From August sales 82 79 83 80 Total cash available 84 81 Cash disbursements: 85 82 Merchandise 86 83 Variable expenses 87 84 Fixed expenses BB 85 Interest paid 89 86 90 87 Total disbursements 91 88 92 89 Cash balance before financing 90 Less: Desired ending balance MASTER + July June August N $8,000 $42,760 $142,720 REARN 29,400 58,800 31,360 19,600 94,080 27,440 31,360 82,320 29,400 $127,560 $183,880 $285,800 00 $74,800 FORMULAS 0 41,160 10,000 0 0 $0 44,100 10,000 0 $84,800 $41,160 $54,100 $42.760 $142,720 $231,700 8,000 8,000 8,000 Ready C94 Ax fx B D E G $ $34,760 $134,720 $223,700 - $0 0 $0 0 $0 0 100 $0 $0 $0 102 $42.760 $142,720 $231,700 FORMULA16 FORMULA17 FORMULA18 94 91 95 92 Excess (deficit) of cash over needs 96 93 97 94 Financing 98 95 Borrowing 99 96 Repayment 97 101 98 Total effects of financing 99 103 100 Cash balance, ending 104 101 105 102 106 103 Forecasted Income Statement 107 104 For Quarter Ended August 31, 1935 108 105 109 106 Sales 110 107 Cost of goods sold 111 108 112 109 Gross profit 113 110 114 111 Expenses: 115 112 Variable expenses 116 113 Fixed expenses 117 114 Depreciation expense 118 115 Interest expense 119 116 120 117 Total expenses 121 118 122 119 Net income 123 120 124 121 125 122 Forecasted Balance Sheet 126 123 August 31, 1935 127 124 128 125 Assets: 129 126 Cash 130 127 Accounts receivable 131 128 Merchandise inventory 132 129 Fixed assets (net) 133 130 134 131 Total assets 135 132 136 133 Liabilities & equity 137 134 Accounts payable 138 135 Loans payable 139 136 Owner's equity 140 137 141 138 Total liabilities & equity FORMULA19 FORMULA20 FORMULA21 FORMULA22 $0 $0 HEBBEN FORMULA23 FORMULA24 FORMULA25 FORMULA26 $0 FORMULA27 0 FORMULA28 $0 MASTER +