Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedplease 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 growth

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

Write or share answers to the following questions:

Answered: 1 week ago