4a

A B C 1 Principal $200,000 2 Term years 30 3 initial 3 4 subsequent 27 5 Rate 6 initial 6% 7 subsequent 4% 8 Fees 1,500.00 9 Payment 1,008.69 10 Calculated rate 4.5247% 11 Payment calc 1,008.69 0.00 Excel 2003

Worksheet Formulas

Cell Formula B10 =RATE(B2*12,-B9,B1-B8,0.044/12)*12 C11 =FV(B7/12,B4*12,-B11,-FV(B6/12,B3*12,-B11,B1))

Welcome to the forum.

If you know the fixed payment amount, try the formula

"calculated rate".

If you need to calculate the payment, consider Goal Seek

with either an amortization chart or a formula like "Payment calc".

I used a guess of a payment of $1,000 and Goal Seek

calculated the required payment amount with the formula in the adjacent cell.

If you built an amortization chart, you could use Excel's function IRR.

## Like this thread? Share it with others