Answered step by step
Verified Expert Solution
Question
1 Approved Answer
18. Create a Cash Budget for the months April through June with the information given below. Determine the amount of financing required (if any). Sales
18. Create a Cash Budget for the months April through June with the information given below. Determine the amount of financing required (if any). Sales are shown in the table below: February March April May June July Month $10,000 $40,000 $50,000 $75,000 $85,000 $90,000 Sales Sales are 30% cash and 70% credit. Of the credit sales, 50% is collected in the month following the sale, and 50% is collected two months following the sale. Cost of Goods Sold is strictly materials (inventory) and is 55% of sales. All inventory purchases are paid for one month after they are made. The store follows a policy of purchasing inventory one month in advance of sales. A minimum cash balance of $8,000 is desired. Wages from April through June are paid as incurred. The corporate tax rate is 35%. No tax payments are due during this quarter. A $6,000 dividend payment will be made in April. Ending cash for March was $10,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