This course is intended as a general introduction to business and financial analysis. The author and publisher are not liable for any consequences arising from the use of or reliance on this advice.
- [Instructor] The techniques taught in this course are meant as a general introduction to business and financial analysis. They are not a substitute for advice from an experienced financial planner who is licensed to practice in your area. The author and publisher are not liable for any consequences arising from the use of or reliance on this advice.
- Calculating the effect of interest rates and inflation
- Finding the arithmetic and geometric means of growth rates
- Calculating the future and present value of an investment
- Calculating loan payments for a fully amortized loan
- Calculating the effect of paying extra principal with each payment
- Finding the number of periods required to meet an investment goal
- Calculating net present value and internal rate of return
- Building a cash tracking worksheet
- Visualizing cash flows using a waterfall chart
Skill Level Intermediate
Excel 2016: Avoiding Common Mistakeswith Dennis Taylor1h 44m Intermediate
1. Introducing the Time Value of Money
2. Calculating Net Present Value and Internal Rate of Return
3. Tracking and Visualizing Cash Flows
Additional resources1m 9s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.