please show all work in excel

Homework for Chapter 4: Problem #3 in the text (Chapter 4) NOTE: PLEASE USE THE ATTACHED EXCEL FILE TITLED "Homework for Chapter 4 Excel TO SOLVE THE FOLLOWING PROBLEM. Active Life Inc., a sports equipment retailer, needs to prepare a cash budget for the first quarter of 2018. The financial staff at Active Life has forecasted the following sales figures: January February March April May STO SI S 000 250.000 $150,000 Actual sales in October, November, and December 2017 were $125,000, S146,000, and $125,000, respectively. Cash sales are 40% of the total, and the rest are on credit. Under the current credit policy the firm expects to collect 60% of eredit sales the following month, 30% two months after, and the remainder in the third month after the sale. Each month, the firm makes inventory purchases cqual to 45% of the of the next month's sales. The firm pays for 40% of its inventory purchases in the same month and 60% in the following month; nevertheless, the firm enjoys a 2% discount if it pays during the same month as the purchase. Estimated disbursements include monthly wages and other expenses representing 25% of the same month's sales; a major capital outlay of $30,000 expected in January, a dividend payment of $25,000 in February: S40,000 of long-term debt maturing in March, and a tax payment of 560,000 in April. The interest rate on its short-term borrowing is 7%. It has a required minimum cash balance of $10,000 every month, and has an ending cash balance of 530,000 for December 2017 a) Using the above information, create a cash budget for January to June 2018. The cash budget should account for short-term borrowing and pay back of outstanding loans. b) Using Excel's outline feature, group the worksheet area at the top of the cash budget so that the preliminary calculations can be easily hidden or unhidden Active Life Ins Cash Budget For the Period January 1 April 2018 November Thermherlan October February March April May Nes Collections Fint Month Second Month Third Moth Total Collections Purchase Poments Durine Month Month Afler Collection Inventory Payments Short-term interesi Wages and other exp. Capital outlay Dividend (Common) Long-term dehi Beginning Cash Balance Nei Addita Cash Unadjusted Cash Balance Add Current Borrowing Andy Car Race Cumulative Borrowing 2.0096 Minimum Cash Balance Discount for Puying in Sumne Month Annual Interest Rate Monthly Interest Rate Total Interest Cost Beginning receivables Beginning pyes