Royal Dutch Shipping is planning on Investing $1,600,000 to buy a freighter

Question # 00095932 Posted By: Prof.Longines Updated on: 08/23/2015 02:22 AM Due on: 08/27/2015
Subject Finance Topic Finance Tutorials:
Question
Dot Image

Based on the information provided below, compute the Net Present Value of the project (CO 3). A Net Present Value Template is Attached. (Hint: Don't forget to update the discount rate to the amount required for this project and add your cash flow numbers.)

Royal Dutch Shipping is planning on Investing $1,600,000 to buy a freighter. Prepare a net present value analysis based on the assumption that the freighter will be sold for 10% of its cost at the end of the year 5. Assume a 10% cost of capital. Annual operating cash flows for the project are:

Year 1: $380,000
Year 2: $390,000
Year 3: $400,000
Year 4: $410,000
Year 5: $420,000

Prepare a loan amortization schedule based on monthlypayments for the $1,600,000 if Royal Dutch Shipping can pay 10% down on a loan for $1,600,000 and can get a loan for 6% interest for 10 years (do not include this in your Net Present Value computations. This is a separate issue. (CO 3). (Hint: www.bankrate.com/calculators/mortgages/amortization-calculator.aspx )

NPV example
Discount rate16%
YearCash in (out)PV factorsPV of cash flows
0 (80,000)1.0000 (80,000)
1 20,0000.8621 17,241
2 18,0000.7432 13,377
3 22,5000.6407 14,415
4 10,0000.5523 5,523
5 30,0000.4761 14,283
Net Present Value (15,161)
Internal rate of return

7.81%

Dot Image
Tutorials for this Question
  1. Tutorial # 00090265 Posted By: Prof.Longines Posted on: 08/23/2015 02:25 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Royal Dutch Shipping is planning on Investing $1,600,000 to buy a freighter...
    Attachments
    Answer_22082015(5)NPV_and_Amortization_Schddule_Royal_Dutch_Shipping.xlsx (22.56 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    gtze...o.com Rating Amazing tutorial experience 03/17/2016

Great! We have found the solution of this question!

Whatsapp Lisa