Question 4 (25 points) For the cash flow series below, calculate the external rate of return, using the return on i...

Question

Question

Answer 1

Answer #1

B8 V fx =MIRR(B2:B6,12%,14%) X Α Year B Cash flows 0 $ 4,000 1 $ (3,000) 2 $ 2,000 3 $ (7,000) 4 $ 3,200 8 External rate of r

$Function Arguments MIRR B2:B6 Values Finance_rate Reinvest_rate 12% 14% 1 1 1 = {4000:-3000;2000;-7000;3200} = 0.12 = 0.14 =$

Please rate thumbs up

Add a comment

Answer 2

Similar Homework Help Questions

For the net cash flow series, find the external rate of return (EROR) using the MIRR...

For the net cash flow series, find the external rate of return (EROR) using the MIRR method with an investment rate of 18% per year and a borrowing rate of 12% per year. Year 1 2 3 4 5 6 Net Cash Flow, $ 5,000 -5,000 -9,000 11,000 -1,500 4,000 The external rate of return is %.
For the net cash flow series, find the external rate of return (EROR) using the MIRR...

For the net cash flow series, find the external rate of return (EROR) using the MIRR method with an investment rate of 25% per year and a borrowing rate of 12% per year Net Cash Flow, $ -6.000 The external rate of return is %
7) (30 points) First draw a cash flow diagram for the cash flow series given below....

7) (30 points) First draw a cash flow diagram for the cash flow series given below. Then, write an expression (e.g., F-500(PA 5%, 3) + 100(FIG 5%, 3)) to compute the future value of the cash flow series at the end of year 10. You must use at least one uniform series factor, one arithmetic gradient series factor, and one geometric gradient series factor and 10% per year compounded annually. No calculations are needed. 10 Cash 1,000 3,000 3,300 -3,600...

Question 2 Determine the Rate of Return (%) for the cash flow shown below, if the...

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%
1. For the following cash flow using a discount rate of 6%, compute the following items:...

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 $...
Doak Corp. is evaluating a project with the following cash flows: Year Cash Flow -$15,100 6,200...

Doak Corp. is evaluating a project with the following cash flows: Year Cash Flow -$15,100 6,200 7,400 7,000 5,800 -3,200 1 2 3 5 The company uses an interest rate of 11 percent on all of its projects. Calculate the MIRR of the project using all three methods. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Discounting approach Reinvestment approach Combination approach %

Determine the Rate of Return (196) for the cash flow shown below, if the MARR is...

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%
1303 Problems: Series A Average rate of return method, net present value method, and analysis The...

1303 Problems: Series A Average rate of return method, net present value method, and analysis The capital investment committee of Nature's Portrait Landscaping Company is consider- ing two capital investments. The estimated income from operations and net cash flows from each investment are as follows: OBJ. 2, 3 V 1. a. 30.096 Excel Front-End Loader Income from Net Cash Income from Operations Net Cash Operations $25,000 20,000 7,000 3,000 1,250 S56,250 Year Flow Me How 22,000 18,000 16,250 $131,250 $11,250...
Problem 2 . Consider the cash flow . Project Cash Flows series given for an investment...

Problem 2 . Consider the cash flow . Project Cash Flows series given for an investment project. Determine the project balances over the life of the project at an interest rate of 12%. End of Year Cash Flow $3,000 -$1,500 $4,000 $3,000 $5,000 0 4

14. The following table shows the cash flow for the costs of the Self Performing Contractor...

14. The following table shows the cash flow for the costs of the Self Performing Contractor and estimates for revenues from a residential project. (in x1000 TL) a) Calculate the Net Cash Flow and the Cumulative Cash Flow for the project (2 points) b) What is the payback period for the project? (2 points) c) What is the Net Present Value (NPV) of the project to the Self Performing Contractor, if the discount rate is i=7% (3 points). d) Would...