Durango Mountain Bike Tours ending cash balance as of December 31, 2022 was $10,000. Its expected cash collections and payments for the next six months are given in the following table.

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?

PLEASE SHOW EXCEL FORMULAS! THANK YOU!

Durango Mountain Bike Tours' ending cash balance as of December 31,2022 was $10,000. Its expected cash collections and payments for the next six months are given in the following table. d) Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2023 to June 2023 \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & December & January & February & March & April & May & June \\ \hline \multicolumn{8}{|l|}{ Beginning Cash } \\ \hline \multicolumn{8}{|l|}{ Add: Collections } \\ \hline \multicolumn{8}{|c|}{ Less: Short-term Interest } \\ \hline \multicolumn{8}{|l|}{ Less: Payments } \\ \hline \multicolumn{8}{|c|}{ Unadjusted Cash Balance } \\ \hline \multicolumn{8}{|l|}{ Add: Borrowing } \\ \hline \multicolumn{8}{|l|}{ Ending Cash Balance } \\ \hline \multicolumn{8}{|l|}{ Cumulative Borrowing } \\ \hline & & & & & & & \\ \hline Minimum Cash & 12,000 & & & & & & \\ \hline Annual Interest Rate & 5% & & & & & & \\ \hline Monthly Interest R & 0.42% & & & & & & \\ \hline \end{tabular}