***please show and use Excel formula so I can learn best****

Halcyon Lines is considering the purchase of a new bulk carrier for $8.5 million. The forecasted revenues are $5.5 million a year and operating costs are $4.5 million. A major refit costing $2.5 million will be required after both the fifth and tenth years. After 15 years, the ship is expected to be sold for scrap at $2.0 million. a. What is the NPV if the opportunity cost of capital is 9%? (Enter your answer in dollars, not millions of dollars. Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest whole dollar amount.) Net present value b. Halcyon could finance the ship by borrowing the entire investment at an interest rate of 4.5%. Will this borrowing opportunity affect your calculation of NPV? Yes No