Course Project—Cost-Volume-Profit Analysis with Capital Budgeting

profilevicori19

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 and 4 (SPREADSHEET) to the project APPROVED you selected in 2.

 

Review the Course Project Guidelines.

 

Assignment Overview:

 

From the Microsoft Excel worksheet you developed in 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 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.
    • The detail must have enough historic data to give an investor an understanding of trends.
    • 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.

Submission Details:

 

Support your predictions and suggestions with scholarly resources and empirical evidence. Use APA format to cite your sources. Use this APA Citation Helper as a convenient reference for properly citing resources.

Your submission should include the following.

  • Your MS Excel worksheet named M5A2_CVP_Lastname_Firstinitial, detailing all calculations.
  • A minimum of 15 Microsoft PowerPoint slides (full copy of slides with notes) presentation.
  • Include the required information concisely highlighting only the key points necessary for the purpose of this presentation, which is to convince a prospective investor to decide if your project is worth investing in.
  • Your presentation should include sections addressing the topics listed and presented in bulleted format, avoiding long paragraphs of content.
  • Support your predictions and suggestions with scholarly resources and empirical evidence.
  • Use APA format to cite your sources.
  • Speaker notes totaling 2–3 pages providing the background summary and details for each slide.
  • Name your presentation Course Project_Lastname_Firstinitial.

 

Grading Criteria

Assignment Components
Proficient
Max Points
From M2 Project Approval Input
  
Complete the Project Approval Input and answer the questions provided.

Selects US public company and provides name and stock symbol. Explains interest in the company and in the investment project.

30
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.
180
Calculate the CVP or break-even point for the project.Calculations are complete and accurate.
15
Calculate NPV and IRR. Provides the numeric viability of the project investment.Calculations are complete and accurate.
25

Slide Presentation Requirements:

  

Includes a minimum of 15 slides

Each slide is visually appealing and formatted consistently. Proper spelling and grammar is used.
30
Cover pageCover page listing the company, project, date, and presenter.
10
Company summarySufficient written background so that a potential investor understands the business.
30
Data from Excel WorksheetEnough historic data from the graded worksheet to give an investor an understanding of revenues, costs, expenses, cash flows, and potential returns in dollars and using capital budgeting analysis concepts to demonstrate viability.
30
Analysis slidesPresent the breakeven and other type of analysis for the project.
40
Final recommendationsProvide your final analysis summary that details why the company should invest the money in this project.
40
Speaker notes on each slideSpeaker notes in your PowerPoint presentation to include background information that you would communicate verbally in a presentation. This background information should be the length necessary to explain the outline presented in the slides. Each slide must have the requisite speaker notes to explain the material/data presented in the slides as if you are making a formal presentation and expect to verbalize those words.
40
Total: 
470

 


    • 7 years ago
    • 30
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      course_project--cost-volume-profit_analysis_with_capital_budgeting.pptx
    • attachment
      course_project--cost-volume-profit_analysis_with_capital_budgeting.xls
    Bids(0)