Calculate the NPV for an investment in the Fokker 100 airplane assuming the following. Show your answers in millions:

Sale price per plane $20 million

Cost per plane $16 million

Deposit upon order per plane $4 million (planes are delivered 2 years after order is placed; the balance due is paid on delivery)

35 planes are sold each year for years 4, 5, 6, 7, 8, and 9.

The investment in the planes is, in millions: Year 1 = $50, Years 2, 3, 4, and 5 = $110 each year.

PLEASE SHOW EXCEL FORMULA

A B C D E F G H I J K L M Fokker 100 1 2 3 4 5 6 7 8 9 10 11 Total (in M$) 3 Planes sold 4 Investment 5 Revenues 6 Production Costs 7 Net CF 8 NPV @10% 9 Price per plane | 10 Cost per plane 11 Deposit/plane 12 Balance paid at delivery