Click here to download a template for comparable company analysis, based on the example below for Steel Dynamics. In the example used above, cash is going to leave the business when the rent is paid, so the cash account should decrease. The amount of rent paid is going to increase, so the rent expense account should increase as a transaction analysis template result of the transaction.
Balance Sheet
A cash flow statement is important to provide a good picture of the inflow and outflow of cash within your company. It shows where the money came from (cash receipts) and where the money went to (cash paid). Use a cash flow statement template, in conjunction with your balance sheet and income statement, to provide a comprehensive look into the financial status of your company. This cash flow template includes two additional worksheets to track month-to-month and year-to-year cash flow. This helps accounting teams catch any errors, omissions, exaggerations or other forms of fraud within their financial statements. Since the accounting equation must always balance, the last step in the transaction analysis involves verifying that the sum of assets is equal to the sum of liabilities and equity after accounting for the transaction.
Comparable Company Analysis Template
Upload your trading data or connect your database, then interact conversationally with the AI to analyze costs across equity and foreign exchange markets. This analysis gives us all the implied share net sales prices across the range of multiples, but it’s a bit difficult to see the results because there are so many numbers on screen. Comparable company analysis (or “comps” for short) is a valuation methodology that looks at ratios of similar public companies and uses them to derive the value of another business. Comps is a relative form of valuation, unlike a discounted cash flow (DCF) analysis, which is an intrinsic form of valuation.
( . Identifying the accounts involved:
- Unlike trading comps, where public companies are obligated to file their financial reports (10-Q, 10-K) periodically, companies and M&A participants are under no obligation to publicly announce the details of an M&A transaction.
- A web-based platform such as Bloomberg, Pitchbook, SDC, CapIQ, or FactSet speeds up the screening process, but transaction information can be found in public company documents as well.
- Its share price at the time of this analysis was close to $25.00, which is above the median implied share price of each methodology, and close to the 75th percentile for some of them.
- The platform generates accurate forecasts and creates customized reports without requiring Excel expertise.
- Post-trade involves recording and comparing data against benchmarks to evaluate execution performance.
- For the purchased equipment to be properly recorded among the company’s assets, the equipment account should reflect an increase, or a debit.
You can upload AI in Accounting your trade data files or connect your database, then simply tell Sourcetable’s AI chatbot what analysis you want to perform. The AI will automatically analyze your data, generate relevant TCA metrics and benchmarks, and create stunning visualizations to help you understand execution quality and trading costs. This eliminates the need for complex Excel functions and makes TCA analysis accessible to everyone. Once you have all the numbers, you calculate the valuation multiples for each company with simple arithmetic.
Income Statement
Upload your trading data or connect your database, and let the AI assist with analysis, chart creation, and data visualization. Talk to Sourcetable’s AI chatbot to tell it what analysis you want to run, and watch Sourcetable do the rest. A comparable transaction Excel template is available for download at the bottom of the page. But if you do not have access, you can also use Finviz or Zacks to find companies and their basic financial information.
