Leave percentages with 1 decimal point. For the Proformas, you can leave as whole dollars. For the TMV and NPV problems, round to the nearest penny. Cells collored yellow are to be solved and cells colored green are to be filled in with information provided in the question You must show the excel formulas, not just the typed in value.

Time Value of Money Problems Part A You are examining an investment for your company that will generate annual cash flows of \$2,500 each year at a 4.25% interest rate. How much will the investment be worth in 25 years? RATE PV FV NPER PMT Answer: Part B Your company is looking to upgrade is ERP software and needs to pay $45,000 in two years. If you can earn 5% annually, how much do you need to invest today? RATE PV FV NPER PMT Answer: Part C Part C You want to purchase a new vehicle for your mobile pet grooming company and you are willing to pay $75,000. If you can invest at 10 percent per year and you currently have $55,000, how long will it be before you have enough money to pay cash for the car? RATE PV FV Proforma FinAnalysis-Rev TMV DCF Investment Criteria Project Analysis WACC