COURSE PROJECT—COST-VOLUME-PROFIT ANALYSIS WITH CAPITAL BUDGETING

MS6010 Course Project Guidelines
Your course project will consist of a 15–20-slide Microsoft PowerPoint presentation. These slides will help you present your investment idea to the President and CEO of the public company. As such, the slides must be well crafted to help convince the leader of the company of the need for the investment, the possible risks, and potential returns. Remember, the slides should outline the key points to be made and not overwhelm the viewer with too many details. You will provide the details in the speaker notes for each slide. The slide presentation must include:

1. Cover page      listing the company, project, date, and presenter.
2. Sufficient      background so that a potential investor understands the business.
3. The      investment idea and summary justification.
4. Enough      historic data from the worksheet you develop in Modules 3 and 4 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.
5. The break-even      of the project.
6. Your final      analysis summary that details why the company should invest the money in      this project.
7. Speaker      notes in your Microsoft PowerPoint presentation to include background      information that you would communicate verbally in a presentation. This speaker      notes content 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.

This slide presentation is due before the end of class on Day 5 of Module 5 and is worth 25% of your course final grade or 250 points. Combined with the other submitted elements of the project, the total points allocated to this course project will be 500 points or 50% of your grade. The grading of this project will be extensive to match the percentage of course grade. Make sure you provide substantial work in the creating of this project.
Breakdown of Course Project Work
 
Module
Major Task
Points
 
1
Select public company and   begin planning project.
 
2
Seek approval of the   company, project investment idea, and justification by completing the Project   Approval Input in the link provided.
30
 
3
Begin working on the   Excel worksheet provided with the project to outline the revenues, costs,   expenses, and resulting cash flows.
 
4
Submit the final Excel   worksheet showing all data and calculations.
 
5
Submit Microsoft PowerPoint   presentation complete with speaker notes before the end of class Day 4.
470
 
Grading Criteria
 
Assignment Components
Proficient
Max Points
 
By end of Module   2, 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 formatted consistently with   proper spelling and grammar.
30
 
Cover page
Cover page listing the company, project, date,   and presenter
10
 
Company summary
Sufficient written background so that a   potential investor understands the business.
40
 
Data from Excel Worksheet
Enough 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 slides
Present the breakeven   and other types of analysis for the project.
50
 
Final recommendations
Provide your final   analysis summary that details why the company should invest the money in this   project.
40
 
Speaker notes on each slide
Speaker 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.
50
 
Total:
500
The company I chose was Lockheed Martin, I would like to have a festival in Pensacola Fl. For children showcasing the robotics the military uses to get the younger generation interested in this type of work and to support our military.
Below is one they are already having in DC, I want one in Pensacola Fl.
USA SCIENCE & ENGINEERING FESTIVAL
FREE EXPO: APRIL 7-8, 2018
Lockheed Martin is proud to be the founding and presenting host of the USA Science & Engineering Festival, the largest—and only—national STEM (science, technology, engineering, mathematics) event, created to inspire the next generation of scientists and engineers.
This free event features more than 1,000 STEM organizations presenting hands-on,
fun science activities for people of all ages.
Course Project—M3 Working Ahead
Last module, you received your instructor’s approval of your company and actual planned investment. In this module, you need to begin working on the Cost, Volume, Profit Analysis spreadsheet provided for the project to outline the revenues, costs, expenses, and resulting cash flows. If you selected a manufacturing company and the project deals with a product or change in project, you will need to consider direct and indirect costs. Detail out your costs and cash flows. Make sure these are reasonable for the project you have selected.
Before the end of Module 3, you should have all of your revenues, expenses, investments, profit, and resulting cash flows on an Excel worksheet complete with all calculations performed using Excel functions.
You will submit this spreadsheet for review by you instructor in Module 4. It will then be included as part of your final project in Module 5 and is worth 220 points, so be sure to get started on it now.
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 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.
Assignment 2: 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.
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.
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 MS6010_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.