Question

***PLEASE SHOW IN EXCEL**** 2. Jane Swan will receive from his investment cash flows of $4,450,...

***PLEASE SHOW IN EXCEL****

2. Jane Swan will receive from his investment cash flows of $4,450, $4,775, and $5,125. If she can earn 7 percent on any investment that he makes, what is the future value of his investment cash flows at the end of three years? (Round to the nearest dollar.)
A. $15,329
B. $15,427
C. $16,427
D. $14,427
E. None of the answers is correct
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Future value of investments = Cash flows * ((1+i)^n)

Here,

i (interest) = 7% or 0.07

n = years

Now,

Future value of investments = $4,450 * ((1 + 0.07)^1) + $4,775 * ((1 + 0.07)^2) + $5,125 * ((1 + 0.07)^3)

Future value of investments = ($4,450 * 1.07) + ($4,775 * 1.1449) + ($5,125 * 1.2250)

Future value of investments = $4,761.50 + $5,466.90 + $6,278.13

Future value of investments = $16,506.53 or $16,507

Answer : E : None of the answers is correct.

Add a comment
Know the answer?
Add Answer to:
***PLEASE SHOW IN EXCEL**** 2. Jane Swan will receive from his investment cash flows of $4,450,...
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
  • Robert White will receive from his investment cash flows of $4,450, $4,775, and $5,125. If he...

    Robert White will receive from his investment cash flows of $4,450, $4,775, and $5,125. If he can earn 7 percent on any investment that he makes, what is the future value of his investment cash flows at the end of three years? (Round to the nearest dollar.)

  • Chuck Brown will receive from his investment cash flows of $3,145, $3,470, and $3,810 at the...

    Chuck Brown will receive from his investment cash flows of $3,145, $3,470, and $3,810 at the end of years 1, 2 and 3 respectively. If he can earn 7.5 percent on any investment that he makes, what is the future value of his investment cash flows at the end of three years? (Round to two decimal places.)

  • Helen Ashley is expecting cash flows of $4,000, $20,000, $9,000, and $32,000 from an inheritance over...

    Helen Ashley is expecting cash flows of $4,000, $20,000, $9,000, and $32,000 from an inheritance over the next four years. If she can earn 9.0 percent on any investment that she makes, what is the present value of her inheritance? (Round to the nearest cent.)

  • Ben Woolmer has an investment that will pay him the following cash flows over the next...

    Ben Woolmer has an investment that will pay him the following cash flows over the next five years: $2,390, $2,740, $3,130, $3,440, and $3,690. If his investments typically earn 6.40 percent, what is the future value of the investment’s cash flows at the end of five years?

  • Use the following information: Annual cash inflows that will arise from two competing investment projects are...

    Use the following information: Annual cash inflows that will arise from two competing investment projects are given below: Investment Year A B 1 $4,000 $16,000 2 $8,000 $12,000 3 $12,000 $8,000 4 $16,000 $4,000 Total $40,000 $40,000 Each investment project will require the same investment outlay. The discount rate is 16% Compute the present value of the cash inflows for Investment A. (Round to nearest dollar) Compute the present value of the cash inflows for Investment B. (Round to nearest...

  • D G H L 6.1. Future value with multiple cash flows: Konerko, Inc., expects to earn...

    D G H L 6.1. Future value with multiple cash flows: Konerko, Inc., expects to earn cash flows of $13,227, $15,611, 518,970, and $19,114 over the next four years. If the company uses an 8 percent discount rate, what is the future value of these cash flows at the end of year 4? 6.4. Present value with multiple cash flows: Saul Cervantes has just purchased some equipment for his landscaping business. For this equipment he must pay the following amounts...

  • Hell with these three questions please. 10. Uneven cash flows Aa Aa E A series of...

    Hell with these three questions please. 10. Uneven cash flows Aa Aa E A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years: Year 1 $250,000 Annual Cash Flows Year...

  • Dan Boyd is a financial planner trying to determine how to invest $100,000 for one of his clients The cash flows for th...

    Dan Boyd is a financial planner trying to determine how to invest $100,000 for one of his clients The cash flows for the five investments under consideration are summarized in the following table Summary of Cash in-Flows and Out-Flows (at Beginning of Year) Year 1 1.00 1.00 1.00 0.00 0.00 1.00 0.00 Year 20.45 0.00 0.00 Year 3 +1.05 1.00 0.00 0.00 1.25 Year 4 +1.30 +1.30 0.00 +1.65 0.00 For example, if Dan invests $1 in investment A at...

  • On January 1, Alan King decided to transfer an amount from his checking account into an investment account that lat...

    On January 1, Alan King decided to transfer an amount from his checking account into an investment account that later will provide $83,000 to send his son to college four years from now). The investment account will earn 9 percent, which will be added to the fund each year-end. (Future Value of $1. Present Value of $1. Future Value Annuity of $1. Present Value Annuity of $1 (Use appropriate factor(s) from the tables provided.) Required: 1. How much must Alan...

  • DeBarry Corporation makes an investment of $57,000 that yields the following cash flows: Year Cash Flow...

    DeBarry Corporation makes an investment of $57,000 that yields the following cash flows: Year Cash Flow 1 $18,000 2 18,000 3 24,000 4 26,000 5 28,000 a. What is the present value with a 7 percent discount rate (cost of capital)? (Use a Financial calculator to arrive at the answers. Do not round intermediate calculations. Round the final answer to the nearest whole dollar.) Net present value           $ b. What is the IRR? (Do not round intermediate calculations. Round...

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