I should also do it with excell formulas

Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to.June 2020 Durango Mountain Bike Tours Forecasted Ending Cash Ehance January 2020 to June 2020 Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 a. Calculate the firm's expected ending cash balance for each month. b. Assuming that the firm must maintain an ending cash balance of at least $12,000, how much must they borrow during each month? c. If the firm must pay 5% annual interest on its short-ferm borrowing, what are the ending cash balances for each month? d. What are the ending cash balances if the firm uses any cash in excess of the minimum to pay off its short-term borrowing in each month? 2. Loblaw A anufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information. Requirement: You will complete most of your weekly assignments using Excel. These assignments will reference the concepts learned from your text, from your chapter PowerPoints, and other videos provided for you to view. Please be sure to review the chapter PowerPoints before beginning your assignments. Topic: Using the information provided in Chapter 4 Problem \#1, complete parts "a" through " d " using the provided Excel template below. Chapter 4 Problem \#1 Student Name Template xis Graded Activity: 1. Read Chapters 3 and 4 of your text. 2. Review the PowerPoint for Chapters 3 and 4 and any related videos provided for the week. 3. Complete Week 2 Assignment: Chapter 4 Problem \#2. Please click on the title link above labeled "Week 2 Assignment: Chapter 4 Problem \#2" to enter and submit your work. Durango Mountain Bike Tours' ending cash balance as of December 31, 2020 was $10,000. Its expected cash collections and payments for the next six months are given in the following table. a. Calculate the firm's expected ending cash balance for each month. b. Assuming that the firm must maintain an ending cash balance of at least $12,000, how much must they borrow during each month? c. If the firm must pay 5% annual interest on its short-term borrowing, what are the ending cash balances for each month? d. What are the ending cash balances if the firm uses any cash in excess of the