30 likes | 132 Views
Lecture One (Ch 1 & Ch 5). Introduction To Corporate Finance & Time Value of Money. Spreadsheet Example. Use the following formulas for TVM calculations FV(rate,nper,pmt,pv) PV(rate,nper,pmt,fv) RATE(nper,pmt,pv,fv) NPER(rate,pmt,pv,fv)
E N D
Lecture One (Ch 1 & Ch 5) Introduction To Corporate Finance& Time Value of Money
Spreadsheet Example • Use the following formulas for TVM calculations • FV(rate,nper,pmt,pv) • PV(rate,nper,pmt,fv) • RATE(nper,pmt,pv,fv) • NPER(rate,pmt,pv,fv) • The formula icon is very useful when you can’t remember the exact formula • Click on the Excel icon to open a spreadsheet containing four different examples.