INTHEBLACK November 2025 - Magazine - Page 58
WORK SMART
EXCEL TIPS
SUBSCRIBE
to the podcast
EXCEL LOAN SCHEDULE
CUSTOM FUNCTION
NEALE BLACKWOOD CPA
A loan schedule has a standard structure that requires
multiple formulas based on four inputs. Learn how to
capture the formulas and create the complete loan
schedule, including headings, using a single custom function.
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
While a previous article demonstrated a flexible loan schedule
technique that handled interest-free periods by combining Goal Seek
with a macro, this article shows the advanced custom function.
Once created, the custom function is easily shared between files.
Read the full article
Excel loan schedule custom function
INTHEBLACK, Neale Blackwood CPA: Excel Tips — Excel loan schedule custom function
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
58 INTHEBLACK November 2025
