Answered step by step
Verified Expert Solution
Question
1 Approved Answer
May I please have guidance on how to calculate a a company's cash budget for the month of June 2020.? In May, 30-day credit sales
May I please have guidance on how to calculate a a company's cash budget for the month of June 2020.?
- In May, 30-day credit sales were $175,000; 80% of this amount is estimated to be collectible in June.
- June sales are estimated to be $425,000; cash sales are usually 25% of total sales. Only 10% of credit sales are collected in the month in which the sale is made.
- Total fixed expenses are $60,000 per month, including $26,000 depreciation. Variable expenses are 55% of sales. All expenses requiring payment are paid in cash when incurred.
- A $40,000 note payable must be paid on June 30. As of May 31, the cash balance is $94,000.
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