Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie, Alex Kane, Alan Marcus, Stylianos Perrakis, Peter

8th Canadian Edition

007133887X, 978-0071338875

More Books

Students also viewed these Finance questions