Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please prepare a plan on excel sheet with figures and calculations Prepare a financial plan for a small restaurant 1) Excel spreadsheet (projected statements, detailed
please prepare a plan on excel sheet with figures and calculations
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 growthStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started