How do you calculate present face value in Excel for Bond Amortization? I thought I was doing it right, however the answer I am getting doesn't look right. C11 T 2345 pr co o A B Bond Details Date Face Value Contract Rate Effective Rate 6 7 Life (years) 8 Payments per Year VII 9 10 11 Present Value 12 Future Value 13 Payment 14 C Bond Calculations J 1/1/2021 $140,000.00 8% 7% 6 4

$146,811.24 $140,000.00 c SERV D =PV (C6/C8,C7* C8,-C4*C5/C8,-C4) TYMIIMSI E F G

How do you calculate present face value in Excel for Bond Amortization? I thought I was doing it right, however the answer I am getting doesn't look right