Question 3: An investment yields expected future cash flows of $21.00, $34.00, $40.00, $33.00, and $17.00 in periods 1 through 5, respectively. Set up the CFs in an Excel spreadsheet as for Question 1. For these expected cash flows, the appropriate discount rate is 8.0%. What is the value of this stream of CFs? a. Estimate the PV as the sum of the PVs of each of the CFs. b. Can we use the annuity formula? c. Use the excel built-in function PV.

Question 3: An investment yields expected future cash flows of $21.00, $34.00, $40.00, $33.00, and $17.00 in periods 1 through 5, respectively. Set up the CFs in an Excel spreadsheet as for Question 1. For these expected cash flows, the appropriate discount rate is 8.0%. What is the value of this stream of CFs? a. Estimate the PV as the sum of the PVs of each of the CFs. b. Can we use the annuity formula? c. Use the excel built-in function PV.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Determine the future 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) Invested Amount i- n Future Value 1. $ 11,500 7% 15 23 $ 15,000 6% 14 $ 28,000 12% 14 4. S 48,000 8% 6
Capital asset pricing model (CAPM) For the asset shown in the following table, use the capital asset pricing model to find the required return. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Risk-free rate, RF 1% The required return for the asset is %. (Round to two decimal places.) C Market return, m 5% Beta, b 0.5
Problem #2: Consider an investment where the cash flows are: - $920.33 at time 1 = 0 (negative since this is your initial investment) S407 at time = 1 in years $222 at time = 2 in years $426 at time = 3 in years (a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the value of IRR found by Solver?
Assume that the risk-free rate, RF, is currently 9% and that the market return, rm, is currently 16%. a. Calculate the market risk premium. b. Given the previous data, calculate the required return on asset A having a beta of 0.4 and asset B having a beta of 1.8.
Computing Present and Future Values Under Different Assumptions Determine the unknown variables in each of the four separate investment scenarios. Round the RATE to one percentage point (for example, enter 8.5 for 8.54444%). Round NPER, PV, and PMT to the nearest whole number. Use a negative sign only for an amount related to PMT. Investment 1 Investment 2 Investment 3 Investment 4 RATE Answer 7% 6% 1% NPER 10 Answer 4 24 PV $216,000 $9,000 Answer $21,600 PMT $(35,000) $(2,300) $(16,200) Answer TYPE End of period Beg. of period End of period Beg. of period
You identify an investment project with the following cash flows. If the discount rate is 10%, what is the present value of these cash flows? Y1- $500 Y2- $550 Y3- $800 Y4- $450. Please type answer no write by hend.
n is the number of periods of an investment, PV is the starting value, FVn is the future value n periods ahead, and ^ means 'to the power of'. What is the correct formula for calculating return? a)(PV/FVn)^n - 1 b)(FVn/PV)^n c)1 - (FVn/PV)^n d)(FVn/PV)^n - 1
Suppose the market risk premium is 6.7% and the risk-free interest rate is 4.9%. Calculate the cost of capital of investing in a project with a beta of 1.3. Question content area bottom Part 1 The cost of capital is enter your response here%. (Round to two decimal places.)
This graph shows the net present value of an investment with annual cash flows of -$1,000, $100, $300, $400, and $675 as a function of different costs of capital (interest %). Note that this cash flow returns increasing amounts after the initial investment. Drag left or right on the graph to move the cursors to see the net present value (NPV) for different costs of capital. The point where the curve crosses the X-axis determines the internal rate of return (IRR). (Note: due to limited pixel resolution, it is sometimes difficult to get to that precise point.)
Consider the investment project with net cash flows shown. There are 2 rates of return for the project. One is 43.47%. What is the other? Enter as a percentage without the percent sign. For instance, if your answer is 10.23%, enter as 10.23. n Net Cash Flow 0 -$8000 1 $10000 2 $30000 3 -$40000
Which of the following comes closest to the net present value (NPV) of a project whose initial investment is $5 and which produces two cash flows: the first at the end of year 2 of $3 and the second at the end of year 4 of $7? The required rate of return is 13%? Select one: a. $1.84 b. $0 c. $1.64 d. $2.05 e. $2.26
A product manager prepared the following forecasts for a product line: 1 3 4 5 6 and later 2 + $2m $2m $3m $4m $4m g=2.5% If the appropriate discount rate is 8.5%, what is the present value of these future cash flows?