Question

A $10000 investment returns this irregular cash flow as shown in the table. The periodic interest...

  1. A $10000 investment returns this irregular cash flow as shown in the table. The periodic interest rate is 3%.

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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

  

  

Add a comment
Know the answer?
Add Answer to:
A $10000 investment returns this irregular cash flow as shown in the table. The periodic interest...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel....

    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​...

    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 De...

    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...

    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)....

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT