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!