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