Completed for 5 years and the NPV Calculated.
Once the ratio formula for the increases are entered for year 2005 then that can just automatically be applied to all the following years. and once the yearly cash flows are determined then the NPV formula applies for the total.
Attachment:- Assignment File.rar