This is not a mortgage, but a company loan. $200,000 over 25 years, paid weekly at 5% annual rate. But it compounds weekly. I’ve only been able to find spreadsheets and calculators that compound monthly, which changes the payment amount! I need one to track the balance left if and when I make extra payments (no penalty for early payoff).
Get the monthly template and change it. All you have to do is change the divisor.
Anybody have a spreadsheet template for a loan payback?
Leave a comment
T-Value
http://www.timevalue.com/tvalue.htm
References :
Get the monthly template and change it. All you have to do is change the divisor.
References :
You need an Amortization Schedule.
I like bankrate.com, but it is pretty simple to create on your own with a little EXCEL knowledge.
References :