For a few years now I’ve used a particular Google Doc spreadsheet to track loan payoff strategies. I like this template because I can see how much impact there is by making an extra payment. Recently I’ve moved away from Google’s services and switching over to iCloud. Unfortunately my loan template didn’t work in Numbers. I found another version for Numbers ’09 that was close but lacked the early payoff feedback. After some twiddling I got it working properly and upgraded it for Numbers ’13.

loan worksheet screenshot

Download the template

A Loan Amortization Worksheet for Numbers ’13