To install StudyMoose App tap and then “Add to Home Screen”
Save to my list
Remove from my list
Diamond chemicals is a leading propylene producer and a major player in the chemicals industry worldwide. However the share of the company had fallen from £60 at the end of 1999 to £30 in 2000 on account of worldwide economic slowdown and poor financial performance. Given the prevalent scenario, it was time to obtain funds from corporate headquarters for a modernization program for Merseyside project. This project will not only renovate and rationalize a production line but also make up for deferred maintenance and increase production efficiency.
Lucy Morris is the Plant Manager at Merseyside and by nature she is a high achiever and a Notre dame MBA.
Frank Greystock is the Controller, President of Diamond Chemicals. To make a compelling case, Frank and Lucy try to make a financial model to calculate the NPV, IRR and Payback period for this project but are challenged on several aspects. To pursue their endeavor, they need to correct the model as per the feedback from the shareholders and management.
Thus the problem statement is to suggest corrections to the existing model and thus calculate the NPV, IRR and payback period which would not be challenged further and the project could be approved. Methodology and Results
In addition to the baseline model presented in Exhibit 2 of the case study, four cash flow models were built considering the following criteria:
Cannibalization of demand: This model reflects a reduced output at Rotterdam. The cannibalization aspect is obtained by shifting the added volume from the plant in Holland (Rotterdam) to the plant England (Merseyside) regardless of the fact that both plants operate under the same company.
The recommended model above considers a 3% inflation which varies from 1.2 – 5.1% in UK. Considering this variation the following graph shows how the NPV and IRR would change with inflation.
The company charges a 3.5% for overhead investments. However, as the project is expected to reduce overhead costs, increase efficiency, output and reduce the power consumption, this overhead investment fee should be waived. If this waiver is implemented, the NPV increases to £15.0 Million. The Purchase Cost of Rolling Stock is currently considered as £ 2 Million. This would be used for transportation needs arising due to the anticipated excessive demand.
However this investment would be made regardless of the project and hence only a part of the investment should be considered for the modeling purposes. What proportion of the investment would be used specifically for this project will determine the value of the Purchase Cost of Rolling Stock that would be definitely lesser than £2 Million. Currently, the model is based on the assumption that the production will run on full capacity and the sales team will be able to sell all of the throughput. This assumption should be tested and, if not valid, the variation should be accounted in the model.
Merseyside Company Case. (2016, Mar 17). Retrieved from https://studymoose.com/merseyside-company-case-essay
👋 Hi! I’m your smart assistant Amy!
Don’t know where to start? Type your requirements and I’ll connect you to an academic expert within 3 minutes.
get help with your assignment