MK Wafflemakers (MKW) is assessing an investment decision. It is considering launching a new product: the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
MK Wafflemakers (MKW) is assessing an investment decision. It is considering launching a new product: the Crispy Waff. The project is based on market research undertaken at a cost of 200,000. The initial investment required is 30M. This attracts capital allowances in equal amounts over 4 years. The company's depreciation policy is to depreciate such investment straight line over 5 years. There will also need to be an investment in working capital at the start (Year 0) of 5M, which is expected to be recovered when production stops at the end of Year 6. Production will take place in an empty factory that MKW owns. If the project does not proceed, the building will be rented out for 1.5M per annum. Revenues are estimated to be 15M in Year 1 and to rise by 2% per annum until the end of Year 6. Costs are estimated to be 40% of revenues. However, it is estimated that the Crispy Waff will cause sales of Waffle Basic (another product made by the company) to fall by 20%. The Waffle Basic has estimated sales after costs, in Year 1, of 7M, rising at 1% per annum. For reporting purposes, head office allocate their costs to each department on the basis of 10% of revenues. Tax is payable at 19%, a year in arrears. The required return is 8.25% per annum. a. Design a spreadsheet model to assess this project. Your spreadsheet should be designed in a way that allows variables to be easily changed in order to facilitate sensitivity analysis. Using this model, find the net present value, the internal rate of return and the payback period in years and months. (20 marks) b. What is your recommendation? Explain your answer. (5 marks) c. Using the goal seek' function in Excel, find what the revenue growth would need to be for you to change your recommendation in part (b). Take a screenshot of the goal seek answer and insert the image into your TMA Word document. (2 marks) d. Insert a data table into your spreadsheet, showing the impact on the net present value of varying percentages of lost Waffle Basic sales and revenue growth. You should include a range of lost sales from 15 to 25% and revenue growth from 1.5 to 2.5%. (4 marks) e. Explain, using your own words, why net present value is generally considered to be a better appraisal test than the internal rate of return. (9 marks) MK Wafflemakers (MKW) is assessing an investment decision. It is considering launching a new product: the Crispy Waff. The project is based on market research undertaken at a cost of 200,000. The initial investment required is 30M. This attracts capital allowances in equal amounts over 4 years. The company's depreciation policy is to depreciate such investment straight line over 5 years. There will also need to be an investment in working capital at the start (Year 0) of 5M, which is expected to be recovered when production stops at the end of Year 6. Production will take place in an empty factory that MKW owns. If the project does not proceed, the building will be rented out for 1.5M per annum. Revenues are estimated to be 15M in Year 1 and to rise by 2% per annum until the end of Year 6. Costs are estimated to be 40% of revenues. However, it is estimated that the Crispy Waff will cause sales of Waffle Basic (another product made by the company) to fall by 20%. The Waffle Basic has estimated sales after costs, in Year 1, of 7M, rising at 1% per annum. For reporting purposes, head office allocate their costs to each department on the basis of 10% of revenues. Tax is payable at 19%, a year in arrears. The required return is 8.25% per annum. a. Design a spreadsheet model to assess this project. Your spreadsheet should be designed in a way that allows variables to be easily changed in order to facilitate sensitivity analysis. Using this model, find the net present value, the internal rate of return and the payback period in years and months. (20 marks) b. What is your recommendation? Explain your answer. (5 marks) c. Using the goal seek' function in Excel, find what the revenue growth would need to be for you to change your recommendation in part (b). Take a screenshot of the goal seek answer and insert the image into your TMA Word document. (2 marks) d. Insert a data table into your spreadsheet, showing the impact on the net present value of varying percentages of lost Waffle Basic sales and revenue growth. You should include a range of lost sales from 15 to 25% and revenue growth from 1.5 to 2.5%. (4 marks) e. Explain, using your own words, why net present value is generally considered to be a better appraisal test than the internal rate of return. (9 marks)
Expert Answer:
Answer rating: 100% (QA)
MK Wafflemakers Crispy Waff Project Spreadsheet Model Assumptions Initial investment 30M Working capital investment 5M Annual rental income from empty factory 15M Project life 6 years Depreciation met... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The general manager of the nationalized postal service of a small country, Zedland, wishes to introduce a new service. This service would offer same-day delivery of letters and parcels posted before...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Discuss the importance of asset allocation when developing a portfolio. In general, what is the conventional guidance in terms of allocating assets across the following three asset classes (equities,...
-
1. Discuss the difference between an emf and a potential difference. 2. In our study of electrostatics, we concluded that there is no electric field within a conductor in electrostatic equilibrium....
-
Which of the following is correct: (a) \(P_{\text {abs }}=P_{\text {atmospheric }}+P_{\text {gauge }}\) (b) \(P_{\text {abs }}=P_{\text {atmospheric }}-P_{\text {gauge }}\) (c) Both (d) None of these
-
When splitting a node of a regression tree into two subsets, how are the variable and its split value determined? a. At each step, the variable and its split value that are selected result in the...
-
The marketing manager for Glissen Paint is working on the weekly sales and marketing plan for the firms industrial and contractor sales staff. Glissens sales representatives contact two types of...
-
Conduct investigation into current trends in healthcare using the BU Library search capabilities and any other materials/resources provided to you in the course. Discuss what you think are some of...
-
Problem 3 addressed the cross-sectional variation in the number of financial analysts who follow a company. In that problem, company size and debt-to-equity ratios were the independent variables. You...
-
val Fatima Question 13 Given triangle ABC, mZA = 30, AB = 8 and AC = 7. Find BC. a) 113-563 ourses 330 [SEC 16 b) 113 Exams Graded c) /106-2 d) 4 57 f) None of the above. Question 14 The function...
-
What is complete crowding out? Is complete crowding out more likely to happen in the long run or in the short run? What would be the value of the government purchases multiplier if there were...
-
An article on brookings.edu noted that in recent years, a tight labor market hasnt led to a pickup in inflation. . . . This phenomenon is often referred to as the flattening of the Phillips curve. a....
-
A columnist on forbes.com observes that Robert Lucas argues that economic policy which depended on tricking people would not long work. Do you agree with this characterization of Lucass position?...
-
Do you think that Robert Lucas and Thomas Sargent would advocate increasing inflation in order to reduce unemployment in the short run? Briefly explain.
-
In an opinion column in the Wall Street Journal, economist Alan Blinder of Princeton University asks, Is the Phillips curve dead? a. Why have some economists and policymakers in recent years wondered...
-
Nu Company reported the following pre-tax data for its first year of operations. Net sales 3000 Cost of goods available for sale 2330 Operating expenses 720 Effective tax rate 40% Ending inventories:...
-
Experiment: Tossing four coins Event: Getting three heads Identify the sample space of the probability experiment and determine the number of outcomes in the event. Draw a tree diagram when...
-
A firm uses the inputs of fertilizer, labor, and hothouses to produce roses. Suppose that when the quantity of labor and hothouses is fixed, the relationship between the quantity of fertilizer and...
-
Angela has a monthly income of $120, which she spends on MP3s and a composite good (whose price you may assume is $1 throughout this problem). Currently, she does not belong to an MP3 club, so she...
-
Why does perfect information have value, even for a risk-neutral decision maker?
-
Complete a simulation of the entire process for the hydrodealkylation of toluene in Figure 6.14. Initially, let the purge/recycle ratio be 0.25 ; then, vary this ratio and determine its effect on the...
-
Use a process simulator to model a two-stage compression system with an intercooler. The feed stream consists of \(95 \mathrm{~mol} \%\) hydrogen and \(5 \mathrm{~mol} \%\) methane at \(100^{\circ}...
-
Cavett Problem. A process having multiple recycle loops formulated by R.H. Cavett [Proc. Am. Petrol. Inst., 43, 57 (1963)] has been used extensively to test tearing, sequencing, and convergence...
Study smarter with the SolutionInn App