{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

HW 3 - HADM 6626 HW 3 Eddie Lo 2840681 Excel Printouts...

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

View Full Document Right Arrow Icon
HADM 6626 HW 3 Eddie Lo 2840681 Excel Printouts Question 1 No Project w/Proj A w/Proj B Before neg NPV After neg NPV S 5,000,000.00 $ 40,000,000.00 $ 55,000,000.00 $ 45,000,000.00 $ 30.00 $ 25.00 $ X 7,000,000.00 $ 50,000,000.00 $ 50,000,000.00 $ 50,000,000.00 $ 50.00 $ 50.00 $ r 3% 5% 5% 5% 4% 4% sig 30% 30% 60% 40% 30% 50% T 4 8 8 8 5 5 d1 -0.063728379 0.621284951 1.134689239 0.817557565 -0.133749747 0.11444767 d2 -0.663728379 -0.227243187 -0.562367036 -0.313813284 -0.80457014 -1.003586319 N(D1) 0.474593254 0.732793923 0.871747226 0.793195067 0.446800233 0.545558537 N(d2) 0.253432086 0.410117324 0.286932987 0.376831427 0.210533889 0.157789026 C 796768.3856 15432579.53 38235720.45 22941060.87 4.751831461 7.154409537 Equity E=C 796,768.39 $ 15,432,579.53 $ 38,235,720.45 $ 22,941,060.87 $ 4.75 $ 7.15 $ Debt D=S-E 4,203,231.61 $ 24,567,420.47 $ 16,764,279.55 $ 22,058,939.13 $ 25.25 $ 17.85 $ Cost Rd=ln(X/D)/T 12.75% 8.88% 13.66% 10.23% 13.67% 20.61% Question 2 Question 3 Question 4 S1 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 S2 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 sig1 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 sig2 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 ro -0.99 -0.95 -0.9 -0.85 -0.8 -0.75 -0.7 -0.65 -0.6 -0.55 -0.5 -0.45 -0.4 -0.35 -0.3 -0.25 -0.2 -0.15 -0.1 -0.05 0 0.05 0.1 0.15 0.2 0.25 0.3 0.35 0.4 0.45 0.5 0.55 0.6 0.65 0.7 0.75 0.8 0.85 0.9 0.95 0.99 sigma 1.246996 1.234909 1.219631 1.204159 1.188486 1.172604 1.156503 1.140175 1.12361 1.106797 1.089725 1.072381 1.054751 1.036822 1.018577 1 0.981071 0.961769 0.942072 0.921954 0.901388 0.880341 0.858778 0.83666 0.813941 0.790569 0.766485 0.74162 0.715891 0.689202 0.661438 0.632456 0.60208 0.570088 0.53619 0.5 0.460977 0.41833 0.37081 0.316228 0.264575 d1 2.464593 2.440703 2.410508 2.379929 2.348953 2.317562 2.28574 2.25347 2.22073 2.1875 2.153758 2.119478 2.084635 2.0492 2.01314 1.976424 1.939012 1.900863 1.861934 1.822172 1.781524 1.739926 1.697309 1.653595 1.608692
Background image of page 1

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

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}