Answered: "A stock has yielded 15.3%, 10.8%,…

"A stock has yielded 15.3%, 10.8%, 5.2%, -3.4%, and 14% over the past five years, respectively. What is the geometric average return? " Please use excel to answer

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter8: Risk And Rates Of Return

Section: Chapter Questions

Problem 17PROB

See similar textbooks

Related questions

Q: The current value of shares in Arden Holdings plc is £5.00. Arden Holdings plc is not expected to…

A: A forward contract is an agreement between two parties to exchange an underlying asset on a future…

Q: An installment contract for the purchase of a car requires payments of $206.33 at the end of each…

A: A loan is a financial arrangement in which one or more people, companies, or other entities lend…

Q: Suppose that your unsubsidized Stafford loans plus accumulated interest total $35000 at the time you…

A: Loan amount is $35000 Interest rate is 9% Time period is 10 years To Find: Fixed Monthly repayment

Q: A project capitalized for P 50,000 in depreciable assets will earn a uniform annual income of P…

A: The process through which an entity evaluates any investment or project's profitability and decides…

Q: 10. Find the optimal investment strategy when 4 dollars is to be invested in between two projects…

A: We have to find the optimal split of total wealth of $ 4 between two projects whose returns are…

Q: The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these…

A: Month Cola Co.(Rc) Gas Co.(Rg) January 6% 9.60% February -1.40% 5.30% March -0.80% -2.50%…

Q: John and Susan just opened saving accounts at two different banks. They each deposited $1000. John's…

A: In case of simple interest the interest is computed and paid only on the principal amount. In…

Q: Problem 19-14 APV Consider a project lasting one year only. The initial outlay is $1,000 and the…

A: Adjusted present value (APV) Adjusted present value (APV) is calculated as shown below. APV=Base…

Q: Complete the following table: Purchase price of product Landcruiser Down payment Amount…

A: Amount financed is calculated as Amount financed = Purchase price of product - Down payment =…

Q: The MLA investments purchased a machine a few years ago. The original cost of the machine was…

A: Particulars Values Original cost of machine $ 1,40,000.00 Project life 5 years Sale…

Q: What is the amount of the annual interest tax shield for a firm with £3 million in debt that pays…

A: Interest payment. Given the loan value = pound 3 million Interest payable =12%= So total interest =…

Q: debt coverage ratio? b. What is the terminal capitalization rate

A: The debt-service coverage ratio is a frequently used measure of a company's financial health,…

Q: An oil and gas company is trying to determine whether or not it should replace a fixture on one of…

A: Concept. Future worth (FW) method. In this method, future value of all the cash flows associated…

Q: Activity 5. My Family's Financial Management during the Lockdown! As a financial manager in your…

A: Managing finance is a very difficult task, and lockdown has made it more tedious. For a family of…

Q: Ramon Hernandez saw the following advertisement for a used Volkswagen Bug and decided to work out…

A: Here, Particulars Values Cash price $ 7,850.00 Down payment $ - Amount…

Q: Adamson Corporation is considering four average-risk projects with the following costs and rates of…

A: Different sources of capital are available. We have to find the component cost and then WACC.…

Q: put option and a call option with an exercise price of $50 expire in three months and sell for $.84…

A: The call and put options give you the opportunity to buy or sell the stocks on the expiration date…

Q: Engr. Gundran wishes his son to receive 10,813 10 years from now. What amount should he invest if it…

A: The money's time worth concept indicates that money is worth more currently as compared to its worth…

Q: How were the depreciation rate and the PV factor at 12% calculated? (the equations)

A: Depreciation rate for 3 year MACRS is provided in the table and is universally available.…

Q: Business cycles vary in the time between recessions but not in the length of recessions. vary in the…

A: Several statements have been made about the length and timing of business cycles. We have to find…

Q: Based on the information in the yellow shaded areas: a) Plot the Security Market Line (SML) b)…

A: We need to plot the SML and then CAPM required return for each stock. We need to find which of them…

Q: [The following information applies to the questions displayed below] Following is information on an…

A: Net present value is important capital budgeting methods and most commonly used and this can be…

Q: Massy Ltd on the other hand is a matured company so their dividend has not changed in years. Their…

A: The value of security can be find out the from dividend discount model and can be calculated as the…

Q: Regarding the EPS fallacy, which of the following statements is correct: a. When a company issues…

A: Several statements have been made about the EPS fallacy. We have to find the statement that is…

Q: Using Table 19-1 and 19-2 Calarlate the annual, Semi annual, quarterly and monthlg (in $) for the…

A: In a contract between an insurance policy holder and an insurer or assurer known as life insurance,…

Q: 7) An investment without any initial outlay promises to pay $100 one year from today, $200 two years…

A: IRR The rate at which the difference between cash inflow and cash outflow equals zero is known as…

Q: er year, and insurance is $360 per year. They are requesting a conventional loan from the local…

A: Mortgage loans are necessary to obtain the loans and mortgage make the purchase of home easy but…

Q: intenance cost of an equipment is P20000 for 2 years, P40000 at the end of 4 years and P80000 at the…

A: The amount to be kept aside depends on the interest rate and period of the deposit for which…

Q: Current prices on Sterling options include the following. Sterling options £500,000 Strike price…

A: We have to find the appropriate risk management technique using options to hedge an exposure to the…

Q: Calculate the preferred and common dividend per share in dollars for the company. If there is no…

A: A dividend per share refers to an amount that is paid to all the shareholders according to the…

Q: ABC Company Limited looking to invest in one of the proposed projects. The cost of that project is…

A: First we need to calculate NPV of project by using both interest rates. NPV =PV of all cash inflows…

Q: discuss the advantages and disadvantages of economic value added for performance measurement

A: Economic value added was developed in 1983 to measure the value that companies generate and is based…

Q: Cari Pump (CP) Company is considering either upgrading or replacing its production equipment. The…

A: The choice between upgrading or replacing the equipment is to be made. You have specifically asked…

Q: what formula was used to find ordinary annuity and annuity due?

A: The concept of the time value of money determines that the worth of money gets depreciated over a…

Q: A friend lends you $830, which you agree to repay with 5% interest. How much will you have to…

A: Given The amount borrowed is $830 Interest rate is 5%

Q: financial institution that invests $100 million into corporate bonds is exposed to which of the…

A: Bond A type of financial instrument that helps companies to raise funds to meet their financial…

Q: -You must decide whether to produce “Straight Out of New Canaan”, a biographical film about four…

A: The internal rate of return is where NPV is zero or the present value of cash flows is equal to the…

Q: Five years ago, you invested in the Future Investco Mutual Fund by purchasing 1,000 shares of the…

A: Value of investment purchased = Number of shares purchased*Net asset value per share at the time of…

Q: With reference to question #8, assume inflationary expectations rise by 1%. As a result, interest…

A: Given that the interest rate increased by 1% due to inflation Dividend growth also increased by 1%…

Q: Q4 Rank from highest credit risk to lowest risk the following bonds, with the same time to…

A: Solution:- Credit risk means the risk of default of payment from the borrower. In case of bonds,…

Q: According to the critics of stock price maximisation, “A practical problem with stock price as a…

A: As per the given statement, rise or fall in share price of a company does not indicate improvement…

Q: You borrow 112000 for 10 years from a bank in order to renovate your flat. The effective interest…

A: Whenever a loan is taken or some amount is borrowed by a person he wants to calculate the repayments…

Q: QUESTION 6 You are considering starting a new factory producing small electric heaters. Each unit…

A: concept. Internal rate of return is rate of return at which present value of cash inflows is equal…

Q: en experiencing a severe cash shortage. As one part of your analysis, you want to determine the…

A: Net Working Capital is the excess of Current Assets over its Current Liabilities. It helps in…

Q: Mr. Anthony orally agreed to sell his refrigerator for P10,000 to Ms. Johnson who made a partial…

A: A situation has been provided. We have to find out if the sale is valid and hence can be enforced.

Q: Inc. maintains a cash buffer for unexpected cash outlays for the year amounting to 3,000. Bank of…

A: The median balances between Chase checking and savings accounts are used to establish the actual…

Q: True or False: The following statement accurately describes how firms make decisions related to…

A: A paragraph is given describing how firm decides to issue new equity. An issuance of equity is…

Q: as of September 2016. Use the stock price arbitrage equation to calculate the no-arbitrage price of…

A: No Arbitrage price of stock formula = (Dividend/riskfree - growth rate)*100 FIRM Dividend(a) RF…

Q: Vilas Company is considering a capital investment of $198,900 in additional productive facilities.…

A: For a typical capital budgeting project, we have to find the cash payback period, annual rate of…

Q: Suppose Intel stock has a beta of 0.73, whereas Boeing stock has a beta of 1.3. If the risk-free…

A: As per guidelines we are supposed to answer only 3 sup-parts Expected return on each stock is…

Question

5."A stock has yielded 15.3%, 10.8%, 5.2%, -3.4%, and 14% over the past five years, respectively. What is the geometric average return? "

Please use excel to answer

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

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

Looking at Morningstars Profitability ratios, what has happened to Hewlett Packards profit margin (net margin %) over the past 10 years? What has happened to its return on assets (ROA) and return on equity (ROE) over the past 10 years?
A stock is trading at $80 per share. The stock is expected to have a yearend dividend of $4 per share (D1 = $4), and it is expected to grow at some constant rate, g, throughout time. The stock’s required rate of return is 14% (assume the market is in equilibrium with the required return equal to the expected return). What is your forecast of gL?
A stock has had returns of −19.2 percent, 29.2 percent, 26.4 percent, −10.3 percent, 35 percent, and 27.2 percent over the last six years. What are the geometric returns for the stock? & is there an excel function for it
Suppose a stock has generated the following annual returns: 13.6%, -12.1% and 7.6%. What was its compound average annual return? Answer in percent, rounded to two decimal places (e.g., 4.32% = 4.32).
A stock has had returns of -7.77 percent, -4.59 percent, 5.87 percent, 9.98 percent, 8.7 percent, and 11.27 percent over the last six years. What is the geometric average return for the stock? Answer as a percentage to two decimals (if you get -0.0435, you should answer -4.35).
Suppose a stock has generated the following annual returns: 11.4%, -7.9% and 5.4%. What was its total return during that period? Answer in percent, rounded to two decimal places (e.g., 4.32% = 4.32).
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.)…
A stock had returns of 11.57 percent, -15.55 percent, 21.95 percent, 27.00 percent, and 10.50 percent over the past five years. What was the geometric average return for this stock?
The common stock of Air United, Inc., had annual returns of 15.6 percent, 2.4 percent, -11.8 percent, and 32.9 percent over the last four years, respectively. What is the standard deviation of these returns? Group of answer choices 13.29 percent 14.14 percent 16.50 percent 17.78 percent 19.05 percent show your work please and let me know if we can solve it by financial calculator
A stock has had returns of 11 percent, 15 percent, 19 percent, and -48 percent over the last four years. What is the geometric average return over this period?
A stock has had returns of −19 percent, 29 percent, 24 percent, −10.1 percent, 34.8 percent, and 27 percent over the last six years. What is the geometric return for the stock?
A stock has had returns of 14 percent, −18 percent, 2 percent, 33 percent, 27 percent, and 6 percent over the last six years, respectively. What is the geometric return for this stock?