Part 1: Forecasting and Seasonal Production Schedule Part 2: Monthly Cash Payments Schedule Part 3: Monthly Cash
Fantastic news! We've Found the answer you've been seeking!
Question:
Part 1: Forecasting and Seasonal Production Schedule
Part 2: Monthly Cash Payments Schedule
Part 3: Monthly Cash Receipts Schedule
Part 4: Monthly Cash Flow
Part 5: Cash Budget
Part 6: Pro Forma Income Statement
Part 7: Cost of Goods Sold Schedule
Part 8: Pro Forma Balance Sheet (March)
Part 9: Explanation of Changes in the Balance Sheet
HINTS: Here are a couple of self-checks for you - that should help you along.
I have provided some key numbers to help you reconcile:
March Pro Forma Balance Sheet
Assets
- Cash
- Accounts Receivable
- Inventory
- Plant & Equip: net plan
- Total Assets = $1,540,000
Liabilities & Stockholders' Equity
- Accounts Payable: $150,000
- Notes Payable
- Longterm debt
- Stockholders' Equity: common stock: 504,200
- Retained Earnings:
- Total Liabilities
Monthly Cash Payments
Rows to be included:
- Units to be produced: Dec = 1,800,000
- Materials from previous month
- Labor ($20 per thousand units)
- Overhead ($10 per thousand units)
- Selling & Admin (20% of sales)
- Interest
- Taxes (40% tax rate)
- Dividends
- Total Payments: Feb = 181,200
Related Book For
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta
Posted Date: