| Date: | 18/06/2024 |
|---|---|
| Time: | 1:00 PM AEST |
| Event: | Excel Loan Schedules |
| Topic: | Excel Loan Schedules |
| Public: | Public |
| Registration: | Click here to register. |
Webinar – Excel Loan Schedules
Price: AU$25
This session will examine 5 different loan schedules.
1. Standard Loan Schedule – using standard formulas – works in all versions.
2. Standard Loan Schedule – using dynamic array formulas – subscription version only.
3. Loan Drawdown Schedule – allows the drawing down of amounts with interest only and repayments begin once the final drawdown has been made. Subscription version only.
4. Interest Only Period Loan Schedule – allows setting an interest only period before the repayments begin. Macro based. Works in all versions except the browser version.
5. Extra Repayments Loan Schedule– models the effect of making extra repayments on the life and total cost of the loan. Works in all versions.