D22 A B C D E F G 1 Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. a) 3 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 Beginning Cash & & 10,000 & 28,563 & 59,444 & 110,519 & 192,363 & 302,051 \\ \hline Add: Collections & & 18,563 & 30,881 & 51,075 & 81,844 & 109,688 & 141,750 \\ \hline Less: Payments & & 21,825 & 35,100 & 48,600 & 68,344 & 90,113 & 107,100 \\ \hline Unadjusted Cash Balance & & 28,563 & 59,444 & 110,519 & 192,363 & 302,051 & 443,801 \\ \hline Ending Cash Balance & 10,000 & 6,738 & 24,344 & 61,919 & 124,019 & 211,938 & 336,701 \\ \hline b) & & & & & & & \\ \hline \end{tabular} 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 Beginning Cash & & 12,000 & & & & & \\ \hline Add: Collections & & 18,563 & 30,881 & 51,075 & 81,844 & 109,688 & 141,750 \\ \hline Less: Payments & & 21,825 & 35,100 & 48,600 & 68,344 & 90,113 & 107,100 \\ \hline Unadjusted Cash Balance & & 30,563 & & & & & \\ \hline \multicolumn{8}{|l|}{ Add: Borrowing } \\ \hline Ending Cash Balance & 10,000 & & & & & & \\ \hline & & & & & & & \\ \hline Minimum Cash & 12,000 & & & & & & \\ \hline c) & & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular} 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 Ending Cash Balance & 10,000 & & & & & & \\ \hline \end{tabular} Cumulative Borrowing Minimum Cash Annual Interest Rate Monthly Interest Rate d) d)