PREQUALIFICATION WORKSHEET
<br />ACCT: #35-1120685 ALT ACCT: # 0449 NEW? SUPP?
<br />NAME: WALSH & KELLY INC
<br />December 31, 2019
<br />ASSETS REPORTED
<br />LIABILITIES REPORTED
<br />NET ASSETS REPORTED
<br />09 OMIT NO DETAIL OR QUANTITY
<br />11 OMIT NO DETAIL
<br />15 CASH SURRENDER VALUE
<br />16 OMIT INTANGIBLES
<br />22 DUE AFTER 24 MONTHS
<br />NET FIXED ASSETS
<br />NET FIXED ASSETS EQUIPMENT
<br />NET ACCEPTABLE ASSETS
<br />RATING FACTORS
<br />--------------------------------------------
<br />- ------------------------------------------
<br />RATING COMPONENTS
<br />CURRENT FIXED EQUIPMENT
<br />------------------------------------------------------------ --------------------
<br />$47,119,378.00 $10,219,627.00 $31,032,017.00
<br />($16,158,151.00) ($16,742,213.00)
<br />$30,961,227.00 ($6,522,586.00) $31,032,017.00
<br />MAXIMUM EQUIPMENT
<br />MAXIMUM FIXED
<br />($4,016,185.00)
<br />$0.00
<br />$0.00
<br />($277,917.00)
<br />$0.00
<br />$0.00
<br />$1,390,248.00
<br />($1,390,248.00)
<br />$0.00
<br />$0.00
<br />($864,210.00)
<br />$0.00
<br />$0.00
<br />$13,536,060.00
<br />$0.00
<br />LONG TERM LIABILITIES:
<br />--------------------------------------------------------------
<br />$16,742,213
<br />$0
<br />$0
<br />NET WORTH:
<br />--------------------------------------------------------------
<br />$55,470,656
<br />$28,057,373
<br />$4,759,016
<br />$31,032,017
<br />X 10
<br />X 2
<br />X 8
<br />------------------ —
<br />$280,573,730
<br />$280,573,730
<br />------ ---------------------
<br />-----------------
<br />$9,518,032
<br />$248,256,136
<br />X 1.5
<br />_
<br />$248,256,136
<br />$420,860,595
<br />$0
<br />8.00
<br />$248,256,136
<br />$0
<br />+ $280,573,730
<br />+
<br />---------------
<br />$4,759,016
<br />--------
<br />$528,829,866
<br />$4,759,016
<br />X 0.25
<br />X 2
<br />$132,207,467
<br />--------------------------
<br />ADJ. FIXED
<br />-------------------
<br />$9,518,032
<br />---- -
<br />NOTES:
<br />PRINTED:
<br />BALANCE SHEET ANALYSIS
<br />----------------------------------------
<br />PQA APPROVED:
<br />CURRENT ASSETS:
<br />$47,119,378
<br />----------- ---- --
<br />CURRENT RATIO:
<br />----------------------------------------------
<br />2.916
<br />INVENTORY:
<br />-----------------------------------
<br />$4,016,185
<br />---------------------------
<br />QUICK RATIO:
<br />-------------------------------------------
<br />2.668
<br />CURRENT LIABILITIES:
<br />--------------------------------------------------------------
<br />$16,158,151
<br />WORKING CAPITAL:
<br />------ — ---------------------------------------
<br />$30,961,227
<br />LONG TERM LIABILITIES:
<br />--------------------------------------------------------------
<br />$16,742,213
<br />DEBT/NET WORTH:
<br />0.593
<br />NET WORTH:
<br />--------------------------------------------------------------
<br />$55,470,656
<br />$50,000,000
<br />E(E)
<br />TOTAL LIABILITIES:
<br />$32,900,364
<br />$50,000,000
<br />A(B)
<br />NOTES:
<br />PRINTED:
<br />5/21/2020
<br />PQA APPROVED:
<br />5/7/2002A0
<br />APPROVED BY:
<br />$9,518,032.00
<br />DATE:
<br />5/21/2020
<br />VALID: 5/21/2020
<br />EXPIRES: 4/30/2021
<br />DENIAL DATE:
<br />DENIAL REASON:
<br />COMPONENT
<br />RATING
<br />----------------------------------
<br />CURRENT
<br />— ---------------------
<br />$280,573,730.00
<br />FIXED
<br />$9,518,032.00
<br />EQUIPMENT
<br />$248,256,136.00
<br />MAXIMUM BALANCE
<br />---------------------------------------------------------
<br />$538,347,898.00
<br />STATEMENT TYPE:
<br />AUDITED
<br />EXPER. REDUCTION
<br />0%
<br />AGGREGATE
<br />UNLIMITED
<br />C(B)
<br />UNLIMITED
<br />B(A)
<br />UNLIMITED
<br />E(F)
<br />$50,000,000
<br />E(E)
<br />$25,000,000
<br />E(R)
<br />$50,000,000
<br />A(B)
<br />$25,000,000
<br />E(Q)
<br />$25,000,000
<br />E(H)
<br />$25,000,000
<br />E(G)
<br />$25,000,000
<br />
|