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.
