| Date: | 17/10/2024 |
|---|---|
| Time: | 1:00 PM AEDST |
| Event: | FREE Webinar - Excel Financial Functions Part 1 |
| Topic: | Financial Functions Part 1 |
| Public: | Public |
| 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
- Dynamic arrays – see how to use them for a loan schedule
The session has a loan model that calculates the “missing” value for a loan scenario.