ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Amortization table- formula for interest - everything else is okay -Please help! Thank you (https://www.excelbanter.com/excel-discussion-misc-queries/245531-amortization-table-formula-interest-everything-else-okay-please-help-thank-you.html)

[email protected]

Amortization table- formula for interest - everything else is okay -Please help! Thank you
 
I have not modeling in amort table in over five years and cannot
format the cell for interest (I forgot). Everything else looks good.
I have already solved for pmt, have BOY balance, so I just need the
interest portion to obtain the principal amount to subtract from Begin
of Y to get end of year. Can someone please help? THANK YOU!


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com