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

What is the NPV of the following cash flows if the required rate of return is 0.13? Year 0 1 2 3 4 CF -3,241 2,952 1,242 3,310 1,616 Enter the answer with 2 decimals (e.g. 1000.23).
Consider an investment where the cash flows are: – $946.21 at time t = 0 (negative since this is your initial investment) $377 at time t = 1 in years $204 at time t = 2 in years $499 at time t = 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?
Determine the rate of return for the cash flows shown in the diagram. Use trial and error (start with two trials with 5% and 10% interest rates) and then use interpolation (or more trials) to approximate the result. Roh?? S7000 1- ? Year 590 s90 s90 sz00 sz00 sz00 $3000
What is the yield on the following set of cashflows? Time Cashflow (£) t = 0 t=1 H 400 t=2 t = 3 -100 -120 t = 4 -140 t = 5 -160
Calculate the APR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Year Number Cashflow 0 -11000 1 3000 2 3500 3 2900 4 2800
Find the internal rate of return (IRR) for the following cash flows. Enter your answer as a percent and include at least two decimal points, e.g., 8.35 for 8.35 %, not 0.08. Year Cash Flow 0 750 1 200 2 375 3 250 4 100 5 75
Consider two assets with the following cash flow streams: Asset A generates $4 at t=1, $3 at t=2, and $10 at t=3. Asset B generates $2 at t=1, $X at t=2, and $10 at t=3. Suppose X=6 and the interest rate r is constant. For r=0.1, calculate the present value of the two assets. Determine the set of all interest rates {r} such that asset A is more valuable than asset Draw the present value of the assets as a function of the interest rate. Suppose r=0.2. Find the value X such that the present value of asset B is 12. Suppose the (one-period) interest rates are variable and given as follows: r01=0.1,r12=0.2, r23=0.3. Calculate the yield to maturity of asset A. (You can use Excel or ascientific calculator to find the solution numerically.)
Consider the calculation of an external rate of return (ERR). The positive cash flows in the cash flow profile are moved forward to t = n using what value of i in the (F|P,i,n–t) factors? a. 0 b. The unknown value of ERR (i′) c. MARR d. IRR.
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
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?
Consider the following risk-return characteristics for funds A and B: Expected return Risk Fund A (Equity) 12% 20% Fund B (Debt) 9% 16% The correlation coefficient between the returns of fund A and fund B is 0.4. 1. Which Fund is riskier? Write 1 if your answer is Fund A, write 2 if your answer is Fund B, or write 3 if your answer is undetermined. 2.1 What is the weight of fund A in the minimum variance portfolio? 2.4 What is the risk of the minimum variance portfolio? 2.2 What is the weight of Fund B in the minimum variance portfolio? 2.3 What is the expected return of the minimum variance portfolio?
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