Financial Calculations and compound interest in Excel
A free course that focuses on the time value of money calculations in all its forms in Excel. Included is debt calculations, compound interest and how to allow for prepayments, ad hoc withdrawals and changes in interest rate. How NPV and IRR work in Excel and the relationship between the two and the debt calculations. These calculations are particularly important for IFRS calculations.
- Time Req – 2 hrs
- Skill Score >6
- FAQ
- All Online Courses
- Live Course Options
- Ask a Question
Modules
Time Value of Money- Debt, NPV, IRR
Lessons
- Nominal vs Effective Rates Free Preview
- Debt Functions in Excel- Same as your Financial Calculator Free Preview
- Calculate the Interest vs Capital portion of debt repayment Free Preview
- Allow for Ad hoc Withdrawals and Prepayments Free Preview
- Allow for changes in Interest rates Free Preview
- EXERCISES: Debt Free Preview
- NPV and IRR Free Preview
- Excel NPV functions Free Preview
- Excel IRR functions Free Preview
- Multiple Discount rates in NPV? Free Preview
- Terminal Cash Flow Discounting Free Preview
- Compound Annual Growth Rates (CAGR) in Excel Free Preview
- EXERCISES: NPV, IRR and Debt Examples Free Preview
