Business Plan Worksheets
riceva
CopyofBalance-Sheet-Template1.xlsBlank Template
| 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 | $ - 0 | $ - 0 | $ - 0 | ||
| Petty Cash | - 0 | - 0 | - 0 | ||
| Accounts Receivables | - 0 | - 0 | - 0 | ||
| Inventory | - 0 | - 0 | - 0 | ||
| Prepaid Expenses | - 0 | - 0 | - 0 | ||
| Employee Advances | - 0 | - 0 | - 0 | ||
| Temporary Investments | - 0 | - 0 | - 0 | ||
| Total Current Assets | - 0 | - 0 | - 0 | ||
| Fixed Assets: | |||||
| Land | - 0 | - 0 | - 0 | ||
| Buildings | - 0 | - 0 | - 0 | ||
| Furniture and Equipment | - 0 | - 0 | - 0 | ||
| Computer Equipment | - 0 | - 0 | - 0 | ||
| Vehicles | - 0 | - 0 | - 0 | ||
| Less: Accumulated Depreciation | - 0 | - 0 | - 0 | ||
| Total Fixed Assets | - 0 | - 0 | - 0 | ||
| Other Assets: | |||||
| Trademarks | - 0 | - 0 | - 0 | ||
| Patents | - 0 | - 0 | - 0 | ||
| Security Deposits | - 0 | - 0 | - 0 | ||
| Other Assets | - 0 | - 0 | - 0 | ||
| Total Other Assets | - 0 | - 0 | - 0 | ||
| - 0 | |||||
| TOTAL ASSETS | $ - 0 | $ - 0 | $ - 0 | ||
| LIABILITIES | |||||
| Current Liabilities: | |||||
| Accounts Payable | $ - 0 | $ - 0 | $ - 0 | ||
| Business Credit Cards | - 0 | - 0 | - 0 | ||
| Sales Tax Payable | - 0 | - 0 | - 0 | ||
| Payroll Liabilities | - 0 | - 0 | - 0 | ||
| Other Liabilities | - 0 | - 0 | - 0 | ||
| Current Portion of Long-Term Debt | - 0 | - 0 | - 0 | ||
| Total Current Liabilities | - 0 | - 0 | - 0 | ||
| Long-Term Liabilities: | |||||
| Notes Payable | - 0 | - 0 | - 0 | ||
| Mortgage Payable | - 0 | - 0 | - 0 | ||
| Less: Current portion of Long-term debt | - 0 | - 0 | - 0 | ||
| Total Long-Term Liabilities | - 0 | - 0 | - 0 | ||
| EQUITY | |||||
| Capital Stock/Partner's Equity | - 0 | - 0 | - 0 | ||
| Opening Retained Earnings | - 0 | - 0 | - 0 | ||
| Dividends Paid/Owner's Draw | - 0 | - 0 | - 0 | ||
| Net Income (Loss) | - 0 | - 0 | - 0 | ||
| Total Equity | - 0 | - 0 | - 0 | ||
| TOTAL LIABILITIES & EQUITY | $ - 0 | $ - 0 | $ - 0 | ||
| Balance Sheet Check | - 0 | - 0 |
Instructions: Enter your Company Name in this cell.
Instructions: Enter the date (as MM/DD/YYYY) all below figures are reported as of.
Instructions: Enter the dates or timeframe the Current Period figures will cover. (e.g. "07/01/2014 to 09/30/2014")
Instructions: Enter the dates or timeframe the company's prior period figures will cover. (e.g. "07/01/2014 to 09/30/2014") 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.
Instructions: Enter the Current Period's Assets, Liabilities and Equity amounts for each category in this column's cells.
Instructions: Enter the Prior Period's Assets, Liabilities and Equity amounts for each category in this column's cells.
Instructions: Enter the total Cash amount on hand at the end of the period. Cash includes amounts in checking, savings and investment accounts.
Instructions: Enter the total amount of Petty Cash on hand at the end of the period.
Instructions: Enter the total amount of Accounts Receivable the company is owed at the end of the period. Accounts Receivables is cash the company is owed, but has not yet collected, for goods or services rendered to customers.
Instructions: Enter the total amount of Temporary Investments the company has at the end of the period. Temporary Investments are defined as investments that are expected to be liquidated in less than one (1) year.
Instructions: Enter the total Prepaid Expenses amount that have been paid in advance that have not yet expired as of the end of the period.
Instructions: Enter the total amount of Employee Advances the company has made at the end of the period. Employee Advances occur when the company pays an employee their wages earlier than regular payroll or pays a travel advance.
Instructions: Enter the total amount of Food Inventory the company has at the end of the period.
Instructions: Enter the cost of the company's furniture and equipment at the end of the period.
Instructions: Enter the cost of the company's computer equipment at the end of the period.
Instructions: Enter the cost of the company's vehicles at the end of the period.
Instructions: Enter the cost of the company's buildings at the end of the period plus any building improvement costs incurred since the building was acquired.
Instructions: Enter the cost of the land the company owns at the end of the period.
Instructions: Enter the current market value of the company's trademarks at the end of the period.
Instructions: Enter the current market value of the company's patents at the end of the period.
Instructions: Enter the total amount of the security deposit(s) paid by the company at the end of the period.
Instructions: Enter the total amount of the company's other current assets that have not been specifically mentioned, as of the end of the period.
Instructions: Enter the total amount the company owes as Accounts Payable at the end of the period. This is the amount owed to vendors for goods or services provided but has not paid.
Instructions: Enter the total Business Credit Card debt the company owes at the end of the period.
Instructions: Enter the total amount of Sales Taxes the company owes to state and local agencies at the end of the period.
Instructions: Enter the total amount employee wages the company currently owes to its employees at the end of the period.
Instructions: Enter the total amount of the company's Other Liabilities not specifically mentioned as of the end of the period.
Instructions: Enter the total amount the company's mortgage balance as of the end of the period. This includes principal and interest.
Instructions: Enter the total Capital Stock or Partner's Equity amount of the company at the end of the period. This is the value of all common and preferred stock or partner's contributions as of the end of the period.
Instructions: Enter the total amount of Dividends or Owner's Draw the company has paid to its shareholders or owners as of the end of the period. Dividends are a voluntary distribution of profits to shareholders and Owner's Draw is a voluntary amount distribution of profits to the partners. Net income will be "rolled" into Opening Retained Earnings for the next reporting period.
Instructions: Enter the amount of the company's Net Income (from the Income Statement) for the entire period (from MM/DD/YYY to MM/DD/YYYY). Net income will be "rolled" into Opening Retained Earnings for the next reporting period.
Instructions: Enter the total current amount owed on all business loans at the end of the period. This includes loans from banks, other businesses, private individuals, and auto financing.
Instructions: Enter the total Accumulated Depreciation of the company's fixed assets at the end of the period. Accumulated Depreciation is the accumulated depreciation recorded based on the useful life of each asset and the depreciation method.
Instructions: Enter the current portion of the company's long term debt as of the end of the period. The current portion is the amount owed over the next 12 months.
Instructions: Enter the current portion of the company's long term debt as of the end of the period (as a negative figure). The current portion is the amount owed over the next 12 months.
Instructions: Enter the amount of the company's retained earnings at the beginning of the period. This is the cumulative earning since the company's inception less the cumulative Dividends or Owner's draws since inception.
Balance Sheet
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.
Example
| Construction Company | |||||
| Balance Sheet | |||||
| 5/1/15 | |||||
| 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 | - 0 | ||
| 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 | - 0 | 100.00 | ||
| Temporary Investments | - 0 | - 0 | - 0 | ||
| Total Current Assets | 48,804.00 | 47,300.00 | 1,504.00 | ||
| Fixed Assets: | |||||
| Land | 150,000.00 | 150,000.00 | - 0 | ||
| Buildings | 60,235.00 | 60,235.00 | - 0 | ||
| Furniture and Equipment | 28,777.00 | 30,777.00 | (2,000.00) | ||
| Computer Equipment | 5,195.00 | 5,195.00 | - 0 | ||
| Vehicles | 32,513.00 | 32,513.00 | - 0 | ||
| 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 | - 0 | ||
| Patents | - 0 | - 0 | - 0 | ||
| Security Deposits | 1,500.00 | 1,500.00 | - 0 | ||
| Other Assets | 583.00 | 600.00 | (17.00) | ||
| Total Other Assets | 6,254.00 | 6,271.00 | (17.00) | ||
| - 0 | |||||
| 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 | - 0 | ||
| 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) | - 0 | ||
| 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 | - 0 | ||
| Opening Retained Earnings | 25,530.00 | 29,129.00 | (3,599.00) | ||
| Dividends Paid/Owner's Draw | (5,000.00) | (5,000.00) | - 0 | ||
| 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 | - 0 | - 0 |
Balance Sheet
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.
