z Interest Rate = 6.50% # of Penacs =5 Futurvalue = 500,000 pv Lump som = ? Interest Rate = 9.25 % # of Periods =is Payment = * 1,000 F Amuity = ? 5. Interest Rate = 7,00% # of Renoot = 12o Payment $500 Pr Anouity Due=? Interest Rate=4,757 t of Reriods =30 Presest Value = 500, ooo PMT = ? 7. Interest Rate = 0,40% t of Renods 360 Present Value - Soo, co Mortgage PMT=? a. # of Deriods =15 Present Value $ 200,000 Future Value $ 400,000 IY= ? Page 5 > of 2 ZOOM + 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,fu,type) 5) Calculate the Present Value (PV) of an annuity due. Formula --PV(rate, nper,pmt,fu, 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 = Nperirate,pmt, pv.fv,type) 9) Calculate the Interest Rate (1/Y). 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,c2.cfn) - initial Investment + cf1 12) Calculate the Internal Rate of Return (IRR). Formula IRR(Initial Investment,cf1,c2,...cfn)