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%
ekkarill92 answered 1 year agoRelated 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
Latest Questions
- Suppose Rialto is the only movie cinema in a small college town, so it is essentially...
- With VMI, members of the supply chain share planning, demand, forecasting, and inventory information.
- Large lots are desirable in supply chain coordination despite increasing holding costs.
- ***Convert the C++ to Python*** #include <iostream> using std::cout; using std::cin; using std::endl; int charClass; char...
- Make-or-Buy Decision Fremont Computer Company has been purchasing carrying cases for its portable computers at a...
- The following costs were incurred for the single product produced during the first year of operations...
- Non-constant growth model: Do=$2.00 required return on equity= 5% g= 9% n=1,2 g=7% n=3,4 g=3% n=5...
ADVERTISEMENT