Question: Create a pro forma for 2012. Sales growth - 5% EBIT Margin - 55% Depreciation is a 7 year straight line method using 2011 net

Create a pro forma for 2012.

Sales growth - 5% EBIT Margin - 55% Depreciation is a 7 year straight line method using 2011 net fixed assets. Tax Rate 21% Net Fixed assets 65% of 2011 Sales Working capital 8% of 2011 sales Debt ratio 35%.

	2011	2012
Net Fixed Assets	104
Working Capital	12.8
Sales	160
EBIT
Depreciation
EBIT*(1 - Tax Rate)
Operating Cash Flows
CapX
Change in Working Capital

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

How do you calculate total cash receipts per month for a cash receipts schedule statement? (Refer to 4-19). Chapter 04: Financial Forecasting Chapter 4 Financial Forecasting Discussion Questions 4-1....

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

Can you please show number 3 , step for step with the formulas? I cannot seem to find the Total Equity inorder to calculate ROE Ryerson University Ted Rogers School of Management FIN300 Midterm Exam...

Can someone please provide me with the solutions for 3, 7 and 27 Ryerson University Ted Rogers School of Management FIN300 Midterm Exam Fall 2013 Version A Student Name (Please print) Student Number...

#15, Please show the step by step process clearly to get the answer, Thanks! Ryerson University Ted Rogers School of Management FIN300 Midterm Exam Fall 2013 Version A Student Name (Please print)...

Please see attachment please ask questions if you have any CaseStudy 2 1) (Relative valuation of common stock)Using the P/E ratio approach to valuation, calculate the value of a share of stock under...

Need help solving problems 5-1, 5-2, 5-3, and 5-7: 92 PART 2: FINANCIAL PLANNING AND ma financial rpose of pro forma fina ems with pro forma, and b a, and benefits - Define the phrase "pro forma" and...

The Financial statements for Nike, Inc. are presented in Appendix C at the end of the text. The following additional information (in thousands) is available. I NEED HELP WITH LETTERS E - M 17...

Year 0 1 2 3 4 5 EBIT Taxes NOPAT Plus: Depreciation Less: CAPEX Less: Net working capital needs (See Note 1) Plus: Salvage value of the fixed assets in year 5 Firm Free Cash Flow (FFCF) Net Fixed...

The Financial statements for Nike, Inc. are presented in Appendix C at the end of the text. The following additional information (in thousands) is available. I need help with letters A-M. 17...

The Petty Cash Book is maintained on imprest system and the Petty Cash Book balance on April 1, was OMR 4,000. The amount reimbursed on May 1 was OMR 3,500. What is the amount of petty cash expenses...

At Suva ( = 18) at 9 a.m. on 20 May, the irradiance measured on a horizontal plane was G h = 1.0MJ/h.m 2 . Determine the angle z between the beam radiation and the vertical, and hence find the...

Question 8 Unanswered - 3 attempts left A company is projected to generate free cash flows of $ 4 2 9 million next year, growing at a 4 . 7 % rate until the end of year 3 . After that, cash flows are...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...