Interest Rate Hof Perods Future Value 6.50% $500,000 what is the pr Lump sum? o interest Rate #of Deriods Payment 9.252 What is the Ev Annuity? o interest Rate Hof Periods Payment What is the PV Arnity Due? 4 boterest Rate #of Pericots Resent value 4.5% $500,oo Cakulate the PMT? 5 interest Rate #of Dericct present Value 0.40% $ 500.000 Cakolate Mortgage PBT? 6 #of Denods Present Value future Value 15 $200,000 $400,000 eaculate the Interest Prate (l/y)? Work the following formulas in Excel: 1) Calculate Future Value (FV) of a lump sum. Formula = FV(rate,nper,pmt,-pv, type) 2) Calculate Present Value (PV) of a lump sum. Formula = -PV(rate,nper,pmt,fv, type) 3) Calculate Future Value (FV) of an annuity. Formula = FV(rate,nper,-pmt,pv, type) 4) Calculate Present Value (PV) of an annuity. Formula = -PV(rate,nper,pmt, fv, type) 5) Calculate the Present Value (PV) of an annuity due. Formula = -PV(rate,nper,pmt,fv, 1) 6) Calculate the Payment/Sinking Fund (PMT). Formula = PMT(rate,nper,-pv.fv, type) 7) Calculate the Mortgage Payment (PMT with compounding). Formula =PMT(rate/12, nper*12,-pv.fv, type) 8) Calculate the Number of Periods (N). Formula = Nper(rate,pmt,pv fv, type) 9) Calculate the Interest Rate (1/4). Formula = Rate(nper,pmt,pv.fv, type,guess) 10) Calculate the Net Present Value (NPV). Formula = NPV(disc rate,cf1,cf2,..., cfn) - Initial Investment 11) Calculate the Net Present Value (NPV) with payments made at the beginning of the period. Formula = NPV(disc rate,cf2,...,cfn) - Initial Investment + cf1 12) Calculate the Internal Rate of Return (IRR). Formula =IRR(Initial Investment,cf1.cf2,...,cfn) 2 Interest Rate = 6.502 Hof Penods = 5 Futurvalve PV Lump sum = ? 500,000 9.25 do Interest Rate = # of Peneds = is Payment = * 1,000 F Amuity = ? 5. Interest Rate = 7,00% # of Denoot = 12o Payment $50o Pr Aruity Due=? Interest Rate=4,757 # of Reriods =30 Present Value =$500,000 PMT = ? 7 Interest Rate = 0,40% t of Renods - 360 Present Value - soo, ooo Mortgage PMT=? a. # of Deriods =15 Present Value = $200,000 Future Value = $400,000 1Y=2