## Question

###### Problem I: A new product line is proposed for investment. The summary of the projected and annual...

Problem I: A new product line is proposed for investment. The summary of the projected and annual receipts for the new product line is shown in the table below. As a business analyst you have been asked to calculate the IRR for this investment opportunity. Furthermore, you have been asked to show the effect of changing IRR with respect to the PW (draw Pw vs i% using a range of İ% from 10% to 100%; use increment of 10) and conclude your analysis with a recommendation. (MARR is 10%) Net Cash Flow -$450,000 $42,500 +$92,800 +$386,000 +$614,600 -$202,200 End of Year

## Answers

IRR is that rate of return at which the NPV is zero. This can be solved using excel Solver or using the IRR() function or by trial and error.

Year (n) Cash flow PW of CF 0 -4,50,000 -4,50,000.00 1 -42,500 -35,008.87 2 92,800 62,968.94 3 3,86,000 2,15,752.04 4 6,14,600 2,82,975.85 5 -2,02,200 -76,687.96 IRR 21.40% - IRR for the given series of cash flows = 21.40%

NPW vs IRR graph:

IRR PW 10% 1,72,295.14 20% 17,540.51 30% -91,356.73 40% -1,69,950.17 50% -2,27,943.21 60% -2,71,577.00 70% -3,04,976.79 80% -3,30,936.72 90% -3,51,391.22 100% -3,67,706.25 The IRR is much higher than the MARR of 10% so this project should be undertaken.

PW vs IRR 2,00,000.00 1,00,000.00 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 1,00,000.00 2,00,000.00 3,00,000.00 4,00,000.00 IRR (96)

#### Similar Solved Questions

1 answers

##### Which of the following is not true of mergers? Liabilities and assets transfer automatically May be...

Which of the following is not true of mergers? Liabilities and assets transfer automatically May be subject to transfer taxes. No minority shareholders remain. May be time consuming due to need for shareholder approvals. May have to pay dissenting shareholders appraised value of stock...

1 answers

##### A debt of $15,000 with interest at 8.3%p.a compounding quarterly is to be repaid with 9...

A debt of $15,000 with interest at 8.3%p.a compounding quarterly is to be repaid with 9 equal end-of-quarter payments. How much interest is in the final instalment? (Hint use excel: You can either: - First calculate the loan outstanding at the beginning of the las...

1 answers

##### Under the rule of seventy, for how many years do you have to deposit € 50000...

Under the rule of seventy, for how many years do you have to deposit € 50000 to get € 100,000 if the deposit rate is 2%?...

1 answers

##### 1. Determine the maximum heart rate and the target zone for a 27 year old. Maximum...

1. Determine the maximum heart rate and the target zone for a 27 year old. Maximum heart rate: ________________ Target zone:____________ beats/min to _________ beats/min 2. Determine the maximum heart rate and the target zone for a 33 year old. Maximum heart rate: _____________ Target zone: ______...

1 answers

##### Imagine that you are hired to manage an underperforming department of a business. Upon assessing day...

Imagine that you are hired to manage an underperforming department of a business. Upon assessing day to day operations for a period of time, you observe that there appears to be a good deal of confusion in the department. The problems run the gamut from unmotivated employees to those who either don&...

1 answers

##### 3. A rocket of mass 10,000 kg will have an escape velocity __________ the escape velocity...

3. A rocket of mass 10,000 kg will have an escape velocity __________ the escape velocity of a rocket with mass 5,000 kg. A. one quarter of B. one half of C. the same as D. double...

1 answers

##### Consider three different processors P1, P2 and P3 executing the same instruction set. P3 has a...

Consider three different processors P1, P2 and P3 executing the same instruction set. P3 has a 4 GHz clock rate and a CPI of 2.5. P2 has 3.5 GHz clock rate and a CPI of 2.0. P1 has a 5.0 GHz clock rate and has a CPI of 3.3. a. Which processor has the highest performance expressed in instructions per...

1 answers

##### Why does the M protein of Rhabdovirus enter the nucleus after the virion enters the host...

Why does the M protein of Rhabdovirus enter the nucleus after the virion enters the host cell?...

1 answers

##### Suppose patients were recruited into a clinical trial from three different clinical sites. Use the following...

Suppose patients were recruited into a clinical trial from three different clinical sites. Use the following data to test for differences in the proportion of hypertensive patients across the three sites Site 2 Site 1 Site 3 Hypertensive 10 14 12 Not Hypertensive 68 56 Step 4 In the table below the ...

1 answers

##### Required information Greenwood Company manufactures two products-14,000 units of Product Y and 6,000 units of Product...

Required information Greenwood Company manufactures two products-14,000 units of Product Y and 6,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all of its manufacturi...

1 answers

##### If f is the inverse of g, then we know that f(g(x))=x, how do you use this fact to derive the derivative formula dy/dx e^x= e^x?

If f is the inverse of g, then we know that f(g(x))=x, how do you use this fact to derive the derivative formula dy/dx e^x= e^x?...

1 answers

##### MHM Bank currently has $850 million in transaction deposits on its balance sheet. The current reserve...

MHM Bank currently has $850 million in transaction deposits on its balance sheet. The current reserve requirement is 8 percent, but the Federal Reserve is increasing this requirement to 10 percent. a. Show the balance sheet of the Federal Reserve and MHM Bank if MHM Bank converts all excess reserves...

1 answers

##### Need parts a,b,c,d According to a state law, the maximum amount of a jury award that...

need parts a,b,c,d According to a state law, the maximum amount of a jury award that attorneys can receive is given below. 40% of the first $140,000 33.3% of the next $140,000 30% of the next $200,000 24% of anything over $480,000 Let f(x) represent the maximum amount of money that an attorney ...

1 answers

##### Nt/52 /fullscreen/7341689/View For Student's ID ending at "1" and "8" 1-Determine the stresses at points K...

nt/52 /fullscreen/7341689/View For Student's ID ending at "1" and "8" 1-Determine the stresses at points K and H for the following bar. Radius of the bar is 0.2m. consider the shear stresses at this points. By using Mohr's circle find out the principal and maximum shear stres...

1 answers

##### 1934. 2. fructose is a sugar found in fruit and honey. Calculate the empirical formula for...

1934. 2. fructose is a sugar found in fruit and honey. Calculate the empirical formula for fructose given its percent composition: 40.00% C, 6.72% H, and 53.29% 0. 1. Match the compound description with the correct formula by placing the letter of the formula after the description. A. H3PO4(aq) B. H...

1 answers

##### An electron, relased in a region where the electric field is uniform, is observed to have...

An electron, relased in a region where the electric field is uniform, is observed to have an acceleration of 7.0e14 m/s^2 in the positive x direction. (A) Determine the electric field producing the acceleration. I found this to be 3.99e3 N/C that it points towards -x. (B) Assuming the electron is re...

1 answers

##### Take the following compound, benzoquinone, which is considered a 'readily available starting material' in this t...

Take the following compound, benzoquinone, which is considered a 'readily available starting material' in this task. Devise a 7 step synthesis starting from benzoquinone (i.e. create your own target molecule). You may use any chemically reasonable reactions and any other reagents as necessar...

1 answers

##### Leontief's paradox is an example of testing a trade model using actual data observations. If Leontief...

Leontief's paradox is an example of testing a trade model using actual data observations. If Leontief had observed that the amount of labor needed per $1 million of U.S. exports was 100 person-years instead of 182. Would he have reached the same conclusion? Explain....