In an excel format, can you please solve the following! thank you!

Calcalate the Cament Price or the Rate of Roum of the fve bonds listed below (40 points) 8 points each question) For Rate use Fomula, Financial Rae Sor Cumnt Price use Fomla Financial PV or RATE or-PV If esing PVS Values Entesed as Negative Numben If esing Rate Present Value is a negative Futue vale a positive Requind Rate of Retum Years to Maturity Coupon Rate (Payment 8.00% 15 6.00% Par Valae $1,000.00 2) |Requied Rase of Retaum 4.00% Years to Maturity Coupoa Rate (Payment) 15 6.00% Pase Value and Futuse Value $1,000.00 3) | Requised Rate of Retum 6.00% Years to Maturity Coupoa Rate Payment) 15 6.00% Pase Value and Futue Value $1,000.00 4) Years to Maturity Aaaual Iaterest Payment 15 $70.00 $1,050.00 $1,000.00 Present Value Fature Value 4) 20 Years to Matunity Aasual Interest Payment $80.00 $950.00 $1,000.00 Present Value |Future Value Calcalate the Cament Price or the Rate of Roum of the fve bonds listed below (40 points) 8 points each question) For Rate use Fomula, Financial Rae Sor Cumnt Price use Fomla Financial PV or RATE or-PV If esing PVS Values Entesed as Negative Numben If esing Rate Present Value is a negative Futue vale a positive Requind Rate of Retum Years to Maturity Coupon Rate (Payment 8.00% 15 6.00% Par Valae $1,000.00 2) |Requied Rase of Retaum 4.00% Years to Maturity Coupoa Rate (Payment) 15 6.00% Pase Value and Futuse Value $1,000.00 3) | Requised Rate of Retum 6.00% Years to Maturity Coupoa Rate Payment) 15 6.00% Pase Value and Futue Value $1,000.00 4) Years to Maturity Aaaual Iaterest Payment 15 $70.00 $1,050.00 $1,000.00 Present Value Fature Value 4) 20 Years to Matunity Aasual Interest Payment $80.00 $950.00 $1,000.00 Present Value |Future Value