Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
McCarthy_MF
 
Posts: n/a
Default Loan amortization schedule with bi-monthly payments

I was looking at the Loan Amortization Schedule downloaded at
http://office.microsoft.com/en-us/te...197771033.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_S tart)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),"")


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TEMPLATE IN EXCEL FOR MONTHLY PAYMENTS FOR MORE THAN ONE PROP tb New Users to Excel 1 January 4th 05 05:20 PM
Loan Amortization Template - Amount of Final Payment Glenn Excel Discussion (Misc queries) 0 December 11th 04 02:05 AM
Amortization Schedule Steven M. Britton Excel Worksheet Functions 0 December 8th 04 05:23 AM
Mortgage Amortization Schedule dpayne Excel Discussion (Misc queries) 0 December 3rd 04 05:49 PM
Unknown IF function parameter on amortization schedule Michael from Austin Excel Worksheet Functions 1 November 9th 04 07:32 PM


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"