Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with this question. please no excel thank u! each year) and its cost of caplal is 11.4% a. Prepare an NPV profle
I need help with this question. please no excel thank u!
each year) and its cost of caplal is 11.4% a. Prepare an NPV profle of the purchase using disceunt rates of 2.0%,11.5% and 17.0%. b. Idenaty the afP (to the nearest 1% ) on a graph. c. ls the purchase atractive based on these estimates? d. How fur of oould Openseas' cost of capital be (to the nearest 1\$6) before your purchase deciglon world change? Note: Subtrast the discount rate from the actual IRR. Use Excel to compute the actual IRR. a. Prepare an NPV profle of the purchase using discount rates of 2.0%,11.5% and 17.0%. The NPV for a siscount rates of 2.0% is 5614 millien. (Round to the searest imeger.) The NPV for a siveount rates of 11.5% is $25 milien. (Round to the nearest indeger.) The NPV for a discount rates of 17.0. is s117m mion. (Phound to the nearest integer) b. Idenaty the Ifor tio the nescest 1\%) on a graph. The approximate tfer from the graph is 12%. (Poound to the nearest integer) c. Is the purchase attractive based on these estimates? (Select the best choice below.) A. No, because at a 11.4% discount rate, the NPV is positive. B. Yes, because at a 11.4% discount rate, the NPV is positive. C. No, because at a 11.4% discount rate, the NPV is negative. D. Yes, because at a 11.4% discount rate, the NPV is negative. d. How far off could OpenSeas' cost of capital be (to the nearest 1\%) before your purchase decision would change? The cost of capital estimate can be off by 0.876%. (Round to three decimal places.) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started