2017	2018	2019	2020	2021
Sales	100,000	120,000	144,000	230,400	414,720

2.2 Methods and Assumptions

We estimate that Papa Geo will attract at least 1,000 families for dinner and entertainment at least once every time we offer specials during the year. We also are projecting that we will see at least 85% of the population will be dinning with us about 14 times a year from year 2019 on.

While we have estimated that during the first three years our sales will steadily increase by 20% we are looking towards a 60% increase in year 2020, and an 80% increase in sales in year 2021. With the constant chance in our fast pace economy we expect our sales to fluctuate which means our sales should be monitored and a close eye on costs annually.

Equipment						Miscellaneous
Soda fountain bar			$ 2,500.00			140 dish set		$ 400.00
Two pizza ovens			$ 8,000.00			utensils		$ 350.00
salad and pizza/dessert bar			$ 21,000.00			cookware		$ 700.00
commercial refrigertor			$ 4,000.00			drinking cups		$ 250.00
two cash registers			$ 800.00			busing cart		$ 3,500.00
six video game machines			$ 9,000.00					$ 5,200.00
microwave			$ 60.00
sink			$ 100.00			Capital Expenditures Budget
refrigerator			$ 200.00			Equipment		$56,160.00
20 tables and chairs			$ 6,500.00			Miscellaneous		$5,200.00
dishwasher			$ 4,000.00			Furniture		$1,400.00
			$ 56,160.00			Facility Costs		$124,500.00
								$187,260.00
Furniture				Facility Costs
office desk		$ 350.00		renovations		$ 15,000.00
laptop		$ 700.00		maintainence		$ 2,500.00
cupboards		$ 350.00		advertising		$ 35,000.00
				rent		$ 72,000.00
		$ 1,400.00				$ 124,500.00

Please provide the follow analysis for the data above:

Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it.

4.1 Cash flows

Provide an Excel spreadsheet screenshot that shows how you arrive at the net cash flows for each period in your planning horizon and describe its highlights.

4.2 NPV Analysis

Provide a screenshot of your Excel NPV analysis here, and describe its highlights.

4.3 Rate of Return

Provide a screenshot of your IRR and accounting rate of return calculations here, and explain the highlights.

4.4 Payback Period

Provide a screenshot of your Excel calculation of the payback period for this venture.

Briefly introduce this section here.

5.1 Pro Forma Income Statement

Describe key figures and assumptions from the income statement, such as important profit or sales figures and their causes. Also, provide a screenshot of your pro forma income statement.

5.2 Pro Forma Balance Sheets

Provide a screenshot of your balance sheets, and describe key figures they contain.

5.3 Pro Forma Cash Budget Provide a screenshot of the cash budget and describe the impact of the budget on cash balances.