Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please fill out the income statement below? Create pro forma financial statements from the information provided below Year 1 Sales revenues increase 3.5%
Can you please fill out the income statement below?
| Create pro forma financial statements from the information provided below | |||||||||
| Year 1 | |||||||||
| Sales revenues increase 3.5% | |||||||||
| Gross margin is 50% | |||||||||
| SG&A increases 1.2% | |||||||||
| $2000 of PP&E is purchased on January 1, | |||||||||
| New PP&E is depreciated over 10 years | |||||||||
| Inventory grows in line with COGS | |||||||||
| Assume that all other asset accounts grow in line with sales (3.5%). | |||||||||
| Accounts Payable grow in line with COGS | |||||||||
| Accrued and deferred income taxes grows in line with taxes. | |||||||||
| Long-term debt declines by $200 | |||||||||
| Unless otherwise stated, liability accounts grow in line with sales (3.5%) | |||||||||
| Treasury Stock purchases equal $300 | |||||||||
| Average interest cost of all interest bearing debt is 1.6% | |||||||||
| Dividend payout ratio is 22% | |||||||||
| Tax rate is 35% | |||||||||
| Funding requirements should be financed with short-term debt | |||||||||
| Y2 | |||||||||
| Sales revenue decline by 2.0% | |||||||||
| Gross margin declinesto 48% | |||||||||
| Inventory grows in line with COGS | |||||||||
| SG&A declines by 1% | |||||||||
| $800of PP&E is sold on January 1 for $600 cash. (Gross =$800, Accumulated depreciation = $200) | |||||||||
| Annual depreciation expense declines by $ 80 | |||||||||
| Assume that all other asset accounts grow in line with sales. (-2.0%) | |||||||||
| Accounts Payable grow in line with COGS | |||||||||
| Long-term debt declines by $150 | |||||||||
| Accrued and deferred income taxes grows in line with taxes. | |||||||||
| Unless otherwise stated, liability accounts grow in line with sales (-2.0%) | |||||||||
| Treasury Stock purchase is $100. | |||||||||
| Average interest cost of all interest bearing debt is 1.8% | |||||||||
| Dividend payout ratio changes to 25% | |||||||||
| Tax rate is 35% | |||||||||
| Funding requirements should be financed with short-term debt | |||||||||
| Excess cash is used to retire short-term debt | |||||||||
| 100 shares of $1 par value common stock is issued for $300. | |||||||||
| Do not add significant amounts to cash unless Loans & notes payable is drawn down to zero. | |||||||||
| Income Statement | ||||
| Year 0 | Year 1 | Year 2 | ||
| Revenues | 17,000 | |||
| Cost of goods sold | 9,200 | |||
| Gross profit | 7,800 | |||
| SG&A | 4,790 | |||
| Depreciation | 1,700 | |||
| Operating Profit | 1,310 | |||
| Interest expense | 155 | |||
| Income before taxes | 1,155 | |||
| Taxes @35% | 404 | |||
| Net Income | 751 | |||
| Dividends | 225 | |||
| Addition to retained earnings | 526 |
that is all the information from the excel
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
Mein Ultimativer Weihnachts Planer
Authors: Zizo Nimane
1st Edition
B0CM2J8GTG
