Overview of a business valuations model for unlisted companies using collaborative analysis.

All Industries, Financial Model, General Excel Financial Models

10-year Financial Projections, 5-year Financial Projections, Amortization, Break-Even, Business Valuation, Capitalized Earnings, Cash Flow Analysis, Cash Flow Projections, Cash on Cash Yield, Cash-on-Cash Multiple, DCF Model, Debt Amortization, Debt Schedule, Discount Rate, Excel, Financial Analysis, Financial Debt, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financing, Forecast, Forecasting, Investors, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), Monthly Recurring Revenue (MRR), Net Yield, NPV (Net Present Value), Payback Period, Profitability Analysis, Return on Invested Capital (ROIC), Return on Investment (ROI), Startup Financial Models, Valuation, WACC (Weighted Average Cost of Capital)

Full Title: Unlisted – Business Valuations and Analysis Model – Unlevered and Levered with PE Ratio, IRR, MIRR, NPV and COC

Value any Non-Listed Business and assess how gearing will affect the returns achieved. The speed at which you can generate meaningful Ratios and arrive at a market-related PE Ratio sets this model apart.

With limited input fields, cutting through the frills, this Business Valuation Model will quickly take you to the heart of any valuation, in that within a few minutes, you will be able to see if the IRR and MIRR beat the hurdle rate and by how many times.

After all, all funders and prudent Investors need to beat the hurdle rate by multiple times depending on the risks or industry risk. The QUINTESSENTIAL Business Valuation Model makes use of a PE RATIO for assessing the GOODWILL component.

The Calculator auto-creates Cash Flow, NPV, IRR, and MIRR. An added feature is the built-in Loan Amort which assesses how different gearing scenarios affect the returns when purchasing the business that you have just valued. You will easily be able to ascertain the viability of business value.

As a rule of thumb, the IRR and MIRR should be at least 3 to 4 times above the hurdle rate. Once a PE Ratio is chosen, the goodwill factor will be calculated and added to the value.

There are also INPUT fields to adjust for known risks and opportunities and adjustments for excessive drawings by the owner.

The Model is aligned to PRINT to PDF in perfect page sizes, ready to save/send. Another important factor is the annual growth in net profit after tax feature, which allows for a realistic exit value which in turn is important for the various financial ratios such as IRR, MIRR, NPV, COC, etc.

You must log in to submit a review.