question archive A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods
Subject:AccountingPrice:4.87 Bought7
A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below:
Option 1
Revenues are estimated to be:
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 - 75,000 100,000 125,000 150,000 150,000 150,000
Option 2
Revenues are estimated to be:
Year 1Year 2Year 3Year 4Year 5Year 6Year 7- 80,000 95,000 130,000 140,000 150,000 160,000
The company's required rate of return and cost of capital is 8%.
Management has turned to its finance and accounting department to perform analyses and make a recommendation on which option to choose. They have requested that the four main capital budgeting calculations be done: NPV, IRR, Payback Period, and ARR for each option.
For this question, compute all required amounts and explain how the computations were performed. Evaluate the results for each option and explain what the results mean. Based on your analysis, recommend which option the company should pursue.
You need to:
Answer:
Requirement 1:
(Note: Depreciation is Not deducted because after that it should be add back and there is not any tax rate give so no use )
Computation of NPV:
Computation of IRR:
Computation of Payback period:
Payback period = Year amount maximum recover + Remaining amount / total amount of that year
= year 5 + 55139.51/56069.81
= year 5 + 0.983 years
= 5.983 years
Computation of ARR:
ARR = Average Cash Flow / Initial investment
= [(-87700-9800+13037+35809.11+58514.38+56069.81+53551.91)/7]/65000
= (119482.21/7) / 65000
= 17068.88714/65000
= 26.26%
Requirement B:
Computation of NPV:
Computation of IRR:
Computation of payback period:
Payback period = Year amount maximum recover + Remaining amount / total amount of that year
= Year 5 + 56048.15/61838.56
= 5 year + 0.906
= 5.906 years
Computation of ARR:
ARR = Average Cash Inflow / Initial investment
= (-83500-300+12846+45936.38+53969.47+61838.56+82643.71)/7 /85000
= (173434.12/7) / 85000
= 24776.302/85000
= 0.29148
or 29.15%
PFA