This is not a mortgage, but a company loan. 0,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).
Anybody have a spreadsheet template for a loan payback?
3 Responses to Anybody have a spreadsheet template for a loan payback?
Leave a Reply
You must be logged in to post a comment.
Get the monthly template and change it. All you have to do is change the divisor.
T-Value
http://www.timevalue.com/tvalue.htm
You need an Amortization Schedule.
I like bankrate.com, but it is pretty simple to create on your own with a little EXCEL knowledge.