Question
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.
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started