19 Jun The ‘Master of Business Administration-CL’ is the grading rubric for this assignment, and the assignment must be completed strictly according to the rubric. 2. The ‘asse
1. The "Master of Business Administration-CL" is the grading rubric for this assignment, and the assignment must be completed strictly according to the rubric.
2. The "assessment 2" document contains the materials for the target company of this assignment, and the assignment must be completed based on these materials.
3. The "investment-appraisal-for-tech-innovations-ltd+%282%29" is a table example. I need you to create a table for this assignment following the format of this example.
Therefore, this assignment requires two submissions:
1. **PPT**: The PPT must include the formulas, processes, and results needed for the calculations. It must be completed strictly according to the grading rubric.
2. **Excel**: The Excel file needs to be completed based on the example I uploaded. The calculation processes (Fx functions) must be retained. Do not provide just the final result.
If this assignment can be completed excellently within the specified time, I will give you four more assignments with the same requirements.
Assessment 2
Assessment Brief
Introduction
The assessment assesses learning outcomes 2 and 3 of the 3 module learning outcomes of this module, which are that on successful completion of the module students will be able to:
· 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;
· Communicate financial information, analysis, issues and recommendations clearly and concisely.
The Question
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”.
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
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 this 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%.
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)
· 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
The Powerpoint file should be uploaded to Turnitin. A template is provided but you should feel free to adapt and personalise this.
Assessment Marking Scheme
The assessment is marked out of 100.
Master of Business Administration
Assignment Submission Form
Module Code: |
MN7029SR |
Module Title: |
Financial Decision Making |
Assessment Title: |
Assessment 2: Individual Work |
Lecturer Name: |
|
Student ID Number: |
|
Student Name: |
|
Assessment due date: |
25 June 2024 |
Student Declaration: |
By submitting this assignment, I/ we confirm that I/we have not sourced or used any information from any online ‘essay’ provider nor any other third party not acknowledged in my/our assignment. I/ We declare that the work submitted is my/our own. Students should note that the University has a formal policy on plagiarism which can be found at https://student.londonmet.ac.uk/your-studies/student-administration/rules-and-regulations/academic-misconduct/ |
Guildhall School of Business and Law
Feedback/Feedforward Coversheet
MN7029SR Financial Decision Making |
Academic Year 2024/25 Assessment 2 Individual Assignment |
|||
First Marker: |
||||
Second Marker: |
||||
Title of presentation: |
||||
Level of achievement |
Marks to be awarded |
First Marker |
Second Marker |
|
15 m |
||||
15 m |
||||
Calculation of NPV and Payback Period using the WACC you have calculated |
15 m |
|||
Calculation of NPV and Payback Period using a 20% cost of capital |
15 m |
|||
A decision as to whether the project should go ahead and your justification for this decision |
5 m |
|||
An explanation of the benefits and limitations of the 4 main investment appraisal techniques |
10 m |
|||
An explanation of the different types of funding available to a companies (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 m |
|||
Your report and presentation: executive summary, professionalism, summary recording, logical flow and conclusion |
10 m |
|||
Total |
100 m |
From First Marker |
|
Knowledge and understanding |
|
Analysis and evaluation |
|
From Second Marker |
|
Knowledge and understanding |
|
Analysis and evaluation |
|
Agreed Marks First Marker’s marks /date Second Marker’s marks/date |
Please upload the Turnitin Report
|
Sheet1
Tech Innovations Ltd Investment Appraisal | |||||||
Development Cost | Dividend Per Share (DPS) | £ 0.35 | |||||
Research Cost | 80,000 | Price Per Share (P) | £ 3.00 | ||||
Total R&D Cost | Growth Rate (g) | 0% | |||||
Tax Rate (T) | 20% | ||||||
Equipment Cost | 1,800,000 | Common Shares Outstanding | |||||
Salvage Value | 420,000 | Irredemmable Capital Loan | £ 12,000,000 | ||||
Proforma Income Statement | |||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | |
Revenue | |||||||
Unit Sales | – | 20,000 | 22,000 | 28,000 | 34,000 | 18,000 | |
Sales Price | – | 280 | |||||
Total Revenue | – | ||||||
Cost of Goods Sold (COGS) | – | ||||||
Gross Profit | – | ||||||
Expenses | |||||||
Supervisor's Salary | – | ||||||
R&D Expenses | – | ||||||
Ad. & Marketing Expenses | – | (400,000) | |||||
Depreciation Expense | – | ||||||
Total Operating Expenses | |||||||
Total Operating Profit (EBIT) | |||||||
Financing | |||||||
Interest Expense | – | ||||||
Pretax Income | |||||||
Tax Expense | – | ||||||
Net Income | |||||||
Cash Flow Projection | |||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | |
Net Income |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. About WridemyWe are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers. How It WorksTo make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Are there Discounts?All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure. Hire a tutor today CLICK HERE to make your first order |