Please include the excel formula You’ve observed the following returns on Pine Computer’s stock over the past five years: 8 percent, −12 percent, 14 percent, 21 percent, and 16 percent. Suppose the average inflation rate over this period was 3.1 percent and the average T-bill rate over the period was 3.9 percent. What was the average real return on the company’s stock? What was the average nominal risk premium on the company’s stock over this period? Input area: Year Returns 1 8% 2 -12% 3 14% 4 21% 5 16% Average inflation 3.10% Average T-bill rate 3.90% (Use cells A6 to B13 from the given information to complete this question. You must use the built-in Excel function to answer this question. Make sure to use the “sample” Excel formula.) Output area: Average return Average real return Average risk premium

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter8: Risk And Rates Of Return

Section: Chapter Questions

Problem 18PROB

See similar textbooks

Related questions

Question

Please include the excel formula

You’ve observed the following returns on Pine Computer’s stock over the past five years: 8 percent, −12 percent, 14 percent, 21 percent, and 16 percent. Suppose the average inflation rate over this period was 3.1 percent and the average T-bill rate over the period was 3.9 percent. What was the average real return on the company’s stock? What was the average nominal risk premium on the company’s stock over this period?

Input area:

Year	Returns
1	8%
2	-12%
3	14%
4	21%
5	16%
Average inflation	3.10%
Average T-bill rate	3.90%

(Use cells A6 to B13 from the given information to complete this question. You must use the built-in Excel function to answer this question. Make sure to use the “sample” Excel formula.)


Output area:

Average return
Average real return
Average risk premium

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions