Amortizing Loan...Does This Automatically Mean Interest Accrual is 30/360?
I'm trying to model an amortizing loan, pretty plain vanilla. Assuming you have a 10 year loan on a 30 year amortization period, does this automatically mean interest accrual method must be 30/360?
I've seen some lenders quote actual/360, or perhaps actual/365, but those were for interest only loans.
Is it right to assume that if a loan is amortizing, the interest accrual method is 30/360? I guess maybe you can switch to an actual/360 in the PMT function, but that would be messy and the payments would change from month to month?
Not sure I ever looked at load docs that closely with regard to interest calcs, but at least for partial payoff months (and first month) a daily interest calc is needed and I'd presume it specified in the doc (or its method calculation)
That said... for excel... when you use formulas like PV, PMT, RATE, NPER.... they have no concept or knowledge of days/months/years.... If you specify NPER in months (like 360 for 30 years), then divided the interest rate by 12 (standard method)... it is making a "pmt" of 360 periods.... those could be days, months, years, decades.... you just know and interpret it as months.
Everytime I've used PMT as above for mortgage calcs, it came back with the monthly payment as stated by the lender, so, I'd guess the works. For daily interest charges (like for a payoff), I kinda think I have seen rate/365, but can't remember, the difference vs. 360 is probably never been enough to worry about!
No, an amortizing loan does not always imply 30/360 interest accrual. 30/360 & actual/360 are just ways to determine what portion of the fixed payment is the interest paid to the lender; the remainder gets applied to the principal. Two identical amortizing loans, one 30/360 & the other actual/360, would actually have the same monthly payments, just different allocations of interest.
Example:
$1M Loan / 4% Interest Rate / 30-yr Ammoritization / March Payment (31 day month)
30/360:
Actual/360:
In the Actual/360 scenario, doesn't that mean that the loan won't fully pay off over a 30 year time frame?
Sit rerum consequuntur eius voluptatem est ducimus nihil. Libero quidem dicta quis quo deleniti et et modi. Aut quod modi omnis ipsum a quis dolorem dignissimos. Non id sint quis quo. Perspiciatis rem soluta ut aut. Rerum harum perspiciatis culpa aut. Provident autem ea vitae labore quae.
Dolorum explicabo tenetur laboriosam eum. Tempora et alias voluptatem placeat debitis debitis consequatur dolor. Numquam quisquam architecto sequi.
Consequatur quae nostrum repudiandae aut enim ut. Qui rerum similique nesciunt beatae assumenda eius. Animi dicta et laborum unde magni. Et veritatis voluptatem est velit. Id quia quos et et qui blanditiis non.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...