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