Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Case Study: Question 3: Prepare a Cash Budget for July - October DC's operates on a calendar year basis Credit Sales from Events and Catering
Case Study:
Question 3: Prepare a Cash Budget for July - October
DC's operates on a calendar year basis Credit Sales from Events and Catering are 20% per month Collections are 60% in the month of sale and 40% in the following month Admin & Selling includes $1,000 depreciation expense Prime (direct) wages are 30% of Sales Admin & Sales salaries are $4,350 per month Wages are paid 80% in current month and 20% the following month Purchases of Direct Materials, which are 32% of Sales, are paid 50% in current month and 50% in following month Loan payment of $1,600 is made at the 1st of each month A dividend to the owners of 10% of the ending quarter's Net Income is paid in Jan, Apr, Jul, Oct April - June Net Income before taxes was $50,000 Ending Inventory needs to be 30% of the following month's Direct Materials Cost of Goods Sold Accounts payable for purchases June 30 was $13,600 Beginning Cash Balance June 30 was $175,000 Effective tax rate is 23%. Quarterly estimated taxes are paid the month following the end of the quarterStep 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