BUSINESS BUDGETING AND FORECASTING PROJECT

Objectives
The Budget Proposal 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 the budgeting process (including sales forecasting) when creating a budget proposal for a new business startup. Please use this outline and grading rubric as a guide in completing your Course Project. It provides specific details of the required elements of the project, and it will be used by your instructor as a grading guide.

The documents you need in order to complete the project are located in the Files section. The Course Project Description provides an overview of the project, as well as the information pertaining to the business for which you will prepare the budget proposal. The weekly Project Activity documents provide a detailed description of the project content that is due each week. All of your work will be done in the Budget Proposal Template and the Budget Proposal Workbook.

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

This is an individual project. The project presentation will be given using a tool such as narrated PowerPoint, WebEx, or other tool that records the presentation.

Guidelines
The following guidelines should be used when completing your project.

Even though this is not a scientific writing assignment and is mostly creative in nature, references are still important. At least one authoritative, outside reference is required (anonymous authors are not acceptable). These should be listed on the last page (titled Works Cited).
Appropriate citations are required.
All University policies are in effect, including the plagiarism policy.
The Final Budget Proposal is due during Week 7 of this course and the Presentation in Week 8. Weekly drafts are due as indicated below as well as in the Course Project Description document.
Any questions about this paper may be discussed in the course Q & A area.
This project is worth 400 total points and will be graded on quality of content, organization, proper use of citations as necessary, and grammar and sentence structure.
The formatting standards outlined in the Budget Proposal Template should be followed.
Milestones
Each week, you will complete a section of the project in draft form. In Week 7, you will submit the final version of the project’s Budget Proposal Template, Budget Proposal Workbook, and Budget Presentation in PowerPoint.

Week Deliverable Points
1 Section 1.0 Business Description/Objectives Summary (Draft) 10
2 Section 2.0 Sales Forecast (Draft) 10
3 Section 3.0 Capital Expenditure Budget (Draft) 20
4 Section 4.0 Investment Analysis (Draft) 20
5 Section 5.1 Pro Forma Income Statement (Draft) 10
5 Section 5.2 Pro Forma Balance Sheet (Draft) 10
6 Section 5.3 Statement of Cash Flow (Draft) 20
7 Final Budget Proposal Template and Budget Proposal Workbook 200
8

Final Budget Presentation in PowerPoint

100

Total

400

Best Practices
Complete a first draft and then go back to edit, evaluate, and make any required changes.
Use visual communication to clarify and support the written part of your report. The Budget Proposal Template indicates where visual aids are required. You may include additional forms of visual communication to support your assumptions and ideas.
Consider your audience when preparing the Budget Presentation.
Weekly Project Activities
Selecting the Project
Review the Course Project Description and select from one of the three businesses defined in the document – the Italian Restaurant, the Landscaper, or the Wireless Electronics store.

Week 1 Project Activity: Business Description/Objectives Summary (Draft)
This week, you will start working on your Project Activity for Week 1. You have been asked to create a budget proposal for one of these businesses: the Italian Restaurant, the Landscaper, or the Wireless Electronics store.. This week, you will begin working on the proposal by drafting the Objectives Summary. Use Word to draft a response. You will be graded on correct analysis, and business-like presentation of the information.

Grading Rubric
Section 1.0 Business Description/Objectives Summary (Draft) Deliverable Points
The business description is in your own words and is not longer than two paragraphs. It must be one of the three businesses defined in the Course Project document 7
Draft the business description as it will appear in the Executive Summary section of the Budget Proposal Template. 3
Total Points 10
Week 2 Project Activity: Sales Forecast (Draft)
This week, you will start working on Project Activity 2.

In Week 1, you selected a business for which you’ll make a budget proposal. Your first step is to create a sales forecast (in sales dollars) when no historical data is available. Use methods such as historical analogy, expert judgment, consumer surveys, the Delphi method, or calculations based on population distributions, estimated growth rates, or expected market penetration rates to arrive at reasonable sales figures for your business for the next 5 years. Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx.

You will be graded on correct analysis, proper use of spreadsheet technology, and business-like presentation of the information.

Grading Rubric
Section 2.0 Sales Forecast (Draft) Deliverable Points
There is a 5-year sales forecast in the Word document Section 2.1 and the Excel spreadsheet (in sales dollars). 3
The 5-year forecast appears to be based on research, reasonable assumptions, and the methodologies described in the course based on the description in section 2.2 of the template. 4
The 5-year forecast calculations appear to be correct. 3
Total Points 10
Week 3 Project Activity: Capital Expenditure Budget (Draft)
Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to develop and present a capital expenditure budget for your new business startup. You will be graded on correct analysis, proper use of spreadsheet technology, and business-like presentation of the information.

Grading Rubric
Section 3.0 Capital Expenditure Budget (Draft) Deliverable Points
Capital Expenditures items have been correctly identified. 6
Cost of these items appear reasonable and based on primary research. 6
The Capital Expenditure budget is properly constructed in the Excel template and the calculations appear correct. 4
The Capital Expenditure section of the word template is complete and correctly describes the capital expenditure budget and underlying assumptions. 4
Total Points 20
Week 4 Project Activity: Investment Analysis (Draft)
Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to develop and present an Investment Analysis for your new business startup. You will be graded on correct analysis, proper use of spreadsheet technology, and business-like presentation of the information.

Grading Rubric
Section 4.0 Investment Analysis (Draft) Deliverable Points
The cash flows show detailed inflows and outflows, as well as net cash flows. 6
The NPV Analysis is properly calculated and presented. 6
The Rate of Return calculations are properly calculated and presented. 4
The payback period is properly calculated and presented. 4
Total Points 20
Week 5 Project Activity: Pro Forma Income Statement and Balance Sheet (Draft)
Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to develop pro forma income statements and balance sheets for the new business. You will be graded on correct analysis, proper use of spreadsheet technology, and business-like presentation of the information.

Grading Rubric
Section 5.1 Pro Forma Income Statement (Draft) Deliverable Points
The pro forma income statement are properly constructed in a contribution format. 3
Other necessary supporting budgets are also present and calculations are correct. 3
The sources of figures in the pro forma income statement and assumptions are identified. 4
Total Points 10
Section 5.2 Pro Forma Balance Sheet (Draft) Deliverable Points
The pro forma balance sheet are properly constructed in a contribution format. 3
Other necessary supporting budgets are also present and calculations are correct. 3
The sources of figures in the pro forma balance sheet and assumptions are identified. 4
Total Points 10
Week 6 Project Activity: Pro Forma Cash Budget (Draft)
Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to develop pro forma cash budgets for the new business. You will be graded on correct analysis, proper use of spreadsheet technology, and business-like presentation of the information.

Grading Rubric
Section 5.3 Pro Forma Cash Budget (Draft) Deliverable Points
The pro forma cash budget is properly constructed. 6
Other necessary supporting budgets are present and all calculations are correct. 6
The sources of figures in the pro forma cash budgets are identified. 8
Total Points 20
Week 7 Project Activity: Final Budget Proposal and Workbook
Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to finalize the budget proposal and presentation. You will be graded on correct analysis, proper use of spreadsheet and word processing technology, and business-like presentation of the information.

Grading Rubric Final Project Proposal
Items Description Points
Content All parts of the templates are fully completed. 10
Section 1.0 Executive Summary (CO 8) The executive summary presents the major details of the budget proposal and adequately describes the business. 20
Section 2.0 Sales Forecast (CO 3) The sales forecast is based on sound methodology and is complete. 20
Section 3.0 Capital Expenditure Budget (CO 2) The capital expenditure budget is complete with capital expenditure items properly identified. 20
Section 4.0 Investment Analysis (CO 6) The investment analysis is complete with NPV, rates of return, payback period, and net cash flow calculations. 20
Pro Forma Financial Statement Interaction 20
Section 5.1 Pro Forma Income Statement (CO 7) The income statement is properly constructed and is internally consistent. 20
Section 5.2 Pro Forma Balance Sheet (CO 7) The balance sheet is properly constructed and is internally consistent. 25
Section 5.3 Pro Forma Cash Budget (CO 7 & 8) The cash budget is properly constructed and is internally consistent. 25
Assumptions and Primary Research Assumptions and sources of financial estimates are understandable and reasonable for all financial statements. 20
Total 200
Week 8 Project Activity: Final Budget Proposal Presentation
Using a presentation tool such as PowerPoint (with narration), WebEx, Prezi, etc., create a presentation directed to the management team for your start-up business that will outline your proposal, summarize the key points and defend your budget.

Grading Rubric Final Project Proposal
Item Descriptions Points
Defending (CO 8) The key assumptions and the proposed budget are defended 30
Summarization (CO 8) The key points from the budget proposal are presented at the right level of detail. 30
Professionalism The layout of the slides, color schemes, and content are readable and highly professional. 20
Spelling and Grammar Limited or no errors in spelling, grammar, sentence structure or use of language 20
Total 100

 

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”


BUSINESS BUDGETING AND FORECASTING PROJECT was first posted on November 2, 2019 at 4:19 pm.
©2019 "Maths Work Help". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at admin@mathsworkhelp.com