A projection for a new product line was prepared by a task force from Engineerin

Question

A projection for a new product line was prepared by a task force from Engineering and Sales. The plan presented to management calls for an initial investment of $13,000,000 which is projected to generate annual revenue which increases at $750,000 per year, with a first year revenue of $5,000,000. Annual costs which are estimated at $2,750,000 for the first year, are expected to increase in direct proportion to the annual revenue. The task force has made a case for a 10 year study period, which managment has accepted. Calculate the annual rate of return (ROI) for this projection. The company uses a MARR of 12%. Is the project attractive?

During the task force's presentation, serious doubt is expressed by management about the first year cost estimate, the opinion is that it is too low. Management accepts the cost estimates for years 2 through 10. How large could the first year cost estimate be and still meet the 12% MARR?

In a second response to management's skepticism about the first year cost, the task force pointed out that the annual cost estimates do not include a learning and experience factor. THis has always been in excess of 5% for the company. Assuming that management accepts the sales pronections and the same annual cost reduction of 5%(for each year), what would be the ROI when this annual cost reduction is applied?

Explanation / Answer

IRR = 21%

Calculated using Trial and Error Method. (Inflow =Outflow)

Yes, the project is attractive.

Part B:

Note:

Calculation Table:?

ROI when this annual cost reduction:

ROI = 23%

Outflows Revenue Cost Net Flows        (13,000,000.00) (13,000,000.00)      5,000,000.00    2,750,000.00        2,250,000.00      5,750,000.00    3,162,500.00        2,587,500.00      6,500,000.00    3,575,000.00        2,925,000.00      7,250,000.00    3,987,500.00        3,262,500.00      8,000,000.00    4,400,000.00        3,600,000.00      8,750,000.00    4,812,500.00        3,937,500.00      9,500,000.00    5,225,000.00        4,275,000.00    10,250,000.00    5,637,500.00        4,612,500.00    11,000,000.00    6,050,000.00        4,950,000.00    11,750,000.00    6,462,500.00        5,287,500.00 IRR 21%

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.