Excel amortization spreadsheet for mac

Finance Productivity. This article will walk you through creating a custom amortization schedule in Excel. Read More … so why not use it to manage your debt, too? An amortization schedule details each payment you make over the life of the loan and shows you the updated principal and interest after each periodic payment.

Read More with a given monthly payment. No matter you financial situation, we have the calculators you need. Read More available.

Watch Me Build a Mortgage Amortization Table in Excel in Under 90 Seconds

If you want a simpler table, you can just include the Period, Payment, Cumulative Principal, Cumulative Interest, and Ending Balance columns; you can also replace the cumulative sections with the non-cumulative ones. Here are the formulas you should use for each of the columns:. Now we can fill in the second row, which will let us automatically populate the rest of the schedule.

Amortization Template Current - Apple Community

Now, you can just use auto-fill to fill in the rest of the rows. Select cells B8 through H8, and auto-fill down as far as you want!


  • drop cap word 2011 mac!
  • Loan Amortization in Quicken for Mac (333 Legacy Votes);
  • delete windows partition on mac bootcamp;

No overdrawn balances or unpaid bills. Sounds like it might do just what I need. Will know in a moment.

Loan Amortization Schedule Pro

Either way, I appreciate your work on it and sharing it. Cheers, J. Your email address will not be published. This site uses Akismet to reduce spam.

Popular Topics

Learn how your comment data is processed. I guess it has been written in the US and there it may be common for monthly payments but elsewhere, banks do offer alternative payment schedules such as fortnightly, resulting in 26 payments a year instead of just 12 which makes quite a difference on the calculations. As for variations caused by rate changes, term changes or voluntary repayments, the easiest solution might be to break the schedule at the last payment and begin the calculations all over again.


  • screenshots!
  • aperture 4 mac talk forum.
  • Setting Up the Worksheet.
  • {{ content.sub_title }};

Therefore a set of instructions how to do this within this spreadsheet may be useful. After doing this, the program would possibly have a more universal application.

What Is an Amortization Schedule?

This is Alex from ReQuantify. I thank you very much for your detailed review. Your criticism is very constructive and I will incorporate many of your suggestions into the next version. Specifically, I plan to add an "Advanced" tab to the spreadsheet so that alternative mortgage terms can be entered which would make the tool applicable for use outside of the US.

Right now, the Mortgage Payment Calculator tab is set up for a fix-rate mortgage with monthly compounding which is common in the US, but obviously not all other countries. Please accept my apologies for your disappointment with the spreadsheet. I should have been clearer in my description of the product when I published it. If you want to be notified when I publish the new version or if you have other suggestions to make the spreadsheet better please feel free to email me at alex requantify.

Thanks again for your review. The posting of advertisements, profanity, or personal attacks is prohibited.

How to make a loan amortization schedule in Excel (with extra payments)

Click here to review our site terms of use. If you believe this comment is offensive or violates the CNET's Site Terms of Use , you can report it below this will not automatically remove the comment.

Publisher's Description

Once reported, our staff will be notified and the comment will be reviewed. Lower-than-expected sales, unexpected glitches, design fails -- it doesn't always go right for Apple Grab your stuff while you still can. Overview User Reviews Specs. You can also compare different mortgage scenarios side-by-side to see what might work best for you.