Module4 ExcelAccounting Class really need help due on the 9th of August

Course Project—M4 Working Ahead

Cost-Volume-Profit (CVP) Analysis

Review the Course Project Guidelines.

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 that you have been working in and calculate the break-even point.of your proposed project. (Access theCVP 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 Dropbox by the end ofWednesday, August 9, 2017. Your grade for this work will be included in your course project final submission in Module 5. The completed worksheet will be worth 220 points or 22% of your grade. This is how your spreadsheet will be graded in Module 5.

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.


In Module 5, you will also be completing your Microsoft PowerPoint that summarizes the investment and seeks the approval of the President and CEO of your public company. You should begin work on this as soon as possible as the due date for the completed presentation is Monday, August 14, 2017. The MS PowerPoint presentation will be worth 250 points.

Scroll to Top