week 7 project

week 7 project
DeVry University Course Project BUSN278 Budgeting and Forecasting Student Project Activity—Week 7 Week 7: Finalized Budget Proposal and Presentation TCOs Addressed TCO 10: Given a description of a new business, new product, service or project develop, present and defend the budget. Project Activity Overview—Scenario/Summary Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to finalize the budget proposal and presentation. Deliverables Put the finishing touches on your appendices and works cited sections and complete your executive summary. Update the table of contents with page numbers. Create a PowerPoint presentation complete with notes defending the presentation. Add Works Cited Section 6.0, any content to Appendices Section 7.0, your executive summary, and an updated table of contents (with page numbers) to the Budget Proposal Template.docx and save it as YourName_Project_WK7.docx. Also save the Budget Proposal workbook.xls as YourName_Worksheet_WK7.xlsx and upload both files to the Week 7 Project Dropbox. Project Tasks: Task 1 Add any works cited, appendices, or other details to your Budget Proposal Template.docx. Also complete your executive summary and page numbers in the table of contents. Task 2 Save the Excel and Word documents and submit them to the Week 7 Project Dropbox. Task 3 Create and save a PowerPoint presentation presenting and defending the budget proposal, placing notes in the presentation indicating your assumptions and defense of the budget components. Task 4 Submit the PowerPoint presentation to the Week 7 Presentation Dropbox. Grading Criteria: Project Proposal Item Description Points Content All parts of the template are fully completed. 5 Executive Summary The executive summary presents the major details of the budget proposal and adequately describes the business. 10 Sales Forecast The sales forecast is based on sound methodology and is complete. 15 Capital Expenditure Budget The capital expenditure budget is complete with capital expenditure items properly identified. 15 Investment Analysis The investment analysis is complete with NPV, rates of return, payback period, and net cash flow calculations. 15 Pro Forma Financial Statement Interaction The income statement, balance sheet and cash budget are properly constructed and are internally consistent. 15 Assumptions and Primary Research Assumptions and sources of financial estimates are understandable and reasonable for all financial statements. 15 Total 90 Grading Criteria: Presentation Item Description Points Spelling and Grammar There are no spelling or grammatical errors. 5 Summarization The key points from the budget proposal are presented at the right level of detail. 20 Professionalism The layout of the slides, color schemes, and content are readable and highly professional. 5 Total 30 End of Week 7 Copyright ®© 2010 by DeVry Educational Development Corporation. All rights reserved. No part of this work may be reproduced or used in any form or by any means—graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems—without the prior consent of DeVry Educational Development Corporation. Page 3 of 3 msk6di9ncw.doc
week 7 project
Dear Class: You will submit your final course project and project presentation by the closing Sunday of Week 7. Please review your assignment requirements in the DeVry Word Project Activity Week 7 document. In addition, I recommend that students review the DeVry Word Course Project Description, the original, blank DeVry Word Course Project Budget Proposal Template and the original, blank DeVry Excel Budget Proposal Workbook, to ensure that you have not overlooked any requirements. All of these documents are posted in Doc Sharing. Each numbered section of the Word template has instructions to include certain content and comments. For example, in Section 1.0 Executive Summary, students are to provide a second paragraph that describes how the budget supports the company’s strategy.  A third paragraph is also entered where you summarize the key points from your budget, including the planning horizon, the amount of up-front investment, the NPV, Payback and IRR of the project, as well as key figures from your income statement, cash flow statement, and balance sheet.  As previously posted in course announcements in Weeks 5 & 6, students are NOT completing a pro forma balance sheet for this course project this term. Do NOT complete “Section 5.3:  Pro-Forma Balance Sheets.”   Each student will submit three documents in the Week 7 drop box: an Excel Budget Proposal Workbook, a Word Course Project Budget Proposal Template, and a PowerPoint slide show.  The Word and Excel workbook can earn up to 90 points, and the PowerPoint slide show can earn up to 30 points, which total 120 points. A course announcement was posted in Week 6 in Course Home: “Instructor Suggestions for the Week 7 Final Course Project PowerPoint Presentation” that provides helpful guidance. Hello Class: To assist the class in finalizing the course project Section 4 investment metrics, I have posted an optional Excel worksheet in Doc Sharing: “Week 7 Final Section 4 Investment Metrics Template.” This worksheet is similar to the optional worksheet I provided to the class to complete the Week 4 course project activity assignment.  The Week 4 investment metrics calculations that students previously completed include estimates that are now obsolete.  The Week 7 final version however, incorporates your project’s Week 5 pro forma income statement net income and your project’s Week 6 pro forma cash flow statement annual net cash flows.    This entire worksheet can be pasted in your Excel Budget Proposal Workbook near Section 4 instead of filling in Sections 4.1 through 4.4.  First, open your Excel workbook. Then right click the worksheet tab below (Section 4.0 FINAL) and select “Move or Copy.” Students may leave their preliminary Week 4 investment metrics work in the Excel workbook or delete it, at your discretion.  If you have questions, please post them in the Q&A forum, send me an email, or call me during office hours, or as arranged Dear Class: This week, we will study about presenting and defending a budget and learn how an annual budget process is managed. You will participate in two graded discussions about administering the budget and presenting and defending a budget. You do NOT have an online homework questions assignment this week.  Your final course project is due this week on the closing Sunday.  Please see my Week 7 course announcement about help with this assignment that points to an optional Excel template to update your Week 4 investment metrics posted in Doc Sharing. 
week 7 project
Week 1 comments:  Please enter the specific five years covered by your proposal starting in 2017 on the cover page.  Papa Geo’s will be located in Orlando Florida and not in Chicago, Illinois; all three project companies are located in Florida—fix this. Excellent: You earned 10/10 points on your Week 1 Project Activity.  The business is briefly described in one paragraph; the business description is in your own words; the business description appears in the Executive Summary section of the Budget Proposal Template; and the business description is one of the three businesses described in the business profiles.  The second and third paragraphs of this section will be revised in the Week 7 final version after the Week 6 assignment has been completed. You are welcome to revise this section as you submit your weekly assignments but I will not grade it again until you submit the final version.  Please let me know if you have comments or questions. Week 2 comments: You earned 10/10 points on your Week 2 Course Project Activity. Your forecast should include arcade revenue. Your assumption to increase sales 50 – 60+% each year is quite aggressive. A 5-year sales forecast in dollars is entered in Section 2.1 of the Word and Excel documents; the 5-year forecast is supported in Section 2.2 of the Word and Excel documents; and the 5-year forecast calculations appear to be correct. You are welcome to revise your sales forecast as you proceed through this project. However, I will not grade it again until the final version of the project is submitted. Please let me know if you have comments or questions. Week 3 comments: You earned 10/10 points on your Week 3 Project Activity. To help clarify your thinking, note please that a Capital Expenditures budget should include only capital assets with a useful life of more than one year that will be depreciated.  Separate assets and expenses. Startup expenses such as business licenses and operating costs like utilities during the pre-opening phase are not capital assets and instead should be classified separately in a Startup Expenses analysis.  Small dollar value items will not be capitalized, even if the useful life is several years or more. Make an assumption please about the minimum amount that will be capitalized versus expensed.  I have suggested in discussion that real companies write a “capital assets policy” that include a “capitalization threshold” at $500 – $2,500 per one each of an item.  You are welcome to revise your capital expenditure budget as you proceed through this project. However, I will not grade it again until the final version of the project is submitted. Please let me know if you have comments or questions. Week 4 comments: Excellent but with errors.  Please see my comments in the purple cells in your Excel worksheet. You earned 10/10 points on your Week 4 Project Activity. Your Excel and Word files were reviewed. Your W3 CapEx budget includes expenses and small dollar value items that should be separately shown as upfront startup expenses rather than depreciable assets.  The optional W4 Excel “Five Year CapEx Investment Metrics Worksheet” that I posted in Doc Sharing is an estimate and is mostly intended to provide students an opportunity to practice how to calculate the investment metrics NPV, IRR, ARR, PI profitability index, and payback, using Excel. Your W7 final version of the W4 capital budgeting metrics will incorporate your company W5 pro forma income statement net income figures and W6 pro forma cash budget annual cash flow figures. For the W7 final version I will provide another optional investment metrics worksheet for students to use. Let me know if you have comments or questions. I attach the week 4 errors file Week 5 comments: Excellent. You earned 9/10 points on your Week 5 Project Activity, as follows: the pro-forma income statement is properly constructed; other necessary supporting budgets are present; most calculations are correct; and the sources and assumptions are not clearly identified. Please fix your Excel worksheet to calculate totals and subtotals. Your comments in your Word document Section 5 pro forma income statement that describe key figures and assumptions do not line up well with your figures.  Your cost of sales is not about $4/meal and your advertising is not 8% of sales. Review your comments and your research sources. Both your Word and Excel documents were reviewed. You are welcome to revise your budget proposal as you proceed through this project. However, I will not grade prior week work again until the final version of the project is submitted. Please see my comments in your attached assignment file. Let me know if you have comments or questions.  I attach week 5 feedback file from pro And also week 5 BUSN278 W5 Five Yr Pro Forma Income Stmt Template too