Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Glenn
 
Posts: n/a
Default Loan Amortization Template - Amount of Final Payment

Hi -- In using one of the updated loan amortization templates, I noticed that
the amount of the final payment does not appear to be correct. The amount
should be the "beginning [principal] balance" immediately before the final
payment + the interest that will accrue on that amount for the final month.
Instead, the template makes the total final payment an amount equal to the
"beginning balance" and then deducts the interest component from that amount.
Is there a bust in the formula?

Thanks very much.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"