can i please have the formula but not EXCEL and can you please round off to the nearest cent , thumb ups will be provided

An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8.8%. Bond C pays a 12% annual coupon, while Bond Z is a zero coupon bond.

1. Assuming that the yield to maturity of each bond remains at 8.8% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Round your answer to the nearest cent.

Years to Maturity	Price of Bond C	Price of Bond Z
4	$	$
3	$	$
2	$	$
1	$	$
0	$	$

1. Plot the time path of prices for each bond. The correct sketch is ??

CENGAGE MINDTAP Chapter 9 Practice Problems b. Plot the time path of prices for each bond. A Bond Pice $1200 Pond 51000 5800 5600 Sond Z 5400 5200 50 3 Yeas to Maurity B Bond Price! $1200 Bond Z $7000 $800 bond 5600 5400 5200 SO 3 Years to Maturity Bond Price $1200 Bond C 51000 $800 5600 Bond Z $400 $200 50 3 Years to Maurity D Bond Pice $1200 Bond Z 51000 5800 5600 Bond $400 $200 50 1 Years to Maturity The correct sketch is-Select