Excel templates

Excel template balance sheet and income statement


Télécharger Excel template balance sheet and income statement

★★★★★★★★★★3.5 étoiles sur 5 basé sur 1 votes.
Votez ce document:

Télécharger aussi :


Excel template balance sheet and income statement

This article provides details of the Excel template balance sheet and income statement that you can download now.

Microsoft Excel software under a Windows environment is required to use this template

These Excel template balance sheet and income statement work on all versions of Excel since 2007.

Examples of a ready-to-use spreadsheet: Download this table in Excel (.xls) format, and complete it with your specific information.

To be able to use these models correctly, you must first activate the macros at startup.



The file to download presents tow templates Excel template balance sheet and income statement

  • Simple Excel template Balance Sheet
  • Financial statements template

Balance Sheet                                   

Instructions                                       

The Balance Sheet shows the financial position of the business as at a point in time        

Prepare a balance sheet for the start of the business, six months later and then at the end of the first year.                                           



Draw the information from the Profit & Loss Statement and the Cash Flow Statement.

A Balance Sheet brings together the results from the Profit & Loss Statement and the Cash Flow Statement.                                     

"What is a profit and loss statement?

The profit and loss statement is a summary of a business’s income and expenses over a specific period. It should be prepared at regular intervals (usually monthly and at financial year end) to show the results of operations for a given period.  

Calculating the cost of goods sold varies depending on whether the business is retail, wholesale, manufacturing, or a service business. In retailing and wholesaling, computing the cost of goods sold during the reporting period involves beginning and ending inventories. This, of course, includes purchases made during the reporting period. In manufacturing, it involves finished-goods inventories, plus raw materials inventories, goods-in-process inventories, direct labour, and direct factory overhead costs.



In the case of a service business, the revenue is being derived from the activities of individuals rather than the sale of a product and hence the calculation of cost of goods sold is a smaller task due to the low-level use of materials required to earn the income."



0