You will receive a lot of likes if you show the work in excel, a lot of students of this class are looking for these answers. Thank you

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% Review the accompanying market and financial information and answer the following questions: 1. Calculate the Value of CPB's debt. 2. Use the Capital Asset Pricing Model to calculate the required return on equity (Re) for CPB. 3. What is the market value of CPB's equity? 4. Calculate the WACC of CPB. 5. Calculate the unlevered (or asset) beta for CFP. Using your unlevered beta, what is the require return on asset (RA) for CPB? 6. What is the Total Enterprise Value (TEV) for CPB? From the TEV, what is the value of its equity? 7. Using the Dividend Discount Model, what is the value of CPB's stock? 8. Explain how else you can derive the value of CPB's equity. Use at least one of the models to value the company. 9. Based on your calculations, do you believe Campbell Soup is correctly, over- or underpriced? 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% Review the accompanying market and financial information and answer the following questions: 1. Calculate the Value of CPB's debt. 2. Use the Capital Asset Pricing Model to calculate the required return on equity (Re) for CPB. 3. What is the market value of CPB's equity? 4. Calculate the WACC of CPB. 5. Calculate the unlevered (or asset) beta for CFP. Using your unlevered beta, what is the require return on asset (RA) for CPB? 6. What is the Total Enterprise Value (TEV) for CPB? From the TEV, what is the value of its equity? 7. Using the Dividend Discount Model, what is the value of CPB's stock? 8. Explain how else you can derive the value of CPB's equity. Use at least one of the models to value the company. 9. Based on your calculations, do you believe Campbell Soup is correctly, over- or underpriced