1,316
18
Analysis Paper, 2 pages (350 words)

Rainbow products company analysis

Rainbow Products and the paint-mixing machine

A) The paint-mixing machine cost 35. 000 dollars, which is the initial cash outflow. The machine will generate additional cash inflows of 5. 000 dollars for the next 1 5 years. With cost of capital of 12% the Net Present value can be calculated using the NP formula in Excel: NP= – 945. 68 Data Description Rate $0. 12 935, 000. 00 Investment $5, 000. 00 scofflaws at the end of year $34, 054. 32 NP $-945. 68

Note that because the cash inflow is constantly reoccurring and occurs for a set period of time the Present value could also be calculated as an Annuity and then added to the initial cash outflow. Doing this calculation, one would expect the result to be the same. Internal Rate of Return, AIR, is the return on the investment when NP is zero. AIR can also be calculated using Excel: Because AIR is less than the cost of capital (12%) and the NP is negative, both methods suggest that undertaking the investment would destroy shareholders value, hush the investment should not be undertaken.

The simple Payback period is when the initial investment is recovered, this will occur at the end of year 7, thus the payback period is 8 years.

B) For an additional 500 dollars the machine can get service each year to ” as-good-as- new’ and the value of the investment can thus be calculated as a perpetuity. A Perpetuity is calculated as: Thus, NP = -35, 000 + 37, 500 = 2500 NP is positive with the service contract, so Rainbow Products should undertake the investment, as it will increase shareholder value.

C) Rainbows engineers have another way of preserving and increasing the capability of the machine, which allows the annual scofflaws to increase by 4%, this requires reinvesting 20% of the annual scofflaws. The Present Value of an end-of-year perpetuity is calculated as: Thus, the NP = -35, 000 + 50, 000 = 15, 000 As the NP of the investment in the machine with engineers added work is 12, 500 dollars more than the NP of the investment in the machine with ” as-good-as-new contract.

Thank's for Your Vote!
Rainbow products company analysis. Page 1
Rainbow products company analysis. Page 2
Rainbow products company analysis. Page 3

This work, titled "Rainbow products company analysis" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Analysis Paper

References

AssignBuster. (2022) 'Rainbow products company analysis'. 28 September.

Reference

AssignBuster. (2022, September 28). Rainbow products company analysis. Retrieved from https://assignbuster.com/rainbow-products-company-analysis/

References

AssignBuster. 2022. "Rainbow products company analysis." September 28, 2022. https://assignbuster.com/rainbow-products-company-analysis/.

1. AssignBuster. "Rainbow products company analysis." September 28, 2022. https://assignbuster.com/rainbow-products-company-analysis/.


Bibliography


AssignBuster. "Rainbow products company analysis." September 28, 2022. https://assignbuster.com/rainbow-products-company-analysis/.

Work Cited

"Rainbow products company analysis." AssignBuster, 28 Sept. 2022, assignbuster.com/rainbow-products-company-analysis/.

Get in Touch

Please, let us know if you have any ideas on improving Rainbow products company analysis, or our service. We will be happy to hear what you think: [email protected]