Category : Lotus and other Spreadsheets
Archive   : BPD22.ZIP
Filename : BPDPROF.WK1

 
Output of file : BPDPROF.WK1 contained in archive : BPD22.ZIP
TޖþyyyyXRRRR R
R R R
RRRRRRRRRRRRRRRRRRR R!R"R#P$P%P&b'b(b)b*b+Þ,Þ-Þ.Þ/Þ0Þ1Þ2Þ3Þ4Þ5Þ6Þ7P8P9P:P;P<P=P>P?P@PAPBPC6D6E6F6GZHZIZJ66K6LMNOPQ
R
ST/ÿÿ q H"+,56789:;<=>?@ABCDEG H JKLMP STd GASSET WORKSHEET,4GBALANCE SHEET,“5ÂGBEG CASHNNGCALCULATORTWGCASH FLOW %EGCASH RESERVEJJGCOMMRTMMGD&B7@;GFED TAX(`(`GFIRSTMONTHGFOURTHMONTHGFRTPCTLLGINCOME STATEMNT,R5GINIT INVESTMNTNNGINITIAL PRICENNGMARK_UPKKGMONTHSHIPGNO OF SHARESNNGOUTSIDE INVESTNNGRATIO ANALYSIS,Å5ÝGRETURNS(^(^GRMACI3GSECONDMONTHGSTATE TAX(_(_GSTATEMENT VAR'^(`GSTOCK ANALYSLSGTHIRDMONTHGVARIABLESHOÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$ÿ%ò&ò'((
LB)'*ÿÿÿÿÿÿÿÿ-·ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ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¢Ÿð°¿€3PMy CompanyÿT^*ÿ'*ÿ+^*ÿ-' Equipment
0
ÿ6^*ÿ9^$ÿ:^%ÿ<^$ÿ=^%ÿ?^$ÿ@^%‚B^*ÿE^Cash & Equivalents G~E 0ÿ6^*‚B^* ÿE^Trade Receivables - (net) Gtaº1J%@鿖€0© d  HIRžü&ä#@鿖€0© d  IIRžü&ä#@ꀖ€0© d ÿK^*ÿT^*$ÿ^Registration brings benefits!ÿ'*ÿ+^*ÿ-' Buildings
0ÿ6^* ÿ8'CASH9Pñÿÿÿϑ@Ô¿=€ :~E @Njø@ÿT^*ÿ \*ÿ '*ÿ+ ^*ÿ- ' Fixtures
0 ÿ6 ^*ÿ8 'ACCOUNTS RECEIVABLE9 àîÿÿÿ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 RECEIVABLE9
÷¿”€ :
ÿ¿€ÿ¿ € d <
õ¿”€ =
ÿ¿€ÿ¿ € d ?
ô¿”€ @
ÿ¿€ÿ¿ € d ‚B
^*ÿE
^Total Current G
tˆžEÎ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 'INVENTORY9 ÷¿”€ : ÿ¿€ÿ¿€ 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 Assets1$@ ÿ¿ø¿ÿ¿ÿ¿Pÿ6^*ÿ8'TOTAL CURRENT9,ïÿÿÿó“@÷¿“€ :tˆžEÎX@ÿ¿€ÿ¿€ d <Pïÿÿÿ?¢@õ¿“€ =Áï¡2¸äX@ÿ¿€ÿ¿€ d ?–èÿÿÿù¨@ô¿“€ @‡ñ, ìX@ÿ¿€ÿ¿€ d ‚B^*ÿE^LIABILITIES G H IÿK^*
ÿM'EPSP&$?ÆÜÅ@ €þ¿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 ASSETS9$@÷¿–€ :¹ÿÅ»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-CURRENT9÷¿–€ :ÿ¿€ÿ¿€ 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Ý@ NN @P5öÿÿå‚A €ü¿N @QGõÿÿM
A €ü¿N @RGõÿÿM
A €ü¿N ÿT^*
ÿ'Sales: ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚  ‚
 ‚  ‚  ‚
 ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‚  ‚! ‚" ‚# ‚$ ‚%ÿ+^* ÿ."Total1 €þ¿€ÿ¿Pÿ6^*ÿ8'TOTAL ASSETS9,ïÿÿÿ”@÷¿–€
: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 PAYABLE9÷¿˜€ :ÿ¿€9 d <õ¿›€ =ÿ¿€< d ?ô¿›€ @ÿ¿€? d  ‚A‚B^* ‚C ‚DÿE^Long Term Debt
G
H
IÿK^* ‚LÿM'Value of InvestmentN´âÿÿÿKÝ@ NN  @P·ÔÿÿϐAà¿©€N è  @Q÷Öÿÿoz%Aà¿©€N è  @R3Çÿÿg\-Aá¿©€N è ÿT^*          
     
                     ! " # $ %ÿ+^*ÿ6^*ÿ8'BANK LOANS9÷¿˜€ :ÿ¿€9 d <õ¿›€ =ÿ¿€< d ?ô¿›€ @ÿ¿€? d ‚B^*ÿE^Deferred Taxes
G
H
IÿK^*ÿT^*ÿ'Total SalesY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿P Y@ €ý¿€þ¿P
Y@ €ý¿€þ¿P Y@ €ý¿€þ¿P Y@ €ý¿€þ¿P
Y@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿PY@ €ý¿€þ¿P Y@ €ý¿€þ¿P!Y@ €ý¿€þ¿P"Y@ €ý¿€þ¿P#Y@ €ý¿€þ¿P$Y@ €ý¿€þ¿P%Y@ €ý¿€þ¿Pÿ+^*ÿ6^*ÿ8'NOTES PAYABLE9÷¿˜€ :ÿ¿€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 CURRENT9÷¿˜€ :ÿ¿€9 d <õ¿›€ =ÿ¿€< d ?ô¿›€ @ÿ¿€? d ‚B^*$ÿE^Total Liabilities & Net Worth
Gd
Hd
IdÿK^*ÿ'Cash Receipts:ÿ+^*ÿ6^* 9 : < = ? @‚B^*ÿE^INCOME DATA G H IÿK^*ÿ' Month of Shipment
°€™™™™¹?ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿  ìÿÿÿÿ#@ €ý¿ 
ìÿÿÿÿ#@ €ý¿  ìÿÿÿÿ#@ €ý¿  ìÿÿÿÿ#@ €ý¿ 
ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿ ìÿÿÿÿ#@ €ý¿  ìÿÿÿÿ#@ €ý¿ !ìÿÿÿÿ#@ €ý¿ "ìÿÿÿÿ#@ €ý¿ #ìÿÿÿÿ#@ €ý¿ $ìÿÿÿÿ#@ €ý¿ %ìÿÿÿÿ#@ €ý¿ & €ý¿ ' €ý¿ ( €ý¿ ) €ý¿ ÿ+^*ÿ6^*ÿ8'TOTAL CURRENT9÷¿˜€ :ÿ¿€9 d <õ¿›€ =ÿ¿€< d ?ô¿›€ @ÿ¿€? d ‚B^*ÿE^Net Sales
Gd
Hd
Idÿ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 GxW@é¿O€é¿E€ d  HY@é¿O€é¿E€ d  IY@ê€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 TERM9÷¿˜€ :ÿ¿€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 WORTH9,ïÿÿÿ”@÷¿ € :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 WORTH9 ,ïÿÿÿ”@÷¿¡€
: 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!^CurrentG!ðÿ鿪€H!ðÿ鿪€I!ðÿꀪ€ÿK!^*ÿ"'Cash Disbursements: " " " " " " "  " 
"  "  " 
" " " " " " " " " " " " " " " " " " "  " !" "" #" $" %" &" '" (" )" ‚*"ÿ+"^* ‚," ‚-" ‚." ‚/" ‚0" ‚1" ‚2" ‚3" ‚4" ‚5"ÿ6"^* ‚7"‚8"'NET SALES9"À’@÷¿>€
:"d ;"<"À’@õ¿>€
="d >"?"À’@ô¿>€
@"d ‚A"‚B"^* ÿE"^QuickG"ðÿ鿪€H"ðÿ鿪€I"ðÿꀪ€ÿK"^*ÿ#' Rent
#
#
#
#
#
#
#
 #

#
 #
 #

#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
 #
!#
"#
##
$#
%# &# '# (# )# ‚*#ÿ+#^* ‚,# ‚-# ‚.# ‚/# ‚0# ‚1# ‚2# ‚3# ‚4# ‚5#ÿ6#^* ‚7#‚8#'GROSS PROFIT9#š‘@÷¿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 TAX9$=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 CAPITAL9%,ïÿÿÿó“@ ÷¿|€÷¿€
 :%^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 Capital4G&­KÓ
î?%é¿{€鿌€
é¿:€é¿{€鿌€
 ;4H& 8pà?%é¿{€鿌€
é¿:€é¿{€鿌€
 ;4I&Ž:–ñÃØ?%ê€{€ꀌ€
ê€:€ê€{€ꀌ€
 ;ÿ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*|£0”qÓ?鿔€é¿|€鿔€ ;&H*fz¸'¢uq?鿔€é¿|€鿔€ ;&I*Å4:˜K‹i?ꀔ€ê€|€ꀔ€ ;ÿ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/|£0”qÓ?÷¿€÷¿w€÷¿€ ; ;/&2</fz¸'¢uq?õ€€õ€w€õ€€ ; =/&2?/Å4:˜K‹i?ô€€ô€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^*ÿ60^* ‚80 90 :0 ;0 <0 =0 >0  ?0 @0‚B0^*ÿE0^Sales/Net Fixed Assets&G0ðÿé¿n€é¿0€é¿n€ ;&H0ðÿé¿n€é¿0€é¿n€ ;&I0ðÿê€n€ê€0€ê€n€ ;ÿK0^*ÿ1' Commissions1ìÿÿÿÿ#@ €æ¿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 ‚01 ‚11 ‚21 ‚31 ‚41 ‚51ÿ61^* ‚71ÿ81' EFFICIENCY  ?1 ‚A1‚B1^*ÿE1^Sales/Total Assets&G1D™íz:Öí?é¿x€é¿/€é¿x€ ;&H1Àò<H^à?é¿x€é¿/€é¿x€ ;&I1x‘¶Þ–ò×?ê€x€ê€/€ê€x€ ;ÿK1^*ÿ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 ‚02 ‚12 ‚22 ‚32 ‚42 ‚52ÿ62^* ‚72ÿ82'COLL PERIOD (DAYS)+92ÉÝÝÝÕD@÷¿.€÷¿k€÷¿.€ m ;+<2dwwwwC@õ€.€õ€k€õ€.€ m ;+?2dwwwwC@ô€.€ô€k€ô€.€ m ; ‚A2‚B2^*!ÿE2^% Depr., Dep., Amort/Sales
2G2
2H2
2I2ÿK2^*"ÿ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 ‚03 ‚13 ‚23 ‚33 ‚43 ‚53ÿ63^* ‚73‚83'SALES TO INV (TIMES)&93ðÿ÷¿l€÷¿-€÷¿l€ ; ;3&<3ðÿõ€l€õ€-€õ€l€ ; =3&?3ðÿô€l€ô€-€ô€l€ ; @3 ‚A3‚B3^*ÿE3^% Officer's Comp./Sales&2G3é¿-€é¿B€é¿-€ ;&2H3é¿-€é¿B€é¿-€ ;&2I3ê€-€ê€B€ê€-€ ;ÿK3^*ÿ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^*ÿ64^*‚84'ASSETS TO SALES (%)&294ÍMÂõ(ñ?÷¿,€÷¿u€÷¿,€ ; ;4&2<4ÍÄz®Gÿ?õ€,€õ€u€õ€,€ ; =4&2?4æf®Ga@ô€,€ô€u€ô€,€ ; @4‚B4^* G4 H4 I4ÿK4^*ÿ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^*ÿ65^*‚85'SALES TO NWC (TIMES)&95­KÓ
î?€ð¿÷¿+€€ð¿ ; ;5&<5ðÿþ€ð¿õ€+€þ€ð¿ ; =5&?5 8pà?ý€ð¿ô€+€ý€ð¿ ; @5‚B5^*0ÿC5'RMA is copyright Robert Morris AssociatesÿK5^*ÿ6' State Taxes &6 '6 (6 )6 ‚*6ÿ+6^* ‚,6 ‚-6 ‚.6 ‚/6 ‚06 ‚16 ‚26 ‚36 ‚46 ‚56ÿ66^* ‚76‚86'ACCTS PAY TO SALES (%)&296÷¿*€÷¿w€÷¿*€ ; ;6&2<6õ€*€õ€w€õ€*€ ; =6&2?6ô€*€ô€w€ô€*€ ; @6 ‚A6‚B6^*ÿC6\*ÿD6\*ÿE6\*ÿF6\*ÿG6\*ÿH6\*ÿI6\*ÿJ6\*ÿK6^*ÿ7' Federal Taxes &7 '7 (7 )7 ‚*7ÿ+7^* ‚,7 ‚-7 ‚.7 ‚/7 ‚07 ‚17 ‚27 ‚37 ‚47 ‚57ÿ67^* ‚77 ‚87 97 :7 ;7 <7 =7 >7  ?7 @7 ‚A7‚B7^* 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 ‚08 ‚18 ‚28 ‚38 ‚48 ‚58ÿ68^* ‚78‚88' PROFITABILITY 98 :8 ;8 <8 =8 >8  ?8 @8 ‚A8‚B8^*ÿ9'Total Disbursements9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P 9ìÿÿÿÿ#@ €ê¿€þ¿P
9ìÿÿÿÿ#@ €ê¿€þ¿P 9ìÿÿÿÿ#@ €ê¿€þ¿P 9ìÿÿÿÿ#@ €ê¿€þ¿P
9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P9ìÿÿÿÿ#@ €ê¿€þ¿P 9ìÿÿÿÿ#@ €ê¿€þ¿P!9ìÿÿÿÿ#@ €ê¿€þ¿P"9ìÿÿÿÿ#@ €ê¿€þ¿P#9ìÿÿÿÿ#@ €ê¿€þ¿P$9ìÿÿÿÿ#@ €ê¿€þ¿P%9ìÿÿÿÿ#@ €ê¿€þ¿P &9 '9 (9 )9 ‚*9ÿ+9^* ‚,9 ‚-9 ‚.9 ‚/9 ‚09 ‚19 ‚29 ‚39 ‚49 ‚59ÿ69^* ‚79‚89'RETURN ON SALES (%)&299nmÙ=Ùá?÷¿'€÷¿W€÷¿'€ ; ;9&2<9L Õxé&ã?õ€'€õ€W€õ€'€ ; =9&2?9L Õxé&ã?ô€'€ô€W€ô€'€ ; @9 ‚A9‚B9^*ÿ:'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€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;* A€þ¿JJ€þ¿
;*
A€þ¿JJ€þ¿
;* A€þ¿JJ€þ¿
;* A€þ¿JJ€þ¿
;*
A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;*A€þ¿JJ€þ¿
;* A€þ¿JJ€þ¿
;*!A€þ¿JJ€þ¿
;*"A€þ¿JJ€þ¿
;*#A€þ¿JJ€þ¿
;*$A€þ¿JJ€þ¿
;*%A€þ¿JJ€þ¿
; &A 'A (A )A ‚*Aÿ+A^* ‚,A ‚-A ‚.A ‚/A ‚0A ‚1A ‚2A ‚3A ‚4A ‚5Aÿ6A^* ‚7A ‚8A ‚9A ‚:A ‚;A ‚<A ‚=A ‚>A ‚?A ‚@A ‚AA ‚BA GA HA IA 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 ‚0B ‚1B ‚2B ‚3B ‚4B ‚5Bÿ6B^* ‚7B ‚8B ‚9B ‚:B ‚;B ‚<B ‚=B ‚>B ‚?B ‚@B ‚AB ‚BB GB HB IBÿ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 ‚0C ‚1C ‚2C ‚3C ‚4C ‚5Cÿ6C^* ‚7C ‚8C ‚9C ‚:C ‚;C ‚<C ‚=C ‚>C ‚?C ‚@C ‚AC ‚BC GC HC IC 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 ‚0D ‚1D ‚2D ‚3D ‚4D ‚5Dÿ6D^* ‚7D ‚8D ‚9D ‚:D ‚;D ‚<D ‚=D ‚>D ‚?D ‚@D ‚AD ‚BD GD HD IDÿE'Ending Cash"Ei@€ú¿€ü¿ €þ¿
"E@üÿÿÿ?p@€ú¿€ü¿ €þ¿
"E@÷ÿÿÿ?u@€ú¿€ü¿ €þ¿
"EÀñÿÿÿ¿z@€ú¿€ü¿ €þ¿
"Eöÿÿÿ'€@€ú¿€ü¿ €þ¿
"EPóÿÿÿï‚@€ú¿€ü¿ €þ¿
"Eˆðÿÿÿ·…@€ú¿€ü¿ €þ¿
" EÀíÿÿÿˆ@€ú¿€ü¿ €þ¿
"
EøêÿÿÿG‹@€ú¿€ü¿ €þ¿
" E0èÿÿÿŽ@€ú¿€ü¿ €þ¿
" E´òÿÿÿk@€ú¿€ü¿ €þ¿
"
EPñÿÿÿϑ@€ú¿€ü¿ €þ¿
"Eìïÿÿÿ3“@€ú¿€ü¿ €þ¿
"Eˆîÿÿÿ—”@€ú¿€ü¿ €þ¿
"E$íÿÿÿû•@€ú¿€ü¿ €þ¿
"EÀëÿÿÿ_—@€ú¿€ü¿ €þ¿
"E\êÿÿÿØ@€ú¿€ü¿ €þ¿
"Eøèÿÿÿ'š@€ú¿€ü¿ €þ¿
"E”çÿÿÿ‹›@€ú¿€ü¿ €þ¿
"E0æÿÿÿïœ@€ú¿€ü¿ €þ¿
"EÌäÿÿÿSž@€ú¿€ü¿ €þ¿
"Ehãÿÿÿ·Ÿ@€ú¿€ü¿ €þ¿
"Eñÿÿÿ @€ú¿€ü¿ €þ¿
"EPðÿÿÿ?¡@€ú¿€ü¿ €þ¿
"Ežïÿÿÿñ¡@€ú¿€ü¿ €þ¿
"Eìîÿÿÿ£¢@€ú¿€ü¿ €þ¿
"E:îÿÿÿU£@€ú¿€ü¿ €þ¿
"Eˆíÿÿÿ¤@€ú¿€ü¿ €þ¿
"EÖìÿÿÿ¹¤@€ú¿€ü¿ €þ¿
"E$ìÿÿÿk¥@€ú¿€ü¿ €þ¿
" Erëÿÿÿ¦@€ú¿€ü¿ €þ¿
"!EÀêÿÿÿϦ@€ú¿€ü¿ €þ¿
""Eêÿÿÿ§@€ú¿€ü¿ €þ¿
"#Eæéÿÿÿ©§@€ú¿€ü¿ €þ¿
"$E¾éÿÿÿѧ@€ú¿€ü¿ €þ¿
"%E–éÿÿÿù§@€ú¿€ü¿ €þ¿
ÿ+E^* ‚,E ‚-E ‚.E ‚/E ‚0E ‚1E ‚2E ‚3E ‚4E ‚5Eÿ6E^* ‚7E ‚8E ‚9E ‚:E ‚;E ‚<E ‚=E ‚>E ‚?E ‚@E ‚AE ‚BE GE HE IE ‚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^*ÿ6F^* GF HF IFÿ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^*ÿ6G^* GG HG IGÿH^Variables ‚#H ‚$H ‚%H ‚&H ‚'H ‚(H ‚)H ‚*Hÿ+H^* ‚,H ‚-H ‚.H ‚/H ‚0H ‚1H ‚2H ‚3H ‚4H ‚5Hÿ6H^* ‚7H ‚8H ‚9H ‚:H ‚;H ‚<H ‚=H ‚>H ‚?H ‚@H ‚AH ‚BH GH HH IHÿI\*ÿI\*ÿI'******** ‚#I ‚$I ‚%I ‚&I ‚'I ‚(I ‚)I ‚*Iÿ+I^* ‚,I ‚-I ‚.I ‚/I ‚0I ‚1I ‚2I ‚3I ‚4I ‚5Iÿ6I^* ‚7I ‚8I ‚9I ‚:I ‚;I ‚<I ‚=I ‚>I ‚?I ‚@I ‚AI ‚BI GI HI IIÿ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 ‚0J ‚1J ‚2J ‚3J ‚4J ‚5Jÿ6J^* ‚7J ‚8J ‚9J ‚:J ‚;J ‚<J ‚=J ‚>J ‚?J ‚@J ‚AJ ‚BJ GJ HJ IJÿK^Mark_Up
2K‚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^*ÿ6K^* GK HK IK
ÿL^Frtpct
2L€™™™™©?‚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^*ÿ6L^* GL HL IL
ÿM^CommRt
2M€™™™™¹?‚M"* ‚#M ‚$M ‚%M ‚&M ‚'M ‚(M ‚)M ‚*Mÿ+M^* ‚,M ‚-M ‚.M ‚/M ‚0M ‚1M ‚2M ‚3M ‚4M ‚5Mÿ6M^* ‚7M ‚8M ‚9M ‚:M ‚;M ‚<M ‚=M ‚>M ‚?M ‚@M ‚AM ‚BM GM HM IMÿN' Beg Cash
NÈ‚N"* ‚#N ‚$N ‚%N ‚&N ‚'N ‚(N ‚)N ‚*Nÿ+N^* ‚,N ‚-N ‚.N ‚/N ‚0N ‚1N ‚2N ‚3N ‚4N ‚5Nÿ6N^* ‚7N ‚8N ‚9N ‚:N ‚;N ‚<N ‚=N ‚>N ‚?N ‚@N ‚AN ‚BN GN HN INÿ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 ‚0O ‚1O ‚2O ‚3O ‚4O ‚5Oÿ6O^* ‚7O ‚8O ‚9O ‚:O ‚;O ‚<O ‚=O ‚>O ‚?O ‚@O ‚AO ‚BO GO HO IO ‚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 ‚0P ‚1P ‚2P ‚3P ‚4P ‚5Pÿ6P^* ‚7P ‚8P ‚9P ‚:P ‚;P ‚<P ‚=P ‚>P ‚?P ‚@P ‚AP ‚BP GP HP IP ‚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\*ÿ0Q\*ÿ1Q\*ÿ2Q\*ÿ3Q\*ÿ4Q\*ÿ5Q\*ÿ6Q^* GQ HQ IQ'ÿ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^*ÿ6R^* GR HR IRÿS\*ÿS\*ÿS\*ÿS\*ÿS'*ÿ+S^*ÿ1S^INCOME STATEMENTÿ6S^* GS HS ISÿT^Principal ‚T
T'ÿT'*ÿ+T^*ÿ6T^* GT HT ITÿU^No. of Payments €U
UÿU'*ÿ+U^*ÿ6U^* GU HU IUÿV^Interest Rate ²V
2V…ëQ¸¾?ÿV'*ÿ+V^*ÿ1V^(000's)ÿ6V^* GV HV IVÿW^Payment ‚W WºÇ¹¤‰”@€ý¿€ÿ¿€þ¿8ÿW'*ÿ+W^*1W+—ðÏ¿´¿31WMy Companyÿ6W^* GW HW IWÿX\*ÿX\*ÿX\*ÿX\*ÿX'*ÿ+X^*ÿ6X^* GX HX IXÿY"*ÿ+Y^*ÿ6Y^* GY HY IYÿZ^RANGE NAMES & LOCATIONSÿZ"*ÿ&Z\*ÿ'Z\*ÿ(Z\*ÿ)Z\*ÿ*Z\*ÿ+Z^*
0Z"Year 1
1Z"Year 2
3Z"Year 3ÿ6Z^* GZ HZ IZÿ["*ÿ&['*ÿ+[^*ÿ-['Revenue:ÿ6[^*ÿ\'ASSET WORKSHEET\'AS1..BA19ÿ\"*ÿ&\'*ÿ(\^Statement Variablesÿ+\^*ÿ2\^%ÿ4\^%ÿ6\^*ÿ]'BALANCE SHEET]'AS148..BB195ÿ]"*ÿ&]'*ÿ+]^*ÿ-]' Gross Sales:0]À’@ Ò¿º¿Ý¿º¿P1]À’@ Ý¿º¿è¿º¿P-22]þ¿€ÿ¿€þ¿€
þ¿€ ;3]À’@ 翺¿ò¿º¿P-24]ý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6]^*ÿ^'BEG CASH
^'B79ÿ^"*ÿ&^'*ÿ'^'Returns
2(^ÿ+^^*#ÿ-^' Less returns, discounts0^ €ÿ¿(^ 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 Sales0`À’@ €ý¿€þ¿
1`À’@ €ý¿€þ¿
-22`þ¿€ÿ¿€þ¿€
þ¿€ ;3`À’@ €ý¿€þ¿
-24`ý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6`^*ÿa'CASH RESERVE
a'B75ÿa"*ÿ&a'*ÿ+a^* 0a 1a 22a 3a 24aÿ6a^*
ÿb'COMMRT
b'B78ÿb"*ÿ&b\*ÿ'b\*ÿ(b\*ÿ)b\*ÿ*b\*ÿ+b^*ÿ-b'Cost of Goods Sold: 0b 1b 22b 3b 24bÿ6b^*
ÿc'D&Bc'BD1..BM60ÿc"*ÿ+c^*ÿ-c' Beginning inventory
0c`R@1cÿ¿€-22cð¿þ¿€ÿ¿€þ¿€
þ¿€ ;3cþ¿€-24cðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6c^*ÿd'FED TAX d'AO97ÿd"*ÿ+d^*ÿ-d' Purchases0d Ò¿Å¿Ý¿Å¿P1d Ý¿Å¿è¿Å¿P-22dðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3d ç¿Å¿ò¿Å¿P-24dðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6d^*ÿe'FIRSTMONTH
e'B28ÿe"*ÿ+e^*ÿ-e' Freight0e Ò¿Å¿Ý¿Å¿P1e Ý¿Å¿è¿Å¿P-22eðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3e ç¿Å¿ò¿Å¿P-24eðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6e^*ÿf'FOURTHMONTH
f'B31ÿf"*ÿ+f^*!ÿ-f' Total goods available0f`R@ €ý¿€ÿ¿P1f €ý¿€ÿ¿P-22fð¿þ¿€ÿ¿€þ¿€
þ¿€ ;3f €ý¿€ÿ¿P-24fðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6f^*
ÿg'FRTPCT
g'B77ÿg"*ÿ+g^*ÿ-g' Ending inventory0g ݿ¿ݿÿ 1g è¿Â¿è¿Ã¿ -22gðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3g ò¿Â¿ò¿Ã¿ -24gðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6g^*ÿh'INCOME STATEMNTh'AS83..BB145ÿh"*ÿ+h^*ÿ-h'Total Cost of Goods Sold0h`R@ €þ¿€ÿ¿
1h €þ¿€ÿ¿
-22hð¿þ¿€ÿ¿€þ¿€
þ¿€ ;3h €þ¿€ÿ¿
-24hðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6h^*ÿi'INIT INVESTMNT i'CA19ÿi"*ÿ+i^* 0i 1i 22i 3i 24iÿ6i^*ÿj'INITIAL PRICE j'CA20ÿj"*ÿ+j^*ÿ-j'Gross Profit0jš‘@ €ö¿€þ¿
1jÀ’@ €ö¿€þ¿
-22j:ûÑèû³°?þ¿€ÿ¿€þ¿€
þ¿€ ;3jÀ’@ €ö¿€þ¿
-24jý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6j^*ÿk'MARK_UP
k'B76ÿk"*ÿ+k^* 0k 1k 22k 3k 24kÿ6k^*ÿl'MONTHSHIP
l'B27ÿl"*ÿ+l^*ÿ-l'Operating Expenses: 0l 1l 22l 3l 24lÿ6l^*ÿm'NO OF SHARES
m'CA9ÿm"*ÿ+m^* 0m 1m 22m 3m 24mÿ6m^*ÿn'OUTSIDE INVEST n'CA17ÿn"*ÿ+n^*ÿ-n'Selling Expenses 0n 1n 22n 3n 24nÿ6n^*ÿo'RATIO ANALYSISo'AS198..BB222ÿo"*ÿ+o^*ÿ-o' Advertising0o Ò¿À¿Ý¿À¿P1o Ý¿À¿è¿À¿P-22oðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3o ç¿À¿ò¿À¿P-24oðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6o^*ÿp'RETURNS p'AO95ÿp"*ÿ+p^*ÿ-p' Commissions0pâÿÿÿÿ]@ Ò¿Á¿Ý¿Á¿P1pâÿÿÿÿ]@ Ý¿Á¿è¿Á¿P-22pþ¿€ÿ¿€þ¿€
þ¿€ ;3pâÿÿÿÿ]@ ç¿Á¿ò¿Á¿P-24pý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6p^*
ÿq'RMAq'BP1..BW52ÿq"*ÿ+q^*ÿ-q' T & E0q ҿ¿ݿ¿P1q ݿ¿è¿Â¿P-22qðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3q ç¿Â¿ò¿Â¿P-24qðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6q^*ÿr'SECONDMONTH
r'B29ÿr"*ÿ+r^* ÿ-r'Total0râÿÿÿÿ]@ €ý¿€ÿ¿P1râÿÿÿÿ]@ €ý¿€ÿ¿P-22rþ¿€ÿ¿€þ¿€
þ¿€ ;3râÿÿÿÿ]@ €ý¿€ÿ¿P-24rý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6r^*ÿs'STATE TAX s'AO96ÿs"*ÿ+s^* 0s 1s 22s 3s 24sÿ6s^*ÿt'STATEMENT VARt'AN95..AO97ÿt"*ÿ+t^*ÿ-t'Administrative 0t 1t 22t 3t 24tÿ6t^*ÿu'STOCK ANALYSu'BY1..CF22ÿu"*ÿ+u^*ÿ-u' Salaries0u Ò¿±¿Ý¿±¿P1u Ý¿±¿è¿±¿P-22uðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3u 翱¿ò¿±¿P-24uðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6u^*ÿv'THIRDMONTH
v'B30ÿv"*ÿ+v^*ÿ-v' Payroll0v Ò¿±¿Ý¿±¿P1v Ý¿±¿è¿±¿P-22vðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3v 翱¿ò¿±¿P-24vðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6v^*ÿw'VARIABLESw'A73..C80ÿw"*ÿ+w^*ÿ-w' Withholding0w Ò¿±¿Ý¿±¿P1w Ý¿±¿è¿±¿P-22wðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3w 翱¿ò¿±¿P-24wðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6w^*ÿx"*ÿ+x^*ÿ-x' Insurance0x Ò¿º¿Ý¿º¿P1x Ý¿º¿è¿º¿P-22xðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3x 翺¿ò¿º¿P-24xðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6x^*ÿy\*ÿy\*ÿy\*ÿy\*ÿ+y^* ÿ-y'Total0y €ü¿€ÿ¿P1y €ü¿€ÿ¿P-22yðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3y €ü¿€ÿ¿P-24yðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6y^*ÿ+z^* 0z 1z 22z 3z 24zÿ6z^*ÿ+{^*ÿ-{'General 0{ 1{ 22{ 3{ 24{ÿ6{^*ÿ+|^*ÿ-|' Rent0| Ò¿§¿Ý¿§¿P1| Ý¿§¿è¿§¿P-22|ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3| 翧¿ò¿§¿P-24|ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6|^*ÿ+}^*ÿ-}' Utilities0} Ò¿§¿Ý¿§¿P1} Ý¿§¿è¿§¿P-22}ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3} 翧¿ò¿§¿P-24}ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6}^*ÿ+~^*ÿ-~' Telephone0~ Ò¿§¿Ý¿§¿P1~ Ý¿§¿è¿§¿P-22~ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3~ 翧¿ò¿§¿P-24~ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6~^*ÿ+^*ÿ-' Office Expenses0 Ò¿¬¿Ý¿¬¿P1 Ý¿¬¿è¿¬¿P-22ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3 翬¿ò¿¬¿P-24ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6^*ÿ+€^*ÿ-€' Vehicle Expenses0€ Ò¿¬¿Ý¿¬¿P1€ Ý¿¬¿è¿¬¿P-22€ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3€ 翬¿ò¿¬¿P-24€ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6€^*ÿ+^*ÿ-' Office Supplies0 Ò¿¬¿Ý¿¬¿P1 Ý¿¬¿è¿¬¿P-22ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3 翬¿ò¿¬¿P-24ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6^*ÿ+‚^*ÿ-‚' Postage0‚ Ò¿¬¿Ý¿¬¿P1‚ Ý¿¬¿è¿¬¿P-22‚ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3‚ 翬¿ò¿¬¿P-24‚ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6‚^*ÿ+ƒ^*ÿ-ƒ' Professionals0ƒ Ò¿­¿Ý¿­¿P1ƒ Ý¿­¿è¿­¿P-22ƒðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3ƒ ç¿­¿ò¿­¿P-24ƒðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6ƒ^*ÿ+„^*ÿ-„' Research0„ Ò¿°¿Ý¿°¿P1„ Ý¿°¿è¿°¿P-22„ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3„ ç¿°¿ò¿°¿P-24„ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6„^*ÿ+…^*ÿ-…' Misc.0… Ò¿°¿Ý¿°¿P1… Ý¿°¿è¿°¿P-22…ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3… ç¿°¿ò¿°¿P-24…ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6…^*ÿ+†^* ÿ-†'Total0† €ö¿€ÿ¿P1† €ö¿€ÿ¿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 Income0ŠÀ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 Income0‰kfffá@ €ý¿€þ¿
1 @ €ý¿€þ¿
-22ûÒɱ²?þ¿€ÿ¿€þ¿€
þ¿€ ;3 @ €ý¿€þ¿
-24ý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6^*ÿ+Ž^*ÿ-Ž' Federal Taxes)0Ž˜.
×£íq@€ÿ¿€ÿ¿(` ;)1Ž¶¼ÌÌÌ þ¿€ ;)3Ž¶¼ÌÌÌ ý¿€ ;ÿ6Ž^*ÿ+^* 0 1 22 3 24ÿ6^*ÿ+^*ÿ-'Net Income0=Táz”ê„@ €ý¿€þ¿
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¿31—My Companyÿ6—^*ÿ+˜^*ÿ6˜^*ÿ+™^*
0™"Year 1
1™"Year 2
3™"Year 3ÿ6™^*ÿ+š^*
ÿ-š'ASSETSÿ6š^*ÿ+›^*ÿ2›^%ÿ4›^%ÿ6›^*ÿ+œ^*ÿ-œ' Cash0œPñÿÿÿϑ@Ý¿©¿1œPðÿÿÿ?¡@è¿©¿-22œgÚsKœúí?þ¿€ÿ¿€þ¿€
þ¿€ ;3œ–éÿÿÿù§@ò¿©¿-24œ-xӛÞôØ?ý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6œ^*ÿ+^*ÿ-' Accounts Receivable90àîÿÿÿa@*Þ¿¿ß¿¿PÞ¿€¿á¿€¿P Þ¿¿â¿¿P Þ¿~¿ 91àÿÿÿÿ_@*é¿¿ê¿¿P鿀¿ë¿€¿P 鿁¿ì¿¿P é¿~¿ -22®Ë;àHÑ°¿þ¿€ÿ¿€þ¿€
þ¿€ ;93àÿÿÿÿ_@*ó¿¿ô¿¿P󿀿õ¿€¿P 󿁿ö¿¿P ó¿~¿ -24ý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6^*ÿ+ž^*ÿ-ž' Notes Receivable
0ž
1ž-22žðÿþ¿€ÿ¿€þ¿€
þ¿€ ;
3ž-24žðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6ž^*ÿ+Ÿ^*ÿ-Ÿ' Inventory0Ÿ€È¿1Ÿ€È¿-22Ÿðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3Ÿ€È¿-24Ÿðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6Ÿ^*ÿ+ ^* 0  1  3 ÿ6 ^*ÿ+¡^*ÿ-¡'Total Current Assets0¡,ïÿÿÿó“@ €û¿€þ¿P1¡Pïÿÿÿ?¢@ €û¿€þ¿P-22¡¶Â ¶…‰ê?þ¿€ÿ¿€þ¿€
þ¿€ ;3¡–èÿÿÿù¨@ €û¿€þ¿P-24¡hײe˖×?ý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6¡^*ÿ+¢^* 0¢ 1¢ 3¢ÿ6¢^*ÿ+£^*ÿ-£' Equipment0£$@€c¿1£$@ÿ¿c¿3£$@ý¿c¿ÿ6£^*ÿ+¤^* ÿ-¤' Less: accum. deprec.
0¤
1¤
3¤ÿ6¤^*ÿ+¥^* 0¥ 1¥ 3¥ÿ6¥^*ÿ+¦^*ÿ-¦' Net Fixed assets0¦$@ €ý¿€þ¿
1¦$@ €ý¿€þ¿
-22¦þ¿€ÿ¿€þ¿€
þ¿€ ;3¦$@ €ý¿€þ¿
-24¦ý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6¦^*ÿ+§^*ÿ-§' Intangible Assets0§€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 Liabilities0² €û¿€þ¿P1² €û¿€þ¿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 Liabilities0¶ €ü¿€þ¿ 1¶ €ü¿€þ¿ -22¶ðÿþ¿€ÿ¿€þ¿€
þ¿€ ;3¶ €ü¿€þ¿ -24¶ðÿý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6¶^*ÿ+·^* 0· 1· 3·ÿ6·^*ÿ+¸^*ÿ-¸'NET WORTH 0¸ 1¸ 3¸ÿ6¸^*ÿ+¹^* 0¹ 1¹ 3¹ÿ6¹^*ÿ+º^*ÿ-º' Paid in Capital0ºi@Ñ¿”¿1ºi@п”¿3ºi@ο”¿ÿ6º^*ÿ+»^*ÿ-»' Retained Earnings0»=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 Worth0¾,ïÿÿÿ”@ €ü¿€þ¿P1¾PïÿÿÿS¢@ €ü¿€þ¿P-22¾º‰š‘¼Tê?þ¿€ÿ¿€þ¿€
þ¿€ ;3¾–èÿÿÿ
©@ €ü¿€þ¿P-24¾ÇÖ¿
}×?ý¿€ÿ¿€ý¿€
ý¿€ ;ÿ6¾^*ÿ+¿^* 0¿ 1¿ 3¿ÿ6¿^*ÿ+À^*ÿ-À'TOTAL LIABILITIES & 0À 1À 3Àÿ6À^*ÿ+Á^*ÿ-Á' NET WORTH0Á,ïÿÿÿ”@ €õ¿€ý¿ 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¿31Ç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Þ^*

  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : BPD22.ZIP
Filename : BPDPROF.WK1

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. 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/