This sheet calculates the minimum annual repayments required
for a loan covered by Division 7A. For each financial year
during the term of the loan, it also calculates the interest
and capital components of total repayments made and the final
loan balance.
Features:
Minimum repayment required for a year is calculated
Alert given if minimum repayment is not met
Interest and principal components of total repayments are calculated
Use government benchmark interest rates or user-defined interest rates
Division 7A Loan Calculator
