I am looking for a good explanation for this excel worksheet. What does this mean and how it works. more explanation
Conditional Format as Formatting ~ Table ~ Clipboard Font Alignment Number Styles 69 X -G8 C D E FI G H Durango Mountain Bike Tours Cash Bugdet For the Period March toJune 2021 December January February March April May June Part A/ Beginning Cash Balance 10.000 6,738 2,519 4.994 18,494 38,069 6 Collections 18,563 30,881 51,075 81.844 109,688 141,750 Distbursements 21,825 35.100 48,600 68.344 90,113 107,100 Anadjusted Cash Balance 6,738 2,519 4.994 18,494 38,069 72,719 Ending Cash Balance 10000 6,738 2,519 4,994 18.494 38,069 72,719 Part B Beginning Cash balance 10.000 12.000 12,000 14.475 27,975 47,350 13 | collections 18,563 50,881 51,075 81,844 109.688 141,750 Distbursements 21,825 35, 100 48,600 68,344 90,113 107,100 15 Anadjusted Cash Balance 6,738 7,781 14.475 27,975 47,550 82,200 16 Current Borrowing 5,262 4,219 0 0 0 0 Ending Cash Balance 10000 12,000 12,000 14.475 27,975 47.550 82,200 18 Commulative Borrowing (Investing) 5,262 9.481 9.481 9.481 9,481 9.481 19 Commulative Interest Expense 20 Minimum Acceptable Cash 12000Conditional Format Formatting ~ Table - Clipboard Number Styles K27 22 Part C/ 23 Beginning Cash Balance 10000 12000 12000 14435.4045 27895.809 47431.2134 24 Collections 18,563 30,881 51,075 81,844 109,688 141,750 25 Payments 21,825 35,100 48,600 68,344 90,113 107,100 26 Interest 21.93 39.60 39.60 39.60 39.60 27 Total Disbursement 21,825 35,122 48,640 68,384 90,153 107,140 28 |Anadjusted Cash Balance 6,738 7,759 14,435 27,896 47,431 82,042 29 Current Borrowing 5,262 4,241 O 0 0 30 Ending Cash Balance 10000 12,000 12,000 14,435 27,896 47,431 82,042 31 Cumulative Borrowing 5,262 9,503 9,503 9,503 9,503 9,503 32 Minimum Acceptable Cash 12000 33 34 Interest (annual) 5% 35 Interest (monthly) 0.42% 36 37 38 |Part D 39 Beginning Cash Balance 10,000 12,000 12,000 12,000 18,403 40 Collections 37,978 18,563 30,881 51,075 81,844 109,688 141,750 41 Payments 21,825 35,100 48,600 68,344 90,113 107,100 42 Interest 40 29 0 43 Total Disbursement 21,825 35.120 48,640 68,373 90,113 107,100 44 Anadjusted Cash Balance 6,738 14.435 25,471 37,978 72,628 45 Current Borrowing 5,262 4,241 (2,435) (7,068) O 0 46 Ending Cash Balance 10000 12.000 12,000 12,000 18.403 37.978 72,628 47 Cumulative Borrowing 5.262 9.503 7.068 48 Minimum Acceptable Cash 12000 49 50 Interest ( annual) 5.00% 51 Interest (monthly) Cash Budget Scenario Sum mar complex Cash Budget chapter 4 problem 1 Ready Type here to sear O
