excel finance project

excel finance project - Equipmentneeded:...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Equipment needed: Rophemerization chamber 350,000,000 Industrial sphereinator 170,000,000 8 year project year 0 year 1 year 2 Unit price 1,550 1,473 Unit sales 80,000 160,000 VC 675 662 FC 800,000 816,000 Revenue 124,000,000 235,680,000 (Costs) (54,800,000) (106,736,000) Operation Profit 69,200,000 128,944,000 (Depreciation) (69,000,000) (117,400,000) EBT 200,000 11,544,000 (Tax) (70,000) (4,040,400) Net Income 130,000 7,503,600 Depreciation 69,000,000  117,400,000  OCF 69,130,000 124,903,600 CAP (520,000,000) NWC (5,000,000) Total Cash Flow (525,000,000) 69,130,000  124,903,600  Depreciation Rates 10 year 10.00% 18.00% 7 year 5 year 20.00% 32.00% Book values rophemerization chamber 315,000,000 252,000,000 industrial sphereinator 136,000,000 81,600,000 7 year MACRS equipment NWC (initial): Tax rate: 5,000,000 35% Starting at end of year 4: 7 year MACRS equipment NWC NPV $503,352.30  IRR 18.47% PI $1.00
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
MIRR 15.50%
Background image of page 2
Depreciation: Salvage value: 10 year MACRS 75,000,000 5 year MACRS n/a year 3 year 4 year 5 year 6 year 7 year 8 1,399 1,329 1,263 1,200 1,140 1,083 240,000 250,000 300,000 380,000 450,000 450,000 649 636 623 611 599 587 832,320 848,966 865,945 883,264 900,929 918,948 335,760,000 332,250,000 378,900,000 456,000,000 513,000,000 487,350,000 (156,592,320) (159,848,966) (187,765,945) (233,063,264) (270,450,929) (265,068,948) 179,167,680 172,401,034 191,134,055 222,936,736 242,549,071 222,281,052 (83,040,000) (61,618,800) (54,792,800) (37,685,800) (24,423,800) (23,996,600) 96,127,680 110,782,234 136,341,255 185,250,936 218,125,271 198,284,452 (33,644,688) (38,773,782) (47,719,439) (64,837,828) (76,343,845) (69,399,558) 62,482,992 72,008,452 88,621,816 120,413,108 141,781,426 128,884,894 83,040,000  61,618,800  54,792,800  37,685,800  24,423,800  23,996,600  145,522,992 133,627,252 143,414,616 158,098,908 166,205,226 152,881,494 (12,000,000) 72,364,770 (1,000,000) 6,000,000  145,522,992  120,627,252  143,414,616  158,098,908  166,205,226  231,246,264  14.40% 11.52% 9.22% 7.37% 6.55% 6.55% 14.29% 24.49% 17.49% 12.49% 8.93% 19.20% 11.52% 11.52% 5.76% 201,600,000 161,280,000 129,010,000 103,215,000 80,290,000 57,365,000 48,960,000 29,376,000 9,792,000 0 10,285,200 7,346,400 5,247,600 3,748,800 2,677,200 Salvage value: 12,000,000 (installed middle of year 5) 4,000,000 1,000,000
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Debt Market Value Par Value Bond 1 $912.90  $1,000  5.875%  4   28.50   25,000  Bond 2 $969.70  $1,000  5.4%  2   8.00   34,500  Bond 3 $1,010.20  $1,000  5.2%  1   3.00   26,400  Total Common Stock Market Value Par Value growth rate beta Class A Sh $28.35  $1.00   0.75  5.0% 1.1  2,735,000  Class B Sh $14.55  $1.00   -    5.2% 1.13  1,845,000  Total Preferred Stock Market Value Par Value Dividend Shares  $115.00   $100   $8.75  150,000 Total Total Market Value WACC Tax Rate 35% Risk Free Rate 3.5% Market Premium 6.0% Total Market Value 204,578,430 WACC (market)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 18

excel finance project - Equipmentneeded:...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online