Pro forma income statements
Not what you're looking for?
Please help with the following problem - provide the solution in Excel.
Company x recently reported the following 2008 income statement in millions of dollars:
sales 700
operating costs including depreciation 500
ebit 200
interest 40
ebt 160
taxes (40%) 64
net income 96
dividends 32
addition to retained earnings 64
This year the company is forecasting a 25% increase in sales; and it expects that its year-end operating costs, including depreciation, will equal 70% of sales. the company's tax rate, interest expense, and dividend payout ratio are all expected to remain constant.
a. what is the company's projected 2009 net income?
b. what is the expected growth rate in the company's dividends?
Purchase this Solution
Solution Summary
This response provides steps to compute the pro forma income statements. The solution is given in an Excel file.
Solution Preview
company x recently reported the following 2008 income statement in millions of dollars:
sales 700
operating costs including depreciation 500
ebit 200
interest ...
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Lean your Process
This quiz will help you understand the basic concepts of Lean.