Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and Payables of 12/31/x1 will have a cash impact in 20x2.) 1.
Assume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and | ||||||||||
Payables of 12/31/x1 will have a cash impact in 20x2.) | ||||||||||
1. 16.00% of sales for the year are made in November and December. Since our customers have 60 day terms | ||||||||||
those funds will be collected be collected in January and February. | ||||||||||
2. 85.00% of material purchases will be paid during the year, the remaining portion will be paid in Januay or February. | ||||||||||
3. All other manufacturing and operating costs are paid for when incurred. | ||||||||||
4. The budgeted depreciation expense is equal to 0.6% of the fixed manufacturing, selling and administrative expenses. | ||||||||||
5. Minimum Cash Balance needed for 20x2, $160,000 . | ||||||||||
I See The Light | ||||||||||
Projected Cash Budget | ||||||||||
For the Year Ending December 31, 20x2 | ||||||||||
Round dollars to two places, $##.## | ||||||||||
Beginning Cash Balance | ||||||||||
Cash Inflows: | ||||||||||
Sales Collections: | ||||||||||
Account Receivable (Sales last year not collected) | $ 67,500.00 | {10.02} | ||||||||
Sales made and collected in 20x2 | {10.03} | |||||||||
Cash Available | {10.04} | |||||||||
Cash Outflows: | ||||||||||
Purchases | ||||||||||
Accounts Payable (Purchases last year) | ||||||||||
Purchases made and paid for in 20x2 | {10.05} | |||||||||
Other Manufacturing Costs | ||||||||||
Direct Labor | ||||||||||
Total Manufacturing Overhead | ||||||||||
Selling and Administrative | ||||||||||
Less: Depreciation | {10.06} | |||||||||
Total Cash Outflows | {10.07} | |||||||||
Budgeted Cash Balance before financing | {10.08} | |||||||||
Needed Minimum Balance | ||||||||||
Amount to be borrowed (if any) | {10.09} | |||||||||
Budgeted Cash Balance | {10.10} | |||||||||
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