Required: You need to prepare comprehensive 6-month budget, including supporting schedules and a report for the period January 1, 2016 to June 30,...

Required:  You need to prepare comprehensive 6-month budget, including supporting schedules and a report for the period January 1, 2016 to June 30, 2016 for Napoleon, Inc (a fictional company). This project must include:

1. Sales Forecast and Budget                            
2. Cash Receipts budget               
3. Purchase budget                        
4. Cash Purchases Disbursements budget
5. Operating Expense budget
6. Summary Cash budget             
7. Budgeted Income Statement                 
8. Budgeted Balance Sheet
9. A written Summary Report                     

Notes and Hints

1. All 9 parts must be submitted before I grade the project.
2. The schedules/budgets must be prepared on Excel. The templates I have prepared must be used as is.
3. Part of this project is demonstrating proper use of Excel. You may only input a "hard number" into a pink cell. All yellow cells must be formula based (no numbers included - use appropriate cell referencing). You must include a copy of the formula version of the project or you will receive a 0 (zero).
4. I recommend constructing the formulas for one month and then copying the formulas over to the remaining months.
5. Rounding is encouraged and you may ignore interest and taxes.
6. The budget templates and this instruction sheet are located on the budget project module. Make sure you save the file to excel and then open the file through Excel (not Internet Explorer). 
7. Check figures are also located on the budget project module.
8. A written summary report, outlining the main issues and problems identified during the budgeting process and suggestions for improving the budget forecast. Don't explain how you prepared the budget. Analyze the issues, including profitability, cash needs, and cost structure. Suggest at least 3 ways you can improve the business forecast for the next 6 months to a year. Test your suggestions by preparing revised budget schedule. Attached is an example of a budget report.
9. The information for Napoleon, Inc. is on the budget project module.