Click to return to the main homepage.

Free Financial Flow Calculator & Worksheet
2/21/17

« Back . [home] . [free profit & discount calculator] . [free finance loan calculator - payments] . [clear/reset page]
This is a free financial flow worksheet to show the connection and link between the income statement (P&L) and the balance sheet. None of the values entered on this page will be recorded in the database. This page is provided for testing, training, and playing with financial numbers and flow. All of the math is done automatically (once you leave the field you are working on). Use your tab key to move from field to field. See the help file for more info.
Quick Financial Totals - All totals are controlled from the worksheet below.
How Many Rows/Options: (the default is 5 rows per section)
Income Statement or P&L Side Totals
 
Balance Sheet Side Totals
Revenue:
COGS:
Gross Profit:

Expenses:
Net Profit:

 
Assets:
Liabilities:
Equity:
Balance Status:
Formula: Assets = Liabilities + Equity

Worksheets & Financial Flow Section - All math on this page is automatic. Use your tab key to move fields.
Income Statement or P&L Worksheet
 
Balance Sheet Worksheet
Revenue Section:
 
 
 
 
 
Revenue Total:
COGS Section:
 
 
 
 
 
COGS Total:
Gross Profit:
Expenses Section:
 
 
 
 
 
Expenses Total:
Net Profit: *
*
* "Net Profit" gets transferred over to the balance sheet.
 
Assets Section:
 
 
 
 
 
Assets Total:
Liabilities Section:
 
 
 
 
 
Liabilities Total:
Equity Section:
 
 
 
 
 
Equity Total:
 

Quick Financial Totals - All totals are controlled from the worksheet above.
Income Statement or P&L Side Totals
 
Balance Sheet Side Totals
Revenue:
COGS:
Gross Profit:

Expenses:
Net Profit:

 
Assets:
Liabilities:
Equity:
Balance Status:
Formula: Assets = Liabilities + Equity

© 2017 powered by adilas.biz