total funding needs for a startup

INDIVIDUAL ASSIGNMENT DETERMINATION OF THE TOTAL FUNDING NEEDS OF A START-UP PROJECT We are a group of entrepreneurs who want to launch an entrepreneurship project ("FOOD AND BEVERAGE RESTAURANT, physical location and online sales"), and we want to calculate the total financing needs that will be necessary for our project knowing the following information: 1. VAT: 21%. 2. Social security in charge of the company: 30%. 3. We must develop an app. Mobile in IOS and Android that will have an investment of 50,000 euros. 4. We will register the brand-trademark "app.A' at European level, with a cost of 1200 euros. 5. Work and remodeling of the premises/restaurant, as well as decoration and furniture: 150,000 euros. 6. A limited liability company will be created, and we will have estimated costs for starting this business: lawyers, fees, taxes, notary, registration, initial business consultancy worth 20,000 euros. 7. Our business will sell food menus (hamburgers + drink + starter) at a price of 12 euros including VAT, estimating that we will sell 200 hamburgers a day. The variable cost of preparing each menu is 25% of the sales price without VAT. 8. For the management of raw materials that make up our menu, we want to have a product stock policy/level to cover 5 days of the daily demand. 9. At the operating level, we estimate the following fixed monthly operating expenses (SG&A: Selling, General and Administration). We would want to inflow liquidity into the business to support without problems 6 months of these fixed monthly operating expenses: a. Marketing and promotion budget: 15,000 euros per month. b. Outsourced independent professional services: 20,000 euros per month. c. Transportation costs for food deliveries to home: 2 excluding VAT per delivery / menu made. d. Wages and salaries: 5,000 euros per month without including social insurances. e. Rent: 2000 euros per month. f. Supplies: 250 euros per month. g. Insurance premiums: 3000 euros per year. h. Licenses for software and computer programs: 200 euros per month. 10. Our financing needs must take into account the VAT we support when starting the business at t = 0. 11. It has been decided to create a buffer of liquidity for unforeseen expenses that may occur for 10% of annual sales (excluding VAT). An explanation of the calculations and results obtained must be explained in Excel. 1 Excel tab with the calculations (all formulas programmed) and explanation of each item and the result of the exercise. INDIVIDUAL ASSIGNMENT DETERMINATION OF THE TOTAL FUNDING NEEDS OF A START-UP PROJECT We are a group of entrepreneurs who want to launch an entrepreneurship project ("FOOD AND BEVERAGE RESTAURANT, physical location and online sales"), and we want to calculate the total financing needs that will be necessary for our project knowing the following information: 1. VAT: 21%. 2. Social security in charge of the company: 30%. 3. We must develop an app. Mobile in IOS and Android that will have an investment of 50,000 euros. 4. We will register the brand-trademark "app.A' at European level, with a cost of 1200 euros. 5. Work and remodeling of the premises/restaurant, as well as decoration and furniture: 150,000 euros. 6. A limited liability company will be created, and we will have estimated costs for starting this business: lawyers, fees, taxes, notary, registration, initial business consultancy worth 20,000 euros. 7. Our business will sell food menus (hamburgers + drink + starter) at a price of 12 euros including VAT, estimating that we will sell 200 hamburgers a day. The variable cost of preparing each menu is 25% of the sales price without VAT. 8. For the management of raw materials that make up our menu, we want to have a product stock policy/level to cover 5 days of the daily demand. 9. At the operating level, we estimate the following fixed monthly operating expenses (SG&A: Selling, General and Administration). We would want to inflow liquidity into the business to support without problems 6 months of these fixed monthly operating expenses: a. Marketing and promotion budget: 15,000 euros per month. b. Outsourced independent professional services: 20,000 euros per month. c. Transportation costs for food deliveries to home: 2 excluding VAT per delivery / menu made. d. Wages and salaries: 5,000 euros per month without including social insurances. e. Rent: 2000 euros per month. f. Supplies: 250 euros per month. g. Insurance premiums: 3000 euros per year. h. Licenses for software and computer programs: 200 euros per month. 10. Our financing needs must take into account the VAT we support when starting the business at t = 0. 11. It has been decided to create a buffer of liquidity for unforeseen expenses that may occur for 10% of annual sales (excluding VAT). An explanation of the calculations and results obtained must be explained in Excel. 1 Excel tab with the calculations (all formulas programmed) and explanation of each item and the result of the exercise