Proforma Earnings Per Share Template
Proforma Earnings Per Share Template
This proforma earnings per share template shows you how to calculate the earnings per share assuming a merger and acquisition takes place.
Here is a preview of the proforma EPS template:
Download the Free Template
Enter your name and email in the form below and download the free template now!
Proforma earnings per share (EPS) is the calculation of EPS assuming a merger and acquisition (M&A) takes place and all financial metrics, as well as the number of shares outstanding, are updated to reflect the transaction. “Pro forma” in Latin means “for the sake of form.” In this case, it refers to calculating EPS “for the sake of form” in the event of the acquisition.
Basic EPS is calculated by dividing a firm’s net income by its weighted shares outstanding. The pro forma EPS, on the other hand, adds the target firm’s net income and any additional synergies or incremental adjustments to the numerator, while adding new shares issued due to the acquisition to the denominator.
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentations, and Word document templates.
Excel Tutorial
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Excel Crash Course now to take your career to the next level and move up the ladder!
