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

Question

Question

Answer 1

Answer #1

Let IRR is I%, then

-200000 + 50000 * (P/A, I%,5) + 30000 * (P/A, I%,3) * (P/F, i%,5) = 0

50000 * (P/A, I%,5) + 30000 * (P/A, I%,3) * (P/F, i%,5) = 200000

Dividing by 10000

5 * (P/A, I%,5) + 3 * (P/A, I%,3) * (P/F, i%,5) = 20

using trail and error method

When I = 15%, value of 5 * (P/A, I%,5) + 3 * (P/A, I%,3) * (P/F, i%,5) = 5 * 3.352155 + 3*2.283225 * 0.497177 = 20.166274

When I = 16%, value of 5 * (P/A, I%,5) + 3 * (P/A, I%,3) * (P/F, i%,5) = 5 * 3.274294 + 3*2.245890 * 0.476113 = 19.579362

using interpolation

i = 15% + (20.166274 - 20) / (20.166274 - 19.579362)*(16%-15%)

I = 15% + 0.28%

I = 15.28%

First option is correct ie. IRR is over 15%

Answer 2

Similar Homework Help Questions

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%
An investment has the cash flow profile shown below: Year Year Year 0 4 8 Cash...

An investment has the cash flow profile shown below: Year Year Year 0 4 8 Cash Flow -$130,000 $30,000 $ 40,000 $15,000 1 Cash Flow $180,000 -$ 15,000 $210,000 Cash Flow $20,000 -$ 50,000 $90,000 -$ 20,000 5 9 2 6 10 3 7 Partc Using an internal rate of return analysis, identify the real, positive-valued root for the polynomial equation used to calculate the internal rate of return. % Round entry to 2 decimal places. The tolerance is +0.05....
please answer both! it would be greatly appreaciated Consider a one-year cash flow as follows. Payments...

please answer both! it would be greatly appreaciated Consider a one-year cash flow as follows. Payments are made at end of a given month. What the value F at the end of month 12 if the nominal interest rate is 20%/year, c.q. (comp. quarterly). 0 1 2 3 4 5 6 7 8 9 10 End of Month Cash Flow, $ 11 12 - 100 -50 -50 -50 +190 +200 -50 +145 less than $100 Between $100-$200 Between $200-$300 Higher...

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

Question 4 (25 points) For the cash flow series below, calculate the external rate of return, using the return on invested capital approach with a reinvestment rate of 14% per year and MARR of 12% per year. Year 1 0 1 Cash Flow (8) +4,000 -3,000 +2,000 - 7,000 +3,200
please help me draw the labelled cash flow For the cash flows shown below, determine the...

please help me draw the labelled cash flow For the cash flows shown below, determine the present worth & the equivalent uniform worth in years 1 through 5 at an interest rate of 18% per year compounded monthly. Draw the cash flow diagram as well. (6+ 2 + 2 pts) Year 0 1 2 3 4 5 Cash Flows, s 0 200,000 0 350,000 0 400,000
Given the cash flow described in table below. Determine the ROR. Given the cash flow described...

Given the cash flow described in table below. Determine the ROR. Given the cash flow described in table below. Determine the ROR. Year 0 1-2 3-5 6-10 Cash flow -15,000 4,000 3,000 1,500 20% 18% 15% 13%

Nu Things, Inc., is considering an investment in a business venture with the following anticipated cash flow results: C...

Nu Things, Inc., is considering an investment in a business venture with the following anticipated cash flow results: Cash Flow EOY 0 -$80,000 $30,000 1 $29,000 2 $28,000 3 $27,000 $26,000 6 $25,000 $24,000 7 $23,000 8 $22,000 $21,000 10 $20,000 11 $19,000 12 13 $18,000 $17,000 14 $16,000 15 $15,000 16 $14,000 17 18 $13,000 19 $12,000 20 $11,000 Assume MARR is 20% per year. Based on an external rate of return analysis Determine the investment's worth. Carry all...
anyone can check my answer? Student Name: QUID: Section: Question 1 (6pts). For the cash flows...

anyone can check my answer? Student Name: QUID: Section: Question 1 (6pts). For the cash flows shown below, answer the following questions. (Assume MARR = 15% (1) (2pts) Provide the equation using PW to find the ROR of the cash flow given. (2) (2pts) Decide whether the project is acceptable or not using RATE function in MS Excel. Provide the screenshot (3) (2pts) Decide whether the project is acceptable or not using IRR_function in MS Excel. Provide the screenshot Year...
D Question 11 3 pts For the net cash flows shown in the table below, the...

D Question 11 3 pts For the net cash flows shown in the table below, the number of possible rate of return solutions according to the Descarte's rule is: Year Net Cash flow, $ -$50,000 $20,000 $40,000 3 -$5,000 $30,000 $40,000 $2,000 1 .0 3 2.

4(a) Expected cash flows for a strip-mining project are estimated as shown below. 7 8 End...

4(a) Expected cash flows for a strip-mining project are estimated as shown below. 7 8 End of 0 year Cash -100,000 flow 20,000 100.000 100.000 50,000 50,000 50,000 50,000 -350,000 A startup cost is incurred immediately. The income exceeds outlays for the next 7 years. During the 8th year, the major cost is for landscape improvement. Does the strip mining project appear to be a profitable investment? On the basis of past experience, the mining company wishes to use MARR...