You must log in to download this spreadsheet.

This excel spreadsheet is your summary of sales and expenses for the past 4 years. When completed accurately by you and your accountant you will know your Discretionary Earnings for each of those years. Lines 1-9 are taken from the summary of your tax filings.To find the discretionary earning lines11-33, you will probably need help from your CPA to find all of them in your tax filings. These are typically expenses that a new owner might treat differently. Line 33 is your total annual SDE (Sellers Discretionary Earnings). You will add all the years you reported and divide that number to learn your average SDE. You then multiply it by the number you received from your questionnaire and that number is the value of your business not including some tangible, intangible, and real estate assets. Receivables and Payables, Short and Long term debt is also excluded in the summary.