Question

In: Accounting

You are a water filter manufacturer trying to decide if you should invest in an automatic...

You are a water filter manufacturer trying to decide if you should invest in an automatic or manually operated machinery. Both alternatives’ present costs are pegged at $5000, however, they lead to different revenue patterns thereafter. The automatic machine allows for higher production levels and thus more revenues immediately, however more energy costs over time than the manual machine means that net revenues diminish over time. The manual machine does not produce as many filters initially but has no energy cost, so its net revenues increase over time. The expected net revenues of the automatic machine are: $3200, $1500, $690, and $310 by the ends of years one to four, respectively. The expected net revenues for the manual machine are $280, $710, $1900, and $3000 by the ends of years one to four, respectively. 1. Calculate the Internal Rate of Return of each alternative and compare them. Which is more feasible? 2. Knowing the MARR is 8%, use NPW analysis to compare these alternatives and find out which one is better. 3. Calculate the benefit cost ratio of the both alternatives.

Solutions

Expert Solution

1.INTERNAL RATE OF RETURN(IRR)

formula for IRR = lower rate + (NPV at lower rate / (NPV at lower rate - NPV at higher rate ))*(higher rate-lower rate)

here , lets assume that the lower rate is 8% and higher rate is 12%

from the given calculations in excel , we can understand that automatic machine have higher internal rate of return which is 8.3% than manual machine which is 4.7%.this indicates that automatic machine will give higher returns than manual machine .automatic machine will be more feasible as manual machine have negative net present value that indicates loss , while auotomatic machine have positive net present value that indicates profit .(refer to the formula cell , in case doubts on applying formula )

2.from the given calculations in excel , automatic machine have higher net present worth of 24.41 than manual machine which is (418.65) . clearly , chosing manual machine will result in loss .it is better to choose automatic machine as this have positive net present worth/value eventhough future revenue diminishes over time .chosing automatic machine will not relsult in overall loss eventhough revenue decreases over time but chosing manual machine will result in overall loss eventhough revenue increases over time . as we have the estimates for only 4 years further benefits/loss for both the alteratives cannot be measured.

3. from the given calculations in excel , automatic machine have higher benefit-cost ratio which is 1 than manual machine which is 0.92 . formula for benefit cost ratio = present value of future benefits / present value of future costs.

present value of future benefits is the total present value of cash inflows (revenue)

present value of the future costs is 5000 which is the initial investment , no additional future costs are given in the question.

(you can refer to the formula cell , in case of any doubts in applying the formula )


Related Solutions

You are a water filter manufacturer trying to decide if you should invest in an automatic...
You are a water filter manufacturer trying to decide if you should invest in an automatic or manually operated machinery. Both alternatives’ present costs are pegged at $5000, however, they lead to different revenue patterns thereafter. The automatic machine allows for higher production levels and thus more revenues immediately, however more energy costs over time than the manual machine means that net revenues diminish over time. The manual machine does not produce as many filters initially but has no energy...
You are an undiversified investor trying to decide whether you should invest in Disney or Amgen....
You are an undiversified investor trying to decide whether you should invest in Disney or Amgen. They both have betas of 1.25, but Disney has an R Squared of 73% while Amgen’s R squared is only 25%. Which one would you invest in? A. You would be indifferent B. Disney, because it has the higher R squared C. Amgen, because it has the lower R squared
You are a diversified investor trying to decide whether you should invest in Disney or Amgen....
You are a diversified investor trying to decide whether you should invest in Disney or Amgen. They both have betas of 1.25, but Disney has an R Squared of 73% while Amgen’s R squared is only 25%. Which one would you invest in? A. Disney, because it has the higher R squared B. Amgen, because it has the lower R squared C. You would be indifferent
Textile manufacturer, Joywill International, is trying to decide which vendor they should source for a yarn...
Textile manufacturer, Joywill International, is trying to decide which vendor they should source for a yarn needed in one of their products. Vendor A has a lower price than Vendor B but the determining factor must be the mean breaking strength of the yarn. Random samples were drawn from the vendors’ supply, with results shown below: Vendor A Vendor B Sample size 10 12 Sample mean 105 98 Sample variance 8 9 Do these data provide sufficient evidence that the...
An investor is trying to decide whether should would invest the Rs. 300,000 she received from...
An investor is trying to decide whether should would invest the Rs. 300,000 she received from the sale of her vanity in a blue whale venture or in a small fast food restaurant. If she invests in the blue whale venture she will receive Rs. 35,000 each quarter (starting three months from now). She expects to sell her share in the blue whale venture for Rs. 400,000 six years from now. If she invests in the fast food restaurant, she...
7) You are trying to decide whether to invest in a monthly income investment plan that...
7) You are trying to decide whether to invest in a monthly income investment plan that promises a variable return each month. You will invest in it only if you are assured of an average $150 monthly income. After doing research, you find that for the past 400 months, the plan had investment returns with an average value of $170 and a standard deviation of $85. Should you invest in this plan? Use a significance level of ? = 0.01....
You are trying to decide if you should build a factory or simply leave the money...
You are trying to decide if you should build a factory or simply leave the money in the bank collecting interest. It will cost $10M to build the factory and two years of time. Assume the factory will run for 25 years after that and generate $1.5M per year in profit each year. Assume a discount rate of 4%. Also assume that all of the $10M building costs are spent on day-one of construction. Should you build the factory or...
You have just received an inheritance of $10,000 and you decide that you should invest the...
You have just received an inheritance of $10,000 and you decide that you should invest the money rather than blow it on frivolous items. You have decided that you will invest the money in one of two types of mutual funds. The first type that you are considering follows a large-value approach to investing. This means that the mutual fund invests only in large, established companies that are considered to be a good bargain. The second type following a large-growth...
You have just received an inheritance of $10,000 and you decide that you should invest the...
You have just received an inheritance of $10,000 and you decide that you should invest the money rather than blow it on frivolous items. You have decided that you will invest the money in one of two types of mutual funds. The first type that you are considering follows a large-value approach to investing. This means that the mutual fund invests only in large, established companies that are considered to be a good bargain. The second type following a large-growth...
Benefit Cost Analysis: You are trying to decide if you should place a solar panel on...
Benefit Cost Analysis: You are trying to decide if you should place a solar panel on your apartment. You can buy the solar for 1000 dollars today, and it will reduce your electricity bill by $300/year from today until you graduate four years from now (NOTE: this means it is a 4-year project). If you face an interest rate of 10%, should you buy the solar panel for your apartment? Time Benefits Costs 0 300 1000 1 300 0 2...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT