common size balance sheet calculator v 1.01

2
© 2014 www.double-entry-bookkeeping.com document.xlsx Common Size Balance Sheet Calculator Balance sheet Balance sheet 1 % Balance sheet 2 % Assets Cash 14,259 6.9% 5,269 20.8% Accounts receivable 57,263 27.7% 7,229 28.6% Inventory 1,764 0.9% 4,992 19.7% Current assets 73,286 35.4% 17,490 69.2% Long-term assets 133,714 64.6% 7,788 30.8% Total assets 207,000 100.0% 25,278 100.0% 0.0% 0.0% Liabilities 0.0% 0.0% Accounts payable 22,367 10.8% 11,145 44.1% Other liabilities 21,291 10.3% 3,751 14.8% Current liabilities 43,658 21.1% 14,896 58.9% Long-term debt 39,793 19.2% 2,625 10.4% Total liabilities 83,451 40.3% 17,521 69.3% 0.0% 0.0% Equity 0.0% 0.0% Capital 19,764 9.5% 5,802 23.0% Retained earnings 103,785 50.1% 1,955 7.7% Total equity 123,549 59.7% 7,757 30.7% Total liabilities and equity 207,000 100.0% 25,278 100.0%

Upload: orestis-konstantinidis

Post on 07-Nov-2015

4 views

Category:

Documents


0 download

DESCRIPTION

for common size calculations

TRANSCRIPT

common size balance sheetCommon Size Balance Sheet CalculatorInput cellsBalance sheetBalance sheet 1%Balance sheet 2%AssetsCash14,2596.9%5,26920.8%Accounts receivable57,26327.7%7,22928.6%Inventory1,7640.9%4,99219.7%Current assets73,28635.4%17,49069.2%Long-term assets133,71464.6%7,78830.8%Total assets207,000100.0%25,278100.0%0.0%0.0%Liabilities0.0%0.0%Accounts payable22,36710.8%11,14544.1%Other liabilities21,29110.3%3,75114.8%Current liabilities43,65821.1%14,89658.9%Long-term debt39,79319.2%2,62510.4%Total liabilities83,45140.3%17,52169.3%0.0%0.0%Equity0.0%0.0%Capital19,7649.5%5,80223.0%Retained earnings103,78550.1%1,9557.7%Total equity123,54959.7%7,75730.7%Total liabilities and equity207,000100.0%25,278100.0%

Instructions and additional templates are available at our websitehttp://www.double-entry-bookkeeping.com

2014 www.double-entry-bookkeeping.com

&8 2014 www.double-entry-bookkeeping.com&8&F

DisclaimerNotes and major health warningsUsers use this template at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example. It is purely illustrative. This is not intended to reflect general standards or targets for any particular company or sector.If you do spot a mistake in the template, please let us know and we will try to fix it.Additional templates are available for download at our websitehttp://www.double-entry-bookkeeping.com/