Loan amortization schedule with bi-monthly payments

M

McCarthy_MF

I was looking at the Loan Amortization Schedule downloaded at
http://office.microsoft.com/en-us/templates/TC010197771033.aspx and found
that the Payment Dates won't calculate for 24 payments per year (e.g. 1st and
15th payments). In stead of 1/1/2005 followed by 1/15/2005 I get 1/1/2005
followed by 2/1/2005 followed by another 2/1/2005. I believe the error stems
from the "DAY(Loan_Start)" portion from the formula, but it could come from
"(Pay_Num)*12/Num_Pmt_Per_Year" yielding 0.5 payment increments.

The original formula is:
=IF(Pay_Num<>"",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top