nent-Excel Activity-Cash Budgeting Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2021 and 2022: 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 raw materials: General and administrative salaries are approximately $36,000 a month. Lease payments under long-term leases are $12,000 a month. Depreciation charges are $48,000 a month. Miscellaneous expenses are $1,800 a month. Income tax payments of $55,000 are due in September and December. A progress payment of $185,000 on a ney design studio must be paid in October. Cash on hand on July 1 will be $122,000, and a minimum cash balance of $95,000 should be maintained throughout the cash budget period. The data has been collected in the Microsoft Excel fie below. Download the spreadsheet and perform the required analivis to answer the questions below. Do not round intermediate caiculations. Round your answers to the nearest dollar. If your answer is zero, enter " 0 ". X Downiond soreadsheet Cash Budgeting.9032c4.xis. a. Prepare a monthly cash budget for the last 6 months of 2021. All payments and expenses should be entered as positive numbers. Net cash losses, negative cash balance, negative cumulative cash, and cumulative loans outstanding, if any, hhovid be indicated by a minus eash. and curnulative loans outstandine. if anv. shnuld be indiented bv a minut eien. No calcuiation are required, aithough if you prefec, yeu can ute caiculabens te ilustrate the effects. In a sauation, atiere inhows and outfions arw not synctraniaed buring the menth, A. Waty ta be possitie ta vise a cash budger centeres an the end cf the month. Te make a vala estiente of the peak financing eequiremonta, the certeacer The months preceding peak cales would sho curtent ratio and debt-to-capital ratio due to addabonal short-eeria bank loans. in ehe follawing manths as reckigts are collected from sales, the current reto would and the debt-to-capital ratio would Rbriormal changet in thete raties affect the fimis abdity to obtain bank credic. sensitivity analycis that shows the effects of these two factors on the madmum loin reguiremeet. Enter yeur answers ans positive numbers. To complete the sensitivity analysis, fotiow these steps in excelt * Ensure that cell M60 is a refenence to cell BS. 0,,3567) * Seincthighilight cells A60 through H69 (Aro:ne9) * Fram the top ribbon, select Data > Forecat > Wrat-H-Analrild > Data Table - Foc row input celi click on cele 65 of enter $615. * For column input cell cick on ceil B14 or manuaty eoter 5B514