Question: Can you please show every single step on hand instead of using excel or, the calculations behind every answer, please. I would like to know

 Can you please show every single step on hand instead of

Can you please show every single step on hand instead of using excel or, the calculations behind every answer, please.

I would like to know how to find the after tax interest expense and the unlevered net income to find every single cash flow.

Use the table for the question(s) below Pro Forma Income Statement for Ideko, 2005-2010 Year 2005 20062007 2008 2009 2010 Income Statement (S 000 1 Sales 2 Cost of Goods Sold 3 Raw Materials 4 Direct Labor Costs 5 Gross Profit 6 Sales and Marketin 7 Administrative 8EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net 12 Pre-tax Income 13 Income Tax 14 Net Income 75,000 88,358 103,234119,777 138,149 158,526 16,000) (18,665) (21,593) (24,808) (28,333) (32,193 (18,000) (21,622) (25,757) (30,471) (35,834) (41,925) 41,000 48,07155,883 64,498 73,982 84,407 11,250) (14,579) (18,582) (23,356) (27,630) (31,705 13.500) (13,254) (15,485) (16,769) (17,959) (20,608 16,250 20,23821,81624,37328,39332,09.4 5,500) (5,450) (5,405) (6,865) (7,678) (7,710 10,750 14,78816,41117,508 20,715 24,38.3 6,800) (6,800) (6,800) (7,820) (8,160 10,675 7,9889,61110,708 12,895 16,22.3 2,796) (3,364) (3,748) (4,513) (5,678 6,9395,1936,2476,9608,38210,545 75 3,736 1) Using the income statement above and the following information and calculate Ideko's Free Cash Flow to the Firm and Free Cash Flow to Equity from 2006 to 2010 Year Increases in NWC 2,250 3,000 3,250 3,600 4,000 Capital Expenditures 5,000 5,000 20,000 15,000 8,000 20062007 2008 2009 2010 Net Borrowin 0 15,000 5,000 0

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!