ssume that an investment is expected to generate the following returns: a 10% chance of a $1,400 return, a 50% chance of a $6,600 return, and a 40% chance of a $1,500 return. What is the expected rate of return on this investment? Note: The solution must be displayed on an Excel sheet using Excel functions such as =PV(...) and =FV(...) etc.

ssume that an investment is expected to generate the following returns: a 10% chance of a $1,400 return, a 50% chance of a $6,600 return, and a 40% chance of a $1,500 return. What is the expected rate of return on this investment? Note: The solution must be displayed on an Excel sheet using Excel functions such as =PV(...) and =FV(...) etc.

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter11: Risk-adjusted Expected Rates Of Return And The Dividends Valuation Approach

Section: Chapter Questions

Problem 4QE

See similar textbooks

Similar questions

How can we calculate the Rate-of-Return with Excel?
(Click on the icon here into a spreadsheet.) T in order to copy the contents of the data table below Investment X Y Z Expected return 17% 17% 17% Standard deviation 7% 8% 9%
What do you understand by TVM principle? Differentiate between commands of PV, PMT & FV in excel & explain with syntax and arguments. Solve for both PV & FV if CF is 3000, N is 5 and interest is 7%. Make Proper table to calculate both FV & PV step-wise
Can you have an investment with DCFRR > MARR, but NPV $0 (calculating NPV with iTyM=MARR)? Can you have an investment with DCFRR < MARR, and NPV < $0 (calculating NPV with iTyM=MARR)?
Please Calculate the Following using the Table Given. Beta Internal Rate of Return (IRR). Gamma’s Internal Rate of Return (IRR). The incremental Internal Rate of Return (ΔIRR) between the Alpha and Gamma harvesters (using Excel’s IRR function).
You are given the following data about Asset A and Asset B. Asset A Asset B Expected returns 8.6% 7.9% Standard Deviation 3.8% 4.6% Assuming that an investor is to choose between Asset A or Asset B, explain which asset a rational investor will choose. c) With the use of a diagram, explain why an investor will always choose a point on the SML line.
6. Use Excel, Calculator, and Formula. Show your work. Based on the data below, estimate the following: E(r) = [Probability of Economic State x Return in Economic State 0² (r) = [[Return in State; - E(r)]³ x Probability of State; a. Estimate the expected return and risk of Asset A (TESLA) b. Estimate the Expected Return and risk of Asset B (APPLE) c. Estimate the Expected return and risk of a 60A and 40B portfolio d. Summarize your results and determine whether the Portfolio Diversification helped decrease the investment risk. Explain your answer. State of the Economy Probability of Economic State S Pr 1 N 0.6 Return In Economic State TESLA APPLE R R 0.27 -0.10 -0.15 0.35
Could you show how to find the internal rate of return IRR using excel and the payback period for this problem?
Determine the present value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) Determine the present value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3. 4. Future Amount $ 25,000 $ 19,000 $ 30,000 $ 45,000 ¡= 6% 10% 12% 11% n = 11 14 29 10 Present Value
The expected value, standard deviation of returns, and coefficient o below.) \table[[Asset A],[Possible Outcomes,Probability,Returns (%)
For the following five spreadsheet functions, (a) write the values of the engineering economy symbols P, F, A, i, and n, using a ? for the symbol that is to be determined, and (b) state whether the displayed answer will have a positive sign, a negative sign, or it can’t be determined from the entries. (1) = FV(8%, 10, 3000, 8000) (2) = PMT(12%, 20, –16000) (3) = PV(9%, 15, 1000,600) (4) = NPER(10%, –290,, 12000) (5) = FV(5%, 5, 500, –2000)
Expected return is best described as ________________________________ and is based on the single word ___?