30 likes | 139 Views
Learn the fundamentals of Corporate Finance and advanced concepts of Time Value of Money through Excel spreadsheet examples. Explore TVM calculations using Excel formula functions and simplify complex financial scenarios effortlessly.
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.