I don't know if I'm wrong or right with my numbers. I used the IF formula for "Less: Short-term Interest" and "Add: Borrowing", which changed my "Ending Cash Balance" numbers.

"Less: Short-term Interest" IF formula is =IF(C59>0,C59*$B$63,C59*$B$63)

"Add: Borrowing" IF formula is =IF(C550,-MIN(C59,C55-$B$61),0))

What is the interpretation of this information? How is this company doing?

HW4-1 (20 POINTS) 51075 35100 48600 68344 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. Month Collections Payments January $18563 $21825 February 30881 March April 81844 May 109688 90113 June 141750 107100 a) Calculate the firm's expected ending cash balance for each month (Analysis 4 pts). 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, you receive 0 point in this HW. A B C D E F G H 1 Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. 2 a) 3 Durango Mountain Bike Tours 4 Forecasted Ending Cash Balance 5 January 2020 to June 2020 6 December January February March April May June 7 Beginning Cash $ 10,000 $ 50,388 $ 46,169 $ 48,644 $ 62,144 $ 81,719 8 Add: Collections $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 9 Less: Payments $ 21.825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 10 Unadjusted Cash Balance 6,738 $ 46,169 $ 48,644 $ 62,144 $ 81,719 $ 116,369 11 Ending Cash Balance $ 10,000 $ 50,388 $ 46,169 $ 48,644 $ 62,144 $ 81,719 $ 116,369 12 13 b) 14 Durango Mountain Bike Tours 15 Forecasted Ending Cash Balance 16 January 2020 to June 2020 17 December January February March April May June 18 Beginning Cash $ 10,000 $ 12,000 "$ 12,000 $ 14,475 '$ 27,975 '$ 47,550 19 Add: Collections $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 20 Less: Payments $ 21,825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 21 Unadjusted Cash Balance $ 6,738 $ 7,781 $ 14,475 $ 27,975 $ 47,550 $ 82,200 22 Add: Borrowing $ 5,262 $ 4,219 $ $ $ $ 23 Ending Cash Balance 10,000 $ 12,000 $ 12,000 $ 14,475 $ 27,975 $ 47,550 $ 82,200 24 25 Minimum Cash 12,000 26 27 c) 28 Durango Mountain Bike Tours 29 Forecasted Ending Cash Balance 30 January 2020 to June 2020 31 December January February March April May June 32 Beginning Cash $ 10,000 $ 12,000 $ 12,044 $ 12,116 '$ 25,655 $ 45,269 33 Add: Collections $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 34 Less: Short-term Interest $ $ 22 $ 39 $ 39 $ 39 $ 39 35 Less: Payments $ 21.825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 36 Unadjusted Cash Balance $ 6,738 $ 7.803 $ 14,558 $ 25,655 $ 45,269 $ 79,959 HW4-1 interpretation + C E F G H B 12,000 mmmm Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 December January February March April May June $ 10,000 $ 12,000 $ 12,044 '$ 12,116 '$ 25,655 '$ 45,269 $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 $ $ 22 $ 39 $ 39 $ 39 $ 39 $ 21,825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 $ 6,738 7,803 $ 14,558 25,655 $ 45,269 $ 79,959 $ 5,262 $ 4,241 $ (2,443) $ $ $ $ 10,000.00 $ 12,000 $ 12,044 $ 12,116 $ 25,655 $ 45,269 $ 79,959 $ 5,262 $ 9,459 $ 9,459 $ 9,459 $ 9,459 $ 9,459 12,000 5% 0.42% 25 Minimum Cash 26 27 C) 28 29 30 31 32 Beginning Cash 33 Add: Collections 34 Less: Short-term Interest 35 Less: Payments 36 Unadjusted Cash Balance 37 Add: Borrowing 38 Ending Cash Balance 39 40 Cumulative Borrowing 41 42 Minimum Cash 43 Annual Interest Rate 44 Monthly Interest Rate 45 46 d) 47 48 49 50 51 Beginning Cash 52 Add: Collections 53 Less: Short-term Interest 54 Less: Payments 55 Unadjusted Cash Balance 56 Add: Borrowing 57 Ending Cash Balance 58 59 Cumulative Borrowing 60 61 Minimum Cash 62 Annual Interest Rate 63 Monthly Interest Rate 64 65 66 Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 December January February March April May June 10,000 $ 12,000 $ 12,000 $ 12,000 $ 25,440$ 45,015 $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 $ $ 22 $ 32 $ 60 $ $ $ 21,825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 $ 6,738 $ 7,759 $ 14,443 $ 25,440$ 45,015 $ 79,665 $ 5,262 $ 4,241 $ (2,443) $ $ $ $ 10,000.00 $ 12,000 $ 12,000 $ 12,000 $ 25,440 $ 45,015 $ 79,665 $ 5,262 $ 7,759 $ 14,443 12,000 5% 0.42% HW4-1 (20 POINTS) 51075 35100 48600 68344 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. Month Collections Payments January $18563 $21825 February 30881 March April 81844 May 109688 90113 June 141750 107100 a) Calculate the firm's expected ending cash balance for each month (Analysis 4 pts). 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, you receive 0 point in this HW. A B C D E F G H 1 Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. 2 a) 3 Durango Mountain Bike Tours 4 Forecasted Ending Cash Balance 5 January 2020 to June 2020 6 December January February March April May June 7 Beginning Cash $ 10,000 $ 50,388 $ 46,169 $ 48,644 $ 62,144 $ 81,719 8 Add: Collections $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 9 Less: Payments $ 21.825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 10 Unadjusted Cash Balance 6,738 $ 46,169 $ 48,644 $ 62,144 $ 81,719 $ 116,369 11 Ending Cash Balance $ 10,000 $ 50,388 $ 46,169 $ 48,644 $ 62,144 $ 81,719 $ 116,369 12 13 b) 14 Durango Mountain Bike Tours 15 Forecasted Ending Cash Balance 16 January 2020 to June 2020 17 December January February March April May June 18 Beginning Cash $ 10,000 $ 12,000 "$ 12,000 $ 14,475 '$ 27,975 '$ 47,550 19 Add: Collections $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 20 Less: Payments $ 21,825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 21 Unadjusted Cash Balance $ 6,738 $ 7,781 $ 14,475 $ 27,975 $ 47,550 $ 82,200 22 Add: Borrowing $ 5,262 $ 4,219 $ $ $ $ 23 Ending Cash Balance 10,000 $ 12,000 $ 12,000 $ 14,475 $ 27,975 $ 47,550 $ 82,200 24 25 Minimum Cash 12,000 26 27 c) 28 Durango Mountain Bike Tours 29 Forecasted Ending Cash Balance 30 January 2020 to June 2020 31 December January February March April May June 32 Beginning Cash $ 10,000 $ 12,000 $ 12,044 $ 12,116 '$ 25,655 $ 45,269 33 Add: Collections $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 34 Less: Short-term Interest $ $ 22 $ 39 $ 39 $ 39 $ 39 35 Less: Payments $ 21.825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 36 Unadjusted Cash Balance $ 6,738 $ 7.803 $ 14,558 $ 25,655 $ 45,269 $ 79,959 HW4-1 interpretation + C E F G H B 12,000 mmmm Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 December January February March April May June $ 10,000 $ 12,000 $ 12,044 '$ 12,116 '$ 25,655 '$ 45,269 $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 $ $ 22 $ 39 $ 39 $ 39 $ 39 $ 21,825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 $ 6,738 7,803 $ 14,558 25,655 $ 45,269 $ 79,959 $ 5,262 $ 4,241 $ (2,443) $ $ $ $ 10,000.00 $ 12,000 $ 12,044 $ 12,116 $ 25,655 $ 45,269 $ 79,959 $ 5,262 $ 9,459 $ 9,459 $ 9,459 $ 9,459 $ 9,459 12,000 5% 0.42% 25 Minimum Cash 26 27 C) 28 29 30 31 32 Beginning Cash 33 Add: Collections 34 Less: Short-term Interest 35 Less: Payments 36 Unadjusted Cash Balance 37 Add: Borrowing 38 Ending Cash Balance 39 40 Cumulative Borrowing 41 42 Minimum Cash 43 Annual Interest Rate 44 Monthly Interest Rate 45 46 d) 47 48 49 50 51 Beginning Cash 52 Add: Collections 53 Less: Short-term Interest 54 Less: Payments 55 Unadjusted Cash Balance 56 Add: Borrowing 57 Ending Cash Balance 58 59 Cumulative Borrowing 60 61 Minimum Cash 62 Annual Interest Rate 63 Monthly Interest Rate 64 65 66 Durango Mountain Bike Tours Forecasted Ending Cash Balance January 2020 to June 2020 December January February March April May June 10,000 $ 12,000 $ 12,000 $ 12,000 $ 25,440$ 45,015 $ 18,563 $ 30,881 $ 51,075 $ 81,844 $ 109,688 $ 141,750 $ $ 22 $ 32 $ 60 $ $ $ 21,825 $ 35,100 $ 48,600 $ 68,344 $ 90,113 $ 107,100 $ 6,738 $ 7,759 $ 14,443 $ 25,440$ 45,015 $ 79,665 $ 5,262 $ 4,241 $ (2,443) $ $ $ $ 10,000.00 $ 12,000 $ 12,000 $ 12,000 $ 25,440 $ 45,015 $ 79,665 $ 5,262 $ 7,759 $ 14,443 12,000 5% 0.42%