I need help with my project, I am stuck on it. I need help figuring out the cash flow for this fake business

Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to develop and present an Investment Analysis for your new business startup.

this is all the information provided for this task

the budget proposal workbook is simply a blank excel file where we input the calculations so it is not needed to be attached, but the below is the budget proposal template that has all information that may be needed.

4.0 Investment Analysis 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 arrived 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.2.0 Sales Forecast Cost research links 2 renovation $ 15,000.co one time fee Soda Fountain Bar if you lease with cocacola for a free style soda $ 4,200.09 or 350 per month can make just about By drink they want) hinetone of the best as the customers Briefly introduce the sales forecast section. 2 Pizza Ovens e deck-countence electioning at $ Salad and Pizza,Dessert Bar $ 5,000.00 one time fee $ 6,000.00 one time fee http:://www.centralrestaurant .com/Qual+Temperature+Food.Tables-ol1491.html Approximately 100 square foot commercial refrigerator $ 6,000.00 one time fee plook-05x6-065-ct-polar-pak-6-x-6:8-6-floorless-indoor-walk-in: I.him! 2.1 Sales Forecast 2 cash registers $ 1,000.00 one time fee chutm campaireShoppingButm content-Burm fer meBeclid-FAla CobChMizMC SonaSe VCaC2071340 PEACHA ABEgluf D AWE 1 6 Video Game vending machines $ 2,000.00 one e fee If you buy used or nonvintage games, found by a simple google search of video arcade games. I expect the sales for Papa Geo's sale to increase throughout the next 5 years as they are Management Office with desk, lower-priced laptop 9 computer $ 500.00 one nothing fancy, basic set up offering something that isn't available to the people in that immediate area. I believe first Staff lunchroom equipment such as microwave, sink. 10 cupboards and refrigerator $ 2,000.00 of he fee if you buy 2-3 microwaves, two bay sink, cheap cupboards, seating, and small fridge starting out they will be a little below their average goal of 40,000 income until they are able to 20 four-seater tables with chairs $ 5,000.00 one time fee grow their name. Enter 3 years I think that Papa Geo's will be growing even more as more Busing cart for transporting dirty dishes from the dining https://www.google.com/acik ?sa-L&Bi-OCheSEwitic 12 area to the dishwashing area D64_OGarDiedeyRIDi4uw1Q/jjPyle people are aware of the cheap affordable pizza buffet that they cannot get anywhere else. By $200.00 one time fee Baduris 13 140 sets of dishes, cutlery and drinking cups 200.00 one time fee year 5 they will be almost at 50,000 sales (in dollars) as the population is growing by 6% each Commercial Dishwasher https://www.google.com/shopping/product/65076716431172061607q-commercial+dishwashersbiw year for the past 5 years. $ 3,000.00 one 17458bih-8526prds-epd:3975195010802356857,prmr:18sa-X&ved-OnNUKEwifgdvopuzqahWookEHDA Miscellaneous cooking and food handling equipment like Year 2 Year 3 Year 4 15 trays, lifters, spoons, pots etcetera $ 1,000.60 Year 1 Year 5 16 Sales 36,000 39,000 42,000 45,000 48,000 20 21 22 tota DO OOT TS S 2.2 Methods and Assumptions Based off of the information provided such as the population, location, and goals I was able I will be attached the excel sheet used for this screen shot for easy access to the links I used to to create a sales forecast. I would assume that at least a little over half of the population gain knowledge on the prices. The investment will be roughly over 50,000 to meet the would make a sale of 7 dollars at the restaurant in a year. After the first year we assume that requirements needed to run the restaurant. I believe the price for 2 or 3 salad/pizza dessert bar is the population grows by 6 percent as a whole and with advertisement the amount of sales will important to include to achieve the company's plan as they will be strictly a buffet style grow by at least 7 or 8 percent. Each year it will continue to grow as more people are being restaurant and in order to easily have all food out they will need either one very large one or 2 to introduced to the newest addition to their area and its one of a kind. Being unique with a 3 small ones. I also believe the more expensive soda machine which is the coca-cola freestyle large and growing population surrounding its immediate area will allow the business to self-serve will benefit the company greatly to go hand in hand with their wide range buffet style increase its sales each year slowly but surely. pizza restaurant as it allows the customers to have a very large range of possible drinks at their 3.0 Capital Expenditure Budget fingertips. Some items I feel could be bought at a cheaper price but to ensure that each item gets as much usage as possible and benefit the company as much as possible I believe the quotes I choose for each item after research will allow the company to achieve the company's strategy. Here you should provide a screenshot of your capital expenditure budget, also listing the sources of data and assumptions that led to each line item in table format. Briefly describe the total investment and, if necessary, why major items are necessary to achieve the company's strategy.Business Profile: Papa Geo's Restaurant Management Office with desk, lower-priced laptop computer Vision Staff lunchroom equipment such as microwave, sink, cupboards and refrigerator The vision of the entrepreneur is to create a single-location, sit-down Italian restaurant called Papa Geo's. The . 20 four-seater tables with chairs goal is to generate an income of $40,000 per year, starting sometime in the second year of operation, as wells . Busing cart for transporting dirty dishes from the dining area to the dishwashing area as profit that is at least 2% of sales. . 140 sets of dishes, cutlery and drinking cups Strategy a) Market Focus/Analysis . Commercial Dishwasher The restaurant targets middle to lower-middle class families with children as well as adults and seniors, Miscellaneous cooking and food handling equipment like trays, lifters, spoons, pots etcetera located in Orlando, Florida. The area within 15 minutes of the store has 10,000 families, mostly from lower to middle class neighborhoods. Average family size is 4 people per household. There is no direct competition; . The cost of an average of 7 employees on the payroll. however, there are fast food restaurants like Mcdonald's, Taco Bell and Wendy's in the geographical target All operating costs, such as advertising, rent for a 3500 square foot facility with male and female market. The lower-to middle class population is growing at about 6% per year over the next five years in this washrooms, already installed, utilities, maintenance, and annual depreciation. area. *if you have questions about startup requirements, or think other startup costs are necessary for the business b) Product are missing, then make an assumption and state it in the relevant section of the report. The product is Italian food served buffet style, in an all-you-can-eat format, with a salad bar, pizza, several different types of pasta with three or four types of sauces, soup, desserts and self-serve soda bar. The Given Financial Assumptions restaurant is also to have a 500 square foot games area which has game machines that children would be The owner will be granted a loan for the initial startup, repayable over 10 years at current interest interested in using. rates for small business loans c) Basis of Competition The owner will use personal funds to operate the business until it generates enough cash flow to fund Customers come to come to this restaurant because of the good Italian food at a low price - where you can itself. get a meal for $7 including drinks. Customers also eat at Papa Geo's due to the cleanliness of the facility, the Essentially, all sales are made by credit card. All credit card sales are a paid to the restaurant daily by speed of getting their seat and food, as well as the vending machines which keep the children busy while the credit card company adults enjoy their meal. 2.5% of sales is paid to a credit card company in fees Startup Requirements* Given Costs . Food suppliers give 30 days of trade credit The cost of registering a Limited Liability Company in Florida, filing fees listed at the bottom of the application Inventories are expected to be approximately 10% of the following month's sales form located at http://form.sunbiz.org/pdf/cr2e047.pdf The average meal costs $4.00 in materials and labor. Renovation of the facility expected to cost $15000 Business Insurance, estimated at $1000 per year . The average family spends $4.00 on vending machine tokens Health and other benefits are 20% of the salaries of the manager and assistant manager Equipment is depreciated on a straight-line basis over 5 years . Managers have health benefits, other workers do not. The company will operate from 10:00 am to 9 pm, 7 days a week. Costs you should estimate through research, experience or other methods The entrepreneur will manage the store and draw a salary. Soda Fountain Ba . Every shift has one person on the cash register, one keeping the food bars stocked with food, and one 2 Pizza Ovens on busing and table cleaning, a manager and assistant manager. . Salad and Pizza/Dessert Bar *If you believe any other assumptions are necessary, then please state them in your budget proposal Approximately 100 square foot commercial refrigerator . 2 cash registers 6 Video Game vending machines Average of 6 staff members at any given time