Question

In: Accounting

A projection for a new product line was prepared by a task force from Engineering and...

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?

Solutions

Expert Solution

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%

IRR = 21%

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

Yes, the project is attractive.

Part B:

Outflow =   Present Value of Inflows
13000000= (5000000-Cost)*0.892857142857143+17539828
(13000000-17539828.23)/0.892857142857143 (5000000-Cost) 5084608.174
Cost 5000000+5084607 = 10084607

Note:

Calculation Table:?

Outflows Revenue Cost Net Flows Discountin Factor Present Value
0        (13,000,000.00)                   (13,000,000.00)
1                                                            5,000,000.00 Cost 5000000-Cost 0.892857143 (5000000-Cost)*0.892857142857143
2                                                            5,750,000.00                              3,162,500.00                       2,587,500.00 0.797193878                                                2,062,739.16
3                                                            6,500,000.00                              3,575,000.00                       2,925,000.00 0.711780248                                                2,081,957.22
4                                                            7,250,000.00                              3,987,500.00                       3,262,500.00 0.635518078                                                2,073,377.73
5                                                            8,000,000.00                              4,400,000.00                       3,600,000.00 0.567426856                                                2,042,736.68
6                                                            8,750,000.00                              4,812,500.00                       3,937,500.00 0.506631121                                                1,994,860.04
7                                                            9,500,000.00                              5,225,000.00                       4,275,000.00 0.452349215                                                1,933,792.90
8                                                          10,250,000.00                              5,637,500.00                       4,612,500.00 0.403883228                                                1,862,911.39
9                                                          11,000,000.00                              6,050,000.00                       4,950,000.00 0.360610025                                                1,785,019.62
10                                                          11,750,000.00                              6,462,500.00                       5,287,500.00 0.321973237                                                1,702,433.49
                                             17,539,828.23

ROI when this annual cost reduction:

Outflows Revenue Cost Net Flows
0        (13,000,000.00)                   (13,000,000.00)
1                                                            5,000,000.00                              2,750,000.00                       2,250,000.00
2                                                            5,750,000.00                              3,004,375.00                       2,745,625.00
3                                                            6,500,000.00                              3,396,250.00                       3,103,750.00
4                                                            7,250,000.00                              3,788,125.00                       3,461,875.00
5                                                            8,000,000.00                              4,180,000.00                       3,820,000.00
6                                                            8,750,000.00                              4,571,875.00                       4,178,125.00
7                                                            9,500,000.00                              4,963,750.00                       4,536,250.00
8                                                          10,250,000.00                              5,355,625.00                       4,894,375.00
9                                                          11,000,000.00                              5,747,500.00                       5,252,500.00
10                                                          11,750,000.00                              6,139,375.00                       5,610,625.00
IRR 23%

ROI = 23%


Related Solutions

The projection or scalar component of a force along a line is found by: A. Finding...
The projection or scalar component of a force along a line is found by: A. Finding the direction cosines for the force with respect to a rectangular coordinate system. B. Taking the cross product of the force and the vector representation of the line. C. Taking the scalar product of the force and the vector representation of the line. D. Finding the direction cosines for the line with respect to a rectangular coordinate system.
An engineering group needs to set up an assembly line to produce a new product. The...
An engineering group needs to set up an assembly line to produce a new product. The following table describes the relationships between the activities, their predecessors, and the estimated activity times (in weeks) for this project. (10 points) Activity Immediate Predecessors) Optimistic (Weeks) Most Likely (Weeks) Pessimistic (Weeks) A --- 4 7 10 B A 2 8 20 C A 8 12 16 D B 1 2 3 E D, C 6 8 22 F C 2 3 4 G...
What is the kinetic energy of the sphere when it is 4.80cm from the line of charge if the only force on it is the force exerted by the line of charge?
A very small sphere with positive charge q=+6.00μC is released from rest at a point 1.30cm from a very long line of uniform linear charge density λ=+2.00μC/m.Part AWhat is the kinetic energy of the sphere when it is 4.80cm from the line of charge if the only force on it is the force exerted by the line of charge?Express your answer with the appropriate units.
Murphy’s Motors is considering a new product line to fulfil a four-year contract. The new product...
Murphy’s Motors is considering a new product line to fulfil a four-year contract. The new product line will require an initial fixed asset investment in a machine of $160,000 with the machine to be depreciated straight-line to zero over its four-year tax life (i.e. fully depreciated with no book value at the end of four years). An initial investment in net working capital (NWC) of $90,000 will also need to be paid, with the assumption that the NWC will be...
The Ashton Group is developing a new product line. Initial costs for the line are $83191....
The Ashton Group is developing a new product line. Initial costs for the line are $83191. Annual utilities will be $29917. The company plans to concentrate on marketing for the first 3 years at a cost of $11746 per year. Profits are anticipated to be zero for the first few years. It is estimated the product line will finally have a profit of $453436 at the end of year 6 and profits will continue to increase by 18% each subsequent...
The Ashton Group is developing a new product line. Initial costs for the line are $94693....
The Ashton Group is developing a new product line. Initial costs for the line are $94693. Annual utilities will be $34518. The company plans to concentrate on marketing for the first 2 years at a cost of $11430 per year. Profits are anticipated to be zero for the first few years. It is estimated the product line will finally have a profit of $469315 at the end of year 6 and profits will continue to increase by 20% each subsequent...
The Ashton Group is developing a new product line. Initial costs for the line are $87985....
The Ashton Group is developing a new product line. Initial costs for the line are $87985. Annual utilities will be $34193. The company plans to concentrate on marketing for the first 4 years at a cost of $13812 per year. Profits are anticipated to be zero for the first few years. It is estimated the product line will finally have a profit of $466925 at the end of year 5 and profits will continue to increase by 19% each subsequent...
A Company is considering a new product line to supplement its range line. It is anticipated...
A Company is considering a new product line to supplement its range line. It is anticipated that the new product line will involve cash investment of $700,000 at time 0 and $1.0 million in year 1. After-tax cash inflows of $500,000 are expected in year 2, $300,000 in year 3, $700,000 in year 4, and $400,000 each year thereafter through year 10. Though the product line might be viable after year 10, the company prefers to be conservative and end...
A company is considering of a new product line that is believed to be marketable for...
A company is considering of a new product line that is believed to be marketable for the next 10 years. An initial investment of $215,000 will be required with an estimated salvage value of $40,000 at the end of 10 years. The annual receipts will start at $53,000, the first year and then increase by $2000 each year thereafter. Disbursements will start at $21,000 the first year and increase by $500 each year thereafter. What is the prospective rate of...
You are the engineering representative on a team for a new product introduction. The proposed manufacturing...
You are the engineering representative on a team for a new product introduction. The proposed manufacturing process uses a semi-automated machine along with people. Components for each unit of the product cost $8. The semi-automated machine costs $1,500,000, and it has a 7-year MACRS recovery period. The salvage value is $0 for this specially designed machine. This machine can manufacture 175 finished parts per hour. Table 29-1 Production Volume (1000’s) Year: 1 2 3 4 5 6 7 8 9...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT