Construction Company Financial Statements in Excel

construction company financial statements in excel

Another portion of the balance sheet is the stakeholder’s equity. Generally, a balance sheet is balanced by the liabilities and stakeholders’ equity sum and assets. This portion can also include various sub-portions, but we have included only one section for demonstration.

You can document all the different parts if you have many sub-parts and add them to find the final stockholder’s equity too.

Step 6 – Calculate Total Liabilities and Equity

=SUM(C20:C21)

construction company financial statements in excel

construction company financial statements in excel

Step 7 – Record Gross Profits

The income statements have the records of income, expenses, and tax records.

=C5-C6

construction company financial statements in excel

construction company financial statements in excel

Step 8 – Calculate the Operating Profit

=C7-C8

construction company financial statements in excel

construction company financial statements in excel

Step 9 – Determine Other Income/Expenses

We have put in all the income values in positive numbers and the expense values in negative numbers. Putting these cells in negative and summing them up makes it easier later on.

Step 10 – Evaluate Expense Before Tax

=SUM(C12:C16)

construction company financial statements in excel

construction company financial statements in excel

Step 11 – Calculate Earnings Before Tax

=C9+C17

construction company financial statements in excel

construction company financial statements in excel

Step 12 – Determine Net Earnings

=C18-C19

construction company financial statements in excel

construction company financial statements in excel

Step 13 – Record Net Earnings for the Cash Flow Statement

Step 14 – Enter the Adjusted Values

construction company financial statements in excel

We have added a plethora of values in this section. There are some negative values for an easier summation later on.

Step 15 – Compute the Net Cash Provided by Operating Activities

=SUM(C5:C18)

construction company financial statements in excel

Press Enter.

construction company financial statements in excel

Step 16 – Record Investing Activities

We have added the purchase cost as a negative value since it’s going to be subtracted from the sale values.

Step 17 – Calculate the Net Cash in Investing Activities

=SUM(C22:C23)

construction company financial statements in excel

construction company financial statements in excel

Step 18 – Record Financing Activities

Step 19 – Determine the Net Cash in Financing Activities

=SUM(C27:C28)

construction company financial statements in excel

construction company financial statements in excel

Step 20 – Document the Net Increase in Cash

Step 21 – Record Cash at Beginning of the Year

Step 22 – Evaluate Cash at End of the Year

=SUM(C30:C31)

construction company financial statements in excel

construction company financial statements in excel

Download the Practice Workbook