Help, amortization table

Discuss the spreadsheet application

Help, amortization table

Postby angiesb » Sat Apr 12, 2008 11:21 pm

someone please help me. I need to create an amortization table that has a given mortgage amount for a 2 year schedule and I don't have a clue how to enter any of the values that will calculate it. Please help!
Posts: 2
Joined: Sat Apr 12, 2008 11:05 pm

Re: Help, amortization table

Postby RonIA » Sat Apr 12, 2008 11:41 pm

A few more details, are you just looking for what the monthly payment would be (the PMT function) or are you looking for a full schedule to indicate amount allocated to principal, and interest and the remaining principal balance at the end of each payment?

i.e. =pmt(6%/12;24;-100000
What is the payment on a 24 month loan at 6% annual interest starting at a principal balance of 100,000.

This will be fine for general use, but you also have to consider if the loan interest is at the beginning of end of the month...

But this will get you started I hope.
Ron from Iowa, USA
Posts: 139
Joined: Mon Oct 08, 2007 1:34 am
Location: Iowa USA

Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests