Answered step by step
Verified Expert Solution
Question
1 Approved Answer
7 Budgeted Income Statement Sales Cost of Goods Sold Gross Profit Selling Expenses & Admin. Expenses Net Income {10.01} 8 Cash Budget Assume actual cash
7 | Budgeted Income Statement | |||||||||
Sales | ||||||||||
Cost of Goods Sold | ||||||||||
Gross Profit | ||||||||||
Selling Expenses & Admin. Expenses | ||||||||||
Net Income | {10.01} | |||||||||
8 | Cash Budget | |||||||||
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. 15.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. 86.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, $175,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) | {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 | $ 384,316.80 | {10.05} | ||||||||
Other Manufacturing Costs | ||||||||||
Direct Labor | ||||||||||
Total Manufacturing Overhead | ||||||||||
Selling and Administrative | ||||||||||
Less: Depreciation | $ 2,298.00 | {10.06} | ||||||||
Total Cash Outflows | $ 532,993.25 | {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