Reference no: EM132194385
Question: In the last module, you completed your estimate of cash flows for your project. In this module, you will calculate the break-even point for the project and the expected financial returns.
• Open the Cost-Volume-Profit spreadsheet and calculate the break-even point of Johnson&Johnson. (Access the CVP template if you have not yet begun this work)
• The project must use a 6.5% cost of capital and a tax rate of 25%.
• Complete IRR (Internal Rate of Return) and NPV (Net Present Value) for the project.
• Make sure you show your Excel formulas or provide calculations so your instructor can review your work.
• You should have also considered key points of any intangible benefits or costs associated with the project and begun supplementing your pro forma statement with sufficient background information to enable a prospective investor to decide if your company is worth investing in.
Submit this worksheet to the M4 Course Project Submissions Area by the due date assigned.
Excel Worksheet Requirements:
Identify the various revenues, expenses, costs, expenses, and cash flows. If a manufacturing company and investment deals with projects, the analysis breaks down costs into fixed and variable, direct and indirect.
All costs, revenues, expenses, and cash flows required to implement the project are identified, listed and summed appropriately.
Calculate the CVP or break-even point for the project.
Calculations are complete and accurate.
Calculate NPV and IRR. Provides the numeric viability of the project investment.
Calculations are complete and accurate.
What is the full legal name of the US public company that you will use in your course project?
• The US public company that I will use in the group project is Johnson & Johnson.
What is the stock symbol for the public company you have chosen?
• JNJ
Why did you specifically choose this company for your project? Why are you interested in the company?
• Johnson & Johnson has been a part of my daily regime for my daughter when I take her bath and use some of their healthcare products. I want to learn more about the product and how the company is operating since the company is going through lawsuits.
What is the nature of the investment for this company that you are planning? Please explain your investment idea.
• Since Johnson&Johnson are going through financial issues, the company needs a new product that aims to gain the trust of the consumers. Therefore, Johnson&Johnson needs a new brand and eco friendly products that consumers can relate to now.
Information related to above question is enclosed below:
Attachment:- Cost_Volume_Profit_Analysis1.rar