Excel Loan Schedules
July
16
2025
(Wednesday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 60 Minutes
2 Days Left To REGISTER
Duration: 60 Minutes
2 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
Overview
This session will examine and explain 5 different loan schedules.
Why you should Attend
Can your loan schedule handle loan drawdowns?
What about interest-only periods?
How about extra repayments?
These types of loan schedules are shared and explained.
Areas Covered in the Session
- Standard Loan Schedule - using standard formulas - works in all versions
- Standard Loan Schedule - using dynamic array formulas - subscription version only
- 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
- 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
- Extra Repayments Loan Schedule - models the effect of making extra repayments on the life and total cost of the loan. Works in all versions
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
Access Recorded Version
One Attendee / Group Attendees
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)