Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The monthly cash budgets for the first quarter of 2016 are shown below ($000 omitted) for XYZ Company. A minimum cash balance of $40,000 is
The monthly cash budgets for the first quarter of 2016 are shown below ($000 omitted) for XYZ Company. A minimum cash balance of $40,000 is required. A line of credit has been established with ABC's bank at a 7.5% interest rate. Calculate the missing amounts:
January | February | March | Q1 Total | ||||||||||||
Cash balance, beginning | $ | 52 | $ | ? | $ | ? | $ | 52 | |||||||
Add collections from customers | ? | 214 | ? | ? | |||||||||||
Total cash available | 188 | ? | 312 | 674 | |||||||||||
Less disbursements: | |||||||||||||||
Purchase of inventory | ? | 120 | 96 | ? | |||||||||||
Operating expenses | 60 | ? | ? | ? | |||||||||||
Capital additions | 68 | 16 | ? | 88 | |||||||||||
Payment of dividends | ? | 18 | |||||||||||||
Total disbursements | ? | 214 | 166 | 608 | |||||||||||
Excess (deficiency) of cash available over disbursements | (40 | ) | ? | 146 | ? | ||||||||||
Borrowings | ? | ? | |||||||||||||
Repayments (including interest) | ? | ? | |||||||||||||
Cash balance, ending | $ | ? | $ | 40 | $ | ? | $ | 65 | |||||||
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