Question: create an excel spreadsheet to do financial analysis of a restaurant Start-up Costs Purchase materials Licenses, fees and permits Kitchen supplies New stove and other

Start-up Costs Purchase materials Licenses, fees and permits Kitchen supplies New stove and other appliances Remodeling and Improvements to the building Furniture Misc SALES Boverage Total Sales EXPENSES Food Annual Profit 5 5 s 5 5 332 Cumulative P $ 5 5 55 Markip Rates (based on selling prico) Food 30S SALES Beverage Total Sales EXPENSES Food $200 Lease Utilities: $ Direct $ Total Expense Annual Profit $ 5 $ 5$ Cumulative P$ 5 5=5 5+5 Markup Rates (based on selling price) FoodBeverage80%90% Financial Analysis Discount Rate 6% 7en 9\%5 NPV Sales Forecast Year Breakeven Polnt Morith Start-up Costs Purchase materials Licenses, fees and permits Kitchen supplies New stove and other appliances Remodeling and Improvements to the building Furniture Misc SALES Boverage Total Sales EXPENSES Food Annual Profit 5 5 s 5 5 332 Cumulative P $ 5 5 55 Markip Rates (based on selling prico) Food 30S SALES Beverage Total Sales EXPENSES Food $200 Lease Utilities: $ Direct $ Total Expense Annual Profit $ 5 $ 5$ Cumulative P$ 5 5=5 5+5 Markup Rates (based on selling price) FoodBeverage80%90% Financial Analysis Discount Rate 6% 7en 9\%5 NPV Sales Forecast Year Breakeven Polnt Morith
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
