Need help in doing a financial bond valuation analysis can you please show me how to do it step-by-step with the calculations

Need to analyze 8 outstanding bonds. By calculating credit spread of this bond by comparing the yield-to-maturity on this bond with the yield on Treasury bonds of comparable duration all info is on Investing website in historical data and Yahoo Finance in the U.S. treasury yield. With the estimation of the bonds price one year from now by keeping the assumption it will remain consistent. Also need an explanation for the reason behind the expected price change from the current price of the bond. Then provide a credit rating for the firms bonds, based on your analysis of the company bond and explain why you have given this rating Step-By-Step including the calculation.

Additional info from findings down Below:

Recent Historical Bond Data: Pfizer Inc PFE 7.2% 15-Mar-2039 (717081CY7=) 136.314 +0.563 +0.42%

Date	Price	Open	High	Low	Change %
May 22	136.314	134.069	134.069	134.069	0.69%
Apr 22	135.387	146.867	146.867	146.867	-7.64%
Mar 22	146.590	149.740	149.740	149.740	-1.78%
Feb 22	149.254	153.402	153.402	153.402	-2.74%
Jan 22	153.456	158.751	158.751	158.751	-4.58%
Dec 21	160.829	162.352	162.352	162.352	0.44%
Nov 21	160.118	160.475	160.475	160.475	-0.28%
Oct 21	160.567	161.667	161.667	161.667	-0.51%
Sep 21	161.384	163.788	163.788	163.788	-1.09%
Aug 21	163.161	165.930	165.930	165.930	-1.32%
Jul 21	165.346	163.390	163.390	163.390	1.62%
Jun 21	162.702	157.767	157.767	157.767	3.03%
May 21	157.911	158.961	158.961	158.961	0.14%
Apr 21	157.684	156.904	156.904	156.904	1.44%
Mar 21	155.440	160.264	160.264	160.264	-3.61%
Feb 21	161.264	165.156	165.156	165.156	-2.55%
Jan 21	165.488	171.374	171.374	171.374	-3.54%
Dec 20	171.556	170.824	170.824	170.824	-0.31%
Nov 20	172.097	164.438	164.438	164.438	4.33%
Oct 20	164.958	166.521	166.521	166.521	-0.93%
Sep 20	166.501	167.610	167.610	167.610	-0.14%
Aug 20	166.730	174.049	174.049	174.049	-5.44%
Jul 20	176.317	166.167	166.485	165.823	5.93%

Highest: 174.049

Lowest: 134.069

Difference: 39.980

Average: 159.611

Change %: -18.099

Bonds Bond Results +Issuer Name PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC Callable Sub-Product Type Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Symbol PFE4989484 Yes PFE4989485 Yes Yes PFE4989487 PFE4989488 Yes Yes PFE5241578 PFE4125871 PFE4297188 PFE4297190 PFE4369660 PFE4369662 PFE4426176 PFE4426183 PFE4685498 PFE4805580 Ratings Moody's S&P A2 A+ A+ A+ A+ A+ NR NR 0.800 05/28/2025 1.700 05/28/2030 A2 2.550 05/28/2040 A2 2.700 05/28/2050 A2 1.750 08/18/2031 A2 2.100 05/15/2019 WR 5.200 08/12/2020 WR 5.800 08/12/2023 WR 1.450 06/03/2019 WR 1.950 06/03/2021 WR 1.700 12/15/2019 WR 2.200 12/15/2021 WR 3.000 09/15/2021 WR 2.800 03/11/2022 WR NR NR NR AA- NR NR NR Previous 1 22 Coupon Maturity Last Sale Price Yield 94.428 2.753 87.233 3.549 82.916 3.878 80.980 86.080 3.811 3.533 99.999 2.506 100.013 0.507 0.792 113.418 3.675 99.987 100.884 0.238 99.996 2.162 100.005 0.396 100.008 0.118 99.992 3.709 of 2 GO Bonds Bond Results Issuer Name PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC Callable Sub-Product Type Symbol PFE.GM Yes Corporate Bond PFE4013012 Yes Corporate Bond PFE4013018 Yes PFE4125872 Yes PFE4125867 Yes PFE4297191 Yes PFE4369661 Yes PFE4426182 Yes PFE4426177 Yes Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond PFE4426178 Yes PFE4685496 PFE4685495 Yes PFE4685497 Yes PFE4685494 Yes PFE4685493 Yes PFE4805581 Yes PFE4805582 Yes PFE4805669 Yes PFE4805670 Yes Corporate Bond Corporate Bond Corporate Bond Corporate Bond PFE4971095 Yes Ratings Moody's S&P Coupon Maturity 03/15/2039 A2 A+ 7.200 3.000 06/15/2023 A2 A+ A+ A+ A+ A+ 4.300 06/15/2043 A2 3.400 05/15/2024 A2 4.400 05/15/2044 A2 5.600 09/15/2040 A2 2.750 06/03/2026 A2 3.000 12/15/2026 A2 4.000 12/15/2036 A2 4.125 12/15/2046 A2 1.156 09/15/2023 A2 A+ A+ A+ A+ A+ A+ A2 A+ 3.200 09/15/2023 A2 3.600 09/15/2028 4.100 09/15/2038 4.200 09/15/2048 A+ A+ 2.950 03/15/2024 A+ A+ 3.450 03/15/2029 03/15/2039 3.900 A2 A+ 4.000 03/15/2049 A2 A+ 2.625 04/01/2030 A2 A+ 1 2 Next 1 2 2 2 2 2 A2 A2 A2 A2 Last Sale Price Yield 137.481 4.091 100.533 2.477 102.058 4.152 101.776 2.464 103.534 4.153 117.876 4.190 98.695 3.099 99.646 3.084 101.713 3.845 100.121 4.117 100.163 101.340 2.068 102.097 3.215 101.392 3.980 101.657 4.095 100.885 2.417 3.575 99.250 98.637 4.012 99.539 4.028 3.539 93.794 of 2 GO Bonds Bond Results +Issuer Name PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC Callable Sub-Product Type Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Symbol PFE4989484 Yes PFE4989485 Yes Yes PFE4989487 PFE4989488 Yes Yes PFE5241578 PFE4125871 PFE4297188 PFE4297190 PFE4369660 PFE4369662 PFE4426176 PFE4426183 PFE4685498 PFE4805580 Ratings Moody's S&P A2 A+ A+ A+ A+ A+ NR NR 0.800 05/28/2025 1.700 05/28/2030 A2 2.550 05/28/2040 A2 2.700 05/28/2050 A2 1.750 08/18/2031 A2 2.100 05/15/2019 WR 5.200 08/12/2020 WR 5.800 08/12/2023 WR 1.450 06/03/2019 WR 1.950 06/03/2021 WR 1.700 12/15/2019 WR 2.200 12/15/2021 WR 3.000 09/15/2021 WR 2.800 03/11/2022 WR NR NR NR AA- NR NR NR Previous 1 22 Coupon Maturity Last Sale Price Yield 94.428 2.753 87.233 3.549 82.916 3.878 80.980 86.080 3.811 3.533 99.999 2.506 100.013 0.507 0.792 113.418 3.675 99.987 100.884 0.238 99.996 2.162 100.005 0.396 100.008 0.118 99.992 3.709 of 2 GO Bonds Bond Results Issuer Name PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC PFIZER INC Callable Sub-Product Type Symbol PFE.GM Yes Corporate Bond PFE4013012 Yes Corporate Bond PFE4013018 Yes PFE4125872 Yes PFE4125867 Yes PFE4297191 Yes PFE4369661 Yes PFE4426182 Yes PFE4426177 Yes Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond Corporate Bond PFE4426178 Yes PFE4685496 PFE4685495 Yes PFE4685497 Yes PFE4685494 Yes PFE4685493 Yes PFE4805581 Yes PFE4805582 Yes PFE4805669 Yes PFE4805670 Yes Corporate Bond Corporate Bond Corporate Bond Corporate Bond PFE4971095 Yes Ratings Moody's S&P Coupon Maturity 03/15/2039 A2 A+ 7.200 3.000 06/15/2023 A2 A+ A+ A+ A+ A+ 4.300 06/15/2043 A2 3.400 05/15/2024 A2 4.400 05/15/2044 A2 5.600 09/15/2040 A2 2.750 06/03/2026 A2 3.000 12/15/2026 A2 4.000 12/15/2036 A2 4.125 12/15/2046 A2 1.156 09/15/2023 A2 A+ A+ A+ A+ A+ A+ A2 A+ 3.200 09/15/2023 A2 3.600 09/15/2028 4.100 09/15/2038 4.200 09/15/2048 A+ A+ 2.950 03/15/2024 A+ A+ 3.450 03/15/2029 03/15/2039 3.900 A2 A+ 4.000 03/15/2049 A2 A+ 2.625 04/01/2030 A2 A+ 1 2 Next 1 2 2 2 2 2 A2 A2 A2 A2 Last Sale Price Yield 137.481 4.091 100.533 2.477 102.058 4.152 101.776 2.464 103.534 4.153 117.876 4.190 98.695 3.099 99.646 3.084 101.713 3.845 100.121 4.117 100.163 101.340 2.068 102.097 3.215 101.392 3.980 101.657 4.095 100.885 2.417 3.575 99.250 98.637 4.012 99.539 4.028 3.539 93.794 of 2 GO