How to Calculate EFN for a Pro Forma Balance Sheet

by Emily Beach; Updated September 26, 2017
Money

A balance sheet is a financial statement showing a company's assets, liabilities and shareholder equity at a particular date in time. When a company is considering a major change, such as an acquisition or merger, it may compile a pro forma balance sheet, which is a summarized version of the traditional statement. Using the pro forma statement, the company or potential investors are able to quickly determine the value of EFN, or external funds needed, to balance the company's financial picture. The money for EFN may come from investors or debt financing.

Items you will need

  • Company financial records
  • Spreadsheet program
Step 1

Gather together the company's financial records. This could include accounting records, bank statements and any accounts owed to or by the organization.

Step 2

Develop a pro forma statement. Because a balance sheet represents only a particular moment in time, it must be recreated and made current to accurately reflect the company's financial picture. The pro forma balance sheet is much easier to compile than many people believe.

Step 3

Add together all the company's assets. This includes cash, receivables, land, offices, equipment and investments. Add the value of all of these items and insert a line item on your pro forma statement entitled "Assets" that shows the total amount you have calculated.

Step 4

Calculate the value of all liabilities. This includes any debt, accounts payable, taxes owed or bonds to be paid. Place the total value of all liabilities on a separate line beneath the assets of your balance sheet.

Step 5

Determine the value of shareholder equity. This includes the present value of all shares of stock that are currently outstanding. Add this value as the third line item on your balance sheet.

Step 6

Find EFN by subtracting the value of the total assets from the sum of liabilities and shareholder equity. The resulting value is the amount of external funds (or financing) needed to balance the company's financial books.

About the Author

Emily Beach works in the commercial construction industry in Maryland. She received her LEED accreditation from the U.S. Green Building Council in 2008 and is in the process of working towards an Architectural Hardware Consultant certification from the Door and Hardware Institute. She received a bachelor's degree in economics and management from Goucher College in Towson, Maryland.

Photo Credits

  • Wiki Commons