Please help me solve step (e). Thank you!!

1. 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 (Analysis 4pts ). b) Assuming that the firm must maintain an ending cash balance of at least $12,000, how much must they borrow during each month? (Analysis \& Identify and Access Needed Information 8 pts) c) If the firm must pay 5% annual interest on its short-term borrowing, what are the ending cash balances for each month? (Identify and Access Needed Information 4 pts) 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 for each month? (Use Information Effectively to Accomplish a Specific Purpose 4 pts). e) Interpretation: please describe where you obtained information to develop analyses and interpret the results. Please include your written description in the "interpretation" tab. If you do not complete this section with your words or leave the interpretation tab as a blank, ylou receive 0 point in this HW. a) Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 b) Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 c) Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 Cumulative Borrowing \begin{tabular}{l|r} \hline Minimum Cash & 12,000 \\ \hline Annual Interest Rate & 5% \\ \hline Monthly Interest Rate & 0.42% \\ \hline \end{tabular} d) Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 Cumulative Borrowing \begin{tabular}{l|r} \hline Minimum Cash & 12,000 \\ \hline Annual Interest Rate & 5% \\ \hline Monthly Interest Rate & 0.42% \end{tabular}