i need help with this assignmnet. Thank you

D Spreadsheetvercise: Chapter 4 You love been the task of potting together statement for the ACME Company that he is expected to out of cash the method July 2013 December 2001 You are bore the foldtafe ACME Company 1 Espero w for May through December, tively $300,000, 5290,000, 5435.000, $300,000 $600.000 5625,000, 5650,000 $700.000 2.12% of the month are collected in that on the imar policy of 31 nat 30, o for at mother month's all 37 of the many more in the footh the 41% of the in my heated during the mind went follow the le The speed chamowany the hand on 60% of the > 11 18 6 Themes 100% often material in the followme Wara lalaria ula Monthly law mature of the month aperte The monitly respects to offel 10 RAD especial to be ablated to Apat, laptubes, and Order at the cate 11 of we is the mech 11 During Decembarystore for the following you that 124.000 12 During the month of July through December, the form expect to a mano espoof $15.000, 520,000, 525,000, 530.000, $35.000, and $40.000 respectively 13 Taas be paid in Septh in the amount of 540.000 and in December in the amount of $45,000 14 The beginning balance in My 515.000 15 The target cash balance S15.000 To Do 10 -20 Praparezcathods for 2025 through December 2023 by eating a combinadaprab that Chapter 4 20 21 To Do 25 24 25 20 Prepare a cash bodget for July 2023 through December 2023 by creating a combined spreadsheet that incorporates spreadsheets similar to those in Table 48, 49 and 4:10. Divide your spreadsheet into the sections (1) Total cash recipes (2) Total cash disbursements (3) Cash bodgat covering the period of July through December The cash badat should reflect the following (1) Beginning and ending monthly cash balance (2) The required total financing in each month required (3) The excess cash balance in each month with excel b. Based on your analysis, briefly describe the outlook for this company over the next 6 months. Dies its specific obligations and the funds available to meet them. What could the firm do in the case of a cash defiest? (Where could it get the money) What should the fim de fit has a cash wel? 27 20 29 + 30 01 sa Solution 08 35 96 a. Prepare a cash budget for July 2023 through December 2023 by creating a combined spreadsheet that incorporates spreadhes similar to those in Table 48, 49 and 410 Divide your preadsheet into three actos (1) Total cash receipts (2) Total cash disbursements (3) Cashbudget covering the period of July through December The cash toeget should reflect the following: (1) Beginning and ending monthly cash balance G) The required total financing in each month required # 40 AL Cal Budget July threagh December 2013 May June July A Super Outer Sale Forecast (0) Norber Deres $ 300.00 $ 190,00 126.00 500.00 SGKLOOS Cash Bale 62600 S 5000 500.00 12% S 2005 24.051.00 6.00 7100 75.00 78005 14.00 Lew: Discount 344 $ 2.00 5 SOS 13.755 15,00 11003 18.75 19. 1100 Collections of AR Le moth 754 5217.0 S 1126 537.00 40.00 S 468S 17.05.09 Lad two month 1346 FR26$65.0 73.00 135 COS 91.00 Total Cash Roma 605 09 s S $ $ $ 1 + Tech (of Balm Cash Purchase Payment of AP Lapin month Wap Lease Pays Advertising Expense RAD speler Prepaid in Other Pape TE Total Cash Dish 10041 64 24 3% 1946 1 30.00 S 15.00 52000 52.00 S40.00 15 15.00 1530.00 55.00 S200 36.000.00 S600 36.00 0.00 + 30.033 5 S 3 5 SRODS 5 66.0015 ES $ IS 35.005 109.00 8 IK 00 Cash Det Totalca Receta Le Total Cash Du New Cash Flow A Bilnae Entin Balance Le Cash Balance Red Total Financing (mots payable Ex Cathalana (male) 16.00 $ 16.005 10 15.905 16.00 160015 16.00 ALE D Le Payments Adverspense RADE Prepaid I wance Other pe Tax Total Cush Dabar 29 39 124 G sa S 15.00 5 30.00 $ 2005 $ 30,00 S 04 $ 2400 35.00 S 40.00 S45.00 35,00 $ 109.00 S 25.005 0.00 65.00$ 5 $ 16.00 30.00 55 66 87 50 S $ 5 15.00 5 5 20.00 S 5 66.00 S $ 30.00 $ 35.00 $ 109.03 65 mi 77 Cash Bot Total Cash Recept Les Total Cash Disa New Cashow Ad Benning Balance Ending Balance Les Mini Cash Balance Rad Total Funcing (ots payable) Exo Cash Balance (mark) $ 15.00 > $ 15.00 15.00 165 15,00 S 16.00 $ 1.00 3 7 35 b. Based on your analysis, Brialy describe the outlook for this company on the moth Discuss its specific obligation and the funde available to meet them. What could the fines de in the case of a cah deficit? (Where could it the money What should the form of it has a chap ACME Corporation will need not payable financing in months ACME Corporation will invest in marketable securities is month TT M TA 30 Points 2 Requirements 1 In cell range F46-M46 by wing call referenten to the pive data calate the cables for the month of Alay thrs December Not: Bente alla calle here necency to the copy pude fonction 03