- Joined
- 14 December 2005
- Posts
- 937
- Reactions
- 1
Good evening to whoever is reading this
Earlier I went off topic in the Liberal v Labor thread when I started talking about calculating mortgage loan repayments.
Anyway, for anyone interested in calculating loan repayments and maximum loan amounts, attached is a spreadsheet that works it for you.
Be aware that results in the spreadsheet might be a little different to some online calculators which might use 26 fortnights and 52 weeks in a year and it certainly doesn't take into account any extra fees or criteria lending institutions might have.
My spreadsheet uses 26.089 fortnights (365.25/14) and 52.179 weeks (365.25/7) in a year. The 365.25 takes into account the extra day in leap years.
The formula behind the spreadsheet's number crunching is:
R = I x L / (1 - (1+I)^(-n))
Where:
R = Monthly/Fortnightly/Weekly Repayments
I = Interest Rate for the repayment period....ie....if annual interest rate = 7%
and repayments are monthly then I = 7/12
L = The Total Initial Loan Amount
n = the number of periods in the loan term....ie...if loan term = 20 years
and the repayments are monthly then n = 20 x 12
Anyway, for anyone interested feel free to download and play with it, hack/butcher it to suit. If anyone needs any help with it I'll try to reply tomorrow.
cheers
bullmarket
Earlier I went off topic in the Liberal v Labor thread when I started talking about calculating mortgage loan repayments.
Anyway, for anyone interested in calculating loan repayments and maximum loan amounts, attached is a spreadsheet that works it for you.
Be aware that results in the spreadsheet might be a little different to some online calculators which might use 26 fortnights and 52 weeks in a year and it certainly doesn't take into account any extra fees or criteria lending institutions might have.
My spreadsheet uses 26.089 fortnights (365.25/14) and 52.179 weeks (365.25/7) in a year. The 365.25 takes into account the extra day in leap years.
The formula behind the spreadsheet's number crunching is:
R = I x L / (1 - (1+I)^(-n))
Where:
R = Monthly/Fortnightly/Weekly Repayments
I = Interest Rate for the repayment period....ie....if annual interest rate = 7%
and repayments are monthly then I = 7/12
L = The Total Initial Loan Amount
n = the number of periods in the loan term....ie...if loan term = 20 years
and the repayments are monthly then n = 20 x 12
Anyway, for anyone interested feel free to download and play with it, hack/butcher it to suit. If anyone needs any help with it I'll try to reply tomorrow.
cheers
bullmarket