Assignment: Course Project-Cost-Volume-Profit Analysis with Capital Budgeting
In this assignment, your goal is to use CVP analysis in a presentation of your project to enable a prospective investor to decide if your project is worth investing in. You will apply the concepts of CVP analysis learned in Modules 3 and 4 to the project you selected in Module 2.
Review the Course Project Guidelines.
Assignment Overview:
From the Microsoft Excel worksheet you developed in Modules 3 and 4, create a basic pro forma statement necessary to convince someone to provide the start-up funding of the project and then use this information, along with other outside research to create a Microsoft Power Point presentation. The slides of your presentation should be visually appealing-only containing the key points while the speaker notes associated with each slide should provide the essential details.
Assignment Tasks:
To create a pro forma statement:
1. Summarize the company and explain CVP and Capital budgeting. Use outside resources to best explain CVP and capital budgeting.
2. Identify and list the various costs-fixed and variable, direct and indirect-required to execute the project.
3. Calculate the break-even point for the project and the expected financial returns. (This is the work you have been doing in the CVP template). Make sure you show your Excel formulas or provide calculations so your instructor can review your work. Save your final calculations as MS6010_M5A2_CVP_Lastname_Firstinitial.xls. The completed template must accompany the slide presentation.
4. Include a brief discussion of key points of any intangible benefits or costs associated with the project.
5. Supplement your pro forma statement with sufficient background information to enable a prospective investor to decide if your company is worth investing in.
• Open the Cost-Volume-Profit spreadsheet that you have been working in and calculate the break-even point.of your proposed project. (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.
o The detail must have enough historic data to give an investor an understanding of trends.
o You should also have sufficient written background so that a potential investor understands the business. Use the speaker notes area of your presentation to add background information that you would communicate verbally in a presentation. This background information should be 1 to 2 pages in length.