Category : Lotus and other Spreadsheets
Archive : BPD22.ZIP
Filename : BPDPROF.WK1
Output of file : BPDPROF.WK1 contained in archive : BPD22.ZIP
R R R
R R R R R R R R R R R R R R R R R R R R ! R " R # P $ P % P & b ' b ( b ) b * b + Þ , Þ - Þ . Þ / Þ 0 Þ 1 Þ 2 Þ 3 Þ 4 Þ 5 Þ 6 Þ 7 P 8 P 9 P : P ; P < P = P > P ? P @ P A P B P C 6 D 6 E 6 F 6 G Z H Z I Z J 6 6 K 6 L M N O P Q
R
S T / ÿ ÿ q H " + , 5 6 7 8 9 : ; < = > ? @ A B C D E G H J K L M P S T d G ASSET WORKSHEET , 4 G BALANCE SHEET , 5 Â G BEG CASH N N G CALCULATOR T W G CASH FLOW % E G CASH RESERVE J J G COMMRT M M G D&B 7 @ ; G FED TAX ( ` ( ` G FIRSTMONTH G FOURTHMONTH G FRTPCT L L G INCOME STATEMNT , R 5 G INIT INVESTMNT N N G INITIAL PRICE N N G MARK_UP K K G MONTHSHIP G NO OF SHARES N N G OUTSIDE INVEST N N G RATIO ANALYSIS , Å 5 Ý G RETURNS ( ^ ( ^ G RMA C I 3 G SECONDMONTH G STATE TAX ( _ ( _ G STATEMENT VAR ' ^ ( ` G STOCK ANALYS L S G THIRDMONTH G VARIABLES H O ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ 0 ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ # ÿÿ ÿÿ g ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ i ( ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ f ÿÿ ÿÿ ÿÿ ÿÿ $ ÿ% ò & ò ' ( (
L B ) '* ÿÿ ÿÿ ÿÿ ÿÿ - ·ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ qq ÿ ^Biz Plan Developer v2.2 ÿ '* ÿ+ ^* ÿ6 ^* B ^* ÿK ^* ÿT ^* ÿ ^Lotus 1-2-3 version ÿ '* ÿ+ ^* ÿ6 ^* B ^* ÿK ^* ÿT ^* ÿ '* ÿ+ ^* ÿ/ ^Asset Worksheet ÿ6 ^* ÿ: ^Dun & Bradstreet B ^*
ÿG ^RMA ÿK ^* ÿP ^STOCK ANALYSIS ÿT ^* $ ÿ ^Proforma Financial Statements ÿ '* ÿ+ ^* ÿ/ ^(000's) ÿ6 ^* ÿ: ^Industry Norms B ^* ÿK ^* ÿT ^* % ÿ ^Copyright 1993, David A. Works ÿ '* ÿ+ ^* ÿ- 'Fixed Assets ÿ6 ^* B ^*
G "Year 1
H "Year 2
I "Year 3 ÿK ^* ÿT ^* ÿ ^Please Read User's Guide! ÿ '* ÿ+ ^* ÿ6 ^* 9 "Year : '1 < "Year = '2 ? "Year @ '3 B ^*
ÿE ^ASSETS ÿK ^* P ¢ ð °¿3 P My Company ÿT ^* ÿ '* ÿ+ ^* ÿ- ' Equipment
0
ÿ6 ^* ÿ9 ^$ ÿ: ^% ÿ< ^$ ÿ= ^% ÿ? ^$ ÿ@ ^% B ^* ÿE ^Cash & Equivalents G ~E
0 ÿ6 ^* ÿ8 'CASH 9 PñÿÿÿÏ@ Ô¿= : ~E
0 ÿ6 ^* ÿ8 'ACCOUNTS RECEIVABLE 9 àîÿÿÿ a@ ÷¿ : taº1J%@ ÿ¿ ÿ¿
d < àÿÿÿÿ_@ õ¿ = -¦±
Ó@ ÿ¿ ÿ¿
d ? àÿÿÿÿ_@ ô¿ @ ¢H~ î@ ÿ¿ ÿ¿
d B ^* ÿE ^All Other Current G é¿é¿ d H é¿é¿ d I êê d ÿK ^* ÿT ^* ÿ+
^* ÿ-
' Machinery
0
ÿ6
^* ÿ8
'NOTES RECEIVABLE 9
÷¿ :
ÿ¿ ÿ¿ d <
õ¿ =
ÿ¿ ÿ¿ d ?
ô¿ @
ÿ¿ ÿ¿ d B
^* ÿE
^Total Current G
tEÎX@ é¿é¿ d H
Áï¡2¸äX@ é¿é¿ d I
ñ, ìX@ êê d ÿK
^*
ÿP
^Year 1
ÿQ
^Year 2
ÿR
^Year 3 ÿT
^* ^My Company ÿ+ ^* ! ÿ- ' Leashold improvements
0 ÿ6 ^* ÿ8 'INVENTORY 9 ÷¿ : ÿ¿ ÿ¿ d < õ¿ = ÿ¿ ÿ¿ d ? ô¿ @ ÿ¿ ÿ¿ d B ^* ÿE ^Fixed Assets (net) G é¿é¿ d H é¿é¿ d I êê d ÿK ^* ÿT ^* ÿ ^Cash Flow Projections ÿ+ ^* ÿ6 ^* ÿ8 'OTHER CURRENT 9 : ÿ¿ ÿ¿ d < = ÿ¿ ÿ¿ d ? @ ÿ¿ ÿ¿ d B ^* ÿE ^All Other Non-Current G é¿é¿ d H é¿é¿ d I êê d ÿK ^* ÿM 'Earnings @P D m$A à¿è @Q ü ðê%A à¿è @R ü ðê%A á¿è ÿT ^*
ÿ
^(000s) ÿ+
^* ÿ6
^* 9
:
<
=
?
@
B
^* ÿE
^Total
G
d
H
d
I
d ÿK
^* ÿT
^* ÿ+ ^* ÿ- 'Total Fixed Assets 1 $@ ÿ¿ø¿ÿ¿ÿ¿P ÿ6 ^* ÿ8 'TOTAL CURRENT 9 ,ïÿÿÿó@ ÷¿ : tEÎX@ ÿ¿ ÿ¿ d < Pïÿÿÿ?¢@ õ¿ = Áï¡2¸äX@ ÿ¿ ÿ¿ d ? èÿÿÿù¨@ ô¿ @ ñ, ìX@ ÿ¿ ÿ¿ d B ^* ÿE ^LIABILITIES G H I ÿK ^*
ÿM 'EPS P &$?ÆÜÅ@ þ¿N Q ò?5^º @ þ¿N R ò?5^º @ þ¿N ÿT ^* ÿ+ ^* ÿ6 ^* 9 : < = ? @ B ^* ÿE ^Notes-Payable-Short Term G é¿é¿² d H é¿é¿² d I êê² d ÿK ^* ÿT ^*
^YEAR 1
^YEAR 2
^YEAR 3 ÿ+ ^* - 'Intangible Assets . / 0 1 ÿ6 ^* ÿ8 'FIXED ASSETS 9 $@ ÷¿ : ¹ÿÅ»0Ýè? ÿ¿ ÿ¿ d < $@ õ¿ = @?^ÍGÛ? ÿ¿ ÿ¿ d ? $@ ô¿ @ :yíÓôÓ? ÿ¿ ÿ¿ d B ^* E ^Cur. Mat.-L/T/D F G é¿ é¿± d H é¿ é¿± d I ê ê± d ÿK ^* M 'Outside Investors
2N 3333Ó? O P Q R S ÿT ^*
ÿ ^Jan
ÿ ^Feb
ÿ ^Mar
ÿ ^Apr
ÿ ^May
ÿ ^Jun
ÿ ^Jul
ÿ ^Aug
ÿ
^Sep
ÿ ^Oct
ÿ ^Nov
ÿ
^Dec
ÿ ^Jan
ÿ ^Feb
ÿ ^Mar
ÿ ^Apr
ÿ ^May
ÿ ^Jun
ÿ ^Jul
ÿ ^Aug
ÿ ^Sep
ÿ ^Oct
ÿ ^Nov
ÿ ^Dec
ÿ ^Jan
ÿ ^Feb
ÿ ^Mar
ÿ ^Apr
ÿ ^May
ÿ ^Jun
ÿ ^Jul
ÿ! ^Aug
ÿ" ^Sep
ÿ# ^Oct
ÿ$ ^Nov
ÿ% ^Dec ÿ+ ^* ÿ- ' Goodwill
1 ÿ6 ^* 8 'OTHER NON-CURRENT 9 ÷¿ : ÿ¿ ÿ¿ d ; < õ¿ = ÿ¿ ÿ¿ d > ? ô¿ @ ÿ¿ ÿ¿ d B ^* E ^Trade Payables F G é¿é¿° d H é¿é¿° d I êê° d ÿK ^* M N O P Q R S ÿT ^* ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ
\- ÿ \- ÿ \- ÿ
\- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ! \- ÿ" \- ÿ# \- ÿ$ \- ÿ% \- ÿ+ ^* ÿ- ' Other
1 ÿ6 ^* 8 9 : ; < = > ? @ B ^* ÿE ^Income Taxes-Payable
G
H
I ÿK ^* ÿM 'Initial Investment @N ´âÿÿÿKÝ@ N N @P 5öÿÿåA ü¿N @Q Gõÿÿ M
A ü¿N @R Gõÿÿ M
A ü¿N ÿT ^*
ÿ 'Sales:
! " # $ % ÿ+ ^* ÿ. "Total 1 þ¿ ÿ¿P ÿ6 ^* ÿ8 'TOTAL ASSETS 9 ,ïÿÿÿ@ ÷¿
: d < PïÿÿÿS¢@ õ¿
= d ? èÿÿÿ
©@ ô¿
@ d B ^* ÿE ^All Other Current
G
H
I ÿK ^* ÿM ' Initial Price
N ÿT ^* " ÿ ' 1st Product or Service
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
d
! d
" d
# d
$ d
% d & ' ( ) * ÿ+ ^* ÿ6 ^* 7 9 : < = ? @ A B ^* C D ÿE ^Total Current G é¿é¿ d H é¿é¿ d I êê d ÿK ^* L ÿT ^* " ÿ ' 2nd Product or Service
!
"
#
$
% & ' ( ) * ÿ+ ^* ÿ, \* ÿ- \* ÿ. \* ÿ/ \* ÿ0 \* ÿ1 \* ÿ2 \* ÿ3 \* ÿ4 \* ÿ5 \* ÿ6 ^* 7 ÿ8 'ACCOUNTS PAYABLE 9 ÷¿ : ÿ¿ 9 d < õ¿ = ÿ¿ < d ? ô¿ @ ÿ¿ ? d A B ^* C D ÿE ^Long Term Debt
G
H
I ÿK ^* L ÿM 'Value of Investment N ´âÿÿÿKÝ@ N N @P ·ÔÿÿÏA à¿©N è @Q ÷Öÿÿoz%A à¿©N è @R 3Çÿÿg\-A á¿©N è ÿT ^*
! " # $ % ÿ+ ^* ÿ6 ^* ÿ8 'BANK LOANS 9 ÷¿ : ÿ¿ 9 d < õ¿ = ÿ¿ < d ? ô¿ @ ÿ¿ ? d B ^* ÿE ^Deferred Taxes
G
H
I ÿK ^* ÿT ^* ÿ 'Total Sales Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P
Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P
Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P Y@ ý¿ þ¿P ! Y@ ý¿ þ¿P " Y@ ý¿ þ¿P # Y@ ý¿ þ¿P $ Y@ ý¿ þ¿P % Y@ ý¿ þ¿P ÿ+ ^* ÿ6 ^* ÿ8 'NOTES PAYABLE 9 ÷¿ : ÿ¿ 9 d < õ¿ = ÿ¿ < d ? ô¿ @ ÿ¿ ? d B ^* ÿE ^All Other Non-Current G é¿é¿ª d H é¿é¿ª d I êêª d ÿK ^* ÿL \* ÿM \* ÿN \* ÿO \* ÿP \* ÿQ \* ÿR \* ÿS \* ÿT ^*
! " # $ % ÿ+ ^* ÿ6 ^* ÿ8 'OTHER CURRENT 9 ÷¿ : ÿ¿ 9 d < õ¿ = ÿ¿ < d ? ô¿ @ ÿ¿ ? d B ^* $ ÿE ^Total Liabilities & Net Worth
G d
H d
I d ÿK ^* ÿ 'Cash Receipts: ÿ+ ^* ÿ6 ^* 9 : < = ? @ B ^* ÿE ^INCOME DATA G H I ÿK ^* ÿ ' Month of Shipment
° ¹? ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿
ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿
ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ìÿÿÿÿ#@ ý¿ ! ìÿÿÿÿ#@ ý¿ " ìÿÿÿÿ#@ ý¿ # ìÿÿÿÿ#@ ý¿ $ ìÿÿÿÿ#@ ý¿ % ìÿÿÿÿ#@ ý¿ & ý¿ ' ý¿ ( ý¿ ) ý¿ ÿ+ ^* ÿ6 ^* ÿ8 'TOTAL CURRENT 9 ÷¿ : ÿ¿ 9 d < õ¿ = ÿ¿ < d ? ô¿ @ ÿ¿ ? d B ^* ÿE ^Net Sales
G d
H d
I d ÿK ^* ÿ ' First Month
° 3333ã?
âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿
âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿
âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ âÿÿÿÿM@ ÿ¿ü¿ ! âÿÿÿÿM@ ÿ¿ü¿ " âÿÿÿÿM@ ÿ¿ü¿ # âÿÿÿÿM@ ÿ¿ü¿ $ âÿÿÿÿM@ ÿ¿ü¿ % âÿÿÿÿM@ ÿ¿ü¿ & âÿÿÿÿM@ ÿ¿ü¿ ' ÿ¿ü¿ ( ÿ¿ü¿ ) ÿ¿ü¿ ÿ+ ^* ÿ6 ^* 9 : < = ? @ B ^* ÿE ^Gross Profit G xW@ é¿Oé¿E d H Y@ é¿Oé¿E d I Y@ êOêE d ÿK ^* ÿ ' Second Month
° É?
ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿
ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿
ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ìÿÿÿÿ3@ þ¿û¿ ! ìÿÿÿÿ3@ þ¿û¿ " ìÿÿÿÿ3@ þ¿û¿ # ìÿÿÿÿ3@ þ¿û¿ $ ìÿÿÿÿ3@ þ¿û¿ % ìÿÿÿÿ3@ þ¿û¿ & ìÿÿÿÿ3@ þ¿û¿ ' ìÿÿÿÿ3@ þ¿û¿ ( þ¿û¿ ) þ¿û¿ ÿ+ ^* ÿ6 ^* ÿ8 'OTHER LONG TERM 9 ÷¿ : ÿ¿ 9 d < õ¿ = ÿ¿ < d ? ô¿ @ ÿ¿ ? d B ^* ÿE ^Operating Expenses G ìÿÿÿÿ#@ é¿lé¿D d H ìÿÿÿÿ#@ é¿lé¿D d I ìÿÿÿÿ#@ êlêD d ÿK ^* ÿ ' Third Month
° ®Gáz´?
àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿
àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿
àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ àÿÿÿÿ @ ý¿ú¿ ! àÿÿÿÿ @ ý¿ú¿ " àÿÿÿÿ @ ý¿ú¿ # àÿÿÿÿ @ ý¿ú¿ $ àÿÿÿÿ @ ý¿ú¿ % àÿÿÿÿ @ ý¿ú¿ & àÿÿÿÿ @ ý¿ú¿ ' àÿÿÿÿ @ ý¿ú¿ ( àÿÿÿÿ @ ý¿ú¿ ) ý¿ú¿ ÿ+ ^* ÿ6 ^* 8 'DEFERRED CREDITS 9 : ; < = > ? @ B ^* ÿE ^Operating Profit G øT@ é¿mé¿C d H V@ é¿mé¿C d I V@ êmêC d ÿK ^* ÿ ' Fourth Month
° ®Gáz?
àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿
àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿
àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ àÿÿÿÿï? ü¿ù¿ ! àÿÿÿÿï? ü¿ù¿ " àÿÿÿÿï? ü¿ù¿ # àÿÿÿÿï? ü¿ù¿ $ àÿÿÿÿï? ü¿ù¿ % àÿÿÿÿï? ü¿ù¿ & àÿÿÿÿï? ü¿ù¿ ' àÿÿÿÿï? ü¿ù¿ ( àÿÿÿÿï? ü¿ù¿ ) àÿÿÿÿï? ü¿ù¿ ÿ+ ^* ÿ6 ^* 8 'NET WORTH 9 ,ïÿÿÿ@ ÷¿ : Y@ ÿ¿ 9 d ; < PïÿÿÿS¢@ õ¿ = Y@ ÿ¿ < d > ? èÿÿÿ
©@ ô¿ @ Y@ ÿ¿ ? d B ^* ÿE ^All Other Expenses (net)
G
H
I ÿK ^* ÿ+ ^* ÿ6 ^* 8 9 : ; < = > ? @ B ^* ÿE ^Profit Before Taxes G ëS@ é¿né¿A d H `U@ é¿né¿A d I `U@ ênêA d ÿK ^* ÿ 'Total Receipts ìÿÿÿÿ#@ ú¿ þ¿P îÿÿÿQ@ ú¿ þ¿P éÿÿÿV@ ú¿ þ¿P çÿÿÿX@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P
@çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P
@çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P @çÿÿÿ¿X@ ú¿ þ¿P ! @çÿÿÿ¿X@ ú¿ þ¿P " @çÿÿÿ¿X@ ú¿ þ¿P # @çÿÿÿ¿X@ ú¿ þ¿P $ @çÿÿÿ¿X@ ú¿ þ¿P % @çÿÿÿ¿X@ ú¿ þ¿P & ' ( ) * ÿ+ ^* , - . / 0 1 2 3 4 5 ÿ6 ^* 7 8 'TOTAL LIAB&NET WORTH 9 ,ïÿÿÿ@ ÷¿¡
: d ; < PïÿÿÿS¢@ õ¿¡
= d > ? èÿÿÿ
©@ ô¿¡
@ d A B ^*
ÿE ^RATIOS G H I ÿK ^* ! ! ! ! ! ! ! !
! ! !
! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! " ! # ! $ ! % ! & ! ' ! ( ! ) ! * ! ÿ+ ! ^* , ! - ! . ! / ! 0 ! 1 ! 2 ! 3 ! 4 ! 5 ! ÿ6 ! ^* 7 ! 8 ! 9 ! : ! ; ! < ! = ! > ! ? ! @ ! A ! B ! ^* ÿE ! ^Current G ! ðÿ 鿪 H ! ðÿ 鿪 I ! ðÿ êª ÿK ! ^* ÿ " 'Cash Disbursements: " " " " " " " "
" " "
" " " " " " " " " " " " " " " " " " " " ! " " " # " $ " % " & " ' " ( " ) " * " ÿ+ " ^* , " - " . " / " 0 " 1 " 2 " 3 " 4 " 5 " ÿ6 " ^* 7 " 8 " 'NET SALES 9 " À@ ÷¿>
: " d ; " < " À@ õ¿>
= " d > " ? " À@ ô¿>
@ " d A " B " ^* ÿE " ^Quick G " ðÿ 鿪 H " ðÿ 鿪 I " ðÿ êª ÿK " ^* ÿ # ' Rent
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
! #
" #
# #
$ #
% # & # ' # ( # ) # * # ÿ+ # ^* , # - # . # / # 0 # 1 # 2 # 3 # 4 # 5 # ÿ6 # ^* 7 # 8 # 'GROSS PROFIT 9 # @ ÷¿G : # xW@ ÿ¿ 9 " d ; # < # À@ õ¿G = # Y@ ÿ¿ < " d > # ? # À@ ô¿G @ # Y@ ÿ¿ ? " d A # B # ^* ÿE # ^Sales/Receivables & G # Z°é«!@ é¿z é¿=é¿z ; & H # À À"@ é¿z é¿=é¿z ; & I # À À"@ êz ê=êz ; ÿK # ^* ÿ $ ' Utilities
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
! $
" $
# $
$ $
% $ & $ ' $ ( $ ) $ * $ ÿ+ $ ^* , $ - $ . $ / $ 0 $ 1 $ 2 $ 3 $ 4 $ 5 $ ÿ6 $ ^* 7 $ 8 $ 'NET PROFIT AFTER TAX 9 $ =Tázê@ ÷¿l : $ ü×£pãK@ ÿ¿ 9 " d ; $ < $ å¦q@ õ¿l = $ ÞÌÌÌìM@ ÿ¿ < " d > $ ? $ å¦q@ ô¿l @ $ ÞÌÌÌìM@ ÿ¿ ? " d A $ B $ ^* ÿE $ ^Cost of Sales/Inventory - G $ ðÿ é¿C é¿Né¿D é¿C ; - H $ ðÿ é¿C é¿Né¿D é¿C ; - I $ ðÿ êC êNêD êC ; ÿK $ ^* ÿ % ' Telephone
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
%
! %
" %
# %
$ %
% % & % ' % ( % ) % * % ÿ+ % ^* , % - % . % / % 0 % 1 % 2 % 3 % 4 % 5 % ÿ6 % ^* 7 % 8 % 'WORKING CAPITAL 9 % ,ïÿÿÿó@ ÷¿|÷¿
: % ^NA ; % < % Pïÿÿÿ?¢@ õ¿|õ¿
= % ^NA > % ? % èÿÿÿù¨@ ô¿|ô¿
@ % ^NA A % B % ^* ÿE % ^Cost of Sales/Payables - G % ðÿ é¿ é¿Mé¿C é¿ ; - H % ðÿ é¿ é¿Mé¿C é¿ ; - I % ðÿ ê êMêC ê ; ÿK % ^* ÿ & ' Salaries
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
&
! &
" &
# &
$ &
% & & & ' & ( & ) & * & ÿ+ & ^* , & - & . & / & 0 & 1 & 2 & 3 & 4 & 5 & ÿ6 & ^* 7 & = & ? & A & B & ^* ÿE & ^Sales/Working Capital 4 G & KÓ
î?% é¿{é¿
é¿:é¿{é¿
; 4 H & 8pà?% é¿{é¿
é¿:é¿{é¿
; 4 I & :ñÃØ?% ê{ê
ê:ê{ê
; ÿK & ^* ÿ ' ' Payroll
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
'
! '
" '
# '
$ '
% ' & ' ' ' ( ' ) ' * ' ÿ+ ' ^* , ' - ' . ' / ' 0 ' 1 ' 2 ' 3 ' 4 ' 5 ' ÿ6 ' ^* 7 '
ÿ8 ' 'RATIOS ? ' A ' B ' ^* ÿE ' ^EBIT/Interest
G '
H '
I ' ÿK ' ^* ÿ ( ' Withholding
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
! (
" (
# (
$ (
% ( & ( ' ( ( ( ) ( * ( ÿ+ ( ^* , ( - ( . ( / ( 0 ( 1 ( 2 ( 3 ( 4 ( 5 ( ÿ6 ( ^* 7 ( 8 ( 9 ( : ( ; ( < ( = ( > ( ? ( @ ( A ( B ( ^* ÿE ( ^Net Profit + Depr.,Dep., G ( H ( I ( ÿK ( ^* ÿ ) ' Inventory ) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
) î¿ K
! ) î¿ K
" ) î¿ K
# ) î¿ K
$ ) î¿ K
% ) î¿ K
ÿ+ ) ^* ÿ6 ) ^* 8 ) ' SOLVENCY 9 ) : ) ; ) < ) = ) > ) ? ) @ ) B ) ^* ÿE ) ^Amort./Cur. Mat. L/T/D
G )
H )
I ) ÿK ) ^* ÿ * ' Freight-In * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L
* ÿ¿ L * ÿ¿ L * ÿ¿ L
* ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L * ÿ¿ L ! * ÿ¿ L " * ÿ¿ L # * ÿ¿ L $ * ÿ¿ L % * ÿ¿ L ÿ+ * ^* ÿ6 * ^* 8 * 'QUICK RATIO (TIMES) 9 * ðÿ ÷¿¢ ; * < * ðÿ õ¢ = * ? * ðÿ ô¢ @ * B * ^* ÿE * ^Fixed/Worth & G * |£0qÓ? é¿ é¿|é¿ ; & H * fz¸'¢uq? é¿ é¿|é¿ ; & I * Å4:Ki? ê ê|ê ; ÿK * ^* ÿ + ' Office Expense
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
! +
" +
# +
$ +
% + & + ' + ( + ) + * + ÿ+ + ^* , + - + . + / + 0 + 1 + 2 + 3 + 4 + 5 + ÿ6 + ^* 7 + 8 + 'CURRENT RATIO (TIMES) 9 + ðÿ ÷¿ ; + < + ðÿ õ = + ? + ðÿ ô @ + A + B + ^* ÿE + ^Debt/Worth & G + é¿ é¿é¿ ; & H + é¿ é¿é¿ ; & I + ê êê ; ÿK + ^* ÿ , ' Vehicle Expense
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
! ,
" ,
# ,
$ ,
% , & , ' , ( , ) , * , ÿ+ , ^* , , - , . , / , 0 , 1 , 2 , 3 , 4 , 5 , ÿ6 , ^* 7 , 8 , 'CURR LIAB TO NW (%) & 29 , ÷¿ ÷¿÷¿ ; ; , & 2< , õ õõ ; = , & 2? , ô ôô ; @ , A , B , ^* ÿE , ^% Profit Before Taxes/ G , H , I , ÿK , ^* ÿ - ' Office Supplies
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
! -
" -
# -
$ -
% - & - ' - ( - ) - * - ÿ+ - ^* , - - - . - / - 0 - 1 - 2 - 3 - 4 - 5 - ÿ6 - ^* 7 - ÿ8 - 'CURR LIAB TO INV (%) & 29 - ðÿ ÷¿r ÷¿ ÷¿r ; & 2< - ðÿ õr õ õr ; & 2? - ðÿ ôr ô ôr ; A - B - ^* ÿE - ^Tangible Net Worth & 2G - _TÆc<Æç? é¿ é¿`é¿ ; & 2H - hÂaýÛ? é¿ é¿`é¿ ; & 2I - sÞÑd§yÔ? ê ê`ê ; ÿK - ^* ÿ . ' Postage
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
! .
" .
# .
$ .
% . & . ' . ( . ) . * . ÿ+ . ^* , . - . . . / . 0 . 1 . 2 . 3 . 4 . 5 . ÿ6 . ^* 7 . 8 . 'TOTAL LIAB TO NW (%) & 29 . ÷¿ ÷¿÷¿ ; ; . & 2< . õ õõ ; = . & 2? . ô ôô ; @ . A . B . ^* ÿE . ^% Profit Before Taxes/ G . H . I . ÿK . ^* ÿ / ' Advertising
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
/
! /
" /
# /
$ /
% / & / ' / ( / ) / * / ÿ+ / ^* , / - / . / / / 0 / 1 / 2 / 3 / 4 / 5 / ÿ6 / ^* 7 / 8 / 'FIXED ASSETS TO NW (%) & 29 / |£0qÓ? ÷¿ ÷¿w÷¿ ; ; / & 2< / fz¸'¢uq? õ õwõ ; = / & 2? / Å4:Ki? ô ôwô ; @ / A / B / ^* ÿE / ^Total Assets & 2G / _TÆc<Æç? é¿z é¿^é¿z ; & 2H / hÂaýÛ? é¿z é¿^é¿z ; & 2I / sÞÑd§yÔ? êz ê^êz ; ÿK / ^* ÿ 0 ' Professionals
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
! 0
" 0
# 0
$ 0
% 0 ÿ+ 0 ^* ÿ6 0 ^* 8 0 9 0 : 0 ; 0 < 0 = 0 > 0 ? 0 @ 0 B 0 ^* ÿE 0 ^Sales/Net Fixed Assets & G 0 ðÿ é¿n é¿0é¿n ; & H 0 ðÿ é¿n é¿0é¿n ; & I 0 ðÿ ên ê0ên ; ÿK 0 ^* ÿ 1 ' Commissions 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M
1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M
1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M 1 ìÿÿÿÿ#@ æ¿ M ! 1 ìÿÿÿÿ#@ æ¿ M " 1 ìÿÿÿÿ#@ æ¿ M # 1 ìÿÿÿÿ#@ æ¿ M $ 1 ìÿÿÿÿ#@ æ¿ M % 1 ìÿÿÿÿ#@ æ¿ M & 1 ' 1 ( 1 ) 1 * 1 ÿ+ 1 ^* , 1 - 1 . 1 / 1 0 1 1 1 2 1 3 1 4 1 5 1 ÿ6 1 ^* 7 1 ÿ8 1 ' EFFICIENCY ? 1 A 1 B 1 ^* ÿE 1 ^Sales/Total Assets & G 1 Díz:Öí? é¿x é¿/é¿x ; & H 1 Àò<H^à? é¿x é¿/é¿x ; & I 1 x¶Þò×? êx ê/êx ; ÿK 1 ^* ÿ 2 ' Insurance
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
! 2
" 2
# 2
$ 2
% 2 & 2 ' 2 ( 2 ) 2 * 2 ÿ+ 2 ^* , 2 - 2 . 2 / 2 0 2 1 2 2 2 3 2 4 2 5 2 ÿ6 2 ^* 7 2 ÿ8 2 'COLL PERIOD (DAYS) + 9 2 ÉÝÝÝÕD@ ÷¿. ÷¿k÷¿. m ; + < 2 dwwwwC@ õ. õkõ. m ; + ? 2 dwwwwC@ ô. ôkô. m ; A 2 B 2 ^* ! ÿE 2 ^% Depr., Dep., Amort/Sales
2G 2
2H 2
2I 2 ÿK 2 ^* " ÿ 3 ' Travel & Entertainment
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
! 3
" 3
# 3
$ 3
% 3 & 3 ' 3 ( 3 ) 3 * 3 ÿ+ 3 ^* , 3 - 3 . 3 / 3 0 3 1 3 2 3 3 3 4 3 5 3 ÿ6 3 ^* 7 3 8 3 'SALES TO INV (TIMES) & 9 3 ðÿ ÷¿l ÷¿-÷¿l ; ; 3 & < 3 ðÿ õl õ-õl ; = 3 & ? 3 ðÿ ôl ô-ôl ; @ 3 A 3 B 3 ^* ÿE 3 ^% Officer's Comp./Sales & 2G 3 é¿- é¿Bé¿- ; & 2H 3 é¿- é¿Bé¿- ; & 2I 3 ê- êBê- ; ÿK 3 ^* ÿ 4 ' Research
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
! 4
" 4
# 4
$ 4
% 4 ÿ+ 4 ^* ÿ6 4 ^* 8 4 'ASSETS TO SALES (%) & 29 4 ÍMÂõ(ñ? ÷¿, ÷¿u÷¿, ; ; 4 & 2< 4 ÍÄz®Gÿ? õ, õuõ, ; = 4 & 2? 4 æf®Ga@ ô, ôuô, ; @ 4 B 4 ^* G 4 H 4 I 4 ÿK 4 ^* ÿ 5 ' Miscellaneous
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
! 5
" 5
# 5
$ 5
% 5 ÿ+ 5 ^* ÿ6 5 ^* 8 5 'SALES TO NWC (TIMES) & 9 5 KÓ
î? ð¿ ÷¿+ ð¿ ; ; 5 & < 5 ðÿ þð¿ õ+þð¿ ; = 5 & ? 5 8pà? ýð¿ ô+ýð¿ ; @ 5 B 5 ^* 0 ÿC 5 'RMA is copyright Robert Morris Associates ÿK 5 ^* ÿ 6 ' State Taxes & 6 ' 6 ( 6 ) 6 * 6 ÿ+ 6 ^* , 6 - 6 . 6 / 6 0 6 1 6 2 6 3 6 4 6 5 6 ÿ6 6 ^* 7 6 8 6 'ACCTS PAY TO SALES (%) & 29 6 ÷¿* ÷¿w÷¿* ; ; 6 & 2< 6 õ* õwõ* ; = 6 & 2? 6 ô* ôwô* ; @ 6 A 6 B 6 ^* ÿC 6 \* ÿD 6 \* ÿE 6 \* ÿF 6 \* ÿG 6 \* ÿH 6 \* ÿI 6 \* ÿJ 6 \* ÿK 6 ^* ÿ 7 ' Federal Taxes & 7 ' 7 ( 7 ) 7 * 7 ÿ+ 7 ^* , 7 - 7 . 7 / 7 0 7 1 7 2 7 3 7 4 7 5 7 ÿ6 7 ^* 7 7 8 7 9 7 : 7 ; 7 < 7 = 7 > 7 ? 7 @ 7 A 7 B 7 ^* 8 8 8 8 8 8 8 8
8 8 8
8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 ! 8 " 8 # 8 $ 8 % 8 & 8 ' 8 ( 8 ) 8 * 8 ÿ+ 8 ^* , 8 - 8 . 8 / 8 0 8 1 8 2 8 3 8 4 8 5 8 ÿ6 8 ^* 7 8 8 8 ' PROFITABILITY 9 8 : 8 ; 8 < 8 = 8 > 8 ? 8 @ 8 A 8 B 8 ^* ÿ 9 'Total Disbursements 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P
9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P
9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P 9 ìÿÿÿÿ#@ ê¿ þ¿P ! 9 ìÿÿÿÿ#@ ê¿ þ¿P " 9 ìÿÿÿÿ#@ ê¿ þ¿P # 9 ìÿÿÿÿ#@ ê¿ þ¿P $ 9 ìÿÿÿÿ#@ ê¿ þ¿P % 9 ìÿÿÿÿ#@ ê¿ þ¿P & 9 ' 9 ( 9 ) 9 * 9 ÿ+ 9 ^* , 9 - 9 . 9 / 9 0 9 1 9 2 9 3 9 4 9 5 9 ÿ6 9 ^* 7 9 8 9 'RETURN ON SALES (%) & 29 9 nmÙ=Ùá? ÷¿' ÷¿W÷¿' ; ; 9 & 2< 9 L Õxé&ã? õ' õWõ' ; = 9 & 2? 9 L Õxé&ã? ô' ôWô' ; @ 9 A 9 B 9 ^* ÿ : 'Net Cash From : : : : : : : :
: : :
: : : : : : : : : : : : : : : : : : : : ! : " : # : $ : % : & : ' : ( : ) : * : ÿ+ : ^* , : - : . : / : 0 : 1 : 2 : 3 : 4 : 5 : ÿ6 : ^* 7 : 8 : 'RETURN ON ASSETS (%) & 29 : ËÛ
y]¤à? ÷¿o ÷¿V÷¿o ; ; : & 2< : ªÚIÄÓ? õo õVõo ; = : & 2? : YÀPªÌ? ôo ôVôo ; @ : A : B : ^* G : H : I : ÿ ; ' Operations ; å¿ þ¿
; âÿÿÿÿM@ å¿ þ¿
; ìÿÿÿÿS@ å¿ þ¿
; êÿÿÿÿU@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
; Àéÿÿÿ?V@ å¿ þ¿
! ; Àéÿÿÿ?V@ å¿ þ¿
" ; Àéÿÿÿ?V@ å¿ þ¿
# ; ìÿÿÿÿ3@ è¿ þ¿P $ ; ìÿÿÿÿ3@ è¿ þ¿P % ; ìÿÿÿÿ3@ è¿ þ¿P & ; ' ; ( ; ) ; * ; ÿ+ ; ^* , ; - ; . ; / ; 0 ; 1 ; 2 ; 3 ; 4 ; 5 ; ÿ6 ; ^* 7 ; 8 ; 'RETURN ON NW (%) & 29 ; ËÛ
y]¤à? ÷¿ ÷¿U÷¿ ; ; ; & 2< ; ªÚIÄÓ? õ õUõ ; = ; & 2? ; YÀPªÌ? ô ôUô ; @ ; A ; B ; ^* G ; H ; I ; < < < < < < < <
< < <
< < < < < < < < < < < < < < < < < < < < ! < " < # < $ < % < & < ' < ( < ) < * < ÿ+ < ^* , < - < . < / < 0 < 1 < 2 < 3 < 4 < 5 < ÿ6 < ^* 7 < 8 < 9 < : < ; < < < = < > < ? < @ < A < B < ^* G < H < I < ÿ = 'Beginning Cash = i@ ÿ¿ = i@ ÿ¿ = @üÿÿÿ?p@ ÿ¿ = @÷ÿÿÿ?u@ ÿ¿ = Àñÿÿÿ¿z@ ÿ¿ = öÿÿÿ'@ ÿ¿ = Póÿÿÿï@ ÿ¿ = ðÿÿÿ· @ ÿ¿
= Àíÿÿÿ@ ÿ¿ = øêÿÿÿG@ ÿ¿ = 0èÿÿÿ@ ÿ¿
= ´òÿÿÿk@ ÿ¿ = PñÿÿÿÏ@ ÿ¿ = ìïÿÿÿ3@ ÿ¿ = îÿÿÿ@ ÿ¿ = $íÿÿÿû@ ÿ¿ = Àëÿÿÿ_@ ÿ¿ = \êÿÿÿÃ@ ÿ¿ = øèÿÿÿ'@ ÿ¿ = çÿÿÿ@ ÿ¿ = 0æÿÿÿï@ ÿ¿ = ÌäÿÿÿS@ ÿ¿ = hãÿÿÿ·@ ÿ¿ = ñÿÿÿ @ ÿ¿ = Pðÿÿÿ?¡@ ÿ¿ = ïÿÿÿñ¡@ ÿ¿ = ìîÿÿÿ£¢@ ÿ¿ = :îÿÿÿU£@ ÿ¿ = íÿÿÿ¤@ ÿ¿ = Öìÿÿÿ¹¤@ ÿ¿ = $ìÿÿÿk¥@ ÿ¿ ! = rëÿÿÿ ¦@ ÿ¿ " = ÀêÿÿÿϦ@ ÿ¿ # = êÿÿÿ§@ ÿ¿ $ = æéÿÿÿ©§@ ÿ¿ % = ¾éÿÿÿѧ@ ÿ¿ & = ' = ( = ) = * = ÿ+ = ^* , = - = . = / = 0 = 1 = 2 = 3 = 4 = 5 = ÿ6 = ^* 7 = \* 8 = \* 9 = \* : = \* ; = \* < = \* = = \* > = \* ? = \* @ = \* A = \* B = ^* G = H = I = > > > > > > > >
> > >
> > > > > > > > > > > > > > > > > > > > ! > " > # > $ > % > & > ' > ( > ) > * > ÿ+ > ^* , > - > . > / > 0 > 1 > 2 > 3 > 4 > 5 > ÿ6 > ^* 7 > A > B > G > H > I > ÿ ? 'Cash on Hand ? i@ ü¿ þ¿ ? @üÿÿÿ?p@ ü¿ þ¿ ? @÷ÿÿÿ?u@ ü¿ þ¿ ? Àñÿÿÿ¿z@ ü¿ þ¿ ? öÿÿÿ'@ ü¿ þ¿ ? Póÿÿÿï@ ü¿ þ¿ ? ðÿÿÿ· @ ü¿ þ¿ ? Àíÿÿÿ@ ü¿ þ¿
? øêÿÿÿG@ ü¿ þ¿ ? 0èÿÿÿ@ ü¿ þ¿ ? ´òÿÿÿk@ ü¿ þ¿
? PñÿÿÿÏ@ ü¿ þ¿ ? ìïÿÿÿ3@ ü¿ þ¿ ? îÿÿÿ@ ü¿ þ¿ ? $íÿÿÿû@ ü¿ þ¿ ? Àëÿÿÿ_@ ü¿ þ¿ ? \êÿÿÿÃ@ ü¿ þ¿ ? øèÿÿÿ'@ ü¿ þ¿ ? çÿÿÿ@ ü¿ þ¿ ? 0æÿÿÿï@ ü¿ þ¿ ? ÌäÿÿÿS@ ü¿ þ¿ ? hãÿÿÿ·@ ü¿ þ¿ ? ñÿÿÿ @ ü¿ þ¿ ? Pðÿÿÿ?¡@ ü¿ þ¿ ? ïÿÿÿñ¡@ ü¿ þ¿ ? ìîÿÿÿ£¢@ ü¿ þ¿ ? :îÿÿÿU£@ ü¿ þ¿ ? íÿÿÿ¤@ ü¿ þ¿ ? Öìÿÿÿ¹¤@ ü¿ þ¿ ? $ìÿÿÿk¥@ ü¿ þ¿ ? rëÿÿÿ ¦@ ü¿ þ¿ ! ? ÀêÿÿÿϦ@ ü¿ þ¿ " ? êÿÿÿ§@ ü¿ þ¿ # ? æéÿÿÿ©§@ ü¿ þ¿ $ ? ¾éÿÿÿѧ@ ü¿ þ¿ % ? éÿÿÿù§@ ü¿ þ¿ & ? ' ? ( ? ) ? * ? ÿ+ ? ^* , ? - ? . ? / ? 0 ? 1 ? 2 ? 3 ? 4 ? 5 ? ÿ6 ? ^* 7 ? A ? B ? G ? H ? I ? @ @ @ @ @ @ @ @
@ @ @
@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ ! @ " @ # @ $ @ % @ & @ ' @ ( @ ) @ * @ ÿ+ @ ^* , @ - @ . @ / @ 0 @ 1 @ 2 @ 3 @ 4 @ 5 @ ÿ6 @ ^* B @ G @ H @ I @ ÿ A 'Bank Loan Required * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; *
A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; *
A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * A þ¿ J J þ¿
; * ! A þ¿ J J þ¿
; * " A þ¿ J J þ¿
; * # A þ¿ J J þ¿
; * $ A þ¿ J J þ¿
; * % A þ¿ J J þ¿
; & A ' A ( A ) A * A ÿ+ A ^* , A - A . A / A 0 A 1 A 2 A 3 A 4 A 5 A ÿ6 A ^* 7 A 8 A 9 A : A ; A < A = A > A ? A @ A A A B A G A H A I A B B B B B B B B
B B B
B B B B B B B B B B B B B B B B B B B B ! B " B # B $ B % B & B ' B ( B ) B * B ÿ+ B ^* , B - B . B / B 0 B 1 B 2 B 3 B 4 B 5 B ÿ6 B ^* 7 B 8 B 9 B : B ; B < B = B > B ? B @ B A B B B G B H B I B ÿ C 'Loan Repayment
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
! C
" C
# C
$ C
% C & C ' C ( C ) C * C ÿ+ C ^* , C - C . C / C 0 C 1 C 2 C 3 C 4 C 5 C ÿ6 C ^* 7 C 8 C 9 C : C ; C < C = C > C ? C @ C A C B C G C H C I C D D D D D D D D
D D D
D D D D D D D D D D D D D D D D D D D D ! D " D # D $ D % D & D ' D ( D ) D * D ÿ+ D ^* , D - D . D / D 0 D 1 D 2 D 3 D 4 D 5 D ÿ6 D ^* 7 D 8 D 9 D : D ; D < D = D > D ? D @ D A D B D G D H D I D ÿ E 'Ending Cash " E i@ ú¿ ü¿ þ¿
" E @üÿÿÿ?p@ ú¿ ü¿ þ¿
" E @÷ÿÿÿ?u@ ú¿ ü¿ þ¿
" E Àñÿÿÿ¿z@ ú¿ ü¿ þ¿
" E öÿÿÿ'@ ú¿ ü¿ þ¿
" E Póÿÿÿï@ ú¿ ü¿ þ¿
" E ðÿÿÿ· @ ú¿ ü¿ þ¿
" E Àíÿÿÿ@ ú¿ ü¿ þ¿
"
E øêÿÿÿG@ ú¿ ü¿ þ¿
" E 0èÿÿÿ@ ú¿ ü¿ þ¿
" E ´òÿÿÿk@ ú¿ ü¿ þ¿
"
E PñÿÿÿÏ@ ú¿ ü¿ þ¿
" E ìïÿÿÿ3@ ú¿ ü¿ þ¿
" E îÿÿÿ@ ú¿ ü¿ þ¿
" E $íÿÿÿû@ ú¿ ü¿ þ¿
" E Àëÿÿÿ_@ ú¿ ü¿ þ¿
" E \êÿÿÿÃ@ ú¿ ü¿ þ¿
" E øèÿÿÿ'@ ú¿ ü¿ þ¿
" E çÿÿÿ@ ú¿ ü¿ þ¿
" E 0æÿÿÿï@ ú¿ ü¿ þ¿
" E ÌäÿÿÿS@ ú¿ ü¿ þ¿
" E hãÿÿÿ·@ ú¿ ü¿ þ¿
" E ñÿÿÿ @ ú¿ ü¿ þ¿
" E Pðÿÿÿ?¡@ ú¿ ü¿ þ¿
" E ïÿÿÿñ¡@ ú¿ ü¿ þ¿
" E ìîÿÿÿ£¢@ ú¿ ü¿ þ¿
" E :îÿÿÿU£@ ú¿ ü¿ þ¿
" E íÿÿÿ¤@ ú¿ ü¿ þ¿
" E Öìÿÿÿ¹¤@ ú¿ ü¿ þ¿
" E $ìÿÿÿk¥@ ú¿ ü¿ þ¿
" E rëÿÿÿ ¦@ ú¿ ü¿ þ¿
" ! E ÀêÿÿÿϦ@ ú¿ ü¿ þ¿
" " E êÿÿÿ§@ ú¿ ü¿ þ¿
" # E æéÿÿÿ©§@ ú¿ ü¿ þ¿
" $ E ¾éÿÿÿѧ@ ú¿ ü¿ þ¿
" % E éÿÿÿù§@ ú¿ ü¿ þ¿
ÿ+ E ^* , E - E . E / E 0 E 1 E 2 E 3 E 4 E 5 E ÿ6 E ^* 7 E 8 E 9 E : E ; E < E = E > E ? E @ E A E B E G E H E I E F F F F F F F F
F F F
F F F F F F F F F F F F F F F F F F F F ! F " F # F $ F % F ÿ+ F ^* ÿ6 F ^* G F H F I F ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ
G \* ÿ G \* ÿ G \* ÿ
G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ G \* ÿ! G \* ÿ" G \* ÿ# G \* ÿ$ G \* ÿ% G \* ÿ& G \* ÿ' G \* ÿ( G \* ÿ) G \* ÿ* G \* ÿ+ G ^* ÿ6 G ^* G G H G I G ÿ H ^Variables # H $ H % H & H ' H ( H ) H * H ÿ+ H ^* , H - H . H / H 0 H 1 H 2 H 3 H 4 H 5 H ÿ6 H ^* 7 H 8 H 9 H : H ; H < H = H > H ? H @ H A H B H G H H H I H ÿ I \* ÿ I \* ÿ I '******** # I $ I % I & I ' I ( I ) I * I ÿ+ I ^* , I - I . I / I 0 I 1 I 2 I 3 I 4 I 5 I ÿ6 I ^* 7 I 8 I 9 I : I ; I < I = I > I ? I @ I A I B I G I H I I I ÿ J ^Cash Reserve
J
J "* J J J J J J J
J J J
J J J J J J J J J J J J J J J J J J J J ! J " J # J $ J % J & J ' J ( J ) J * J ÿ+ J ^* , J - J . J / J 0 J 1 J 2 J 3 J 4 J 5 J ÿ6 J ^* 7 J 8 J 9 J : J ; J < J = J > J ? J @ J A J B J G J H J I J ÿ K ^Mark_Up
2 K K "* K K K K K K K
K K K
K K K K K K K K K K K K K K K K K K K K ! K " K ÿ+ K ^* ÿ6 K ^* G K H K I K
ÿ L ^Frtpct
2 L ©? L "* L L L L L L L
L L L
L L L L L L L L L L L L L L L L L L L L ! L " L ÿ+ L ^* ÿ6 L ^* G L H L I L
ÿ M ^CommRt
2 M ¹? M "* # M $ M % M & M ' M ( M ) M * M ÿ+ M ^* , M - M . M / M 0 M 1 M 2 M 3 M 4 M 5 M ÿ6 M ^* 7 M 8 M 9 M : M ; M < M = M > M ? M @ M A M B M G M H M I M ÿ N ' Beg Cash
N È N "* # N $ N % N & N ' N ( N ) N * N ÿ+ N ^* , N - N . N / N 0 N 1 N 2 N 3 N 4 N 5 N ÿ6 N ^* 7 N 8 N 9 N : N ; N < N = N > N ? N @ N A N B N G N H N I N ÿ O \* ÿ O \* ÿ O '******** O O O O O O
O O O
O O O O O O O O O O O O O O O O O O O O ! O " O # O $ O % O & O ' O ( O ) O * O ÿ+ O ^* , O - O . O / O 0 O 1 O 2 O 3 O 4 O 5 O ÿ6 O ^* 7 O 8 O 9 O : O ; O < O = O > O ? O @ O A O B O G O H O I O P P P P P P P P
P P P
P P P P P P P P P P P P P P P P P P P P ! P " P # P $ P % P & P ' P ( P ) P * P ÿ+ P ^* , P - P . P / P 0 P 1 P 2 P 3 P 4 P 5 P ÿ6 P ^* 7 P 8 P 9 P : P ; P < P = P > P ? P @ P A P B P G P H P I P Q Q Q Q Q Q Q
Q Q Q
Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q ! Q " Q ÿ+ Q ^* ÿ, Q \* ÿ- Q \* ÿ. Q \* ÿ/ Q \* ÿ0 Q \* ÿ1 Q \* ÿ2 Q \* ÿ3 Q \* ÿ4 Q \* ÿ5 Q \* ÿ6 Q ^* G Q H Q I Q ' ÿ R ^Simple Loan Repayment Calculator R R R R R R R R
R R R
R R R R R R R R R R R R R R R R R R R R ! R " R ÿ+ R ^* ÿ6 R ^* G R H R I R ÿ S \* ÿ S \* ÿ S \* ÿ S \* ÿ S '* ÿ+ S ^* ÿ1 S ^INCOME STATEMENT ÿ6 S ^* G S H S I S ÿ T ^Principal T
T ' ÿ T '* ÿ+ T ^* ÿ6 T ^* G T H T I T ÿ U ^No. of Payments U
U ÿ U '* ÿ+ U ^* ÿ6 U ^* G U H U I U ÿ V ^Interest Rate ² V
2 V ëQ¸¾? ÿ V '* ÿ+ V ^* ÿ1 V ^(000's) ÿ6 V ^* G V H V I V ÿ W ^Payment W W ºÇ¹¤@ ý¿ ÿ¿ þ¿8 ÿ W '* ÿ+ W ^* 1 W + ð Ï¿´¿3 1 W My Company ÿ6 W ^* G W H W I W ÿ X \* ÿ X \* ÿ X \* ÿ X \* ÿ X '* ÿ+ X ^* ÿ6 X ^* G X H X I X ÿ Y "* ÿ+ Y ^* ÿ6 Y ^* G Y H Y I Y ÿ Z ^RANGE NAMES & LOCATIONS ÿ Z "* ÿ& Z \* ÿ' Z \* ÿ( Z \* ÿ) Z \* ÿ* Z \* ÿ+ Z ^*
0 Z "Year 1
1 Z "Year 2
3 Z "Year 3 ÿ6 Z ^* G Z H Z I Z ÿ [ "* ÿ& [ '* ÿ+ [ ^* ÿ- [ 'Revenue: ÿ6 [ ^* ÿ \ 'ASSET WORKSHEET \ 'AS1..BA19 ÿ \ "* ÿ& \ '* ÿ( \ ^Statement Variables ÿ+ \ ^* ÿ2 \ ^% ÿ4 \ ^% ÿ6 \ ^* ÿ ] 'BALANCE SHEET ] 'AS148..BB195 ÿ ] "* ÿ& ] '* ÿ+ ] ^* ÿ- ] ' Gross Sales: 0 ] À@ Ò¿º¿Ý¿º¿P 1 ] À@ Ý¿º¿è¿º¿P - 22 ] þ¿ ÿ¿ þ¿
þ¿ ; 3 ] À@ 翺¿ò¿º¿P - 24 ] ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ] ^* ÿ ^ 'BEG CASH
^ 'B79 ÿ ^ "* ÿ& ^ '* ÿ' ^ 'Returns
2( ^ ÿ+ ^ ^* # ÿ- ^ ' Less returns, discounts 0 ^ ÿ¿( ^ 1 ^ ÿ¿( ^ - 22 ^ ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 ^ ÿ¿( ^ - 24 ^ ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^ ^* ÿ _ 'CALCULATOR _ 'A85..C88 ÿ _ "* ÿ& _ '* ÿ' _ 'State Tax
2( _ ©? ÿ+ _ ^* 0 _ 1 _ 22 _ 3 _ 24 _ ÿ6 _ ^* ÿ ` 'CASH FLOW ` 'A12..AL70 ÿ ` "* ÿ& ` '* ÿ' ` 'Fed Tax
2( ` 3333Ó? ÿ+ ` ^* ÿ- ` 'Net Sales 0 ` À@ ý¿ þ¿
1 ` À@ ý¿ þ¿
- 22 ` þ¿ ÿ¿ þ¿
þ¿ ; 3 ` À@ ý¿ þ¿
- 24 ` ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ` ^* ÿ a 'CASH RESERVE
a 'B75 ÿ a "* ÿ& a '* ÿ+ a ^* 0 a 1 a 22 a 3 a 24 a ÿ6 a ^*
ÿ b 'COMMRT
b 'B78 ÿ b "* ÿ& b \* ÿ' b \* ÿ( b \* ÿ) b \* ÿ* b \* ÿ+ b ^* ÿ- b 'Cost of Goods Sold: 0 b 1 b 22 b 3 b 24 b ÿ6 b ^*
ÿ c 'D&B c 'BD1..BM60 ÿ c "* ÿ+ c ^* ÿ- c ' Beginning inventory
0 c `R@ 1 c ÿ¿ - 22 c ð¿ þ¿ ÿ¿ þ¿
þ¿ ; 3 c þ¿ - 24 c ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 c ^* ÿ d 'FED TAX d 'AO97 ÿ d "* ÿ+ d ^* ÿ- d ' Purchases 0 d Ò¿Å¿Ý¿Å¿P 1 d Ý¿Å¿è¿Å¿P - 22 d ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 d ç¿Å¿ò¿Å¿P - 24 d ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 d ^* ÿ e 'FIRSTMONTH
e 'B28 ÿ e "* ÿ+ e ^* ÿ- e ' Freight 0 e Ò¿Å¿Ý¿Å¿P 1 e Ý¿Å¿è¿Å¿P - 22 e ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 e ç¿Å¿ò¿Å¿P - 24 e ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 e ^* ÿ f 'FOURTHMONTH
f 'B31 ÿ f "* ÿ+ f ^* ! ÿ- f ' Total goods available 0 f `R@ ý¿ ÿ¿P 1 f ý¿ ÿ¿P - 22 f ð¿ þ¿ ÿ¿ þ¿
þ¿ ; 3 f ý¿ ÿ¿P - 24 f ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 f ^*
ÿ g 'FRTPCT
g 'B77 ÿ g "* ÿ+ g ^* ÿ- g ' Ending inventory 0 g ݿ¿ݿÿ 1 g è¿Â¿è¿Ã¿ - 22 g ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 g ò¿Â¿ò¿Ã¿ - 24 g ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 g ^* ÿ h 'INCOME STATEMNT h 'AS83..BB145 ÿ h "* ÿ+ h ^* ÿ- h 'Total Cost of Goods Sold 0 h `R@ þ¿ ÿ¿
1 h þ¿ ÿ¿
- 22 h ð¿ þ¿ ÿ¿ þ¿
þ¿ ; 3 h þ¿ ÿ¿
- 24 h ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 h ^* ÿ i 'INIT INVESTMNT i 'CA19 ÿ i "* ÿ+ i ^* 0 i 1 i 22 i 3 i 24 i ÿ6 i ^* ÿ j 'INITIAL PRICE j 'CA20 ÿ j "* ÿ+ j ^* ÿ- j 'Gross Profit 0 j @ ö¿ þ¿
1 j À@ ö¿ þ¿
- 22 j :ûÑèû³°? þ¿ ÿ¿ þ¿
þ¿ ; 3 j À@ ö¿ þ¿
- 24 j ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 j ^* ÿ k 'MARK_UP
k 'B76 ÿ k "* ÿ+ k ^* 0 k 1 k 22 k 3 k 24 k ÿ6 k ^* ÿ l 'MONTHSHIP
l 'B27 ÿ l "* ÿ+ l ^* ÿ- l 'Operating Expenses: 0 l 1 l 22 l 3 l 24 l ÿ6 l ^* ÿ m 'NO OF SHARES
m 'CA9 ÿ m "* ÿ+ m ^* 0 m 1 m 22 m 3 m 24 m ÿ6 m ^* ÿ n 'OUTSIDE INVEST n 'CA17 ÿ n "* ÿ+ n ^* ÿ- n 'Selling Expenses 0 n 1 n 22 n 3 n 24 n ÿ6 n ^* ÿ o 'RATIO ANALYSIS o 'AS198..BB222 ÿ o "* ÿ+ o ^* ÿ- o ' Advertising 0 o Ò¿À¿Ý¿À¿P 1 o Ý¿À¿è¿À¿P - 22 o ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 o ç¿À¿ò¿À¿P - 24 o ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 o ^* ÿ p 'RETURNS p 'AO95 ÿ p "* ÿ+ p ^* ÿ- p ' Commissions 0 p âÿÿÿÿ]@ Ò¿Á¿Ý¿Á¿P 1 p âÿÿÿÿ]@ Ý¿Á¿è¿Á¿P - 22 p þ¿ ÿ¿ þ¿
þ¿ ; 3 p âÿÿÿÿ]@ ç¿Á¿ò¿Á¿P - 24 p ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 p ^*
ÿ q 'RMA q 'BP1..BW52 ÿ q "* ÿ+ q ^* ÿ- q ' T & E 0 q ҿ¿ݿ¿P 1 q ݿ¿è¿Â¿P - 22 q ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 q ç¿Â¿ò¿Â¿P - 24 q ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 q ^* ÿ r 'SECONDMONTH
r 'B29 ÿ r "* ÿ+ r ^* ÿ- r 'Total 0 r âÿÿÿÿ]@ ý¿ ÿ¿P 1 r âÿÿÿÿ]@ ý¿ ÿ¿P - 22 r þ¿ ÿ¿ þ¿
þ¿ ; 3 r âÿÿÿÿ]@ ý¿ ÿ¿P - 24 r ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 r ^* ÿ s 'STATE TAX s 'AO96 ÿ s "* ÿ+ s ^* 0 s 1 s 22 s 3 s 24 s ÿ6 s ^* ÿ t 'STATEMENT VAR t 'AN95..AO97 ÿ t "* ÿ+ t ^* ÿ- t 'Administrative 0 t 1 t 22 t 3 t 24 t ÿ6 t ^* ÿ u 'STOCK ANALYS u 'BY1..CF22 ÿ u "* ÿ+ u ^* ÿ- u ' Salaries 0 u Ò¿±¿Ý¿±¿P 1 u Ý¿±¿è¿±¿P - 22 u ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 u 翱¿ò¿±¿P - 24 u ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 u ^* ÿ v 'THIRDMONTH
v 'B30 ÿ v "* ÿ+ v ^* ÿ- v ' Payroll 0 v Ò¿±¿Ý¿±¿P 1 v Ý¿±¿è¿±¿P - 22 v ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 v 翱¿ò¿±¿P - 24 v ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 v ^* ÿ w 'VARIABLES w 'A73..C80 ÿ w "* ÿ+ w ^* ÿ- w ' Withholding 0 w Ò¿±¿Ý¿±¿P 1 w Ý¿±¿è¿±¿P - 22 w ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 w 翱¿ò¿±¿P - 24 w ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 w ^* ÿ x "* ÿ+ x ^* ÿ- x ' Insurance 0 x Ò¿º¿Ý¿º¿P 1 x Ý¿º¿è¿º¿P - 22 x ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 x 翺¿ò¿º¿P - 24 x ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 x ^* ÿ y \* ÿ y \* ÿ y \* ÿ y \* ÿ+ y ^* ÿ- y 'Total 0 y ü¿ ÿ¿P 1 y ü¿ ÿ¿P - 22 y ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 y ü¿ ÿ¿P - 24 y ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 y ^* ÿ+ z ^* 0 z 1 z 22 z 3 z 24 z ÿ6 z ^* ÿ+ { ^* ÿ- { 'General 0 { 1 { 22 { 3 { 24 { ÿ6 { ^* ÿ+ | ^* ÿ- | ' Rent 0 | Ò¿§¿Ý¿§¿P 1 | Ý¿§¿è¿§¿P - 22 | ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 | 翧¿ò¿§¿P - 24 | ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 | ^* ÿ+ } ^* ÿ- } ' Utilities 0 } Ò¿§¿Ý¿§¿P 1 } Ý¿§¿è¿§¿P - 22 } ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 } 翧¿ò¿§¿P - 24 } ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 } ^* ÿ+ ~ ^* ÿ- ~ ' Telephone 0 ~ Ò¿§¿Ý¿§¿P 1 ~ Ý¿§¿è¿§¿P - 22 ~ ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 ~ 翧¿ò¿§¿P - 24 ~ ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ~ ^* ÿ+ ^* ÿ- ' Office Expenses 0 Ò¿¬¿Ý¿¬¿P 1 Ý¿¬¿è¿¬¿P - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 翬¿ò¿¬¿P - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Vehicle Expenses 0 Ò¿¬¿Ý¿¬¿P 1 Ý¿¬¿è¿¬¿P - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 翬¿ò¿¬¿P - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Office Supplies 0 Ò¿¬¿Ý¿¬¿P 1 Ý¿¬¿è¿¬¿P - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 翬¿ò¿¬¿P - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Postage 0 Ò¿¬¿Ý¿¬¿P 1 Ý¿¬¿è¿¬¿P - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 翬¿ò¿¬¿P - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Professionals 0 Ò¿¿Ý¿¿P 1 Ý¿¿è¿¿P - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 ç¿¿ò¿¿P - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Research 0 Ò¿°¿Ý¿°¿P 1 Ý¿°¿è¿°¿P - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 ç¿°¿ò¿°¿P - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Misc. 0 Ò¿°¿Ý¿°¿P 1 Ý¿°¿è¿°¿P - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 ç¿°¿ò¿°¿P - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- 'Total 0 ö¿ ÿ¿P 1 ö¿ ÿ¿P - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 ö¿ ÿ¿P - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* 0 1 22 3 24 ÿ6 ^* ÿ+ ^* ÿ- 'Total Operating Expenses ! 0 âÿÿÿÿ]@ ê¿ ñ¿ þ¿ ! 1 âÿÿÿÿ]@ ê¿ ñ¿ þ¿ - 22 þ¿ ÿ¿ þ¿
þ¿ ; ! 3 âÿÿÿÿ]@ ê¿ ñ¿ þ¿ - 24 ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* 0 1 22 3 24 ÿ6 ^* ÿ+ ^* ÿ- 'Total Operating Income 0 À t@ à¿ þ¿
1 à à@ à¿ þ¿
- 22 ûÒɱ²? þ¿ ÿ¿ þ¿
þ¿ ; 3 à à@ à¿ þ¿
- 24 ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' State Taxes ) 0 p)I@ ÿ¿ ÿ¿( _ ; ) 1 èÿÿÿÿJ@ ÿ¿ ÿ¿( _ ; - 22 ûÒɱ²? þ¿ ÿ¿ þ¿
þ¿ ; ) 3 èÿÿÿÿJ@ ÿ¿ ÿ¿( _ ; - 24 ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* 0 1 22 3 24 ÿ6 ^* ÿ+ ^* ÿ- 'Pretax Income 0 kfffá@ ý¿ þ¿
1 @ ý¿ þ¿
- 22 ûÒɱ²? þ¿ ÿ¿ þ¿
þ¿ ; 3 @ ý¿ þ¿
- 24 ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Federal Taxes ) 0 .
×£íq@ ÿ¿ ÿ¿( ` ; ) 1 ¶¼ÌÌÌ
1 å¦q@ ý¿ þ¿
- 22 ûÒɱ²? þ¿ ÿ¿ þ¿
þ¿ ; 3 å¦q@ ý¿ þ¿
- 24 ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ6 ^* ÿ+ ^* ÿ, \* ÿ- \* ÿ. \* ÿ/ \* ÿ0 \* ÿ1 \* ÿ2 \* ÿ3 \* ÿ4 \* ÿ5 \* ÿ6 ^* ÿ+ ^* ÿ6 ^* ÿ+ ^* ÿ6 ^* ÿ+ ^* ÿ1 ^BALANCE SHEET ÿ6 ^* ÿ+ ^* ÿ1 ^(000's) ÿ6 ^* ÿ+ ^* 1 È ð Ï¿t¿3 1 My Company ÿ6 ^* ÿ+ ^* ÿ6 ^* ÿ+ ^*
0 "Year 1
1 "Year 2
3 "Year 3 ÿ6 ^* ÿ+ ^*
ÿ- 'ASSETS ÿ6 ^* ÿ+ ^* ÿ2 ^% ÿ4 ^% ÿ6 ^* ÿ+ ^* ÿ- ' Cash 0 PñÿÿÿÏ@ Ý¿©¿ 1 Pðÿÿÿ?¡@ è¿©¿ - 22 gÚsKúí? þ¿ ÿ¿ þ¿
þ¿ ; 3 éÿÿÿù§@ ò¿©¿ - 24 -xÓÞôØ? ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Accounts Receivable 9 0 àîÿÿÿ a@* Þ¿¿ß¿¿PÞ¿¿á¿¿P Þ¿¿â¿¿P Þ¿~¿ 9 1 àÿÿÿÿ_@* é¿¿ê¿¿Pé¿¿ë¿¿P é¿¿ì¿¿P é¿~¿ - 22 ®Ë;àHÑ°¿ þ¿ ÿ¿ þ¿
þ¿ ; 9 3 àÿÿÿÿ_@* ó¿¿ô¿¿Pó¿¿õ¿¿P ó¿¿ö¿¿P ó¿~¿ - 24 ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Notes Receivable
0
1 - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ;
3 - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* ÿ- ' Inventory 0 È¿ 1 È¿ - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 È¿ - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ^* 0 1 3 ÿ6 ^* ÿ+ ¡ ^* ÿ- ¡ 'Total Current Assets 0 ¡ ,ïÿÿÿó@ û¿ þ¿P 1 ¡ Pïÿÿÿ?¢@ û¿ þ¿P - 22 ¡ ¶Â ¶ ê? þ¿ ÿ¿ þ¿
þ¿ ; 3 ¡ èÿÿÿù¨@ û¿ þ¿P - 24 ¡ hײeË×? ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ¡ ^* ÿ+ ¢ ^* 0 ¢ 1 ¢ 3 ¢ ÿ6 ¢ ^* ÿ+ £ ^* ÿ- £ ' Equipment 0 £ $@ c¿ 1 £ $@ ÿ¿c¿ 3 £ $@ ý¿c¿ ÿ6 £ ^* ÿ+ ¤ ^* ÿ- ¤ ' Less: accum. deprec.
0 ¤
1 ¤
3 ¤ ÿ6 ¤ ^* ÿ+ ¥ ^* 0 ¥ 1 ¥ 3 ¥ ÿ6 ¥ ^* ÿ+ ¦ ^* ÿ- ¦ ' Net Fixed assets 0 ¦ $@ ý¿ þ¿
1 ¦ $@ ý¿ þ¿
- 22 ¦ þ¿ ÿ¿ þ¿
þ¿ ; 3 ¦ $@ ý¿ þ¿
- 24 ¦ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ¦ ^* ÿ+ § ^* ÿ- § ' Intangible Assets 0 § l¿ 1 § l¿ - 22 § ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 § þ¿l¿ - 24 § ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 § ^* ÿ+ ¨ ^* 0 ¨ 1 ¨ 3 ¨ ÿ6 ¨ ^* ÿ+ © ^* ÿ- © 'Total Assets ! 0 © ,ïÿÿÿ@ ø¿ ý¿ þ¿ ! 1 © PïÿÿÿS¢@ ø¿ ý¿ þ¿ - 22 © º¼Tê? þ¿ ÿ¿ þ¿
þ¿ ; ! 3 © èÿÿÿ
©@ ø¿ ý¿ þ¿ - 24 © ÇÖ¿
}×? ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 © ^* ÿ+ ª ^* 0 ª 1 ª 3 ª ÿ6 ª ^* ÿ+ « ^* ÿ- « 'LIABILITIES 0 « 1 « 3 « ÿ6 « ^* ÿ+ ¬ ^* 0 ¬ 1 ¬ 3 ¬ ÿ6 ¬ ^* ÿ+ ^* ÿ- ' Accounts payable
0
1 - 22 ðÿ þ¿ ÿ¿ þ¿
þ¿ ;
3 - 24 ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ^* ÿ+ ® ^* ÿ- ® ' Bank notes
0 ®
1 ® - 22 ® ðÿ þ¿ ÿ¿ þ¿
þ¿ ;
3 ® - 24 ® ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ® ^* ÿ+ ¯ ^* ÿ- ¯ ' Notes payable
0 ¯
1 ¯ - 22 ¯ ðÿ þ¿ ÿ¿ þ¿
þ¿ ;
3 ¯ - 24 ¯ ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ¯ ^* ÿ+ ° ^* ÿ- ° ' CPLTD
0 °
1 ° - 22 ° ðÿ þ¿ ÿ¿ þ¿
þ¿ ;
3 ° - 24 ° ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ° ^* ÿ+ ± ^* 0 ± 1 ± 3 ± ÿ6 ± ^* ÿ+ ² ^* ÿ- ² 'Total Current Liabilities 0 ² û¿ þ¿P 1 ² û¿ þ¿P - 22 ² ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 ² û¿ þ¿P - 24 ² ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ² ^* ÿ+ ³ ^* 0 ³ 1 ³ 3 ³ ÿ6 ³ ^* ÿ+ ´ ^* $ ÿ- ´ 'Total non-current liabilities
0 ´
1 ´ - 22 ´ ðÿ þ¿ ÿ¿ þ¿
þ¿ ;
3 ´ - 24 ´ ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ´ ^* ÿ+ µ ^* 0 µ 1 µ 3 µ ÿ6 µ ^* ÿ+ ¶ ^* ÿ- ¶ 'Total Liabilities 0 ¶ ü¿ þ¿ 1 ¶ ü¿ þ¿ - 22 ¶ ðÿ þ¿ ÿ¿ þ¿
þ¿ ; 3 ¶ ü¿ þ¿ - 24 ¶ ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ¶ ^* ÿ+ · ^* 0 · 1 · 3 · ÿ6 · ^* ÿ+ ¸ ^* ÿ- ¸ 'NET WORTH 0 ¸ 1 ¸ 3 ¸ ÿ6 ¸ ^* ÿ+ ¹ ^* 0 ¹ 1 ¹ 3 ¹ ÿ6 ¹ ^* ÿ+ º ^* ÿ- º ' Paid in Capital 0 º i@ Ñ¿¿ 1 º i@ п¿ 3 º i@ ο¿ ÿ6 º ^* ÿ+ » ^* ÿ- » ' Retained Earnings 0 » =Tázê@ Õ¿ 1 » }=
®@ ÿ¿ Õ¿ - 22 » °/ +ñ? þ¿ ÿ¿ þ¿
þ¿ ; 3 » ( ëqs @ þ¿ Õ¿ - 24 » Ñõ¸Ià? ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 » ^* ÿ+ ¼ ^* ÿ- ¼ ' Other ( 0 ¼ 6=
×z@ í¿ ú¿ þ¿ ÿ¿
( 1 ¼ Âëѳ@ í¿ ú¿ þ¿ ÿ¿
- 22 ¼ úãO/ ê? þ¿ ÿ¿ þ¿
þ¿ ; ( 3 ¼ P ëQ8*@ í¿ ú¿ þ¿ ÿ¿
- 24 ¼ qâ*KÈ? ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ¼ ^* ÿ+ ½ ^* 0 ½ 1 ½ 3 ½ ÿ6 ½ ^* ÿ+ ¾ ^* ÿ- ¾ 'Total Net Worth 0 ¾ ,ïÿÿÿ@ ü¿ þ¿P 1 ¾ PïÿÿÿS¢@ ü¿ þ¿P - 22 ¾ º¼Tê? þ¿ ÿ¿ þ¿
þ¿ ; 3 ¾ èÿÿÿ
©@ ü¿ þ¿P - 24 ¾ ÇÖ¿
}×? ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 ¾ ^* ÿ+ ¿ ^* 0 ¿ 1 ¿ 3 ¿ ÿ6 ¿ ^* ÿ+ À ^* ÿ- À 'TOTAL LIABILITIES & 0 À 1 À 3 À ÿ6 À ^* ÿ+ Á ^* ÿ- Á ' NET WORTH 0 Á ,ïÿÿÿ@ õ¿ ý¿ 1 Á PïÿÿÿS¢@ õ¿ ý¿ - 22 Á º¼Tê? þ¿ ÿ¿ þ¿
þ¿ ; 3 Á èÿÿÿ
©@ õ¿ ý¿ - 24 Á ÇÖ¿
}×? ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Á ^* ÿ+ Â ^* 3 Â ÿ6 Â ^* ÿ+ Ã ^* ÿ6 Ã ^* ÿ+ Ä ^* ÿ, Ä \* ÿ- Ä \* ÿ. Ä \* ÿ/ Ä \* ÿ0 Ä \* ÿ1 Ä \* ÿ2 Ä \* ÿ3 Ä \* ÿ4 Ä \* ÿ5 Ä \* ÿ6 Ä ^* ÿ+ Å ^* ÿ6 Å ^* ÿ+ Æ ^* ÿ1 Æ ^RATIO ANALYSIS ÿ6 Æ ^* ÿ+ Ç ^* 1 Ç § ð Ï¿D¿3 1 Ç My Company ÿ6 Ç ^* ÿ+ È ^* ÿ6 È ^* ÿ+ É ^*
ÿ0 É "Year 1
ÿ1 É "Year 2
ÿ3 É "Year 3 ÿ6 É ^* ÿ+ Ê ^* ÿ6 Ê ^* ÿ+ Ë ^* ÿ- Ë 'Current Ratio & 0 Ë ðÿ ç¿ Ö¿ ç¿ ; & 1 Ë ðÿ ç¿ Ö¿ ç¿ ; - 22 Ë ðÿ þ¿ ÿ¿ þ¿
þ¿ ; & 3 Ë ðÿ ç¿ Ö¿ ç¿ ; - 24 Ë ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Ë ^* ÿ+ Ì ^* ÿ- Ì 'Acid Ratio - 0 Ì ðÿ æ¿ Ð¿ D¿ æ¿ ; - 1 Ì ðÿ æ¿ Ð¿ D¿ æ¿ ; - 22 Ì ðÿ þ¿ ÿ¿ þ¿
þ¿ ; - 3 Ì ðÿ æ¿ Ð¿ D¿ æ¿ ; - 24 Ì ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Ì ^* ÿ+ Í ^* 0 Í 1 Í 3 Í ÿ6 Í ^* ÿ+ Î ^* ÿ- Î 'Debt Ratio & 0 Î ðÿ è¿ Û¿ è¿ ; & 1 Î ðÿ è¿ Û¿ è¿ ; - 22 Î ðÿ þ¿ ÿ¿ þ¿
þ¿ ; & 3 Î ðÿ è¿ Û¿ è¿ ; - 24 Î ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Î ^* ÿ+ Ï ^*
ÿ- Ï 'TIE 0 Ï 1 Ï 3 Ï ÿ6 Ï ^* ÿ+ Ð ^* 0 Ð 1 Ð 3 Ð ÿ6 Ð ^* ÿ+ Ñ ^* ÿ- Ñ 'Inventory Turnover + 0 Ñ ¿ ¿h ¿ ; + 1 Ñ ðÿ ¿ ¿h ¿ ; - 22 Ñ ðÿ þ¿ ÿ¿ þ¿
þ¿ ; + 3 Ñ ðÿ ¿ ¿h ¿ ; - 24 Ñ ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Ñ ^* ÿ+ Ò ^* ÿ- Ò 'Average Collection 0 Ò 1 Ò 3 Ò ÿ6 Ò ^* ÿ+ Ó ^* ÿ- Ó ' Period + 0 Ó @¸ÌÌÌD@ ¿ Ê¿h ¿ ; + 1 Ó 3333C@ ¿ Ê¿h ¿ ; - 22 Ó ®Ë;àHÑ°¿ þ¿ ÿ¿ þ¿
þ¿ ; + 3 Ó 3333C@ ¿ Ê¿h ¿ ; - 24 Ó ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Ó ^* ÿ+ Ô ^* ÿ- Ô 'Total Asset Turnover & 0 Ô Díz:Öí? Õ¿ ¿ Õ¿ ; & 1 Ô Àò<H^à? Õ¿ ¿ Õ¿ ; - 22 Ô $S·ØãÜ¿ þ¿ ÿ¿ þ¿
þ¿ ; & 3 Ô x¶Þò×? Õ¿ ¿ Õ¿ ; - 24 Ô I2¦².Ñ¿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Ô ^* ÿ+ Õ ^* 3 Õ ÿ6 Õ ^* ÿ+ Ö ^* ÿ- Ö 'Gross Margin & 20 Ö
×£p=
î? ¿ ¿ ¿ ; & 21 Ö ð? ¿ ¿ ¿ ; - 22 Ö <ûÑèû³°? þ¿ ÿ¿ þ¿
þ¿ ; & 23 Ö ð? ¿ ¿ ¿ ; - 24 Ö ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Ö ^* ÿ+ × ^* ÿ- × 'Net Margin & 20 × nmÙ=Ùá? ¿ ¹¿ ¿ ; & 21 × L Õxé&ã? ¿ ¹¿ ¿ ; - 22 × ûÒɱ²? þ¿ ÿ¿ þ¿
þ¿ ; & 23 × L Õxé&ã? ¿ ¹¿ ¿ ; - 24 × ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 × ^* ÿ+ Ø ^* ÿ- Ø 'Return on Assets & 20 Ø ËÛ
y]¤à? Ñ¿ ¸¿ Ñ¿ ; & 21 Ø ªÚIÄÓ? Ñ¿ ¸¿ Ñ¿ ; - 22 Ø _Ï{SÚ¿ þ¿ ÿ¿ þ¿
þ¿ ; & 23 Ø YÀPªÌ? Ñ¿ ¸¿ Ñ¿ ; - 24 Ø I2¦².Ñ¿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Ø ^* ÿ+ Ù ^* ÿ- Ù 'Return on Equity & 20 Ù ËÛ
y]¤à? å¿ ·¿ å¿ ; & 21 Ù ªÚIÄÓ? å¿ ·¿ å¿ ; - 22 Ù _Ï{SÚ¿ þ¿ ÿ¿ þ¿
þ¿ ; & 23 Ù YÀPªÌ? å¿ ·¿ å¿ ; - 24 Ù I2¦².Ñ¿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Ù ^* ÿ+ Ú ^* 23 Ú 24 Ú ÿ6 Ú ^* ÿ+ Û ^* ÿ- Û 'Off. Comp./Sales & 20 Û ¿ ¿ ¿ ; & 21 Û ¿ ¿ ¿ ; - 22 Û ðÿ þ¿ ÿ¿ þ¿
þ¿ ; & 23 Û ¿ ¿ ¿ ; - 24 Û ðÿ ý¿ ÿ¿ ý¿
ý¿ ; ÿ6 Û ^* ÿ+ Ü ^* ÿ6 Ü ^* ÿ+ Ý ^* ÿ6 Ý ^* ÿ+ Þ ^* ÿ, Þ \* ÿ- Þ \* ÿ. Þ \* ÿ/ Þ \* ÿ0 Þ \* ÿ1 Þ \* ÿ2 Þ \* ÿ3 Þ \* ÿ4 Þ \* ÿ5 Þ \* ÿ6 Þ ^*
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/