-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Finance Question NPV, Payback Period, Profitability Index, IRR Calculations
Question
MCL Ltd is a manufacturer and distributor of agricultural equipment. MCL produces milking machines and supplies as well as being the sole Australian distributor of machinery from the US- based company FarmGo Ltd.
The CEO of MCL has been negotiating for some time with a German company that produces new technology equipment that assists farmers with climatic information such as recording and predicting rainfall patterns, temperature readings and historical livestock sale values. In order to become the Australian distributor of this new technology, a $300,000,000 payment would be required to secure the rights. A further $20,000 would need to be spent to secure trade names in Australia.
It is expected that the unit price of the sale of the technology to farmers would be $50,000 with the cost being $38,000 per unit. The following unit sales are anticipated:
Year 1 - 6,000
Year 2 - 12,000
Year 3 - 12,000
Year 4 - 10,000
Year 5 - 6,000
The company’s Marketing Manager anticipates that a $40,000 marketing campaign would need to be undertaken in the first year in order to create the expected demand. This is based on a $12,000 study already completed by an external marketing agency. MCL’s Finance Manager has determined that the license will lead to an increase in Net Working Capital of $60,000. An ATO ruling has been gained to allow the write off of the rights and trade name payments over the 5 years for tax purposes. The cost of external assistance in gaining this ruling was $7,000. At present the company pays tax at a rate of 30 cents per dollar.
The cost of capital for the company is 12%.
Part 1
(a) Calculate, showing all workings:
- Net Present Value
- Discounted and Undiscounted Payback Period
- Profitability Index
- Internal Rate of Return to 2 decimal places
(b) Write a one page memo to the CEO of MCL advising him as to whether the company should proceed with gaining the right, giving reasons for your decision.
(c) The original contract with FarmGo Ltd includes a clause requiring MCL to make a one-off payment of $70,000 to the US company if they gain any other exclusive distribution rights. Also an ongoing payment of $10,000 is required for the life of the license.
Calculate the impact of this or your analysis and write a short (1-2 paragraphs) memo to the Finance Manager on the implications of this.
Part 2
(a) What is the effect on the NPV for the project if (Treat each of the following situations independently): a. Sale of rides figure decreased by 10% (from the initial estimates) between year 3 and 5
b. The tax rate changed from 30% to 25%
c. The board is not convinced with your study and would like to order another independent study. The study is estimated to cost $7500.
Summary
The question is in finance. This question is about a company acquiring dealership of an agricultural equipment producing company. The selling price of the units, the cost of the units and the number of units expected to be sold for 5 years are given. NPV, payback period, profitability index, IRR, have been calculated. Please refer to the Excel document for calculations.
WHAT OUR STUDENTS SAY
Thank you guys for your great assistance. Loved the way you dealt with the assignment. Very satisfied with the work and will use your service again.
Aaron Student
I found it very difficult in keeping up with the assignments with the rest of the class and also had problems with the topics like probability, displaying data etc. Then I found TheReliableTutor.com and all my misery has come to an end. The stats experts here helped me out with all my assignments and since then I have been getting better grades. Thanks a lot….
Evan Nicholas Student
The tutors at TheReliableTutor.com are experts at taxation laws of multiple countries which makes their research work of very high quality. I am very impressed with the quality of taxation assignment tutoring I received for my assignment help request on capital transfer tax. The tutor assigned to me was aware of all the latest judicial amendments and litigation which made the assignment content that much better. I got a B and now have taken a package for the entire semester.
Monica Fredrickson Student
1. As an undergraduate statistics student at one of the leading institutes in London I was finding it increasingly difficult keeping up with the assignments with the rest of the class. I was lost, and not in a good way, in probability, displaying data etc. That is when I found TheReliableTutor.com. Here the stats homework solver helped me out with all my assignments and I have been getting great reviews and grades since then.
Jeremy Schein Student
I was struggling with the deadlines of my assignments and increasingly felt at a loss with my undergrads law program at the Victoria Law College. 24 hours in a day were not enough to do the research and structure the assignment essay. At TheReliableTutor the tutors understand my deadlines and I have never had them delay.
Alison Tait Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.