Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TEMPLATE IN EXCEL FOR MONTHLY PAYMENTS FOR MORE THAN ONE PROP | New Users to Excel | |||
Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
Amortization Schedule | Excel Worksheet Functions | |||
Mortgage Amortization Schedule | Excel Discussion (Misc queries) | |||
Unknown IF function parameter on amortization schedule | Excel Worksheet Functions |