sbseg-Balance-Sheet-Template

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 4

Balance Sheet

Enter your Company name here


Balance Sheet
[Month] [Day], [Year]

Current Period Prior Period Increase (Decrease)


[Start Date] to [End Date] [Start Date] to [End Date] [Start Date] to [End Date]
ASSETS
Current Assets:
Cash $ - $ - $ -
Petty Cash - - -
Accounts Receivables - - -
Inventory - - -
Prepaid Expenses - - -
Employee Advances - - -
Temporary Investments - - -
Total Current Assets - - -

Fixed Assets:
Land - - -
Buildings - - -
Furniture and Equipment - - -
Computer Equipment - - -
Vehicles - - -
Less: Accumulated Depreciation - - -
Total Fixed Assets - - -

Other Assets:
Trademarks - - -
Patents - - -
Security Deposits - - -
Other Assets - - -
Total Other Assets - - -
-
TOTAL ASSETS $ - $ - $ -

LIABILITIES
Current Liabilities:
Accounts Payable $ - $ - $ -
Business Credit Cards - - -
Sales Tax Payable - - -
Payroll Liabilities - - -
Other Liabilities - - -
Current Portion of Long-Term Debt - - -
Total Current Liabilities - - -

Long-Term Liabilities:
Notes Payable - - -
Mortgage Payable - - -
Less: Current portion of Long-term debt - - -
Total Long-Term Liabilities - - -

EQUITY
Capital Stock/Partner's Equity - - -
Opening Retained Earnings - - -
Dividends Paid/Owner's Draw - - -
Net Income (Loss) - - -
Total Equity - - -

TOTAL LIABILITIES & EQUITY $ - $ - $ -

Balance Sheet Check - -


TIP: Sheet 2 (Example) Has a
filled out example
TIP: Hover over column titles for
more instructions

Notes on Preparation:
Note: You may want to print this information to use as reference later. To
delete these instructions, click the border of this text box and then press
the DELETE key.

Note: Understanding a company's Balance Sheet is vital to ensuring it has


a strong financial position. It is also used as a key factor in determining a
company's value. Typically, when assets are greater than liabilities, this
represents a strong financial position. Conversely, when liabilities are
greater than assets, this represents a weak financial position and a
company with lower value. Understanding a company's Balance Sheet
can help the owners and/or management understand its strengths and
weaknesses and develop appropriate strategies.

Note: Enter data into cells beneath column headers and to the right of
rows headers that contain comments (red triangle in upper right corner
of cell). Explanations of what type of data should be entered into each
row are outlined in the row header's comments.

Steps for Preparation:


Step 1: Enter your Company Name and the Date all figures are reported
as of in the report header.

Step 2: Enter the 'Start Date to End Date' as MM/DD/YYYY in the Current
Period and Prior Period column headers. Please note that for the best
comparison to the Current Period, the Prior Period time frame should
cover the same number of days as the Current Period. Typically, the prior
period is the same timeframe but for the previous year. However, you
can use whatever timeframe you would like to compare the Current
Period to, such as the previous quarter or month.

Step 3: Enter the amounts in each cell of the Current Period column that
represents your company's balances for that a period.

Step 4: Enter the amounts in each cell of the Prior Period column that
represents your company's balances for that period.

Note: Amounts in the Increase (Decrease) column will automatically


populate with values based on the imbedded formulas. Please note
negative numbers represent a decrease in the Current Period compared
to the Prior Period. Amounts in the rows that do not have comments in
the row header will also automatically populate with values based on the
imbedded formulas.

Note: The Total Assets and Total Liabilities and Equity figures should
always be equal. If they are not equal, the Balance Sheet Check row will
indicate an error by highlighting the column with an issue.

Step 5: If additional rows are required in order to best reflect your


company, click on a Column A cell below the row you would like to add
and right click your mouse, click Insert, select Entire Row and click OK
(repeat as many times as necessary in order to add multiple rows). Then
copy any existing row into the newly inserted rows by selecting an entire
previously existing single row (click on the row number to the left of
Column A), click the right mouse button and select Copy and then
highlight the Row numbers for the rows just added, then right click the
mouse again and select Paste (be sure the mouse pointer is located on
the highlighted range). Repeat as necessary.
Balance Sheet
Construction Company
Balance Sheet
5/1/2015

Current Period Prior Period Increase (Decrease)


05/01/15 to 05/01/16 05/01/14 to 05/01/15 05/01/15 to 05/01/16
ASSETS
Current Assets:
Cash $ 21,506.00 $ 20,000.00 $ 1,506.00
Petty Cash 200.00 200.00 -
Accounts Receivables 5,013.00 5,000.00 13.00
Inventory 20,887.00 21,000.00 (113.00)
Prepaid Expenses 1,098.00 1,100.00 (2.00)
Employee Advances 100.00 - 100.00
Temporary Investments - - -
Total Current Assets 48,804.00 47,300.00 1,504.00

Fixed Assets:
Land 150,000.00 150,000.00 -
Buildings 60,235.00 60,235.00 -
Furniture and Equipment 28,777.00 30,777.00 (2,000.00)
Computer Equipment 5,195.00 5,195.00 -
Vehicles 32,513.00 32,513.00 -
Less: Accumulated Depreciation (43,183.00) (45,201.00) 2,018.00
Total Fixed Assets 233,537.00 233,519.00 18.00

Other Assets:
Trademarks 4,171.00 4,171.00 -
Patents - - -
Security Deposits 1,500.00 1,500.00 -
Other Assets 583.00 600.00 (17.00)
Total Other Assets 6,254.00 6,271.00 (17.00)
-
TOTAL ASSETS $ 288,595.00 $ 287,090.00 $ 1,505.00

LIABILITIES
Current Liabilities:
Accounts Payable $ 18,237.00 $ 18,000.00 $ 237.00
Business Credit Cards 7,523.00 6,000.00 1,523.00
Sales Tax Payable 1,055.00 1,000.00 55.00
Payroll Liabilities 2,382.00 2,500.00 (118.00)
Other Liabilities 941.00 1,000.00 (59.00)
Current Portion of Long-Term Debt 12,111.00 12,111.00 -
Total Current Liabilities 42,249.00 40,611.00 1,638.00

Long-Term Liabilities:
Notes Payable 50,195.00 48,301.00 1,894.00
Mortgage Payable 148,222.00 146,231.00 1,991.00
Less: Current portion of Long-term debt (1,200.00) (1,200.00) -
Total Long-Term Liabilities 197,217.00 193,332.00 3,885.00

EQUITY
Capital Stock/Partner's Equity 20,000.00 20,000.00 -
Opening Retained Earnings 25,530.00 29,129.00 (3,599.00)
Dividends Paid/Owner's Draw (5,000.00) (5,000.00) -
Net Income (Loss) 8,599.00 9,018.00 (419.00)
Total Equity 49,129.00 53,147.00 (4,018.00)

TOTAL LIABILITIES & EQUITY $ 288,595.00 $ 287,090.00 $ 1,505.00

Balance Sheet Check - -


TIP: Sheet 2 (Example) Has a
filled out example
TIP: Hover over column titles for
more instructions

Notes on Preparation:
Note: You may want to print this information to use as reference later. To
delete these instructions, click the border of this text box and then press
the DELETE key.

Note: Understanding a company's Balance Sheet is vital to ensuring it has


a strong financial position. It is also used as a key factor in determining a
company's value. Typically, when assets are greater than liabilities, this
represents a strong financial position. Conversely, when liabilities are
greater than assets, this represents a weak financial position and a
company with lower value. Understanding a company's Balance Sheet
can help the owners and/or management understand its strengths and
weaknesses and develop appropriate strategies.

Note: Enter data into cells beneath column headers and to the right of
rows headers that contain comments (red triangle in upper right corner
of cell). Explanations of what type of data should be entered into each
row are outlined in the row header's comments.

Steps for Preparation:


Step 1: Enter your Company Name and the Date all figures are reported
as of in the report header.

Step 2: Enter the ‘Start Date to End Date' as MM/DD/YYYY in the Current
Period and Prior Period column headers. Please note that for the best
comparison to the Current Period, the Prior Period time frame should
cover the same number of days as the Current Period. Typically, the prior
period is the same timeframe but for the previous year. However, you
can use whatever timeframe you would like to compare the Current
Period to, such as the previous quarter or month.

Step 3: Enter the amounts in each cell of the Current Period column that
represents your company's balances for that a period.

Step 4: Enter the amounts in each cell of the Prior Period column that
represents your company's balances for that period.

Note: Amounts in the Increase (Decrease) column will automatically


populate with values based on the imbedded formulas. Please note
negative numbers represent a decrease in the Current Period compared
to the Prior Period. Amounts in the rows that do not have comments in
the row header will also automatically populate with values based on the
imbedded formulas.

Note: The Total Assets and Total Liabilities and Equity figures should
always be equal. If they are not equal, the Balance Sheet Check row will
indicate an error by highlighting the column with an issue.

Step 5: If additional rows are required in order to best reflect your


company, click on a Column A cell below the row you would like to add
and right click your mouse, click Insert, select Entire Row and click OK
(repeat as many times as necessary in order to add multiple rows). Then
copy any existing row into the newly inserted rows by selecting an entire
previously existing single row (click on the row number to the left of
Column A), click the right mouse button and select Copy and then
highlight the Row numbers for the rows just added, then right click the
mouse again and select Paste (be sure the mouse pointer is located on
the highlighted range). Repeat as necessary.

You might also like