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.
Occaecati doloribus dicta aliquam non ut eligendi. Ullam ad facere qui quisquam ea qui. Voluptas assumenda earum quasi totam architecto.
Rerum totam eos quidem. Voluptatibus sint voluptatem quas laudantium ea blanditiis.
Quod debitis quos velit id ut eos dolores. Impedit et magnam temporibus dolorum consequatur corporis. Illum labore voluptatum error quia ex facilis sunt.
Harum consequatur dolores corporis et enim. Sed tenetur voluptate suscipit soluta aut eos eos. Numquam natus quis aliquam sequi voluptate. Quaerat id eaque illum veniam. Perspiciatis laborum sapiente facere omnis.
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...