Business Valuation
Vicky-shema
VALUATIONSPREADSHEET_2018Goodwillarticlev1.xlsxDATA&DCF
| THIS WORKSHEET IS MY COMPENDIUM OF THE HYPOTHETICAL DATA | |||||||
| DISC RATE(YRS1-5)= | 10% | ||||||
| DISC RATE(TERM)= | 3% | ||||||
| 2018 | 2019 | 2020 | 2021 | 2022 | 2023 ONWARDS | AVERAGE(2018-2022) | |
| SCENARIO A | |||||||
| Total revenue(TR) | $10,000,000 | $9,500,000 | $9,975,000 | $10,000,000 | $10,000,000 | $10,000,000 | $9,895,000 |
| EBITDA | $500,000 | $525,000 | $551,250 | $578,813 | $500,000 | $500,000 | $525,844 |
| Pres Val Factors | 1.00 | 0.91 | 0.83 | 0.75 | 0.68 | 33.3333333333 | |
| Pres Val of EBITDA | $500,000 | $477,273 | $455,579 | $434,870 | $341,507 | $10,348,689 | |
| CUMULATIVE PV | $12,557,917 |
Sheet2
PE_EBITDA METHOD
| PRICE/EBITDA METHOD | ||||
| P/EBITDA RATIO= | 10 | 9 | 7.5 | 6 |
| SCENARIO A | SCENARIO B | SCENARIO C | SCENARIO D | |
| I-A. VALUE BASED ON CURRENT YEAR | ||||
| Current yr EBITDA--2018 | $500,000 | $525,000 | $551,250 | $578,813 |
| P/EBITDA RATIO x EBITDA | $5,000,000 | $4,725,000 | $4,134,375 | $3,472,875 |
P_SALES
| PRICE/SALES METHOD | ||||
| SCENARIO A | SCENARIO B | SCENARIO C | SCENARIO D | |
| PRICE/SALES RATIO= | 2.00 | 2.20 | 1.50 | 1.25 |
| VALUE BASED ON CURRENT YEAR | ||||
| Current yr sales | $10,000,000 | $9,500,000 | $9,975,000 | $10,000,000 |
| VALUE | $20,000,000 | $20,900,000 | $14,962,500 | $12,500,000 |
Sheet1
| PRICE/SALES METHOD | ||||
| SCENARIO A | SCENARIO B | SCENARIO C | SCENARIO D | |
| PRICE/SALES RATIO= | 2 | 2.2 | 1.5 | 1.25 |
| VALUE BASED ON CURRENT YEAR | ||||
| Current yr sales | 10000000 | 9500000 | 9975000 | 10000000 |
| VALUE | 20000000 | 20900000 | 14962500 | 12500000 |
