I need format, please.

Complete the simple cash budget given below by using the assumptions in points 1 and 2. Then answer the questions in point 3. 2 All yellow cells in the model must be filled in USING FORMULAS. The cells cannot contain any typed in numbers 3 4 5 int Calculate the Interest on Short-term Borrowing in tow 39 only after you calculate everything else in the model 6 7 1 40pts Ending cash balance in September was $60,000. Calculate unadjusted cash balance 8 The firm requires miniumah balance of $45,000. Any shortfall in cash will be covered by short-term borrowing 9 Calculate how much the firm needs to borrow every month to assure that the cash balance does not fall below $45,000 10 Calculate ending cash balance in each month 11 2 10pts The firm will be charged 11% annual interest rate on its short-term borrowing Calcutate monthly interest expense, 12 The firm had no short-term borrowing the end of September 13 3 10pts Based on your completed cash budget model, answer the following three questions 14 What is the projected amount of interest that the firm has to pay in the period Oa 2021 to Feb. 2022? 15 How much cash is the company expected to have at the end of February 16 Can the company repay the short-term loan at the end of February? Answer Yes/No and why 17 4 20 pts Conduct a Scenario Analysis which allows the Sales Commission to vary as follows: High -20%, Base -12% and Low 5%. Your objective is Ending Cash Balance in February 18 80pts 19 Sport Equipment, Inc. Forecasted Ending Cash Balance October 2021 through February 2022 09/01/21 10/01/21 11/01/21 given 230,000 240,000 185.000 12/01/21 02/01/22 01/01/22 450.000 03/01/22 270,000 Expected Sales 310,000 310,000 Cash Collections: Cash Sales Credit Sales Total Collections 60.0% 40.0% 144,000 92,000 236,000 111,000 96,000 207.000 186,000 74,000 260,000 270,000 124,000 394,000 186,000 180,000 366,000 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Cash Disbursements: Purchases - all cash Fixed and Admin Wages Bonuses in December and June Sales Commissions Interest on Short-term Borrowing Total Disbursements 70% 45,000 70,000 12% 129,500 45,000 0 217,000 45,000 0 28,800 315.000 45,000 70,000 22,200 217,000 45,000 0 37,200 189,000 45,000 0 54,000 27,600 Beginning Cash Balance +Collections - Disbursements Unadjusted Cash Balance Monthly Short-term Borrowing Ending Cash Balance 60,000 Cumulative Short-term Borrowing (Loan Amount) Minimum Cash Balance 45,000 Interest Ratran Shartem Rewing 11% annually 0