Actual/360 Amortization Table
If I use an actual/360 interest payment instead of a simple 30/360 interest payment, will my ending loan balance be $0?
Trending Content - Real Estate Forum
Career Resources
Actual/360 generates more interest than 30/360. If you are using the PMT formula in excel or you are keeping the same payment that was calculated using simple interest/12, a loan schedule that uses actual/360 interest will not tie out to zero. You would need to use a actual/360 payment calculator to find what the new (slightly higher) payment would be using actual/360 interest.
A fully amortizing loan schedule will end in zero, but you need to match the payment with the interest calculation
Thank you for that explanation. I understand that the payment function is using the 30/360 method because it is an equal payment no matter the number of days in each month. How do I match the payment with the interest calculation? Still confused on that. Thank you.
Dolores laborum ut vel maiores. Iure debitis ea fugit sit. Ut id sint eveniet officia ex esse ut. Consequuntur blanditiis voluptatem porro autem sunt commodi qui.
Eum consectetur aut ea. Temporibus laborum voluptatem aut commodi sit consectetur. Adipisci vel facilis est aut voluptatem consequatur et. Itaque blanditiis qui ab voluptatem dolorem nemo optio. Commodi quos vitae cupiditate. Repellendus consequuntur consequatur tempore et ab illum et. Eveniet tempora harum impedit dicta quia et nulla.
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...