Please help me solve the following questions and provide the excel formulas. Thanks in advance.

8 You may solve this problem with or without building a cash flow timeline, whichever works best for you.

Find the YTM on the following bond:

Face Value 1000

Coupon Rate 8%

Number of Years Until Maturity 10

Number of Payments Per Year 1

Price of the Bond 1020

A. 7.71%

B. 3.86%

C. 8.00%

D. 8.91%

9 If the same bond in Part G may be called in 5 years for $1050, what is the yield-to-call?

A. 7.51%

B. 8.05%

C. 8.84%

D. 8.34%

Find the YTM on the following bond: Find the YTM: Yield To Call Bond may be called in ... years: Call premium on bond: Yield to call