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,...
-
The product of the following reaction has a broad absorption at 3330 cm -1 in its IR spectrum. Its 13C-NMR spectrum shows absorptions at 70(C), 34 (CH2), 30 (CH3), and 15 (CH3). Suggest a structure...
-
The ordinary share capital of W Ltd (which is a trading company) is owned 30% by X Ltd, 25% by Y Ltd and 45% by Z Ltd. All of these companies are UK resident and they prepare accounts to 31 March....
-
How to draft a demurrer?
-
(Fill in the blanks) 1. The FASB publishes its Accounting Standards Codification (ASC) as the source of accounting and reporting guidance for _______ hospitals. 2. FASB standards _______ (lways,...
-
An epicyclic, gear train, as shown in Fig.15.26 is composed of a fixed annular wheel A having 150teeth. The wheel A is meshing with wheel B which drives wheel D through an idle wheel C, D...
-
What size loan must we take today with a 6% compound interest rate to have end-of-year payments of $1400, $1320, $1240, $1160, and $1080 for the next five years, respectively? In other words, if you...
-
Is it possible that certain mental illnesses are really demon possessions? If yes, would any classified with a particular disorder be demon possessed? Or would only certain cases of a disorder by...
-
How do critical race theories challenge conventional understandings of race and ethnicity, especially in terms of systemic racism and intersectionality ?
-
A client has an internal control where the Director of IT approves software updates before they are available for download by employees. Which approach would an auditor use to test this control? ...
-
Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for $46. Wesley expects the following unit...
-
What role do assimilationist and multicultural policies play in shaping the dynamics of race and ethnicity, particularly in multicultural and postcolonial societies ?
-
What are the ethical considerations and challenges involved in conducting research on race and ethnicity, particularly in terms of reflexivity, positionality, and the potential for perpetuating harm...
-
Use the "percent of sales method" of preparing pro forma financial statements to determine the projection for next year's cost of goods sold. Make the following assumptions: current year's sales are...
-
How do individual companies respond to economic forces throughout the globe? One way to explore this is to see how well rates of return for stock of individual companies can be explained by stock...
-
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?
-
What is the difference between a primary beneficiary relationship and a foreseen party relationship?
-
What is the difference between a privity relationship and a primary beneficiary relationship?
-
What is the difference between a foreseen party relationship and a foreseeable party relationship?
Study smarter with the SolutionInn App