Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Provided the income statement below. 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

Provided the income statement below.








Year 0Year 1Year 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


Create pro forma financial statements from the information provided above

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.

Step by Step Solution

3.48 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

To create pro forma financial statements based on the provided information we will calculate the values for each item in the income statement and balance sheet for Year 1 and Year 2 Pro Forma Income S... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Accounting questions