NEED HELP ASAP PLEASE HELP THANKS

Instructions: Practice Problem 1. Complete the 4th 5th and 6th columns. Using the previous example and find the Net Present Value of the investment 2. Using the Present Total Value over the 10 year cycle calculate the ROI. Use a 15% discount rate. Cash Flows in Year of Occurrence Energy Saving Repair and Present Value Year Maintenance Escalation Rate Install Cost Total Annual Total Annual (n) Escalation Rate 5% per year Cash Flow Discount Rate 5% per year 15% (-) 0 (30,000) (30,000) (30,000) 1 7,500 (500) 2 7.875 3 8,269 4 8,682 5 9,116 6 9,572 7 10,051 8 10,553 9 11,081 10 11,635 Net Present Value of Life-Cycle Cash Flows ($) ROI = Year o represents the purchase/equipment start-up date. Total Annual Cash Flow - this is the cash amount and is always in the year it occurs shown in dollars. Present Value = Future Value x laton