huge assignment due soon and need major help, excel sheet is where i the answers, word doc has all the info needed. thank you

the excel information is the last two slides thstcis all that needs to be answered the word document has provided the prompt

Work as part of a team of 2 people to complete this assignment. Hand in one spreadsheet with both names included in your file's name. Due Friday, 3/24. Hand In via D2L assignment folder. Angelina Dunkin, owner of Angelina's Scents, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15\%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus salaries: Estimates regarding payments obtained from the credit department are as rollows: collected within the month of sale, 10\%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus salaries: General and administrative salaries are approximately $27,000 a month. Lease payments under longterm leases are $9,000 a month. Miscellaneous expenses are $2,700 a month. Income tax payments of $63,000 are due in September and December. A progress payment of $180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be $132,000, and a minimum cash balance of $90,000 should be maintained throughout the cash budget period. In Excel, prepare a monthly cash budget for the last 6 months of 2019. Use the Excel template posted on D2L, and Figure 15.1 (p. 542 of your text (10th)) to help you complete the assignment. Hand in your spreadsheet via D2L with both team members' names in the file name. This assignment is due by Friday, 3/24. 23 The Cuht Beder 24 May Jane Jaty Aasest September October November Deermber January 26 Sale (gress) 27 Collatilens 28 Dartag menth of aile 29 During tut moe th ahter sale 30 Durlng 2nd month after sale 31. Total eolinetions 32. Purchase 33 Labor and rew materials 34 Payment for laber and now materials 35