These free cash flow statement templates to convey how efficiently your company manages the inflow …
Download Pro Forma Balance Sheet Excel Template
A running log template is essential for tracking your daily progress and accomplishments, whether you are …
Salary Arrears Calculator is a ready-to-use template in Excel to calculate month wise salary arrears …
Use these free Pro forma balance sheet templates to convey the financial position of your business during a specific time period to potential investors and stakeholders.
Moreover, Small businesses can use this sheet template to project account balances for assets, liabilities, and equity for a designated period. So, Established businesses can use this template (and its built-in formulas) to calculate key financial ratios, including working capital.
How to Create a Pro-Forma Balance Sheet
- Firstly, Short Term Assets. The first two items will be your current cash assets and your accounts receivable. …
- Secondly, Long Term Assets. …
- Thirdly, Total Assets. …
- Fourthly, Liabilities. …
- Lastly, Final Tabulation
Is a pro forma the same as a balance sheet?
Benefits of creating a pro forma
Pro Forma Balance Sheet Example
Before creating your own pro forma balance sheet, take a look at our pro forma balance sheet sample:
So, Sample Business Plan Financials: Bob’s Rent-A-Bike
|Balance Sheets, Bob’s Rent-A-Bike||Starting||Pro forma||Pro forma||Pro forma||Pro forma|
|May 31 Year 1||June 20 Year 1||May 31 Year 2||May 31 Year 3||May 31 Year 4|
|to show max|
|Assets||cash need date)|
|Total Current Assets||1200||2100||16472||36548||68360|
|Accumulated Dep. (SL 60 mos)||0||0||1500||4000||7100|
|Net Long-Term Assets||1500||7500||6000||8500||8400|
|Liabilities & Equity|
|Total Current Liabilities||200||600||1000||1300||1600|
|Owner’s Paid-in Capital||2500||2500||2500||2500||2500|
|Owner’s Share Retained Earnings||-500||5736||16874||32580|
|Investor’s Paid-in Capital||7500||7500||7500||7500|
|Investor’s Share Retained Earnings||-500||5736||16874||32580|
|Total Liabilities & Equity||2700||9600||22472||45048||76760|
|By June 20 Year 1 Pro Forma Expenditures and Investments:|
|Less Accounts Payable||600|
|Projected Cash Usage||8400|
To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets.
After installing Excel or Spreadsheet, download the xlsx file of this template to use it
Once extracted, you can open the file using Excel and start entering data or customizing the template.
Click The Button Below To Download Pro Forma Balance Sheet Excel Template
All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.
Popular Excel Templates: