Question
Does the cash budget based on the given parameters provide the firm with the liquidity in needs in meeting operations for the quarter (and why)?
Does the cash budget based on the given parameters provide the firm with the liquidity in needs in meeting operations for the quarter (and why)?
Cash Collections Schedule | |||||||
May | June | July | August | September | |||
Sales | $ 15,000 | $ 16,000 | $ 18,000 | $ 24,000 | $ 28,000 | ||
| |||||||
Cash | 30% | $ 4,500 | $ 4,800 | $ 5,400 | $ 7,200 | $ 8,400 | |
Credit | 70% | $ 10,500 | $ 11,200 | $ 12,600 | $ 16,800 | $ 19,600 | |
A/R Schedule | |||||||
From credit sales | May | June | July | August | September | ||
May | $ 2,100 | $ 7,350 | $ 1,050 | ||||
June | $ 2,240 | $ 7,840 | $ 1,120 | ||||
July | $ 2,520 | $ 8,820 | $ 1,260 | ||||
Aug | $ 3,360 | $ 11,760 | |||||
Sept |
|
|
|
| $ 3,920 | ||
Total Cash Collections | $ 2,100 | $ 9,590 | $ 11,410 | $ 13,300 | $ 16,940 | ||
Cash Sales | $ 4,500 | $ 4,800 | $ 5,400 | $ 7,200 | $ 8,400 | ||
Total Cash Collected | $ 6,600 | $ 14,390 | $ 16,810 | $ 20,500 | $ 25,340 | ||
What is the impact of interest rate changes on the a) the budget as proposed, and b) the CFOs request for higher minimum cash balance?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started