Question: Input the required data into Columns B-G and calculate the following: 1. Calculate the annual nominal return (2010-2020) for the stock in column H. 2.

Input the required data into Columns B-G and calculate the following: 1. Calculate the annual nominal return (2010-2020) for the stock in column H. 2. Calculate the annual nominal return (2010-2020) for the market in column I. 3. Calculate the annual nominal return (2010-2020) for the risk-free asset in column J. 4. Calculate the annual rate of inflation (2010-2020) in Column K. (Use the four-quarter average.) 0 Answer to Part 1 Year End of year price of stock 2010 14.9 2011 11.99 2012 8.5 2013 7.24 2014 9 2015 3.5 2016 6 2017 6.5 2018 6.2 2019 11.49 2020 13.2 Average Standard deviation Dividend per share of stock Value of ASX All Ordinaries Index 0 4846.9 4111 0 4664.6 0 5353.1 0 5388.6 0.17 5344.6 0.17 5719.1 0.17 6167.3 0.58 5709.4 0.88 6802.4 0.56 6850.6 Dividend yield of ASX All Ordinaries Index (%) Risk Free rate (%) 3.68 5.03 5.05 4.51 4.28 3.11 3.95 2.61 4.19 2.75 4.62 2.34 1.78 3.98 1.77 4.47 2.02 3.99 0.90 2.81 0.02 Inflation (%) 2.8 3.0 2.2 2.7 1.7 1.7 1.5 1.9 1.8 1.8 0.9 4.04 ? 5. Calculate the exact annual real return (2010-2020) for the stock in column L. 6. Calculate the exact annual real return (2010-2020) for the market in column M. 7. Calculate the exact annual real return (2010-2020) for the risk-free asset in column N. Input the required data into Columns B-G and calculate the following: 1. Calculate the annual nominal return (2010-2020) for the stock in column H. 2. Calculate the annual nominal return (2010-2020) for the market in column I. 3. Calculate the annual nominal return (2010-2020) for the risk-free asset in column J. 4. Calculate the annual rate of inflation (2010-2020) in Column K. (Use the four-quarter average.) 0 Answer to Part 1 Year End of year price of stock 2010 14.9 2011 11.99 2012 8.5 2013 7.24 2014 9 2015 3.5 2016 6 2017 6.5 2018 6.2 2019 11.49 2020 13.2 Average Standard deviation Dividend per share of stock Value of ASX All Ordinaries Index 0 4846.9 4111 0 4664.6 0 5353.1 0 5388.6 0.17 5344.6 0.17 5719.1 0.17 6167.3 0.58 5709.4 0.88 6802.4 0.56 6850.6 Dividend yield of ASX All Ordinaries Index (%) Risk Free rate (%) 3.68 5.03 5.05 4.51 4.28 3.11 3.95 2.61 4.19 2.75 4.62 2.34 1.78 3.98 1.77 4.47 2.02 3.99 0.90 2.81 0.02 Inflation (%) 2.8 3.0 2.2 2.7 1.7 1.7 1.5 1.9 1.8 1.8 0.9 4.04 ? 5. Calculate the exact annual real return (2010-2020) for the stock in column L. 6. Calculate the exact annual real return (2010-2020) for the market in column M. 7. Calculate the exact annual real return (2010-2020) for the risk-free asset in column N

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Refer back to the beginning of this chapter to the excerpt from a Los Angeles Times article about Reed Slatkin's fraud. The article insinuates that the FBI and IRS's raiding of Slatkin's office...

Calculate the annual nominal return (2010-2020) for the stock in column H (in decimals). Calculate the annual nominal return (2010-2020) for the market in column I (in decimals). Present the annual...

Calculate the annual nominal return (2010-2020) for the stock (in decimals). 2. Calculate the annual nominal return (2010-2020) for the market (in decimals). 3. Present the annual nominal return...

1. Calculate the annual nominal return (2011-2020) for the stock in column H (in decimals). 2. Calculate the annual nominal return (2011-2020) for the market in column I (in decimals). 3. Present the...

DATA EXERCISE #1 Due at the end of week 3 Format of the Project: The Data Exercise must be posted to the LEO Student Assignments as a Attachments are limited to a maximum two files in doc, docx.,...

Part 1: Expenditures Approach to Calculating GDP (weight 45% of the assignment grade) BEA estimates the nation's GDP for each year and each quarter. But new GDP statistics are released every month....

Saving for Retirement Assume an investor begins saving for retirement at age 25 and retires at age 65. Each year, she contributes $5,000 to her retirement account and her employer matches this...

BEA estimates the nation's GDP for each year and each quarter. But new GDP statistics are released every month. Why? Because for each quarter, BEA estimates GDP three times. The advance estimate,...

Do everything in Excel, and upload your Excel spreadsheet to blackboard. Late assignments will not be accepted, please be sure you upload the correct file. You have $12,000 to invest today. Based on...

Why is it difficult to assign a dollar figure to an intangible cost? When and how can it be done? Provide an example with your explanation.

Let X and Y be 2x2 matrices with integer entries such that []+ X'+Y'. Find the matrices X and Y.

Transaction / EventFinancial RatioEffecta. Split the common stock 2 for 1 . Book value per share of common stock b . Collected accounts receivable.Number of days' sales in accounts receivable c ....

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".