please prepare it on excel spreadsheet sheet. Please do all the assumptions and calculations on excel spreadsheet.

Prepare a financial plan for a small restaurant 1) Excel spreadsheet (projected statements, detailed calculations, inputs, assumptions) 3) Assumptions and input data 4) Cash flow forecasts for 5-7 years of operations, Projected Income Statement for the same period. 5) Projected balance sheet (Bonus) 6) Valuation sheets (NPV, IRR, payback), 3 Scenarios Assume that you have 100% equity investment, use discount rate 20% or come up with more refined rate (CAPM (beta of industry)+ add premium for size, bonus) The plan should include 1) Description of your business idea, why you think it is a good idea to start this project 2) Initial investment: CAPEX +Working capital 3) Sales forecasts, put assumptions quantity of units sold, prices, sales growth 4) Assumptions on variable costs of production 5) Assumptions on other operating expenses. 6) Taxes/depreciating of fixed assets 7) Exit value: Assume either you sell the business to another company (use either multiples or compute terminal value as PV of growing perpetuity, need to assume a growth rate for the long run) 8) Compute NPV, IRR, discounted payback 9) Sensitivity of your investment matrix to change in the assumptions. Do scenario analysis (Base case, Worst cast and Best case) be consistent with your assumption, be conservative, numbers are just numbers, try to be realistic in assumption of growth