Additional Paid in Capital Template

Additional Paid in Capital Template

This additional paid in capital template demonstrates the calculation of additional amount of capital paid by investors.

Below is a preview of the additional paid in capital template:

Additional Paid In Capital Template Screenshot


Download the Free Template

Enter your name and email in the form below and download the free template now!

Additional Paid In Capital Template

Download the free Excel template now to advance your finance knowledge!


Additional Paid In Capital (APIC) is the value of share capital above its stated par value and is an accounting item under Shareholders’ Equity on the balance sheet.  APIC can be created whenever a company issues new shares and can be reduced when a company repurchases its shares.  APIC is also commonly referred to as Contributed Surplus.

The formula for calculating addition paid in capital is:

Additional Paid In Capital = (Issue Price − Par Value)  x  Number of Shares Issued


Note that the additional paid in capital is only recorded at the initial public offering (IPO) because it is only dependent on the issue price of equity, not the market value.  Once a company’s shares start trading on a public exchange, their price movements don’t impact the APIC account on the balance sheet.


More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.

  • Excel Modeling Templates
  • PowerPoint Presentation Templates
  • Transaction Document Templates

Financial Analyst Certification

Become a certified Financial Modeling and Valuation Analyst (FMVA)® by completing CFI’s online financial modeling classes and training program!