Dates |
15-Jan-2018 |
16-Feb-2018 |
5-Mar-2018 |
14-Jun-2018 |
11-Dec-2018 |
Cash Flow |
-10000 |
2000 |
2500 |
3500 |
3500 |
Calculate the present and future value of this cash flow.
1 investment date = 15-jan-2018, we assume that this is our today's date and pv of initial investment is 10000
we will receive our first cash flow on 16-feb-2018 so period will be 32 days
Present value = Cashflow/ {1+(rate/360)}n there are 360 days in year n is number of days
=2000/ {1+(0.03/360}32
=2000/ 1.002670
=1994.67
we will receive our second cash flow on 5-march-2018 so period will be 49 days
Present value = Cashflow/ {1+(rate/360)}n
=2500/ {1+(0.03/360}49
=2489.81
we will receive our third cash flow on 14-jun-2018 so period will be 150 days
Present value = Cashflow/ {1+(rate/360)}n
= 3500/ {1+(0.03/360}150
=3500/1.012577
=3456.524
we will receive our third cash flow on 11-dec-2018 so period will be330 days
Present value = Cashflow/ {1+(rate/360)}n
= 3500/ {1+(0.03/360}330
=3405.056
FUTURE VALUE our future date will be last cash flow date that is 11 dec 2018
we will receive our first cash flow on 16-feb-2018 so future period will be 298 days
Future value = Cashflow* {1+(rate/360)}n
=2000* {1+(0.03/360}298
= 2000*1.025143
=2050.28
.
we will receive our second cash flow on 5-march-2018 so future period will be 281 days
Future value = Cashflow* {1+(rate/360)}n
=2500* {1+(0.03/360}281
= 2500*1.02369
= 2559.22
we will receive our third cash flow on 14-jun-2018 so future period will be 180 days.
Future value = Cashflow*
{1+(rate/360)}n
=3500* {1+(0.03/360}180
=3500*1.01511
=3552.89
future value of forth cash flow is 3500.
Future value of initial investment = Cashflow* {1+(rate/360)n
=10000* {1+(0.03/360}330
=10000*1.02788
=10278.8
A $10000 investment returns this irregular cash flow as shown in the table. The periodic interest...
calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel. In a text box nearby, comment on whether investors’ trading decisions have created value. Month ADKSX Return (%) ADKSX Cash Flow ($) Nov-09 3.49 -$10,648,393 Dec-09 6.93 -$618,800 Jan-10 -2.05 $940,820 Feb-10 5.74 -$2,484,437 Mar-10 5.19 -$3,699,836 Apr-10 5.48 -$1,379,757 May-10 -4.68 $2,145,936 Jun-10 -6.31 -$2,953,884 Jul-10 5.9 -$4,160,472 Aug-10 -5.18 $1,096,304 Sep-10 8.61 -$5,571,657 Oct-10 4.5 -$669,464 Nov-10 2.77 -$3,145,367 Dec-10 9.16 -$6,162,018...
Use the data table to estimate the alpha of Nike and HP Inc. stock, expressed as % per month. Monthly Returns Date Nike HP Inc. S&P 500 Jan-11 -3.442% 8.527% 2.330% Feb-11 7.941% -4.509% 3.474% Mar-11 -14.624% -5.913% -0.005% Apr-11 8.745% -1.465% 2.896% May-11 2.587% -7.406% -1.121% Jun-11 6.915% -2.301% -1.706% Jul-11 0.189% -3.379% -2.000% Aug-11 -3.882% -25.988% -5.498% Sep-11 -0.958% -13.292% -6.910% Oct-11 12.677% 18.530% 10.915% Nov-11 -0.176% 5.036% -0.406% Dec-11 0.572% -7.406% 1.024% Jan-12 7.907% 8.618% 4.637% Feb-12...
Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14 un-14 Jul-14 14 ep-14 ct-14 4.67 9.05 8.57 Feb-15 5.02 4.8 Apr-15 0.58 7.79 Aug-15 4.83 5.81 Dec-15 11.81 1.5 8.84 1.8 12.42 Apr-16 May-16 2.62 2.75 0.04 5.2 4.95 0.59 7.67 Jul-16 Aug-16 Dec-16 0.2 5.23 The following table shows a portion of the monthly returns data (in percent) for 2010-2016 for two of Vanguard's mutual funds: the Vanguard Energy Fund and the...
Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14 un-14 Jul-14 14 ep-14 ct-14 4.67 9.05 8.57 Feb-15 5.02 4.8 Apr-15 0.58 7.79 Aug-15 4.83 5.81 Dec-15 11.81 1.5 8.84 1.8 12.42 Apr-16 May-16 2.62 2.75 0.04 5.2 4.95 0.59 7.67 Jul-16 Aug-16 Dec-16 0.2 5.23 The following table shows a portion of the monthly returns data (in percent) for 2010-2016 for two of Vanguard's mutual funds: the Vanguard Energy Fund and the...
Consider the following 5-years investment table of Agus's cash flow with required return rate j=11% (RRR). Discounted is a discount factor based on RRR. Contribution is amount of money that Agus paid to start the business (investment). Whereas, return is amount of money that Agus received from the investment. Furthermore, PV Contrib is present value of Contribution based on RRR, then Net Cash Flow is Return minus Contribution. Moreover, Discounted Cash Flow is present value of Net Cash Flow based...
4% C9 The monthly returns of two investment funds, Fund A and Fund B are given in the table. Expected return in this case is the historic return Risk free rate is 2% per annum 1 1 Calculate the Sharpe ratios of the two funds 2 Based on only the Sharpe ratio, which fund has performed better Monthly return Fund A Fund B an-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 4% 2% 5% 9% 5%...
I. An investment has the following cash flow series where interest is 8%; Cash End of Year 0 Flow $300 $300 $600 $500 $300 $0 $800 $700 $600 2 4 7 8 a. Find the future worth of this cash flow series using the actual cash flows. b. Find the present worth of this series using the actual cash flows c. Find the present worth using the future worth. d. Find the worth of the series at the end of...
integrated mini-case: Disney’s Beta
When you go on the web to find a firm’s beta, you do not know
how recently it was computed, what index was used as a proxy for
the market portfolio, or which time series of returns the
calculations used. Earlier in this chapter, it was shown that when
we went on the Web to find a beta for Disney, we found the
following: MSN Money (1.29) and Yahoo! Finance (1.18). An
alternative is to compute...
Compute the net present worth (NPW) of the cash flows described
in table below for investment being considered by MGM Industries in
Georgia. MARR =6%
Question 2 10 pts Compute the net present worth (NPW) of the cash flows described in table below for investment being considered by MGM Industries in Georgia. MARR-6% Year 1-10 11-15 16-25 26-30 Cash Flow -$200K10K 20K 5K 30K
1.) An investment in manufacturing equipment yields the following cash flows for 8 years. At the end of the 8th year the equipment can be sold for $15,000. Assuming an interest rate of 14% (compounded annually), how much would you be willing to invest in this manufacturing equipment? C=? I=2000 I=2000 I=2000 I=2000 I=1000 I=1000 I=1000 I=1000 L=$15,000 0 1 2 3 4 5 6 7 8 C: Cost, I: Income, L: Salvage Value 2.) Suppose that the nominal annual...