It is a typical Amortization schedule. My porblem is that the rate per
period is taken from another cell that has a drop down box of the frequency
of payment which indicates Monthly, Semi-Monthly etc. . . What I need is my
rate per period to reflect a number that shows the monthly payment based off
a 30 day month and or a 360 day year.
Loan Amount $58,700
Annual Interest Rate 5.75%
Term of Loan in Years 3
First Payment Date 1/15/2009
Frequency of Payment Monthly

Summary

Rate (per period) 0.479%
Payment (per period) $1,130.04

Total Payments $66,118.71
Total Interest $7,418.71
Interest Savings ($2,070.17)
This is the data entry portion of the file.
If you can help that would be great!!

"xlm" wrote:

is there aformula that you can post, if not would you provide the link to where
you download

HTH
--
Appreciate that you click on the Yes button below if this posting was
helpful.

Thank You

cheers, francis









"Trish" wrote:

I am using a Amortization Schedule template from Microsoft Office online. I
am trying to change the Per Period from Monthly - Semi-Monthly etc... to days
per year. My current loan is based on a 360 day year and not a 365 which
changes the interest payment monthly. Can anyone help me.