Category : Lotus and other Spreadsheets
Archive : BPD22.ZIP
Filename : BPDHIST.WK1
Output of file : BPDHIST.WK1 contained in archive : BPD22.ZIP
P P H P N
M 3 M M 3 M M M M 3 M M > > > > > 4 > > > > > > > > > ! > " 4 5 # 5 $ 5 5 % 5 & 5 ' 5 ( 5 5 ) 5 / ÿ ÿ q H !
! " # ( ) d G ASSET WORKSHEET G BALANCE SHEET / G D&B < G FED TAX N N G INCOME STATEMNT F ÿ ÿ G RATIO ANALY 4 K G RETURNS L L G RMA " ' 2 G STATE TAX M M G STATEMENT VAR L N ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ 0 ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ # ÿÿ ÿÿ g ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ i ( ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ f ÿÿ ÿÿ ÿÿ ÿÿ $ ÿ% ò & ò ' ( (
L B ) '* ÿÿ ÿÿ ÿÿ ÿÿ - ·ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ qq ÿ ^Biz Plan Developer v2.2 ÿ ^* ÿ ^* ÿ
^* ÿ ^BALANCE SHEET ÿ ^* ÿ ^Dun & Bradstreet ! ^*
ÿ% ^RMA ÿ) ^* ÿ ^Lotus 1-2-3 version ÿ ^* ÿ ^* ÿ
^* ÿ ^(000's) ÿ ^* ÿ ^Industry Norms ! ^* ÿ) ^* ÿ ^Historical Financial Data ÿ ^* ÿ ^* ÿ
^* ^My Company ÿ ^* ! ^*
% "Year 1
& "Year 2
' "Year 3 ÿ) ^* % ÿ ^Copyright 1993, David A. Works ÿ ^* ÿ ^* ÿ
^* ÿ ^* "Year '1 "Year '2 "Year '3 ! ^* ÿ) ^* ÿ ^* ÿ ^* ÿ
^*
"Year 1
"Year 2
"Year 3 ÿ ^* ÿ ^$ ÿ ^% ÿ ^$ ÿ ^% ÿ ^$ ÿ ^% ! ^*
ÿ# ^ASSETS ÿ) ^* ÿ ^Please Read User's Guide! ÿ ^* ÿ ^* ÿ
^* ÿ ^* ! ^* ÿ# ^Cash & Equivalents % 2Æc1H@ ìì d & 2Æc1H@ ìì d ' 2Æc1H@ ìì d ÿ) ^* ÿ ^* ÿ ^* ÿ
^* ÿ ^* ! ^* ÿ# ^Trade Receivables - (net) % ìì d & ìì d ' ìì d ÿ) ^* ^This is SHAREWARE. ÿ ^* ÿ ^* ÿ
^*
ÿ 'ASSETS ÿ ^* ÿ 'CASH .@ ù¿ 2Æc1H@ ÿ¿ ÿ d .@ ÷ 2Æc1H@ ÿ¿ ÿ d .@ õ 2Æc1H@ ÿ¿ ÿ d ! ^* ÿ# ^Inventory % !B!0@ ìì d & !B!0@ ìì d ' !B!0@ ìì d ÿ) ^* $ ÿ ^Registration brings benefits! ÿ ^* ÿ ^* ÿ ^Asset Worksheet ÿ
^* ÿ ^* ÿ 'ACCOUNTS RECEIVABLE ù¿ ÿ¿ ÿ
d ÷ ÿ¿ ÿ
d õ ÿ¿ ÿ
d ! ^* ÿ# ^All Other Current
%
&
' ÿ) ^* ÿ \* ÿ '***** ÿ ^* ÿ
^* ÿ ' Cash
ÿ ^* ÿ 'NOTES RECEIVABLE ù¿ ÿ¿ ÿ d ÷ ÿ¿ ÿ d õ ÿ¿ ÿ d ! ^* ÿ# ^Total Current % !B!P@ ìì
d & !B!P@ ìì
d ' !B!P@ ìì
d ÿ) ^* ÿ
^INCOME STATEMENT ÿ
^* ÿ
^(000's) ÿ
^* ÿ
' Accounts Receivable
ÿ
^* ÿ
'INVENTORY
@ ù¿
!B!0@ ÿ¿ ÿ¿ d
@ ÷¿
!B!0@ ÿ¿ ÿ¿ d
@ õ¿
!B!0@ ÿ¿ ÿ¿ d !
^* ÿ#
^Fixed Assets (net) %
!B!P@ ì¿ì¿ d &
!B!P@ ì¿ì¿ d '
!B!P@ ì¿ì¿ d ÿ)
^* ÿ ^* ÿ 'Fixed Assets ÿ
^* ÿ ' Notes Recivable
ÿ ^* ÿ 'OTHER CURRENT ÿ¿ ÿ¿ d ÿ¿ ÿ¿ d ÿ¿ ÿ¿ d ! ^* ÿ# ^All Other Non-Current % Î9çsÎ @ ì¿ ì¿ d & Î9çsÎ @ ì¿ ì¿ d ' Î9çsÎ @ ì¿ ì¿ d ÿ) ^* ÿ ^(000's) ÿ ^* ÿ
^* ÿ ' Inventory @ ñ¿ @ ñ¿ @ ñ¿ ÿ ^* ! ^* ÿ# ^Total
% d
& d
' d ÿ) ^*
^My Company ÿ
^* ÿ
' Equipment
ÿ
^* ÿ
^* ÿ
'TOTAL CURRENT
4@ ù¿
!B!P@ ÿ¿ ÿ¿ d
4@ ÷¿
!B!P@ ÿ¿ ÿ¿ d
4@ õ¿
!B!P@ ÿ¿ ÿ¿ d !
^* ÿ#
^LIABILITIES ÿ)
^* ÿ ^* ÿ ' Automotive, trucks
ÿ
^* ÿ 'Total Current Assets 4@ û¿ þ¿P 4@ û¿ þ¿P 4@ û¿ þ¿P ÿ ^* ! ^* ÿ# ^Notes-Payable-Short Term % ì¿
ì¿ d & ì¿
ì¿ d ' ì¿
ì¿ d ÿ) ^* ÿ ^* ÿ ' Buildings
ÿ
^* ÿ ^* ÿ 'FIXED ASSETS $@ ù¿ !B!@@ ÿ¿ ÿ¿ d $@ ÷¿ !B!@@ ÿ¿ ÿ¿ d $@ õ¿ !B!@@ ÿ¿ ÿ¿ d ! ^* # ^Cur. Mat.-L/T/D % ì¿
ì¿ d & ì¿
ì¿ d ' ì¿
ì¿ d ÿ) ^*
"Year 1
"Year 2
"Year 3 ÿ ^* ÿ ' Fixtures
à? ÿ
^* ÿ ' Equipment $@ ù¿ý¿ $@ ø¿ý¿ $@ ÷¿ý¿ ÿ ^* 'OTHER NON-CURRENT ð? ù¿ Î9çsÎ @ ÿ¿ ÿ¿ d ð? ÷¿ Î9çsÎ @ ÿ¿ ÿ¿ d ð? õ¿ Î9çsÎ @ ÿ¿ ÿ¿ d ! ^* # ^Trade Payables % ì¿
ì¿ d & ì¿
ì¿ d ' ì¿
ì¿ d ÿ) ^* ÿ ^------- ÿ ^------- ÿ ^------- ÿ ^* ÿ ' Machinery
ÿ
^* ÿ ' Less: accum. deprec.
ÿ ^* ! ^* ÿ# ^Income Taxes-Payable
%
&
' ÿ) ^* ÿ 'Revenue: ÿ ^* " ÿ ' Leasehold improvements
{®Gáz? ÿ
^* ÿ ^* ÿ 'TOTAL ASSETS ?@ ù¿
d ?@ ÷¿
d ?@ õ¿
d ! ^* ÿ# ^All Other Current % ì¿ì¿ d & ì¿ì¿ d ' ì¿ì¿ d ÿ) ^* ÿ ' Gross Sales:
ÿ ^* ÿ
^* ÿ ' Net Fixed assets $@ ý¿ þ¿
$@ ý¿ þ¿
$@ ý¿ þ¿
ÿ ^* ! ^* ÿ# ^Total Current % ì¿ ì¿ d & ì¿ ì¿ d ' ì¿ ì¿ d ÿ) ^* # ÿ ' Less returns, discounts âÿÿÿÿ @ ÿ¿ L âÿÿÿÿ @ ÿ¿ L âÿÿÿÿ @ ÿ¿ L ÿ ^* ÿ
^* ÿ ' Intangible Assets ð? ú¿ ð? ù¿ ð? ø¿ ÿ ^* ÿ 'ACCOUNTS PAYABLE ù¿ ÿ¿ d ÷¿ ÿ¿ d õ¿ ÿ¿ d ! ^* ÿ# ^Long Term Debt % ì¿ì¿ d & ì¿ì¿ d ' ì¿ì¿ d ÿ) ^* ÿ ^* ÿ 'Total Fixed Assets Ãõ(\3@ ÿ¿ø¿ÿ¿ý¿P ÿ
^* ÿ ^* ÿ 'BANK LOANS ù¿ ÿ¿ d ÷¿ ÿ¿ d õ¿ ÿ¿ d ! ^* ÿ# ^Deferred Taxes
%
&
' ÿ) ^* ÿ 'Net Sales ð Ða@ ý¿ þ¿
ð Ða@ ý¿ þ¿
ð Ða@ ý¿ þ¿
ÿ ^* ÿ
^* ÿ 'Total Assets ! ?@ ø¿ ý¿ þ¿ ! ?@ ø¿ ý¿ þ¿ ! ?@ ø¿ ý¿ þ¿ ÿ ^* ÿ 'NOTES PAYABLE ù¿ ÿ¿ d ÷¿ ÿ¿ d õ¿ ÿ¿ d ! ^* ÿ# ^All Other Non-Current
%
&
' ÿ) ^* ÿ ^* 'Intangible Assets ÿ
^* ÿ ^* ÿ 'OTHER CURRENT ù¿ ÿ¿ d ÷¿ ÿ¿ d õ¿ ÿ¿ d ! ^* $ ÿ# ^Total Liabilities & Net Worth
% d
& d
' d ÿ) ^* ÿ 'Cost of Goods Sold: ÿ ^* ÿ ' Goodwill
ÿ
^* ÿ 'LIABILITIES ÿ ^* ! ^* ÿ# ^INCOME DATA ÿ) ^* ÿ ' Beginning inventory
@ ÿ¿ @ ÿ¿ ÿ ^* ÿ ' Other ÿ
^* ÿ ^* ÿ 'TOTAL CURRENT ù¿ ÿ¿ d ÷¿ ÿ¿ d õ¿ ÿ¿ d ! ^* ÿ# ^Net Sales
% d
& d
' d ÿ) ^* ÿ ' Purchases
2
2
2 ÿ ^* ÿ "Total ð? þ¿ ÿ¿P ÿ
^* ÿ ' Accounts payable
ÿ ^* ! ^* ÿ# ^Gross Profit % ·2ÅtI@ Ý¿Ý¿ü¿ d & PQ^Cy
P@ Ý¿Ý¿ü¿ d ' PQ^Cy
P@ Ý¿Ý¿ü¿ d ÿ) ^* ÿ ' Freight
ÿ ^* ÿ
^* ÿ ' Bank notes
ÿ ^* ÿ 'OTHER LONG TERM ù¿ ÿ¿ d ÷¿ ÿ¿ d õ¿ ÿ¿ d ! ^* ÿ# ^Operating Expenses % Ù^ÙæË8@ Ý#Ý¿û¿ d &
êÂrµ8@ Ý#Ý¿û¿ d ' ;u¬@i9@ Ý#Ý¿û¿ d ÿ) ^* ! ÿ ' Total goods available S@ ý¿ ÿ¿P L@ ý¿ ÿ¿P L@ ý¿ ÿ¿P ÿ ^* ÿ \* ÿ \* ÿ \* ÿ
\* ÿ \* ÿ \* ÿ
^* ÿ ' Notes payable
ÿ ^* 'DEFERRED CREDITS ù¿ ÿ¿ d ÷¿ ÿ¿ d õ¿ ÿ¿ d ! ^* ÿ# ^Operating Profit % a¤ +:@ Ý$Ý¿ú¿ d & -Û|9ÀC@ Ý$Ý¿ú¿ d ' hffffC@ Ý$Ý¿ú¿ d ÿ) ^* ÿ ' Ending inventory
ÿ ^* ÿ
^* ÿ ' CPLTD
ÿ ^* 'NET WORTH ?@ ù¿ Y@ ÿ¿ d ?@ ÷¿ Y@ ÿ¿ d ?@ õ¿ Y@ ÿ¿ d ! ^* ÿ# ^All Other Expenses (net) % #çéJïô? Ý$Ý¿ù¿ d & ÷Âõÿ? Ý$Ý¿ù¿ d ' º£p=
ÿ? Ý$Ý¿ù¿ d ÿ) ^* ÿ 'Total Cost of Goods Sold ÀQ@ þ¿ ÿ¿
I@ þ¿ ÿ¿
I@ þ¿ ÿ¿
ÿ ^* ÿ
^* ÿ ^* ! ^* ÿ# ^Profit Before Taxes % ]Âõ(Ü8@ Ý%Ý¿ø¿ d & 6ÐiÃB@ Ý%Ý¿ø¿ d ' .JáznB@ Ý%Ý¿ø¿ d ÿ) ^* ÿ ^* ÿ
^* ÿ 'Total Current Liabilities û¿ þ¿P û¿ þ¿P û¿ þ¿P ÿ ^* 'TOTAL LIAB&NET WORTH ?@ ù¿
d ?@ ÷¿
d ?@ õ¿
d ! ^*
ÿ# ^RATIOS ÿ) ^* ÿ 'Gross Profit à àQ@ ö¿ þ¿
à àV@ ö¿ þ¿
à àV@ ö¿ þ¿
ÿ ^* ÿ
^* ÿ 'Deferred Credits
ÿ ^* ! ^* ÿ# ^Current % ðÿ ì¿ & ðÿ ì¿ ' ðÿ ì¿ ÿ) ^* ÿ ! ^* ÿ
! ^* ÿ ! ^* ! 'NET SALES ! ð Ða@ ê¿õ¿
! d ! ð Ða@ è¿õ¿
! d ! ð Ða@ æ¿õ¿
! d ! ! ^* ÿ# ! ^Quick % ! ðÿ ì¿ & ! ðÿ ì¿ ' ! ðÿ ì¿ ÿ) ! ^* ÿ " 'Operating Expenses: ÿ " ^* ÿ
" ^* $ ÿ " 'Total non-current liabilities
"
"
" ÿ " ^* " 'GROSS PROFIT " ê¿ÿ¿ " ÿ¿ ! d " è¿õ¿ " ÿ¿ ! d " æ¿õ¿ " ÿ¿ ! d ! " ^* ÿ# " ^Sales/Receivables & % " ðÿ ì¿è¿ Ý¿ô¿ì¿è¿ ; & & " ðÿ ì¿è¿ Ý¿ô¿ì¿è¿ ; & ' " ðÿ ì¿è¿ Ý¿ô¿ì¿è¿ ; ÿ) " ^* ÿ # ^* ÿ
# ^* ÿ # ^* # 'NET PROFIT AFTER TAX # .Éå?Ì8@ ê# # éÕxéf1@ ÿ¿ ! d # ìù g·B@ è# # ê²VÇD:@ ÿ¿ ! d # >)§èHbB@ æ# # ér;ßOÍ9@ ÿ¿ ! d ! # ^* ÿ# # ^Cost of Sales/Inventory - % # 333333.@ ì¿é¿ Ý¿û¿Ý¿ ì¿é¿ ; - & # &@ ì¿é¿ Ý¿û¿Ý¿ ì¿é¿ ; - ' # '@ ì¿é¿ Ý¿û¿Ý¿ ì¿é¿ ; ÿ) # ^* ÿ $ 'Selling Expenses ÿ $ ^* ÿ
$ ^* ÿ $ 'Total Liabilities ! $ û¿ þ¿ ü¿ ! $ û¿ þ¿ ü¿ ! $ û¿ þ¿ ü¿ ÿ $ ^* $ 'WORKING CAPITAL $ 4@ ù¿ê¿ù¿û¿
$ ^NA $ 4@ ÷¿ê¿÷¿û¿
$ ^NA $ 4@ õ¿ê¿õ¿û¿
$ ^NA ! $ ^* ÿ# $ ^Cost of Sales/Payables - % $ ðÿ ì¿ö¿ Ý¿ú¿Ý¿ ì¿ö¿ ; - & $ ðÿ ì¿ö¿ Ý¿ú¿Ý¿ ì¿ö¿ ; - ' $ ðÿ ì¿ö¿ Ý¿ú¿Ý¿ ì¿ö¿ ; ÿ) $ ^* ÿ % ' Advertising
% à?
% à?
% à? ÿ % ^* ÿ
% ^* ÿ % ^* ! % ^* ÿ# % ^Sales/Working Capital 4 % % @% ì¿é¿ì¿ú¿
Ý¿ñ¿ì¿é¿ì¿ú¿
; 4 & % @% ì¿é¿ì¿ú¿
Ý¿ñ¿ì¿é¿ì¿ú¿
; 4 ' % @% ì¿é¿ì¿ú¿
Ý¿ñ¿ì¿é¿ì¿ú¿
; ÿ) % ^* ÿ & ' Commissions
&
&
& ÿ & ^* ÿ
& ^* ÿ & 'NET WORTH ÿ & ^*
ÿ & 'RATIOS ! & ^* ÿ# & ^EBIT/Interest
% &
& &
' & ÿ) & ^* ÿ ' ' T & E
'
'
' ÿ ' ^* ÿ
' ^* ÿ ' ^* ! ' ^* ÿ# ' ^Net Profit + Depr.,Dep., ÿ) ' ^* ÿ ( 'Total ( @ ý¿ ÿ¿P ( @ ý¿ ÿ¿P ( @ ý¿ ÿ¿P ÿ ( ^* ÿ
( ^* ÿ ( ' Paid in Capital
(
(
( ÿ ( ^* ( ' SOLVENCY ! ( ^* ÿ# ( ^Amort./Cur. Mat. L/T/D
% (
& (
' ( ÿ) ( ^* ÿ ) ^* ÿ
) ^* ÿ ) ' Retained Earnings
)
)
) ÿ ) ^* ) 'QUICK RATIO (TIMES) ) ðÿ ù¿ ) ðÿ ÷ ) ðÿ õ ! ) ^* ÿ# ) ^Fixed/Worth & % ) ¥RJ)¥Ô? ì¿ ì¿ê¿ì¿ ; & & ) ¥RJ)¥Ô? ì¿ ì¿ê¿ì¿ ; & ' ) ¥RJ)¥Ô? ì¿ ì¿ê¿ì¿ ; ÿ) ) ^* ÿ * 'Administrative ÿ * ^* ÿ
* ^* ÿ * ' Other ( * ?@ ì¿ ú¿ þ¿ ÿ¿
( * ?@ ì¿ ú¿ þ¿ ÿ¿
( * ?@ ì¿ ú¿ þ¿ ÿ¿
ÿ * ^* * 'CURRENT RATIO (TIMES) * ðÿ ù¿ * ðÿ ÷ * ðÿ õ ! * ^* ÿ# * ^Debt/Worth & % * ì¿ ì¿ú¿ì¿ ; & & * ì¿ ì¿ú¿ì¿ ; & ' * ì¿ ì¿ú¿ì¿ ; ÿ) * ^* ÿ + ' Salaries
+
+
+
ÿ + ^* ÿ
+ ^* ÿ + ^* + 'CURR LIAB TO NW (%) & 2 + ù¿ ù¿ô¿ù¿ ; & 2 + ÷¿ ÷¿ô¿÷¿ ; & 2 + õ õô¿õ ; ! + ^* ÿ# + ^% Profit Before Taxes/ ÿ) + ^* ÿ , ' Payroll
,
,
, ÿ , ^* ÿ
, ^* ÿ , 'Total Net Worth , ?@ ü¿ þ¿P , ?@ ü¿ þ¿P , ?@ ü¿ þ¿P ÿ , ^* ÿ , 'CURR LIAB TO INV (%) & 2 , ê¿ñ¿ ù¿ó¿ê¿ñ¿ ; & 2 , èñ¿ ÷ó¿èñ¿ ; & 2 , æñ¿ õó¿æñ¿ ; ! , ^* ÿ# , ^Tangible Net Worth & 2% , i%®¼Hò? ì¿ Ýì¿ ; & 2& , îF4ªû? ì¿ Ýì¿ ; & 2' , jê[»$ û? ì¿ Ýì¿ ; ÿ) , ^* ÿ - ' Withholding
- É?
- É?
- É? ÿ - ^* ÿ
- ^* ÿ - ^* - 'TOTAL LIAB TO NW (%) & 2 - ù¿ÿ¿ ù¿ø¿ù¿ÿ¿ ; & 2 - ÷ÿ¿ ÷ø¿÷ÿ¿ ; & 2 - õÿ¿ õø¿õÿ¿ ; ! - ^* ÿ# - ^% Profit Before Taxes/ ÿ) - ^* ÿ . ' Insurance
. {®Gáz?
. {®Gáz?
. {®Gáz? ÿ . ^* ÿ
. ^* ÿ . 'TOTAL LIABILITIES & ÿ . ^* . 'FIXED ASSETS TO NW (%) & 2 . ¥RJ)¥Ô? ù¿þ¿ ù¿å¿ù¿þ¿ ; & 2 . ¥RJ)¥Ô? ÷þ¿ ÷å¿÷þ¿ ; & 2 . ¥RJ)¥Ô? õþ¿ õå¿õþ¿ ; ! . ^* ÿ# . ^Total Assets & 2% . i%®¼Hò? ì¿è¿ Ýì¿è¿ ; & 2& . îF4ªû? ì¿è¿ Ýì¿è¿ ; & 2' . jê[»$ û? ì¿è¿ Ýì¿è¿ ; ÿ) . ^* ÿ / 'Total / ìQ¸ k&@ ü¿ ÿ¿P / ìQ¸ k&@ ü¿ ÿ¿P / ìQ¸ k&@ ü¿ ÿ¿P ÿ / ^* ÿ
/ ^* ÿ / ' NET WORTH / ?@ õ¿ ý¿ / ?@ õ¿ ý¿ / ?@ õ¿ ý¿ ÿ / ^* ! / ^* ÿ# / ^Sales/Net Fixed Assets & % / ,@ ì¿ä¿ Ý¿ç¿ì¿ä¿ ; & & / ,@ ì¿ä¿ Ý¿ç¿ì¿ä¿ ; & ' / ,@ ì¿ä¿ Ý¿ç¿ì¿ä¿ ; ÿ) / ^* ÿ 0 ^* ÿ
0 ^* ÿ 0 ^* ÿ 0 ' EFFICIENCY ! 0 ^* ÿ# 0 ^Sales/Total Assets & % 0 [1Æc@ ì¿æ¿ Ý¿æ¿ì¿æ¿ ; & & 0 [1Æc@ ì¿æ¿ Ý¿æ¿ì¿æ¿ ; & ' 0 [1Æc@ ì¿æ¿ Ý¿æ¿ì¿æ¿ ; ÿ) 0 ^* ÿ 1 'General ÿ 1 ^* ÿ
1 ^* ÿ 1 ^* ÿ 1 'COLL PERIOD (DAYS) + 1 ê¿å¿ ù¿Ù¿ê¿å¿ m ; + 1 èå¿ ÷Ù¿èå¿ m ; + 1 æå¿ õÙ¿æå¿ m ; ! 1 ^* ! ÿ# 1 ^% Depr., Dep., Amort/Sales
2% 1
2& 1
2' 1 ÿ) 1 ^* ÿ 2 ' Rent
2 à?
2 à?
2 à? ÿ 2 ^* ÿ
2 ^* ÿ 2 ^* 2 'SALES TO INV (TIMES) & 2 <@ ê¿ë¿ ê¿ä¿ê¿ë¿ ; & 2 <@ èë¿ èä¿èë¿ ; & 2 <@ æë¿ æä¿æë¿ ; ! 2 ^* ÿ# 2 ^% Officer's Comp./Sales & 2% 2 ~ Á}÷±? Ý¿ä¿ Ý¿ù¿Ý¿ä¿ ; & 2& 2 ~ Á}÷±? Ý¿ä¿ Ý¿ù¿Ý¿ä¿ ; & 2' 2 ~ Á}÷±? Ý¿ä¿ Ý¿ù¿Ý¿ä¿ ; ÿ) 2 ^* ÿ 3 ' Utilities
3
3
3 ÿ 3 ^* ÿ
3 ^* ÿ 3 \* ÿ 3 \* ÿ 3 \* ÿ 3 \* ÿ 3 \* ÿ 3 \* ÿ 3 \* ÿ 3 ^* 3 'ASSETS TO SALES (%) & 2 3 ¼Q)zØË? ê¿ã¿ ù¿ã¿ê¿ã¿ ; & 2 3 ¼Q)zØË? èã¿ ÷ã¿èã¿ ; & 2 3 ¼Q)zØË? æã¿ õã¿æã¿ ; ! 3 ^* ÿ) 3 ^* ÿ 4 ' Telephone
4
4
4 ÿ 4 ^* ÿ
4 ^* ÿ 4 ^* 4 'SALES TO NWC (TIMES) & 4 @ ð¿ ê¿â¿ ð¿ ; 4 & 4 ðÿ þð¿ èâ¿þð¿ ; & 4 ðÿ üð¿ æâ¿üð¿ ; ! 4 ^* 0 ÿ" 4 'RMA is copyright Robert Morris Associates ÿ) 4 ^* ÿ 5 ' Office Expenses
5
5
5 ÿ 5 ^* ÿ
5 ^* ÿ 5 ^* 5 'ACCTS PAY TO SALES (%) & 2 5 ê¿á¿ ù¿Õ¿ê¿á¿ ; & 2 5 èá¿ ÷Õ¿èá¿ ; & 2 5 æá¿ õÕ¿æá¿ ; ! 5 ^* ÿ" 5 \* ÿ# 5 \* ÿ$ 5 \* ÿ% 5 \* ÿ& 5 \* ÿ' 5 \* ÿ( 5 \* ÿ) 5 ^* ÿ 6 ' Auto Expenses
6
6
6 ÿ 6 ^* ÿ
6 ^* ÿ 6 ^RATIO ANALYSIS ÿ 6 ^* ! 6 ^* ÿ 7 ' Supplies
7
7
7 ÿ 7 ^* ÿ
7 ^* 7 'My Company ÿ 7 ^* 7 ' PROFITABILITY ! 7 ^* ÿ 8 ' Postage
8
8
8 ÿ 8 ^* ÿ
8 ^* ÿ 8 ^* 8 'RETURN ON SALES (%) 2 8 5ØlIFÆ? ù¿ 2 8 iw¼ÛÏÐ? ÷ 2 8 /ºmQfÐ? õ ! 8 ^* ÿ 9 ' Professionals
9
9
9 ÿ 9 ^* ÿ
9 ^*
9 "Year 1
9 "Year 2
9 "Year 3 ÿ 9 ^* 9 'RETURN ON ASSETS (%) 2 9 ¿7'é? ù¿ 2 9 Ó×[÷Qó? ÷ 2 9 ùY¶úò? õ ! 9 ^* ÿ : ' Research
:
:
: ÿ : ^* ÿ
: ^* ÿ : ^* : 'RETURN ON NW (%) 2 : ¿7'é? ù¿ 2 : Ó×[÷Qó? ÷ 2 : ùY¶úò? õ ! : ^* ÿ ; ' Misc.
;
;
; ÿ ; ^* ÿ
; ^* ÿ ; 'Current Ratio & ; ðÿ ä¿ Ó¿ ä¿ ; & ; ðÿ ä¿ Ó¿ ä¿ ; & ; ðÿ ä¿ Ó¿ ä¿ ; ÿ ; ^* ! ; ^* ÿ < 'Total < 2@ ö¿ ÿ¿P < 2@ ö¿ ÿ¿P < 2@ ö¿ ÿ¿P ÿ < ^* ÿ
< ^* ÿ < 'Acid Ratio - < ðÿ ã¿ Í¿ ο ã¿ ; - < ðÿ ã¿ Í¿ ο ã¿ ; - < ðÿ ã¿ Í¿ ο ã¿ ; ÿ < ^* ! < ^* ÿ = ^* ÿ
= ^* ÿ = ^* ! = ^* ÿ > 'Total Operating Expenses ! > {®GáA@ ê¿ ñ¿ þ¿ ! > {®GáA@ ê¿ ñ¿ þ¿ ! > {®GáB@ ê¿ ñ¿ þ¿ ÿ > ^* ÿ
> ^* ÿ > 'Debt Ratio & > ðÿ æ¿ Ø¿ æ¿ ; & > ðÿ æ¿ Ø¿ æ¿ ; & > ðÿ æ¿ Ø¿ æ¿ ; ÿ > ^* > \* > \* > \* > \* > \* > \* > \* > \* > \* > \* > \* ! > ^* ÿ ? ^* ÿ
? ^*
ÿ ? 'TIE ÿ ? ^* ÿ @ 'Total Operating Income @ EïQ¸ ¥B@ à¿ þ¿
@ EïQ¸ %L@ à¿ þ¿
@ EïQ¸ ¥K@ à¿ þ¿
ÿ @ ^* ÿ
@ ^* ÿ @ ^* ÿ A ' State Taxes ) A Í-¶óýÔý? ÿ¿ ÿ¿ M ; ) A æ¨t@ ÿ¿ ÿ¿ M ; ) A æB-² @ ÿ¿ ÿ¿ M ; ÿ A ^* ÿ
A ^* ÿ A 'Inventory Turnover + A E+l$Z9@ ñ¿Ý¿ ñ¿Ü¿h ñ¿Ý¿ ; + A ¦¥¥¥¥¥A@ ñ¿Ý¿ ñ¿Ü¿h ñ¿Ý¿ ; + A ¦¥¥¥¥¥A@ ñ¿Ý¿ ñ¿Ü¿h ñ¿Ý¿ ; ÿ A ^* ÿ B ^* ÿ
B ^* ÿ B 'Average Collection ÿ B ^* ÿ C 'Pretax Income C ×=´Èv¶A@ ý¿ þ¿
C ·¤/ݼJ@ ý¿ þ¿
C CCJ@ ý¿ þ¿
ÿ C ^* ÿ
C ^* ÿ C ' Period + C ñ¿Ó¿ Ç¿h ñ¿Ó¿ ; + C ñ¿Ó¿ Ç¿h ñ¿Ó¿ ; + C ñ¿Ó¿ Ç¿h ñ¿Ó¿ ; ÿ C ^* ÿ D ' Federal Taxes ) D Z>W[A%@ ÿ¿ ÿ¿ N ; ) D C ë
0@ ÿ¿ ÿ¿ N ; ) D dg³ê/@ ÿ¿ ÿ¿ N ; ÿ D ^* ÿ
D ^* ÿ D 'Total Asset Turnover & D [1Æc@ Ò¿ ñ¿Ò¿ Ò¿ ; & D [1Æc@ Ò¿ ñ¿Ò¿ Ò¿ ; & D [1Æc@ Ò¿ ñ¿Ò¿ Ò¿ ; ÿ D ^* ÿ E ^* ÿ
E ^* ÿ E ^* ÿ F 'Net Income F .Éå?Ì8@ ý¿ þ¿
F ìù g·B@ ý¿ þ¿
F >)§èHbB@ ý¿ þ¿
ÿ F ^* ÿ
F ^* ÿ F 'Gross Margin & 2 F ½Ë6_à? ñ¿Ð¿ ñ¿Ú¿ñ¿Ð¿ ; & 2 F \I;V ä? ñ¿Ð¿ ñ¿Ú¿ñ¿Ð¿ ; & 2 F \I;V ä? ñ¿Ð¿ ñ¿Ú¿ñ¿Ð¿ ; ÿ F ^* ÿ G ^* ÿ
G ^* ÿ G 'Net Margin & 2 G 5ØlIFÆ? ñ¿Ï¿ ñÿ¿ñ¿Ï¿ ; & 2 G iw¼ÛÏÐ? ñ¿Ï¿ ñÿ¿ñ¿Ï¿ ; & 2 G /ºmQfÐ? ñ¿Ï¿ ñÿ¿ñ¿Ï¿ ; ÿ G ^* ÿ H \* ÿ H \* ÿ H \* ÿ H \* ÿ H \* ÿ H \* ÿ H ^* ÿ
H ^* ÿ H 'Return on Assets & 2 H ¿7'é? ο ñþ¿ ο ; & 2 H Ó×[÷Qó? ο ñþ¿ ο ; & 2 H ùY¶úò? ο ñþ¿ ο ; ÿ H ^* ÿ I ^* ÿ
I ^* ÿ I 'Return on Equity & 2 I ¿7'é? ã¿ ñý¿ ã¿ ; & 2 I Ó×[÷Qó? ã¿ ñý¿ ã¿ ; & 2 I ùY¶úò? ã¿ ñý¿ ã¿ ; ÿ I ^* ÿ J ^Statement Variables ÿ J ^* ÿ
J ^* ÿ J ^* ÿ K ^* ÿ
K ^* ÿ K 'Off. Comp./Sales & 2 K ~ Á}÷±? ñ¿Ë¿ ñ¿à¿ñ¿Ë¿ ; & 2 K ~ Á}÷±? ñ¿Ë¿ ñ¿à¿ñ¿Ë¿ ; & 2 K ~ Á}÷±? ñ¿Ë¿ ñ¿à¿ñ¿Ë¿ ; ÿ K ^* ÿ L 'Returns
2 L ©? ÿ L ^* ÿ
L ^* ÿ L ^* ÿ M 'State Tax
2 M ©? ÿ M ^* ÿ
M ^* ÿ M \* ÿ M \* ÿ M \* ÿ M \* ÿ M \* ÿ M \* ÿ M \* ÿ M ^* ÿ N 'Fed Tax
2 N 3333Ó? ÿ N ^* ÿ P \* ÿ P \* ÿ P \* ÿ P \* ÿ P \* ÿ P \* ÿ Q ^* ÿ R ^* ÿ S ^RANGE NAME TABLE ÿ S ^* ÿ T ^* ÿ U 'ASSET WORKSHEET U 'I9..L28 ÿ U ^* ÿ V 'BALANCE SHEET V 'O1..U48 ÿ V ^*
ÿ W 'D&B W 'W1..AG61 ÿ W ^* ÿ X 'FED TAX
X 'B79 ÿ X ^* ÿ Y 'INCOME STATEMNT Y 'F71..IV8192 ÿ Y ^* ÿ Z 'RATIO ANALY Z 'O53..U76 ÿ Z ^* ÿ [ 'RETURNS
[ 'B77 ÿ [ ^*
ÿ \ 'RMA \ 'AI1..AN51 ÿ \ ^* ÿ ] 'STATE TAX
] 'B78 ÿ ] ^* ÿ ^ 'STATEMENT VAR ^ 'A77..B79 ÿ ^ ^* _ ÿ _ ^* ÿ ` \* ÿ ` \* ÿ ` '***** a b c d e f g
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/