October 2 - 4 Early Bird tickets are now ON SALE. Purchase your tickets today and save $100!

Get tickets

October 2 - 4 Early Bird tickets are now ON SALE. Purchase your tickets today and save $100!

Get tickets
Skip to content
Two investors reviewing resources on a laptop

Get industry-leading resources — for free

Unlock resources for every investing strategy and stage with a free account.

By continuing, you agree to BiggerPockets LLC's Terms of Use and Privacy Policy

FilePlaceFrank Jiang's FilesAmortization Table

Amortization Table

XLSX

uploaded by Frank Jiang

73.5 KB

File Size

630

Downloads

N/A

Rating

Simple fixed rate amortization table with a data table to calculate the decrease in loan payoff time with additional principal payments.

Download File
Disclaimer: Safety of files uploaded to the BiggerPockets FilePlace cannot be guaranteed. Download at your own risk.
Rate this file
Pick a rating between 1 and 5 stars

Comments

Great work, Frank. Any chance you can add a formula/ column/ cell for paying add'l principal starting in a certain month? (i.e. I'm in month 35 of my current mortgage, haven't paid extra so far but want to start paying extra in month 36)

Anthony Stamper | about 8 years ago