• Pages
  • Numbers
  • Keynote
  • Script
  • Submit New Template
iWorkCommunity

iWorkCommunity

Free Templates and Scripts for iWorks (Pages, Numbers, Keynote)

  • Pages
  • Numbers
  • Keynote
  • Script
  • Submit New Template

Personal Loan Amortization Schedule

[Total: 21   Average: 2.7/5]
  • Posted by:

    sara

  • Category: Apple Numbers Template
  • Tags: Loan Templates [Mac Pages / Numbers], Schedule Templates [Mac Pages / Numbers]
Personal Loan Amortization Schedule

Amortization schedule for personal loans with interest and missed payment calculations. This template includes calculations for extra payments to the principal and offers automatic calculations with entry of loan amount, simple interest rate, length of loan, and start date.

A running loan schedule that allows for extra payments and missed payments. All you need to know is Loan Amount, Simple Interest Rate, Length of loan in years, and loan start date. It shows a self adjusting Amortization schedule that adds interest to the principal if you miss a payment and subtracts from principal extra payments. Great for personal loans. Just stretch things down for a loan longer than 3 years. (Doesn’t do compound interest)
File Nameloan.zip
Downloads14330
File Size123 KB
Download Your download will start automatically. If it did not, please try reloading this page.
Similar Templates
Basic Semester Course Schedule Color-Coded Semester Course Schedule Greenhouse Seeding Log Equipment Temperature Logs Employee Schedule Tracking Worksheet Film Production Call Sheet Seed Planting Guide Travel Log with Itinerary and Miles Academic Schedule Planner Monthly Schedule of Activities Simple School Schedule by Hour Travel Itinerary with Flight Tracking Breastfeeding and Diaper Log Teacher’s Day Planner Veterinary Care Log Course Attendance Log
  1. Qmepongo Ana March 3, 2018 at 2:56 pm

    how do I get the template?

    Reply

    1. iwork March 4, 2018 at 7:08 am

      Click link next to “download”

      Reply

      1. K April 14, 2018 at 12:34 am

        Thanks!

        Reply

  2. CS May 28, 2018 at 4:08 pm

    “Just stretch things down for a loan longer than 3 years”… Can someone please expound on this for me? I am tracking a 4 year payoff plan and do not understand how to stretch things down or find the formula so the rest of the spreadsheet will track on another 12 months of payments. Thank you.

    Reply

  3. perry April 9, 2020 at 1:29 am

    Your math is wrong on this spread sheet, it does not compute the daily rate of interest correctly as extra payments are made.

    Reply

    1. Jill August 4, 2020 at 6:43 pm

      I agree! this schedule is showing different calculations from my old one. How do I fix it?

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

I accept the Privacy Policy * for Click to select the duration you give consent until.

Copyright © 2006 - 2018 iworkcommunity.com. All Rights Reserved.
  • Privacy
  • Terms of Service
  • Contact Us