In this extension, you will complete an “opening day balance sheet” to outline your business’s
expected finances on its opening day.
A balance sheet shows your business’s financial position at a specific point in time.
It calculates “net worth.”
This is the value of your business based on cash and equipment you own.
An “opening day balance sheet” lists assets -- such as cash and property -- and liabilities
-- or debts and expenses.
It finds how much a business is worth by subtracting liabilities from assets.
This shows “net worth,” also known as “owner’s equity.”
To complete your balance sheet, you will: Set up your spreadsheet,
Add assets and liabilities, And use functions to calculate net worth.
To begin, make a copy of the starter project and rename it.
Then, add your business name.
Next, list “current assets.”
These are assets that change often while running your business, including cash; inventory;
and prepaid expenses such as insurance premiums, website costs, or other item that you’ve
paid for in advance.
Put additional assets in the “other” category.
Review your “total current assets.”
This is calculated by the SUM function, which adds together each asset to find total assets.
Then, list “fixed assets.”
The values of these assets don’t change, though equipment may depreciate over time.
This includes machinery and equipment, furniture and fixtures, improvements to a rented space,
or real estate.
Review your “total fixed assets,” which are also calculated automatically.
List “other assets,” such as lease and utility deposits.
Also include things of value for your business, such as patents, trademarks, and special certifications.
Most new businesses will only list deposits.
Then, review the total of your current, fixed, and other assets.
Next, add liabilities.
Current liabilities include accounts, taxes, and debts you owe money on within one year.
Long-term liabilities include debts owed beyond one year, such as bank loans and payments
to investors or shareholders.
Totals for current, long-term, and total liabilities are automatically calculated by the sum function.
Totaling your assets and liabilities automatically calculates your net worth, or owner equity.
This is how much your business is worth after subtracting liabilities from assets.
Don’t worry if this number is low, as your estimate is just a starting point.
Go to your business plan and add a link to your worksheet under your financing information
section.
This important information will help when you talk with lenders or investors.
Now, it’s your turn: Make a copy of the opening day balance sheet
and rename it, List your assets and liabilities,
Review total assets, total liabilities, and net worth,
And add a link to your spreadsheet in your business plan.