Contact a Consultant
Plano, Texas
Established 2008

Level 1 Financial Statements Template

The Level 1 financial statements can be downloaded for $49. This page shows the 5 different tabs on the Excel spreadsheet. Each of the 5 tabs are shown below as a web page link. Click on the 'Input', "Income Statement', 'Cash Flow', 'Balance Sheet', and 'Loan Amortization' links below to see how the spreadsheet works. All numbers are locked online but will be easy to change once downloaded into Excel.
The financial statement template tool can be purchased and downloaded in Microsoft Excel for only $49. Please follow the link below to download this tool. Following your payment, you will be redirected to the download page.

Level 1 Financial Statements Template

Input - Location on the spreadsheet where all inputs are made. All areas in gray can be changed by the user to create the other 4 tables. Changing numbers here will create your financial model. 5 different revenue lines, 15 expense lines, loan amount, interest, depreciation, and long-term assets can be changed and created.

Income Statement - Tab on the spreadsheet that includes revenue, expenses, and earnings. This tab is completely automated by the input tab.

Cash Flow - Tab on the spreadsheet that includes operating activities, investing activities, and financing activities. This tab is completely automated by the input tab.

Balance Sheet - Tab on the spreadsheet that includes assets, liabilities, and shareholders' equity. This tab is completely automated by the input tab.

Loan Amortization - Tab on the spreadsheet that breaks down the loan repayment schedule. This tab is completely automated by the input tab.

Input | Income Statement | Cash Flow | Balance Sheet | Loan Amortization |

                   
  Line Title Month 1 Revenue Amount Direct Cost of Revenue Percent Yearly Revenue Growth Percent  
  Revenue Line 1 Hats $8,000 35.0% 35.0%  
  Revenue Line 2 Shirts $10,000 35.0% 35.0%  
  Revenue Line 3 Pants $15,000 35.0% 35.0%  
  Revenue Line 4 Shoes $20,000 35.0% 35.0%  
  Revenue Line 5 Accessories $5,000 35.0% 35.0%  
       
    Line Title Year 1 Amount Yearly Expense Growth Percent    
  Expense Line 1 Marketing $3,000 15.0%    
  Expense Line 2 Rent $3,000 15.0%    
  Expense Line 3 Travel $3,000 15.0%    
  Expense Line 4 Entertainment $3,000 15.0%    
  Expense Line 5 Utilities $3,000 15.0%    
  Expense Line 6 Insurance $3,000 15.0%    
  Expense Line 7 Commission $3,000 15.0%    
  Expense Line 8 Royalties $3,000 15.0%    
  Expense Line 9 Professional Fees $3,000 15.0%    
  Expense Line 10 Legal $3,000 15.0%    
  Expense Line 11 Accounting $3,000 15.0%    
  Expense Line 12 Leased Equipment $3,000 15.0%    
  Expense Line 13 Advertising $3,000 15.0%    
  Expense Line 14 Merchant Fees $3,000 15.0%    
  Expense Line 15 Other $3,000 15.0%    
       
       
  Amount    
  Investments $20,000    
  Loans $90,000    
  Interest Rate 9.0%    
  Loan Term (Years) 7.0    
         
         
    Year 1 Year 2 Year 3      
  Assets Purchased $25,000 $20,000 $10,000      
         
         
    Amount      
  Depreciation Rate Years 10.0      
  Tax Rate 35.0%      
       



555 Republic Drive, Suite 200, Plano, TX 75074
(214) 491-4001 Info@Financial-Projections.com
all content copyright 2008-2017 Butler Consultants
privacy policy | sitemap | terms of use