Use the 2021 annual Income Statement and Balance sheet from MarketWatch.com to calculate the cost of debt and the effective tax rate for Texas Instruments. In calculating the market capitalization of the company, use the last observation in your sample as the stock price, and obtain the number of outstanding shares from Yahoo.com.

Use the monthly returns on the Texas Instruments stock for the past 5 years (Start date: September 30, 2017 and end date: September 30, 2022) to compare against the monthly returns on the S&P 500 (^GSPC in Yahoo Finance!) for the same period.

Assume that the Annual risk-free rate (Rf) is 2.5%

Assume that the projected future risk-premium of the market is 4.0%.

Include the stock price data, your return calculations, the CAPM model estimation on the next spreadsheet EstBeta. Provide all necessary documentations of your work, if needed.

please fill out the excel with FORMULAS !! I will upvote