The rate of return is close to 10%
Explanation:
Rate of return is rate at which the net present value is equal to 0. The same is computed as under:
| Year | Cash flows | PVF @ 10% | Present value | |
| 1 | -6209 | 0.909091 | -5644.55 | |
| 2 | -6209 | 0.826446 | -5131.4 | |
| 3 | -6209 | 0.751315 | -4664.91 | |
| 4 | -6209 | 0.683013 | -4240.83 | |
| 5 | -6209 | 0.620921 | -3855.3 | |
| 6 | 10000 | 0.564474 | 5644.739 | |
| 7 | 10000 | 0.513158 | 5131.581 | |
| 8 | 10000 | 0.466507 | 4665.074 | |
| 9 | 10000 | 0.424098 | 4240.976 | |
| 10 | 10000 | 0.385543 | 3855.433 | |
| Present worth | 0.808 | |||
| Rate of Return is close to 10% | ||||
Use formulas (f/a,I,n) or whichever. 7-13 Compute the rate of return for the following cash flow...
te of return for the following cash Compute the rate of return for the 7-8 flow. Year 0 Cash Flow -$7400 1500 3000 4500 6000
1. For the following cash flow using a discount rate of 6%, compute the following items: a) Present worth b) Future worth (at the end of year 10) c) Equivalent annual worth d) Internal rate of return e) Modified internal rate of return at a 10% borrowing and reinvestment rate f) Payback period (non-discounted) g) Payback period (discounted at discount rate) 0 $ 1 $ 2 $ 3 $ 4 $ 5 $ 6 $ 7 $ 8s 9 $...
EXAMPLE 18 Compute the rate of return for the investment represented by the following cash flow: Year Cash Flow -$595 0 1 +250 +200 +150 +100 +50- 2 3 4 5
Problem a) Use Excel to find the rate of return for the following cash flow. (5 points) 12,000 1 2 3 4 5 6 7 8 Year 100 100 100 300 300 300 300 4000
Determine the Rate of Return (196) for the cash flow shown below, if the MARR is 7%: Year 0 1-5 6-8 Cash Flow - 200,000 +50,000 +30,000 over 15% less than 10% 13% 11%
Using excel formulas, refer to the accompanying cash‐flow diagram and solve for the unknown quantity in Parts (a) through (d) that makes the equivalent value of cash outflows equal to the equivalent value of the cash inflow, a) If F=$10,000, G=$600, and N=6, then i=? b) If F=$10,000, G=$600, and i=5% per period, then N=? c) If G=$1,000, N=12, and i=10% per period, then F=? d) If F=$8,000, N=6, and i=10% per period, then G=?
Question 2 Determine the Rate of Return (%) for the cash flow shown below, if the MARR is 7%: Year Cash Flow -200,000 +50,000 +30,000 1-5 6-8 O 11% 13% less than 10% o over 15%
Use XIRR to compute the internal rate of return for the following investment (please provide excel work and functions): A B 1 Date Cash flow 2 30-Jun-07 -799 3 14-Feb-08 70 4 14-Feb-09 70 5 14-Feb-10 70 6 14-Feb-11 70 7 14-Feb-12 70 8 14-Feb-13 1,020
EXAMPLE 18 Compute the rate of return for the investment represented by the following cash flow: Year 0 Cash Flow - $595 +250 +200 +150 +100 +50-
Discounted Cash Flow models use a hurdle rate, or the desired rate of return, to compute the present value of future cash flows. Briefly describe how management might determine the hurdle rate for an investment opportunity.