Devry BUSN278 2022 September Week 5 Course Project Part 2 Latest
BUSN278 Budgeting and Forecasting
Week 5 Course Project Part 2
Your Course Project is intended to be a comprehensive evaluation of the key objectives covered throughout this course. It will challenge you to apply your knowledge of various forecasting methods as well as CVP analysis and capital budgeting for a new business startup. Please use the grading rubrics below as an insight to how your course project submissions will be graded.
You will complete all your work on the Course Project Excel Template. Please click on this Course Project Excel Template linkLinks to an external site. to download and save this template. It contains all the project information, and this file is what you will submit for each Milestone once you have filled out the required fields and answered all the questions.
This is an individual project.
The following guidelines should be used when completing your project:
All DeVry University policies are in effect, including the plagiarism policy.
Any questions about this project may be discussed in the course Q & A area.
This project is worth 200 total points and will be graded on adherence to instructions, accuracy of computations, work shown, quality and completeness of question responses, and grammar and sentence structure.
All submissions must be on the Excel template provided rather than your own format.
Course Project Milestones
Milestone 1 Due Week 3Milestone 2 Due Week 5Milestone 3 Due Week 7
Milestone 2 is worth 100 points and is due at the end of Week 5.
Given a history of past annual sales and several forecast assumptions, you will create a 5-year forecasted Income Statement and a 5-year forecasted Balance Sheet using a mix of the percent-of-sales and pro forma methods of forecasting. Based on your resulting forecasted financials, you will conduct a ratio analysis, compute Required New Funds (RNF), and answer questions about your results. See the Course Project Excel Template for additional details and requirements.
Although Milestone 1 is fairly straightforward, Milestones 2 and 3 will take more time and effort. Make sure to start Milestone 2 by the beginning of Week 4, and Milestone 3 by the beginning of Week 6.
If you are new to Excel, view the Excel orientation videos. You may also want to watch some Excel tutorials -- there are numerous tutorials on YouTube.
If clear, proper writing is a challenge for you, then download the FREE software from Grammarly.com. It will find your spelling mistakes and will even suggest better ways to structure your sentences. Even if you write well, you should use this tool!
After completing Milestone 2, make sure to correct any errors you have made, since your Milestone 3 will be based upon your Milestone 2 results. You don't want to risk losing points twice for the same error.