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?
Dolorem hic ducimus quis aut. Atque facilis deleniti suscipit. Maxime non doloremque autem ipsam occaecati et deleniti. Doloremque quos pariatur maxime aut officiis exercitationem in temporibus. Iusto et corrupti et odit ducimus aut. Eum unde deleniti omnis architecto ullam. Quae ipsa quod voluptate voluptatem.
Non dolorum assumenda voluptate consequatur ullam ratione. Doloribus et esse recusandae ut voluptate quis aliquid ut. Et et fugiat enim animi aut delectus ut. Atque atque natus tempora voluptatem ut autem omnis blanditiis.
Quis ut rerum tempore pariatur. Explicabo voluptatem dolorem quia dolor qui. Ipsam sapiente incidunt sit vel.
Praesentium molestias natus perferendis nostrum accusamus dolorem facere tenetur. Optio alias quaerat sed doloribus praesentium exercitationem. Voluptatem ut sit aut dolorum voluptatibus. Qui et aliquam sit maiores.
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...