I have been trying hard to figure how do we get the P&I amount given in the solutions using a calculater. I have a BA II plus. I tried entering the values given but I am missing someting. I’d appreciate if someone could help me figure it out.
This does not get you P&I, it only gets you P. However, the “I” is irrelevant in this question so this method would suffice for the first period. It needs to be done again for the second period by reducing “N” by 1. These two amounts (in addition to the prepayments) are the amounts by which you reduce the principal.
I’m pretty sure that calculation DOES get you the P&I. To get the P, we can multiply (WAC/12) by the Carrying Amount. Then, to get the prepayments for the period, we use this formula: SMM = (Prepayments)/(Carrying Amount - Scheduled Principle Prepayments). In this case, the “Prepayments” is the unkown, so we solve for that. Finally, we add the P amount with the Prepayments and subtract this Total from the current Carrying Value, which get us the next period’s carrying amount.
This does give you P&I. The PMT solved for gives the amortization payment asssuming no prepayments. You subtract the interest off the P&I PMT calculated to get the scheduled principal payment. The only reason it needs to be done again in the second period is because there was a prepayment which will change the annuity payment.
I keep getting the wrong number in the calculator as well. Something like $480,000 for monthly PMT for . This is something that would normally in my wheel house and find frustrating? I know I must be misisng something simple here…
That is strange, as your inputs should yield the correct answer with the fixed interest rate. I might suggest just resetting your calculator if you have the option? Also, sometimes it just helps to clear the tvm settings a couple times for good measure. Don’t know why but sometimes ill get a strange answer before I have cleared the tvm for a new problem. Sorry I couldn’t be more help, I was sure it was the interest rate that was throwing you off