Webinar banner
FREE - Excel Financial Functions Part 1
This free webinar demonstrates some of Excel’s financial functions. These functions take three or more arguments, but 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 covered the following six functions

- PV – Present Value of future regular cash outflow
- PMT – periodic loan repayment calculation
- CUMIPMT – cumulative interest – great for loan schedules
- RATE – interest rate
- FV – future value of regular investment
- NPER – number of periods

The session finishes with a loan model that calculates the “missing” value for a loan scenario based on two out of three inputs. The IFERROR function is also discussed.

Jun 11, 2019 11:00 AM in Perth

Webinar is over, you cannot register now. If you have any questions, please contact Webinar host: Neale Blackwood.