The impact of investment can sometimes be challenging to evaluate. Excel simplifies the process for you with its range of financial functions. In this course, you will learn the most useful functions to help assess the value, growth and return on investment of your company’s business choices.
Intermediate 5 Lessons 60 Minutes CPD Credits
About This Course
If you’ve ever tried to evaluate investments, you’ll know there’s room for error with calculations. Excel will do the hard work for you with the financial functions you’ll learn in this course.
Through detailed explanations, you’ll gain confidence in applying formulas to calculate value, growth, rate of return, and loan repayments, giving you a fuller picture of the company’s return on investment.
Once you’ve completed these five lessons, you’ll be well equipped to run regular assessments of the data using formulas that make the whole process efficient and effective.
Evaluate investments using Internal Rate of Return and Net Present Value
Calculate the Compound Annual Growth Rate for an investment
Model the repayments of an amortizing loan
Calculate the payback period of an investment