|Date:||April 13, 2022|
|Time:||1:00 PM AEST|
|Event:||FREE Webinar - Excel Financial Functions Part 1|
|Registration:||Click here to register.|
FREE Webinar – Financial Functions Part 1
Excel has many functions dedicated to financial calculations. These functions take three or more arguments and there are a few things you need to know to use them correctly.
Most involve loans or calculations associated with the time value of money.
This session will cover the following functions
- PV – Present Value
- PMT – loan payments
- CUMIPMT – cumulative interest for loan schedules
- RATE – interest rate
- FV – future value
- NPER – number of period
The session finishes with a loan model that calculates the “missing” value for a loan scenario.