Balance Sheet Template

Projected Balance Sheet
 
Historical
Projected
 Year 1Year 2OpeningYear 1Year 2Year 3
Assets      
Current      
Cash and bank accounts      
Accounts receivable      
Inventory      
Prepaid expense      
Other current assets (A)      
Fixed assets      
Land      
Building      
Livestock      
Furniture & equipment      
Infrastructure      
Leaseholds / renovations      
Other assets      
Total fixed assets      
Less accumulated depreciation      
Total assets      
       
Liabilities      
Current      
Bank loans      
Accounts payable      
Taxes payable      
Current portion of long term debt      
Other current liabilities      
Total current liabilities      
Long term      
Mortgages & notes payable      
Loans from shareholders      
Other long term loans      
Total long term liabilities      
Shareholders’ equity      
Shareholders equity      
Shares      
Total shareholders equity      
Total liabilities & shareholder equity      
Working capital (A-B)      
Editor and Publisher: Jeff Grill
 

Exel Balance Sheet Template

(PDF Download)
Business Plans Guide

 

Resources

How to Create a Balance Sheet 

Balance Sheet Example

Financial Planning

Leave a Comment