Estimating Betas: Real-world example #2 🧮
Calculate beta of the P&G stock!
Use the monthly returns for the last 5 years: i.e. 2019-2023.
S&P 500 will be the proxy for the market portfolio.
Lastly, regress P&G’s returns on the market returns and calculate beta that way for the monthly case!
Rely on publicly available data resources and compare your results with the values already calculated on these platforms! Explain the difference or the similarity!
Estimating Betas: Real-world example 🧮
Calculate beta of the Visa stock!
Use the monthly returns for the last 5 years.
S&P 500 will be the proxy for the market portfolio.
Lastly, regress Visa’s returns on the market returns and calculate beta that way for the monthly case! Rely on publicly available data resources and compare your results with the values already calculated on these platforms!
Explain the difference or the similarity!
Create an additional model for which every input value is the same except for market portfolio being NASDAQ!
Assume that Hyrule Electronics is an all-equity firm producing and marketing video game consoles and software. Hyrule has a beta of 1.35. The market risk premium is 7.2% and the risk-free rate is 3.5%.
There are three projects Hyrule is considering investment. Projects have the same beta as that of the firm. What should the discount rate be for these projects?
Also, each project requires an investment of $1,000,000 and lasts for a single year after the initial investment. Project A’s expected cash flows next year is $1,500,000, B’s $1,250,000, and C’s $1,050,000.
Calculate each project’s IRR and NPV!
Which projects should Hyrule invest considering that each project is independent? Plot the security market line (SML), label the regions within which you should accept or reject a project, also show each project on that plot!
How to account for the changes in depreciation estimates 🧮
Assume that Sega purchased an arcade cabin production machinery for $80,000,000 with an estimated useful life of 15 years and estimated residual value of $5,000,000. Shortly after the start of Year 6, Sega changed the initial estimated life to 10 years and lowered the estimated residual value to $7,500,000.
What will be the depreciation expense that needs to be recorded by Sega from Year 6 onwards?
Statistical modeling in corporate finance: Determining beta 🔮
As a statistical measure, beta estimation is prone to measurement error.
Which of the following inputs do affect beta estimates?
-Time period observed
-Time interval used
-Market portfolio against which the individual stock is benchmarked
-Whether close or adjusted close values are used
Understanding Inventory Valuation for Automakers, a real-world example: Medium
From the courses I have been teaching 📖
The following note was contained in a recent Ford Motor Company annual report:
Inventory Valuation–Automotive.
Inventories are stated at the lower of cost or market. The cost of most US inventories is determined by the last-in, first-out (“LIFO”) method. The cost of the remaining inventories is determined substantially by the first-in, first-out (“FIFO”) method.
If FIFO were the only method of inventory accounting used by the company, inventories would have been $1,235 million higher than reported this year and $1,246 million higher than reported last year.
1. Determine the ending inventory that would have been reported in the current year if Ford had used only FIFO.
2. The cost of goods sold reported by Ford for the current year was $74,315 million. Determine the cost of goods sold that would have been reported if Ford had used only FIFO for both years.
3. If the company had always used FIFO, what would have been the effects on taxes and retained earnings? Assume 30% marginal tax rate.
Management Science Series #157: Solution to the Detective Marvel Action Figures Company 🕵️
See the question in here:
https://shorturl.at/bswG8
Refer to Amazon 10-K for the year 2020.
Record summary journal entries related to the allowance for doubtful accounts for the current year!
What was the effect of bad debt expense entry on “Income before income taxes?” What was the effect on “Net cash provided by operating activities?”
What was the effect of the write-off entry on “Income before income taxes?” What was the effect on “Net cash provided by operating activities?”
Did bad debt expense as a percentage of Net revenues increase or decrease from 2019 to 2020?
Did management disclose any information indicating the reason for the increase or decrease?
—
Assume that all of Amazon’s sales to customers are on account. Its 10-K indicates that $1 billion bad (trade) accounts receivable were written-off in 2020 and there were no reinstatements. Bad debt expense for the period were recorded by debiting “General and Administrative Expenses” and crediting the “Allowance for doubtful accounts.” What amount of bad debt expense was recorded in 2020?
Assuming all sales revenues were on account, what were collections on accounts receivable during 2020?
Learn Finance. 💹
At least the basics.
Whether you use it for your retirement, financial independence or investment plans, you are required to know the basics of finance. 💰
Up for a quick test ⬇️
-You plan to retire within 20 years from now.
-You need to cover first 5 years of your retirement through your own savings.
-You think that during these first 5 years of your retirement, your expenses will run $200,000 per year.
-You have found an investment vehicle that will help you earn 9% annually on your savings throughout the following decades.
Question:
How much money should you save each year on average, i.e. in terms of equal amounts per year, until your retirement so that you will solely rely on these savings without running out of money throughout the first 5 years of your retirement?
A portfolio that combines the risk-free asset and the market portfolio has an expected return of 9% and a standard deviation of 13%.
The risk-free rate is 5% and the expected return on the market portfolio is 14%.
Assume that the CAPM holds in that market!
What expected return should a security earn if it has a 0.53 correlation with the market portfolio and a standard deviation of 61%?
