1. Calculate the Value of CPBs debt. Show your work in excel please

Table 1: Market Data Rf 1.18% 10% RM BBB Yields: 9-months 2-year 3-year 5-Year 7-year 9-year 19-year 27-year 29-yar 0.94% 1.39% 1.82% 2.32% 2.70% 2.99% 3.81% 3.86% 3.85% Table 2: CPB Debt Securities: Description Finance Leases Maturity 2026 Amount 30,000,000 Coupon 0.800% Note Aug-02-2022 450,000,000 2.500% Note Mar-15-2023 566,000,000 3.650% Note Mar-15-2025 850,000,000 3.950% Note Mar-19-2025 300,000,000 3.300% Note Mar-15-2028 4.150% 1,000,000,000 500,000,000 Note Apr-24-2030 2.375% Note Aug-02-2042 163,000,000 3.800% Note Mar-15-2048 700,000,000 4.800% Note Apr-24-2050 500,000,000 3.125% Operating Leases 234,000,000 2.300% Table 3: Equity Price Per Share Dividends per share Shares outstanding $41.52 $1.48 Long-term Growth Rate Beta 301,518,000 1% 0.55 Table 4: Other Financial Data Total revenue EBITDA $ 8,476,000,000 $ 1,820,000,000 $ 328,000,000 $ 1,492,000,000 Taxes Operating Cash Flow Change in NWC Capital Spending 571,000,000 $ 300,000,000 $ 621,000,000 Free Cash Flow From the Firm Tax rate 24.55%