|
Profit-Sharing Calculation Worksheet |
|||||||||
|
Company Name |
for Period |
||||||||
|
Profit |
Owner-Backed Credit Cards |
Participants |
Payroll |
% of Payroll |
|||||
|
(From Income Statement) |
|||||||||
|
Total Net Profit |
|||||||||
|
Accumulated Losses From Prior Years |
|||||||||
|
(From Equity section of Balance Sheet) |
|||||||||
|
Owner-Backed Loans |
|||||||||
|
Equity |
|||||||||
|
(From Equity section of Balance Sheet) |
|||||||||
|
PRINT: Portrait, Margins=Minimum, Scale=85% |
|||||||||
|
Profit-Sharing Calculation |
|||||||||||
|
DATA |
PARAMETERS |
CALCULATIONS |
DISTRIBUTIONS |
||||||||
|
Input |
Profit - Period To Date |
||||||||||
|
Profit retained to fund company growth |
Profit retained to fund company growth |
||||||||||
|
Owner-Backed Credit Cards |
Years to pay off owner-backed credit cards |
Pay off owner-backed credit cards |
|||||||||
|
Owner-Backed Loans |
Years to pay off owner-backed loans |
Pay off owner-backed loans |
|||||||||
|
Total Owner Loans to Company |
|||||||||||
|
Losses From Prior Years |
Years to recover past losses |
Profit retained to recover past losses |
|||||||||
|
Equity |
Return On Equity |
Owner's Return on Equity (ROE) |
|||||||||
|
Profit available for distribution |
|||||||||||
|
PRINT: Portrait, Margins=Minimum, Scale=85% |
|||||||||||
|
Adjust Parameters |
|||||||||||
|
DATA |
PARAMETERS |
CALCULATIONS |
DISTRIBUTIONS |
||||||||
|
Input |
Profit - Period To Date |
||||||||||
|
Profit retained to fund company growth |
Profit retained to fund company growth |
||||||||||
|
Owner-Backed Credit Cards |
Years to pay off owner-backed credit cards |
Pay off owner-backed credit cards |
|||||||||
|
Owner-Backed Loans |
Years to pay off owner-backed loans |
Pay off owner-backed loans |
|||||||||
|
Total Owner Loans to Company |
|||||||||||
|
Losses From Prior Years |
Years to recover past losses |
Profit retained to recover past losses |
|||||||||
|
Equity |
Return On Equity |
Owner's Return on Equity (ROE) |
|||||||||
|
Profit available for distribution |
|||||||||||
|
PRINT: Portrait, Margins=Minimum, Scale=85% |
|||||||||||
|
Adjust Profit |
|||||||||||
|
DATA |
PARAMETERS |
CALCULATIONS |
DISTRIBUTIONS |
||||||||
|
Input |
Profit - Period To Date |
||||||||||
|
Profit retained to fund company growth |
Profit retained to fund company growth |
||||||||||
|
Owner-Backed Credit Cards |
Years to pay off owner-backed credit cards |
Pay off owner-backed credit cards |
|||||||||
|
Owner-Backed Loans |
Years to pay off owner-backed loans |
Pay off owner-backed loans |
|||||||||
|
Total Owner Loans to Company |
|||||||||||
|
Losses From Prior Years |
Years to recover past losses |
Profit retained to recover past losses |
|||||||||
|
Equity |
Return On Equity |
Owner's Return on Equity (ROE) |
|||||||||
|
Profit available for distribution |
|||||||||||
|
PRINT: Portrait, Margins=Minimum, Scale=85% |
|||||||||||
|
Adjust Parameters and Profit |
|||||||||||
|
DATA |
PARAMETERS |
CALCULATIONS |
DISTRIBUTIONS |
||||||||
|
Input |
Profit - Period To Date |
||||||||||
|
Profit % retained to fund company growth |
Profit retained to fund company growth |
||||||||||
|
Owner-Backed Credit Cards |
Years to pay off owner-backed credit cards |
Pay off owner-backed credit cards |
|||||||||
|
Owner-Backed Loans |
Years to pay off owner-backed loans |
Pay off owner-backed loans |
|||||||||
|
Total Owner Loans to Company |
|||||||||||
|
Losses From Prior Years |
Years to recover past losses |
Profit retained to recover past losses |
|||||||||
|
Equity |
Return On Equity |
Owner's Return on Equity (ROE) |
|||||||||
|
Profit available for distribution |
|||||||||||
|
PRINT: Portrait, Margins=Minimum, Scale=85% |
|||||||||||