Question

Based on 15% compound interest rate and the following cash flows, present the answer in the...

Based on 15% compound interest rate and the following cash flows, present the answer in the form of a single table.

  1. What is the overall present worth
  2. What is the present worth for each year?
  3. What is the overall future worth?
  4. What is the future worth for each year?

End of Year (EOY)

Cash Flow (CF)

0

-$25,000

1

$12,500

2

$10,000

3

$7,500

4

$10,000

5

$12,500

Homework Answers

Answer #1

Answer:

EOY Cash flow(CF)(in $) Present worth(b)(in $) Future worth(d)(in $)
0 -25000 -25000 -25000(2.011)=-50275
1 12500 12500(0.8696)=10870 12500(1.749)=21862.5
2 10000 10000(0.7561)=7561 10000(1.521)=15210
3 7500 7500(0.6575)=4931.25 7500(1.322)=9915
4 10000 10000(0.5718)=5718 10000(1.150)=11500
5 12500 12500(0.4972)=6215 12500
Total (a)=10295.25 (c)=20712.5

Future worth is calculated at the end of year 5.

Present worth is calculated as cashflow(P/F,15%, EOY)

Future worth is calculated as cashflow[F/P,15%,(5-EOY)]

Know the answer?
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
Similar Questions
Present value Mixed streams Consider the mixed streams of cash flows shown in the following​ table...
Present value Mixed streams Consider the mixed streams of cash flows shown in the following​ table A B 1   $-15,000 $5,000 2   $12,500 $7,500 3   $10,000 $10,000 4   $7,500 $12,500 5   $5,000 $-15,000 Totals   $20,000   $20,000 a.  Find the present value of each stream using a 6​% discount rate. b.  Compare the calculated present values and discuss them in light of the undiscounted cash flows totaling $20,000 in each case. Is there some discount rate at which the present values...
a) For the cash flows shown below, determine the present worth at an interest rate of...
a) For the cash flows shown below, determine the present worth at an interest rate of 12% per year.    Draw the cash flow diagram. (b) If the cash flow is converted into an A series from year 1 through year 5, what would be the amount of the uniform cash flow series? cash flow for yr 0 is $0, for yr 1 is $0, for yr 2 is $800, for yr 3 is $600, for yr 4 is $400, for...
Present value - Mixed streams???Consider the mixed streams of cash flows shown in the following? table:...
Present value - Mixed streams???Consider the mixed streams of cash flows shown in the following? table: a.??Find the present value of each stream using a 13?% discount rate. b.??Compare the calculated present values and discuss them in light of the undiscounted cash flows totaling ?$125,000 in each case. Cash flow stream Year 1 ?A= $37,500 B= $12,500 Year 2 A= ?$31,250 B= $18,750 Year 3 A= $25,000 B= ?$25,000 Year 4 A?= $18,750 B= ?$31,250 Year 5 A= $12,500 B=...
The cash flows associated with a project are shown below. The interest rate varies from year...
The cash flows associated with a project are shown below. The interest rate varies from year to year as shown. EOY Cash Flow 0 $0 1 $600 2 $-300 3 $700 4 $0 5 $1,000 Interest Period Interest Rate EOY 0 to EOY 1 10%/yr EOY 1 to EOY 2 10%/yr EOY 2 to EOY 3 8%/yr EOY 3 to EOY 4 8%/yr EOY 4 to EOY 5 12%/yr Determine the amount required to create an equivalent uniform annual series...
11. Consider the following cash flows:                                  Time Period &nb
11. Consider the following cash flows:                                  Time Period                            Expected Cash Flows 1 $100 2 $400 3 $500 4 ??CF?? 5 $800 Total Present Value (at a 10% discount rate)= $1,771.99 Note that the present value of all five cash flows (including the “unknown” cash flow at the end of year 4) is $1,771.99. What is the value of the “unknown” cash flow at period 4? (Worth 2 points)
1. What's the internal rate of return of the following cash flows with a 8% WACC?...
1. What's the internal rate of return of the following cash flows with a 8% WACC? 2. What's the modified internal rate of return of the following cash flows with a 8% WACC? Year 0 = 100,000 Year 1 = 10,000 Year 2 = 50,000 Year 3 = 45,000 Year 4 = 25,000 3. How long should a company keep the following project? WACC = 8% CF year 0 = 1,500,000 Salvage = 1,500,000 CF year 1 = 750,000 Salvage...
What is the present value the following set up cash flows at an interest rate of...
What is the present value the following set up cash flows at an interest rate of 7% $1000 today $2000 at the end of the year one $4000 at the end of the year three and $6000 at end of year five?
What is the present value of the following net cash flows if the discount rate is...
What is the present value of the following net cash flows if the discount rate is 12%: Year Cash Flow 1-5 $10,000 each year 6-10 $15,000 each year 11-15 $17,000 each year A. $ 86,462 B. $ 79,252 C. $151,400 D. $144,037 Sarah borrowed $125,000 to buy a house, her your loan cost was 11% and she promised to repay the loan in 15 equal annual payments. What is the principal outstanding after the first loan payment? A. $121,367 B....
(a) What is the future value of the following unequal cash flows using 9% interest rate?...
(a) What is the future value of the following unequal cash flows using 9% interest rate? YEAR                  1                2                3                   4                5 CASH FLOW   $600         $800           $500            $400           $900 (b) What would be an annuity payment (PMT) that would give the same future value      using the same interest rate and same number of years? (c) What is the present value of the following unequal cash flows using       7.5% interest rate? YEAR                  1                2                3                   4               CASH FLOW   $950        ...
Simple and compound interest rate 5. I considered an investment of $ 15,000 made in the...
Simple and compound interest rate 5. I considered an investment of $ 15,000 made in the present (year 0) and that remains for 15 years. Determine the total amount accumulated at the end of year 15, if the investment offers (a) a simple interest rate of 8% per year, and (b) a compound interest rate of 8% per year effective 6. If a person requires a loan in the amount of $ 25,000 in the present. If your financial institution...