|
Page 1 of 2
<br />PREQUALIFICATION WORKSHEET
<br />PRINTED: 05/20/2021
<br />ACCOUNT #: 351120685
<br />VALID: 05/19/2021
<br />NAME: Milestone Contractors North, Inc.
<br />EXPIRES: 09/30/2022
<br />APPLICATION TYPE: New
<br />AUDITOR APPROVED: 05/12/2021
<br />FINANCIAL STATEMENT TYPE:
<br />Audit
<br />ANALYST APPROVED: 05/19/2021
<br />FINANCIAL STATEMENT DATE:
<br />12/31/2020
<br />PREQUALIFICATION APPROVED: 05/20/2021
<br />CURRENTFIXED EQUIPMENT
<br />-----------------
<br />ASSETS REPORTED
<br />$45,301,075.00 $11,290,806.00 $32,767,124.00
<br />COMPONENT"
<br />RATING
<br />LIABILITIES REPORTED
<br />$15,307,087.00 $16,142,099.00
<br />- - - - - -
<br />- . . . . . . .. . . . . :::: . : . : . . . .
<br />--------------------------------------
<br />NET ASSETS REPORTED
<br />----- --- -- - -------- — ---- ----.- ------
<br />$29,993,988.00 $(4,851,293.00) $32,767,124.00
<br />CURRENT
<br />$279,489,810.00
<br />----- - ------"------
<br />FIXED
<br />$10,540,314.00
<br />NET FIXED ASSETS
<br />$0.00
<br />EQUIPMENT
<br />$262,136,992.00
<br />NET FIXED ASSETS EQUIPMENT $0.00
<br />-------------------------------------- -- - - - ------
<br />- - - - - - - - - - -
<br />MAXIMUM BALANCE
<br />- . - - - - " - -
<br />$552,167,116.00
<br />NET ACCEPTABLE ASSETS
<br />$27,948,981.00 $5,270,157.00 $32,767,124.00
<br />= = = _ = : " " " " "
<br />STATEMENT TYPE
<br />Audit
<br />RATING FACTORS
<br />X110 X2 X8
<br />::.::::---------------------------------------------------------------
<br />----------
<br />EXPER. REDUCTION
<br />0.00%
<br />RATING COMPONENTS
<br />$279,489,810.00 $10,540,314.00 $262,136,992.00
<br />AGG. BIDDING CAPACITY $552,167,000.00
<br />X 1.5 _ $262,136,992.00
<br />-"""""""""""""""""""-"
<br />MAXIMUM EQUIPMENT $419,234,715.00 $0.00
<br />8
<br />$262,136,992.00 $0.00
<br />+ $279,489,810.00
<br />+ $5,270,157.00
<br />--------------- --------- -- -----
<br />$541,626,802.00 $5,270,157.00
<br />X 0.25X 2
<br />----------------- ---------------
<br />MAXIMUM
<br />FIXED $135,406,701.00 ADJUSTED FIX. $10,540,314.00
<br />-------------------- --------- - - -- ----- - ..........
<br />BALANCE SHEET ANALYSIS
<br />CURRENTASSETS:
<br />$45,301,075.00 CURRENTRATIO:
<br />2.96
<br />INVENTORY:
<br />--------------------
<br />$5,215,421.00 QUICK RATIO:
<br />----------------- -------
<br />2.62
<br />CURRENT LIABILITIES:
<br />$15,307,087.00 WORKING CAPITAL:
<br />$29,993,988.00
<br />---- ----- - — - — ------ - --
<br />LONG TERM LIABILITIES:
<br />-- -- ---- -- -- - --------------------- -
<br />$16,142,099.00 DEBIT/ NET WORTH:
<br />---- - ---------------------------
<br />0.54
<br />-------------------- - --
<br />NET WORTH:
<br />------------- . ...................... .
<br />$57,909,819.00 ACCOUNTS RECEIVABLE TURNOVER:
<br />------ - -- -- ---
<br />------------- -
<br />8.63
<br />--------- ------ -
<br />TOTAL LIABILITIES:
<br />-----------------
<br />-------------- - ---------------------------------------
<br />$31,449,186.00 ACCOUNTS RECEIVABLEITOTAL CURRENTASSETS:
<br />--------------- ------ --------- - ---- ---- ------ — ----
<br />-- ---- ---- -.
<br />------ -- --- ----
<br />-----•
<br />0.38
<br />.. .... -----
<br />ACCOUNTS PAYABLE/TOTAL CURRENT LIABILITIES:0.30
<br />------ -
<br />-----
<br />RECEIVABLES/PAYABLES:
<br />3.74
<br />DAYS IN ACCOUNTS RECEIVABLE:
<br />- -------- --- -- -- -------------------------------------
<br />42.27
<br />ADJUSTMENTS
<br />Line Item
<br /># - Description
<br />Adjustment Amount
<br />Current
<br />Fixed
<br />Equipment
<br />11 Detail is not Clear
<br />$(38,221.00)
<br />$0.00
<br />$0.00
<br />16 Omit Goodwill
<br />$0.00
<br />$(1,138,640.00)
<br />$0.00
<br />17 Due after 24 Months
<br />$0.00
<br />$12,033,636.00
<br />$0.00
<br />99 Omit Affiliates
<br />$(2,780,332.00)
<br />99 Reclassify to Current
<br />$1,274,516.00
<br />$(1,274,516.00)
<br />99 To 16 Long Term
<br />$(500,970.00)
<br />$500,970.00
<br />Page 1 of 2
<br />
|