Calculate the break-even point for the project

Assignment Help Financial Management

Reference no: EM131815028

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.

Reference no: EM131815028

Questions Cloud

Compare and contrast emergency management : Compare and contrast emergency management in 2 countries other than the United States, such as Israel and Great Britain.

Network notepad needs a computer running windows : Links to an external site.) to sketch the approximate location of each computer. (Network Notepad needs a computer running Windows 7 or 8 or 8.1 or 10)

Prepare an amortization table for this installment note : Prepare an amortization table for this installment note, similar to the one presented in Exhibit 3. Journalize the entries for the issuance of the note

Discuss transactions and economic events : Dogwood florist opened a business January 1st 2010. During 2010, they had the following transactions and economic events

Calculate the break-even point for the project : 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).

Recovery of a really large organization : Consider the statement: "No amount of disaster recovery planning will ever be enough to assure the recovery of a really large organization in every possible

Classifying the balance sheet accounts : Classifying balance sheet accounts For each account listed, identify the category that it would appear on a classified balance sheet.

Except that new distribution and general office facilities : except that new distribution and general office facilities are expected to increase fixed costs by $225 million

Clearly explain what n represents in your program : Clearly explain what n represents in your program. Make some assumption about how long it would take to execute one of the operations that you are counting.

User Account

All Pages