MN7029NX – Financial Decision MakingWord Count - No word Limit. In your system, I have to select word count. So I select 3250 word count. But don't concern about the word count.Two Section - Report...

1 answer below »
MN7029NX – Financial Decision Making
Word Count - No word Limit. In your system, I have to select word count. So I select 3250 word count. But don't concern about the word count.



Two Section - Report and Presentation



Period - 40 hours























Page 1 of 5 MN7029NX – Financial Decision Making Assessment 2 London Metropolitan University Master of Business Administration MN7029NX – Financial Decision Making Assessment Title Assessment 2 – Individual Coursework Module Leader Natalie Langley/ Yogesh Bhawnani Assessment Weighting 70% Contact Person Tharinda Rajapaksha – Student Services Team Date of Submission 07th September 2023 at 2359H GST Learning Outcomes On successful completion of this module, you will be able to demonstrate the following learning outcomes: ▪ LO 1 - Critically evaluate company financial performance and make recommendations for improvement ▪ LO 2 - Demonstrate an understanding and use of the appropriate analytical techniques to be applied to business case development and Investment appraisal; the raising of finance and the distribution of funds to investors ▪ LO 3 - Communicate financial information, analysis, issues and recommendations clearly and concisely Task The assessment assesses learning outcomes 2 and 3 of the 3 module learning outcomes of this module. Background information Smart Home Plc (a fictional company) is a UK incorporated and UK tax resident technology company focussing on the manufacture and retail of internet enabling devices for homes. The business has been conducting Research and Development on a new smart watch and now needs to make a decision whether to go ahead with launching the product and determining what is an appropriate price for it. You are the Business Manager responsible for the product launch and the CEO has asked you to prepare a report on the investment in the new product. With the Finance Manager on leave for the next 3 weeks, you are on your own for the presentation. You have been given the following information from various teams in the organisation. R&D Team “We’ve spent quite a lot on developing this project - £450,000 – and it would be a shame if we didn’t get it to market. I would estimate that we would need to spend around and other £60,000 on research costs to get it to a position where it is ready to launch”. Page 2 of 5 MN7029NX – Financial Decision Making Assessment 2 The production department “I’ve looked into the production of the smart watch and we will need to purchase a new machine to manufacture at the scale we want which will which will cost us £1,500,000. We have spare capacity in current staff to run the machine, but we will need to hire a “Specialist Supervisor” for the machine – I asked the HR team to let me know what the salary for that person would be, but they haven’t got back to me yet. The machine will last for around 5 years – you need that for your depreciation calculations, right?” The Marketing director “I’ve done some research on the potential pricing of the watch and likely customer targets and worked with someone in the finance team to look at pricing. I think our wholesale sales price should be £150 per watch over the course of the whole 5 years. The cost of the raw materials makes up 40% of the sales price. My team have estimated that sales for the first 5 years should be as follows: Year 1 10,000 watches Year 2 12,500 watches Year 3 15,750 watches Year 4 15,750 watches Year 5 12,350 watches After 5 years we think that the tech will have advanced beyond this and the product will no longer be attractive so we are assuming that the life of this project will probably only be until then before we need to make a new investment, and we are constantly innovating other projects. The machine will not have any scrap value at this stage. We’re planning an advertising and marketing campaign costing £545k in year 1 to get started and these costs will the same in in year 2 and 3, and fall to £190k in years 4 and 5. Oh, and HR have just confirmed that the Supervisor salary and benefits will start at £36k in year 1 but we expect inflationary rises to be 3% year on year. That includes our National Insurance costs” You have investigated how to calculate an appropriate cost of capital (WACC) and gathered the following information: ▪ The market value of the shares is £2.75 per share and there are 5.5 million ordinary shares in issue. Dividends are expected to continue at 30p per share for the foreseeable future ▪ The company has £10m in irredeemable loan capital with an interest rate of 7% and it is currently quoted at £95 per £100. The tax rate is 20%. The business has previously been using an estimated Weighted Average Cost of Capital of 20% and the management team would like to see your calculations using the WACC you have calculated and the original estimate of 20%. Your Task In the absence of the Finance Manager the CEO wants you to make a presentation to the Board about whether the project should go ahead. The Board are not finance people but are very interested in the techniques that are used to appraise investments and so would like a comprehensive explanation of how you came to your conclusion. In particular they would like you to include the following: 1. Executive summary (please also include a short voiceover recording on the slide of no more than 5 minutes presenting the executive summary and conclusion of your project) Page 3 of 5 MN7029NX – Financial Decision Making Assessment 2 2. A projected cash flow for the project over its 5-year life 3. An explanation of cost of capital including: a) What is Weighted Average Cost of Capital (WACC)? b) What do we use WACC for? c) Your calculations of the WACC of capital for the business showing each of the individual components. 4. A financial evaluation of the project using the NPV and Payback Period Methods including: a) Your calculations of NPV and Payback period for the project using WACC (the detail should be in the Appendix of the report and should be calculated in Excel ) b) Your calculations of NPV and Payback period for the project using the previous business cost of capital of 20% (the detail should be in the Appendix of the report and should be calculated in Excel ) c) A decision as to whether the project should go ahead and your justification for these decisions 5. An explanation of the benefits and limitations of the 4 main investment appraisal techniques. 6. An explanation of the different types of funding available to a company (Long term, short term, equity and debt and others), the advantages and disadvantages of each and a detailed explanation of what a bank might look at in deciding whether to make a loan to a company and the steps they might take for extra protection on the loan repayment. 7. Conclusion Your report should have an executive summary at the start and a conclusion at the end and you should conclude on the viability of the project at the current cost of capital and the situation if cost of capital were 20%. Please also remember to include a voiceover recording (no more than 5 minutes) on the executive summary page highlighting your executive summary and conclusions regarding the project. Structure of the Report The report should be prepared in PowerPoint and should contain the following slides: ▪ Executive summary (A summary of your proposal in a page & Voiceover recording) ▪ Introduction ▪ Calculation and critical evaluation of WACC (detailed calculation may be shown in an Appendix) ▪ Projected cash flow ▪ Calculation of NPV and PP (detailed calculation may be shown in an Appendix) using the WACC ▪ Calculation of NPV and PP (detailed calculation may be shown in an Appendix) using a cost of capital of 20% ▪ Explanation of and critical evaluation of the 4 main capital investment appraisal techniques ▪ Critical explanation of different forms of funding for companies ▪ Conclusion ▪ Appendices – detailed calculations and references. Format Page 4 of 5 MN7029NX – Financial Decision Making Assessment 2 This is an Individual Coursework in the form of a Presentation. You are required to submit a presentation PPT. Assessment Criteria The available marks for the assessment will be awarded as follows; Assessment Criteria Weighing Calculation and explanation of WACC for the company 15 A projected cash flow for the project 15 Calculation of NPV and Payback Period using the WACC you have calculated 15 Calculation of NPV and Payback Period using a 20% cost of capital 15 A decision as to whether the project should go ahead and your justification for this decision 5 An explanation of the benefits and limitations of the 4 main investment appraisal techniques 10 An explanation of the different types of funding available to a company (Long term, short term, equity and debt and others), the advantages and disadvantages of each and a detailed explanation of what a bank might look at in deciding whether to make a loan to a company and the steps they might take for extra protection on the loan repayment. 15 Your report and presentation: executive summary, professionalism, summary recording, logical flow and conclusion 10 TOTAL 100 Please note that marks 50-100 are in the Pass category (P for pass on E-Vision). Marks 70-100 support an award with Distinction, 60-69 an award with Merit, 50-59 a Pass award. Marks below 50 are in the Fail category, meaning that your award is at risk and that you will have to participate in re-assessment. Submission The following submission instructions must be applied and strictly adhered to: ▪ Assessment Cover Slide needs to be attached as the 1st slide of your presentation. ▪ You are required to submit the following components. ▪ Presentation PPT (PPT including the voiceover recording) ▪ You are required to name your submission files as follows; ▪ LMU ID Number_MN7029NX_A2(e.g.; 12345678_MN7029NX_A2) ▪ Submissions must be made to the NEXT Moodle submission point on or before 07th September 2023 at 2359H GST. (Please note that submissions through e-mails will not be accepted under any circumstances). Academic Integrity & Plagiarism Page 5 of 5 MN7029NX – Financial Decision Making Assessment 2 Post Graduate Marking Criteria Mark Range An outstanding answer, showing evidence of a deep understanding and critical appreciation of the subject, with judicious choice and appropriate use of sources going beyond the references provided (e.g., on reading lists). The approach to the subject demonstrates originality and flair. 80 – 100 An excellent answer, showing evidence of wide knowledge and understanding of the subject and/or originality of approach, with the development of an independent critical analysis. Answer draws on judicious choice and appropriate use of sources going beyond the references provided (e.g., on reading lists). 70 – 79 A comprehensive, well-organised and accurate answer, drawing on a good range of relevant sources, showing good grasp of relevant theory and the development of an independent analysis. 60 – 69
Answered 2 days AfterAug 29, 2023

Answer To: MN7029NX – Financial Decision MakingWord Count - No word Limit. In your system, I have to select...

Sandeep answered on Sep 01 2023
25 Votes
Appendix - WACC (New) (2)
        Determination of NPV of Internet Enabling devices                 Depreciation Calcualtion
        
                Cost of New Machine     1,500,000.00
                    Less    Scrap Value    0
        Cost of New Machine    1,500,000.00                1,500,000.00
            1,500,000.00            Depreciation - Amortize cost equally over 5 years    300,000.00
        Projected Cash Flows (CFAT) and NPV Calculation
            Year 1    Year 2    Year 3    Year 4     Year 5
        Sales (Units)    10,000    12,500    15,750    15,750    12,350
        Saleds (£)    150    150    150    150    150
        Total Sales(£)    1,500,000    1,875,000    2,362,500    2,362,500    1,852,500    A
                                        £
    Less     Cost of Raw Material(40% of Sales)    600,000    750,000    945,000    945,000    741,000
    Less     Advertising and Marketing cost    545,000    545,000    545,000    190,000    190,000
    Less     Supervisor salary and benefit    36,000    37,080    38,192    39,338    40,518
    Less     Depreciation     300,000    300,000    300,000    300,000    300,000
        Total Costs    1,481,000    1,632,080    1,828,192    1,474,338    1,271,518
        Earning before Taxes (EBT)    19,000    242,920    534,308    888,162    580,982
    Less    Taxes (20%)    3,800    48,584    106,862    177,632    116,196
        EAT     15,200    194,336    427,446    710,529    464,785
        CFAT (EAT +...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers