I need some help putting together an amortization schedule for a homework question I had, any help would be appreciated.

Assignment: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 onmonthlypayments 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)

Instructions:Prepare the homework in Excel template provided.

Here is the feedback from my professor so I guess that some of the answers are wrong in the excel sheet as well.

Information also needs to go through turnitin without any problems.

Thank you in advance

Royal Dutch Shipping Solution Discount rate Cost of Freightor Value of Salvage Year 0 1 2 3 4 5 10 Percent $1,600,000 $160,000 $ $ $ $ $ $ Cash Flow (1,600,000.0) 380,000.00 390,000.00 400,000.00 410,000.00 580,000.00 Present Value Factors 1.0000 0.9091 0.8264 0.7513 0.6830 0.6209 Net Present Value Internal rate of return Cost of Freightor x 10% (at end of 5 Yr) Present Value of cash flows (1,600,000) 345,458.00 322,296.00 300,520.00 280,030.00 360,122.00 $ 8,426.00 10.19% one time investment Present value of the future cash flow sums