Excel project

profileneed-help101
SigmaBankV7.xlsx
Home>Information Systems homework help>Excel project

SQ1

EOD_DATE Loan_Number NET_AVAILABLE_CREDIT PRINCIPAL PRINCIPAL_PARTICIPATION NON_ACCRUAL_PAID_INTEREST CUMULATIVE_CHARGE_OFFS DEFERRED_ORIGINATION_FEES MATURITY_DATE TDR_STATUS TDR_DATE NON_ACCRUAL_STATUS NON_ACCRUAL_DATE RISK_RATING DAYS_DELINQUENT RATE_INDEX COUPON_INTEREST_RATE OBLIGOR_NUMBER FACILITY_TYPE NAICS_CODE Group ADDRESS2 ADDRESS3 CITY STATE ZIPCODE LOAN_ORIG_AMT LAST_RENEWAL_DATE LAST_EXTNSN_DATE NO_OF_RENEWALS LOAN_PURPOSE INTEREST_RATE_INDEX INTEREST_RATE_SPREAD BORRWR_RATING_DATE SHARED_NATIONAL_CREDIT GUARANTOR_NAME LOAN_TYPE COLLATERAL_DESCRIPTION PAYMENT_FREQUENCY INT_RATE_RESET_INTRVL LAST_PYMNT_DATE STAGE INDUSTRY_GROUP PCI_PURCHASE_DISCOUNT NON_PCI_PURCHASE_PREM_OR_DISCT PCI_ALLL_RESERVE IMPAIRMENT_STATUS IMPAIRMENT_DATE PURCHASED_CREDIT_IMPAIRED CALL_REPORT_CODE UNDERWRITING_SECTION FOREIGN_LOAN UG CRC LOCK LOCK_ID AS_OF_DATE_ID RECORDED_INVESTMENT
12/31/17 SQ1-00009886 0 0 0 0 0 NULL Monday, May 27, 2019 N NULL N NULL 30 NULL Y 5.5 F1641 Y 523910 Equity Funds Group NULL NULL NY NY 10022 10/3/13 6/5/18 12/8/06 7 WORKING CAPITAL PRIME RATE 12/29/1899 5/17/18 N NULL SECURED LOANS NULL MONTHLY Daily 11/17/08 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00009121 0 1300000 NULL 0 0 NULL Sunday, August 18, 2019 N NULL N NULL 30 NULL Y 5.5 F2024 Y 523910 Equity Funds Group NULL NULL BOSTON MA 2210 2/19/66 8/20/18 8/28/07 7 WORKING CAPITAL PRIME RATE 12/31/99 7/30/18 N NULL SECURED LOANS CAPITAL CALL RIGHTS MONTHLY Daily 3/1/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 1,300,000.00
12/31/17 SQ1-00002253 0 15087333.34 NULL 0 0 NULL Thursday, March 12, 2020 N NULL N NULL 30 NULL Y 5.5 15308 Y 562910 Portfolio NULL NULL DURHAM NC 27712 2/27/95 2/26/19 10/23/08 7 WORKING CAPITAL PRIME RATE 12/31/99 2/20/19 N NULL SECURED LOANS BLANKET LIEN NEGATIVE PLEDGE MONTHLY Daily 2/28/19 EXPANSION STAGE INDUSTRIAL - ENERGY 0 0 0 N NULL N 4A 2-V.C N 2-V.C NULL 0 NULL NULL 15,087,333.34
12/31/17 SQ1-00003412 0 0 0 0 0 NULL Tuesday, January 21, 2020 N NULL N NULL 30 NULL Y 5.5 F1709 Y 523910 Equity Funds Group NULL NULL WOODSIDE CA 94062 11/26/26 1/28/19 11/20/08 9 WORKING CAPITAL PRIME RATE 12/31/99 1/18/19 N NULL SECURED LOANS BLANKET LIEN W/ CAPITAL CALL RIGHTS MONTHLY Daily 2/24/14 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00008871 0 0 NULL 0 0 NULL Saturday, November 14, 2020 N NULL N NULL 30 NULL Y 5.5 10935 Y 541219 Portfolio 3RD FLOOR NULL FAIRFIELD CT 6824 6/5/53 11/15/18 1/7/09 8 WORKING CAPITAL PRIME RATE 12/31/99 3/20/19 N NULL SECURED LOANS BLANKET LIEN W/NEGATIVE IP MONTHLY Daily 5/11/15 LATER STAGE BUSINESS PRODUCTS AND SERVICES 0 0 0 N NULL N 4A 2-V.D N 2-V.D NULL 0 NULL NULL - 0
12/31/17 SQ1-00007969 0 0 0 0 0 NULL Monday, May 27, 2019 N NULL N NULL 30 NULL Y 5.5 F1641 Y 523910 Equity Funds Group NULL NULL NY NY 10022 8/16/51 6/5/18 3/12/09 9 WORKING CAPITAL PRIME RATE 12/31/99 5/17/18 N NULL SECURED LOANS NULL MONTHLY Daily 7/2/14 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00004180 11118.38 0 NULL 0 0 NULL Monday, April 22, 2019 N NULL N NULL 30 NULL N 0 F2122 Y 523910 Equity Funds Group NULL NULL CABIN JOHN MD 20818 4/2/02 2/26/15 4/17/09 4 LETTER OF CREDIT NULL 12/31/99 4/5/18 N NULL FINANCE LETTER OF CR BLANLET LIEN NULL NULL 6/1/18 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00003364 0 0 0 0 0 NULL Thursday, June 27, 2019 N NULL N NULL 30 NULL Y 5.5 F2109 N 523910 Equity Funds Group NULL NULL NEW YORK NY 10036 5/6/65 7/16/18 6/10/09 7 WORKING CAPITAL PRIME RATE 12/31/99 9/12/18 N NULL SECURED LOANS BLANLET LIEN MONTHLY Daily 3/1/16 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00002864 0 0 NULL NULL 0 NULL Monday, April 22, 2019 N NULL N NULL 30 NULL Y 5.5 F2122 Y 523910 Equity Funds Group NULL NULL CABIN JOHN MD 20818 1/10/16 4/23/18 6/29/09 8 WORKING CAPITAL PRIME RATE 1/1/00 4/5/18 N NULL SECURED LOANS BLANLET LIEN MONTHLY Daily 6/5/18 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00007847 0 98739.78 NULL NULL 0 NULL Tuesday, November 01, 2039 N NULL N NULL 30 NULL N 7 16358 N 531110 Portfolio NULL NULL ANDERSON SC 29624 10/21/08 NULL 10/30/09 0 DEBT REFINANCE NULL 12/31/99 11/8/07 N NULL SECURED LOANS OTHER MONTHLY NULL 3/15/19 LATER STAGE OTHER 0 0 0 N NULL N 1D 3-D N 3-D NULL 0 NULL NULL 98,739.78
12/31/17 SQ1-00005358 0 0 NULL NULL 0 NULL Monday, May 27, 2019 N NULL N NULL 30 NULL Y 5.5 F4038 Y 523910 Equity Funds Group NULL NULL NEW YORK NY 10022 8/8/73 6/19/18 12/14/09 8 WORKING CAPITAL PRIME RATE 12/31/99 5/17/18 N NULL SECURED LOANS OTHER MONTHLY Daily 2/1/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00006412 374314.67 0 NULL NULL 0 NULL Tuesday, December 31, 2019 N NULL N NULL 20 NULL N 0 F2299 Y 523910 Equity Funds Group NULL NULL NEW YORK NY 10036 10/31/24 5/22/15 12/15/09 4 LETTER OF CREDIT NULL 12/31/99 4/30/18 N NULL FINANCE LETTER OF CR BLANKET LIEN IP NULL NULL 1/3/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00004720 0 2200000 NULL NULL 0 NULL Thursday, March 28, 2019 N NULL N NULL 40 1 Y 5.5 F2579 N 523910 Equity Funds Group SUITE 1801 NULL NEW YORK NY 10017 12/17/69 10/4/18 4/9/10 8 WORKING CAPITAL PRIME RATE 12/31/99 8/20/18 N NULL SECURED LOANS CAPITAL CALL RIGHTS MONTHLY Daily 3/28/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 2,200,000.00
12/31/17 SQ1-00005421 0 4000000 NULL NULL 0 NULL Saturday, August 31, 2019 N NULL N NULL 40 NULL Y 5.5 16708 Y 621111 Portfolio NULL NULL PITTSBURGH PA 15222 7/22/71 6/25/18 9/3/10 9 WORKING CAPITAL PRIME RATE 1/2/00 1/10/19 N NULL SECURED LOANS BLANKET LIEN W/NEGATIVE IP MONTHLY Daily 3/20/19 LATER STAGE HEALTHCARE SERVICES 0 0 0 N NULL N 4A 2-V.D N 2-V.D NULL 0 NULL NULL 4,000,000.00
12/31/17 SQ1-00001546 0 0 NULL NULL 0 NULL Sunday, July 28, 2019 N NULL N NULL 30 NULL Y 5.5 F0231 N 523910 Equity Funds Group NULL NULL PRINCETON NJ 8540 11/24/36 7/31/18 10/22/10 9 WORKING CAPITAL PRIME RATE 1/1/00 12/20/18 N NULL SECURED LOANS EQUITY FUNDS GROUP MANAGEMENT FEES MONTHLY Daily 1/4/16 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00006318 0 450000 NULL NULL 0 NULL Tuesday, September 10, 2019 N NULL N NULL 40 NULL Y 5.5 18523 Y 339920 Portfolio NULL NULL SANTA CLARA CA 95050 9/7/10 8/20/18 12/23/10 7 WORKING CAPITAL PRIME RATE 1/2/00 2/12/19 N NULL SECURED LOANS BLANKET LIEN W/NEGATIVE IP MONTHLY Daily 3/1/19 EXPANSION STAGE SOFTWARE 0 0 0 N NULL N 4A 2-V.C N 2-V.C NULL 0 NULL NULL 450,000.00
12/31/17 SQ1-00008843 0 6350000 NULL NULL 0 NULL Thursday, February 13, 2020 N NULL N NULL 40 NULL Y 5.5 16949 Y 541519 Portfolio NULL NULL ST. LOUIS MO 63119 4/6/58 2/14/19 12/28/10 9 WORKING CAPITAL PRIME RATE 1/1/00 3/27/19 N NULL SECURED LOANS CASH-SQUARE 1 BANK MONTHLY Daily 3/1/19 LATER STAGE ELECTRONICS/ INSTRUMENTATION 0 0 0 N NULL N 4A 2-V.D N 2-V.D NULL 0 NULL NULL 6,350,000.00
12/31/17 SQ1-00008490 0 15000000 NULL NULL 0 NULL Tuesday, July 28, 2020 N NULL N NULL 40 NULL Y 5.5 7570 Y 518210 Portfolio NULL NULL BROOMFIELD CO 80021 5/22/03 8/18/17 1/10/11 5 WORKING CAPITAL PRIME RATE 12/31/99 3/13/19 N NULL SECURED LOANS BLANKET LIEN NEGATIVE PLEDGE MONTHLY Daily 3/1/19 EXPANSION STAGE IT SERVICES 0 0 0 N NULL N 4A 2-V.C N 2-V.C NULL 0 NULL NULL 15,000,000.00
12/31/17 SQ1-00003929 0 0 NULL NULL 0 NULL Friday, May 24, 2019 N NULL N NULL 30 NULL Y 5.5 18533 Y 522292 Portfolio SUITE 50 NULL TREVOSE PA 19053 5/3/02 6/4/18 1/11/11 6 WORKING CAPITAL PRIME RATE 1/1/00 3/20/19 N NULL SECURED LOANS CASH-SQUARE 1 BANK MONTHLY Daily NULL EXPANSION STAGE SOFTWARE 0 0 0 N NULL N 4A 2-V.C N 2-V.C NULL 0 NULL NULL - 0
12/31/17 SQ1-00003723 0 88653.57 NULL NULL 0 NULL Saturday, February 17, 2029 N NULL N NULL 30 NULL N 6.25 18836 N 531110 Portfolio NULL NULL LYNCHBURG VA 24501 10/14/73 NULL 2/17/11 0 DEBT REFINANCE NULL 12/31/99 5/29/09 N NULL SECURED LOANS OTHER MONTHLY NULL 3/15/19 LATER STAGE OTHER 0 0 0 N NULL N 1D 3-D N 3-D NULL 0 NULL NULL 88,653.57
12/31/17 SQ1-00009811 0 469440 0 0 0 NULL Tuesday, April 09, 2019 N NULL N NULL 40 NULL Y 5.5 F2147 Y 523910 Equity Funds Group NULL NULL CHARLOTTESVILLE VA 22902 5/22/33 4/10/18 3/25/11 8 WORKING CAPITAL PRIME RATE 12/31/99 3/13/19 N NULL SECURED LOANS BLANLET LIEN MONTHLY Daily 3/1/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 469,440.00
12/31/17 SQ1-00007039 0 180650 0 0 0 NULL Tuesday, April 09, 2019 N NULL N NULL 40 NULL Y 5.5 F2335 Y 523910 Equity Funds Group NULL NULL CHARLOTTESVILLE VA 22902 7/1/97 4/10/18 3/25/11 8 WORKING CAPITAL PRIME RATE 12/31/99 3/19/18 N NULL SECURED LOANS BLANLET LIEN MONTHLY Daily 3/1/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 180,560.00
12/31/17 SQ1-00005806 43968.75 0 NULL 0 0 NULL Monday, September 30, 2019 N NULL N NULL 10 NULL N 0 18295 Y 512290 Portfolio NULL NULL NEW YORK NY 10003 2/26/87 10/1/18 4/19/11 9 LETTER OF CREDIT NULL 12/31/99 12/21/18 N NULL FINANCE LETTER OF CR CASH-SQUARE 1 BANK NULL NULL 10/1/18 EXPANSION STAGE CONSUMER PRODUCTS AND SERVICES 0 0 0 N NULL N 4A 2-V.C N 2-V.C NULL 0 NULL NULL - 0
12/31/17 SQ1-00007109 26398.25 0 NULL 0 0 NULL Tuesday, April 30, 2019 N NULL N NULL 10 NULL N 0 14041 Y 334510 Portfolio NULL NULL DURHAM NC 27713 4/9/72 4/27/18 4/21/11 7 LETTER OF CREDIT NULL 12/31/99 6/4/18 N NULL FINANCE LETTER OF CR BLANKET LIEN IP NULL NULL 4/30/18 EXPANSION STAGE MEDICAL DEVICES AND EQUIPMENT 0 0 0 N NULL N 4A 2-V.C N 2-V.C NULL 0 NULL NULL - 0
12/31/17 SQ1-00001552 0 3124457 NULL 0 0 NULL Monday, April 01, 2019 N NULL N NULL 50 -3 Y 5.5 17058 Y 518210 Portfolio NULL NULL MCKINNEY TX 75070 9/11/11 3/30/18 5/6/11 8 WORKING CAPITAL PRIME RATE 12/31/99 3/18/19 N NULL SECURED LOANS BLANKET LIEN IP MONTHLY Daily 3/1/19 LATER STAGE IT SERVICES 0 0 0 N NULL N 4A 2-V.D N 2-V.D NULL 0 NULL NULL 3,124,457.00
12/31/17 SQ1-00003045 0 0 NULL 0 0 NULL Saturday, October 19, 2019 N NULL N NULL 30 NULL Y 5.5 F2668 Y 523910 Equity Funds Group NULL NULL BALA CYNWYD PA 190041706 11/5/05 10/22/18 5/10/11 9 WORKING CAPITAL PRIME RATE 12/31/99 10/3/18 N NULL SECURED LOANS CAPITAL CALL RIGHTS MONTHLY Daily 1/2/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00004187 0 700000 NULL 0 0 NULL Friday, July 12, 2019 N NULL N NULL 40 NULL Y 5.5 15010 Y 511210 Portfolio NULL NULL SAN DIEGO CA 92127 10/14/73 7/19/18 7/12/11 5 WORKING CAPITAL PRIME RATE 1/1/00 2/12/19 N NULL SECURED LOANS BLANKET LIEN W/NEGATIVE IP MONTHLY Daily 3/1/19 LATER STAGE SOFTWARE 0 0 0 N NULL N 4A 2-V.D N 2-V.D NULL 0 NULL NULL 700,000.00
12/31/17 SQ1-00008537 0 0 NULL 0 0 NULL Wednesday, June 12, 2019 N NULL N NULL 30 NULL Y 5.5 F2434 N 523910 Equity Funds Group NULL NULL NORTHBROOK IL 60062 8/24/80 6/30/16 7/19/11 5 WORKING CAPITAL PRIME RATE 12/31/99 6/18/18 N NULL SECURED LOANS BLANKET LIEN W/ CAPITAL CALL RIGHTS MONTHLY Daily 10/10/14 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00005601 0 89395.25 NULL 0 0 NULL Saturday, July 20, 2041 N NULL N NULL 30 NULL N 6.25 19919 N 531110 Portfolio NULL NULL N CHARLESTON SC 29405 10/14/73 NULL 7/20/11 0 DEBT REFINANCE NULL 12/31/99 8/25/09 N NULL SECURED LOANS OTHER MONTHLY NULL 3/15/19 LATER STAGE OTHER 0 0 0 N NULL N 1D 3-D N 3-D NULL 0 NULL NULL 89,395.25
12/31/17 SQ1-00008445 0 1654411.76 NULL 438504.09 1165389.39 NULL Tuesday, December 31, 2019 Y 7/17/18 Y 3/1/17 80 NULL Y 5.5 12266 N 325411 Portfolio SUITE150 NULL SAN DIEGO CA 92130 11/26/37 12/26/17 7/27/11 7 WORKING CAPITAL PRIME RATE 1/1/00 12/4/18 N NULL SECURED LOANS FOREIGN COLLATERAL MONTHLY Daily 3/1/19 EARLY STAGE BIOTECH 0 0 0 Y 3/31/17 N 4A 2-V.B N 2-V.B NULL 0 NULL NULL 50,518.28
12/31/17 SQ1-00009008 0 750000 NULL 0 0 NULL Monday, August 05, 2019 N NULL N NULL 30 NULL Y 5.5 F3033 Y 523910 Equity Funds Group NULL NULL BOSTON MA 2110 8/11/58 8/6/18 8/17/11 7 WORKING CAPITAL PRIME RATE 12/31/99 7/12/18 N NULL SECURED LOANS ASSIGN CAPITAL CALL MONTHLY Daily 5/10/18 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 750,000.00
12/31/17 SQ1-00009931 0 0 NULL 0 0 NULL Sunday, May 27, 2018 N NULL N NULL 30 NULL Y 5.5 F3140 Y 523910 Equity Funds Group NULL NULL NEW YORK NY 10022 5/25/11 6/5/18 9/27/11 7 CAPITAL CALL PRIME RATE 12/29/1899 5/17/18 N NULL SECURED LOANS CAPITAL CALL RIGHTS MONTHLY Daily 8/1/18 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00004271 0 0 NULL 0 0 NULL Monday, June 03, 2019 N NULL N NULL 20 NULL Y 5.5 F3231 Y 523910 Equity Funds Group 28TH FLOOR NULL NEW YORK NY 10017 8/7/68 6/5/18 9/30/11 6 WORKING CAPITAL PRIME RATE 12/31/99 5/24/18 N NULL SECURED LOANS BLANLET LIEN MONTHLY Daily 10/2/17 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00008429 0 0 NULL 0 0 NULL Sunday, July 28, 2019 N NULL N NULL 30 NULL Y 5.5 F0231 Y 523910 Equity Funds Group NULL NULL PRINCETON NJ 8540 3/25/60 7/31/18 10/4/11 9 WORKING CAPITAL PRIME RATE 1/1/00 12/20/18 N NULL SECURED LOANS EQUITY FUNDS GROUP MANAGEMENT FEES MONTHLY Daily 6/1/18 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00006303 0 94000 NULL 0 0 NULL Sunday, June 30, 2019 N NULL N NULL 30 NULL Y 5.5 F3070 Y 523910 Equity Funds Group SUITE 204 NULL CHARLESTON SC 29401 12/15/74 7/3/18 10/26/11 6 WORKING CAPITAL PRIME RATE 12/31/99 6/28/18 N NULL SECURED LOANS CAPITAL CALL RIGHTS MONTHLY Daily 3/1/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 94,000.00
12/31/17 SQ1-00009806 0 3800000 NULL 0 0 NULL Friday, May 24, 2019 N NULL N NULL 30 NULL Y 5.5 F2748 Y 523910 Equity Funds Group SUITE 930 NULL ATLANTA GA 30342 1/1/36 5/29/18 11/3/11 6 CAPITAL CALL PRIME RATE 1/1/00 5/7/18 N NULL SECURED LOANS BLANLET LIEN MONTHLY Daily 3/1/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 3,800,000.00
12/31/17 SQ1-00001266 0 300000 NULL 0 0 NULL Saturday, October 19, 2019 N NULL N NULL 30 NULL Y 5.5 F2939 Y 523910 Equity Funds Group NULL NULL BALA CYNWYD PA 19004 10/23/75 10/22/18 12/23/11 8 CAPITAL CALL PRIME RATE 12/31/99 10/3/18 N NULL SECURED LOANS CAPITAL CALL RIGHTS MONTHLY Daily 1/2/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 300,000.00
12/31/17 SQ1-00005665 0 242203.98 NULL 0 0 NULL Friday, April 12, 2019 N NULL N NULL 40 NULL Y 5.5 10797 Y 519190 Portfolio NULL NULL AUSTIN TX 78758 10/10/64 4/17/18 1/6/12 9 WORKING CAPITAL PRIME RATE 1/1/00 3/7/19 N NULL SECURED LOANS BLANKET LIEN IP MONTHLY Daily 3/1/19 EXPANSION STAGE ELECTRONICS/ INSTRUMENTATION 0 0 0 N NULL N 4A 2-V.C N 2-V.C NULL 0 NULL NULL 242,203.98
12/31/17 SQ1-00006501 0 225000 NULL 0 0 NULL Monday, June 24, 2019 N NULL N NULL 40 NULL Y 5.5 20651 Y 541519 Portfolio NULL NULL SAN DIEGO CA 92127 11/12/02 6/29/18 1/20/12 6 WORKING CAPITAL PRIME RATE 1/1/00 1/31/19 N NULL SECURED LOANS STOCK/EQUITY SECURITIES MONTHLY Daily 3/5/19 LATER STAGE SOFTWARE 0 0 0 N NULL N 4A 2-V.D N 2-V.D NULL 0 NULL NULL 225,000.00
12/31/17 SQ1-00007882 0 2500000 NULL 0 0 NULL Friday, March 22, 2019 N NULL N NULL 30 7 Y 5.5 16672 Y 561440 Portfolio NULL NULL WILMINGTON DE 19801 5/15/21 10/24/18 1/30/12 6 WORKING CAPITAL PRIME RATE 1/1/00 3/20/19 N NULL SECURED LOANS STOCK/EQUITY SECURITIES MONTHLY Daily 3/22/19 EXPANSION STAGE BUSINESS PRODUCTS AND SERVICES 0 0 0 N NULL N 4A 2-V.C N 2-V.C NULL 0 NULL NULL 2,500,000.00
12/31/17 SQ1-00007803 0 1200000 NULL 0 0 NULL Sunday, June 30, 2019 N NULL N NULL 30 NULL Y 5.5 8433 Y 561110 Portfolio NULL NULL SANDY UT 84094 6/21/84 7/26/18 2/14/12 9 WORKING CAPITAL PRIME RATE 1/1/00 2/5/19 N NULL SECURED LOANS BLANKET LIEN NEGATIVE PLEDGE MONTHLY Daily 3/1/19 LATER STAGE SOFTWARE 0 0 0 N NULL N 4A 2-V.D N 2-V.D NULL 0 NULL NULL 1,200,000.00
12/31/17 SQ1-00007588 558053.36 0 NULL 0 0 NULL Thursday, May 09, 2019 N NULL N NULL 20 NULL N 0 F3231 Y 523910 Equity Funds Group 28TH FLOOR NULL NEW YORK NY 10017 11/23/27 6/11/15 4/23/12 3 LETTER OF CREDIT NULL 12/31/99 5/24/18 N NULL FINANCE LETTER OF CR BLANLET LIEN NULL NULL 5/16/18 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL - 0
12/31/17 SQ1-00005383 0 90697.38 NULL 0 0 NULL Saturday, April 26, 2042 N NULL N NULL 30 NULL N 0 21666 N 531110 Portfolio NULL NULL MORGANTON NC 28655 10/14/73 NULL 4/26/12 0 DEBT REFINANCE NULL 1/6/00 11/9/11 N NULL SECURED LOANS OTHER MONTHLY NULL 3/15/19 LATER STAGE OTHER 0 0 0 N NULL N 1D 3-D N 3-D NULL 0 NULL NULL 90,697.38
12/31/17 SQ1-00009531 0 500000 NULL 0 0 NULL Monday, May 06, 2019 N NULL N NULL 20 NULL Y 5.5 F1921 Y 523910 Equity Funds Group 100 FRONT STREET, SUITE 1225 NULL WEST CONSHOHOCKEN PA 19428 10/14/73 5/9/18 6/11/12 6 WORKING CAPITAL PRIME RATE 12/31/99 4/30/18 N NULL SECURED LOANS BLANLET LIEN MONTHLY Daily 3/1/19 EQUITY FUNDS GROUP EQUITY FUNDS GROUP 0 0 0 N NULL N 9B2 2-V.A N 2-V.A NULL 0 NULL NULL 500,000.00

OverRides

Loan_Number_Display Codes_Override_Staging_Id Asset_System Loan_Number Code Start_Date End_Date Value Comment User_ID Modified Import_Date ASSET_ID
SQ1-000041599 666 SQ1 24818 Payoff Date 10/31/17 NULL 10/31/17 Fully charged off loan 1073741823;#System Account 1/4/18 9:33 PM 4/25/19 6:39 AM 15534
SQ1-000025057 90 SQ1 25057 Payoff Date 12/31/15 NULL 12/31/15 Fully charged off loan at acquisition 1073741823;#System Account 1/5/16 3:15 PM 4/25/19 6:39 AM 15539
SQ1-000036621 610 SQ1 36621 Payoff Date 7/31/17 NULL 7/31/17 Fully charged off loan 1073741823;#System Account 1/4/18 9:33 PM 4/25/19 6:39 AM 15700
SQ1-000038958 586 SQ1 38958 Payoff Date 6/30/17 NULL 6/30/17 Fully charged off loan 1073741823;#System Account 7/7/17 8:25 AM 4/25/19 6:39 AM 15741
SQ1-000039364 114 SQ1 39364 Payoff Date 12/31/15 NULL 12/31/15 Fully charged off loan at acquisition 1073741823;#System Account 1/5/16 3:19 PM 4/25/19 6:39 AM 15748
SQ1-000039301 536 SQ1 41596 Payoff Date 1/31/17 NULL 1/31/17 Paidoff 1073741823;#System Account 2/6/17 2:04 PM 4/25/19 6:39 AM 15807
SQ1-000050144 589 SQ1 50144 Payoff Date 6/30/17 NULL 6/30/17 Fully charged off loan 1073741823;#System Account 7/7/17 8:25 AM 4/25/19 6:39 AM 16082
SQ1-000052178 105 SQ1 52178 Purchased Credit Impaired 12/31/15 NULL NonPCI Loan is not PCI but another loan under the same facility is PCI 1073741823;#System Account 1/7/16 6:40 PM 4/25/19 2:03 AM 16165
SQ1-000057647 431 SQ1 57647 Purchased Credit Impaired 10/31/16 NULL PCI Coding error 1073741823;#System Account 11/6/16 12:38 PM 4/25/19 2:03 AM 16423
SQ1-000057647 569 SQ1 57647 Payoff Date 3/31/17 NULL 3/31/17 Fully charged off loan - PCI 1073741823;#System Account 4/5/17 4:36 PM 4/25/19 6:39 AM 16423
SQ1-000059227 119 SQ1 59227 Acquisition Reserve Code 12/31/15 NULL 1 Missing code 1073741823;#System Account 1/7/16 6:44 PM 4/25/19 2:03 AM 17363
SQ1-000059227 428 SQ1 59227 Purchased Credit Impaired 10/31/16 NULL PCI Coding error 1073741823;#System Account 11/6/16 12:37 PM 4/25/19 2:03 AM 17363
SQ1-000059227 608 SQ1 59227 Payoff Date 6/30/17 NULL 6/30/17 Fully charged off loan - PCI 1073741823;#System Account 7/7/17 8:25 AM 4/25/19 6:39 AM 17363
SQ1-000059236 122 SQ1 59236 Acquisition Reserve Code 12/31/15 NULL 1/1/00 Missing code 1073741823;#System Account 1/7/16 6:44 PM 4/25/19 2:03 AM 17364
SQ1-000059236 429 SQ1 59236 Purchased Credit Impaired 10/31/16 NULL PCI Coding error 1073741823;#System Account 11/6/16 12:37 PM 4/25/19 2:03 AM 17364
SQ1-000059236 606 SQ1 59236 Payoff Date 6/30/17 NULL 6/30/17 Fully charged off loan - PCI 1073741823;#System Account 7/7/17 8:25 AM 4/25/19 6:39 AM 17364
SQ1-000061635 581 SQ1 61635 Payoff Date 5/31/17 NULL 5/31/17 Fully charged off loan 1073741823;#System Account 6/8/17 8:55 AM 4/25/19 6:39 AM 16662
SQ1-000064374 432 SQ1 64374 Purchased Credit Impaired 10/31/16 NULL PCI Coding error 1073741823;#System Account 11/6/16 12:39 PM 4/25/19 2:03 AM 16837
SQ1-000066685 576 SQ1 66685 Non Accrual Date 5/31/17 NULL 5/31/17 Back date 1073741823;#System Account 6/6/17 12:31 PM 4/25/19 6:39 AM 16996
SQ1-000066724 590 SQ1 66724 Payoff Date 6/30/17 NULL 6/30/17 Fully charged off loan 1073741823;#System Account 7/7/17 8:26 AM 4/25/19 6:39 AM 17000
SQ1-000067553 430 SQ1 67553 Purchased Credit Impaired 10/31/16 NULL PCI Coding error 1073741823;#System Account 11/6/16 12:38 PM 4/25/19 2:03 AM 17050
SQ1-00008445 104 SQ1 67562 Purchased Credit Impaired 12/31/15 NULL NonPCI Loan is not PCI but another loan under the same facility is PCI 1073741823;#System Account 1/7/16 6:40 PM 4/25/19 2:03 AM 17051
SQ1-000068301 120 SQ1 68301 Purchased Credit Impaired 12/31/15 NULL PCI Added to Day 1 PCI 1073741823;#System Account 1/7/16 6:41 PM 4/25/19 2:03 AM 17092
SQ1-000071227 605 SQ1 71227 Payoff Date 5/31/17 NULL 5/31/17 Fully charged off loan 1073741823;#System Account 6/8/17 10:15 PM 4/25/19 6:39 AM 17568
SQ1-000072114 560 SQ1 72114 Non Accrual Date 3/31/17 NULL 2/1/17 Consistent with loan status 1073741823;#System Account 4/7/17 4:45 PM 4/25/19 6:39 AM 17733
SQ1-000073335 559 SQ1 73335 Non Accrual Date 3/31/17 NULL 2/1/17 Consistent with loan status 1073741823;#System Account 4/7/17 4:45 PM 4/25/19 6:39 AM 18091
SQ1-000074527 172 SQ1 74527 Purchased Credit Impaired 12/31/15 NULL NonPCI Loan is not PCI but another loan under the same facility is PCI 1073741823;#System Account 4/4/16 9:19 AM 4/25/19 2:03 AM 18283
SQ1-00006318 272 SQ1 79195 Purchased Credit Impaired 6/30/16 NULL PCI Restructured loan 1073741823;#System Account 7/6/16 11:38 AM 4/25/19 2:03 AM 21299
SQ1-000079195 274 SQ1 79195 Original Institution Id 6/30/16 NULL 6/8/00 Restructured loan 1073741823;#System Account 7/6/16 12:44 PM 4/25/19 2:03 AM 21299
SQ1-000079195 275 SQ1 79195 Acquisition Reserve Code 6/30/16 NULL 1/1/00 Restructured loan 1073741823;#System Account 7/6/16 12:45 PM 4/25/19 2:03 AM 21299
SQ1-000079207 273 SQ1 79207 Purchased Credit Impaired 6/30/16 NULL PCI Restructured loan 1073741823;#System Account 7/6/16 11:38 AM 4/25/19 2:03 AM 21300
SQ1-000079207 284 SQ1 79207 Original Institution Id 6/30/16 NULL 6/8/00 Restructured loan 1073741823;#System Account 7/6/16 12:44 PM 4/25/19 2:03 AM 21300
SQ1-000079207 285 SQ1 79207 Acquisition Reserve Code 6/30/16 NULL 1/1/00 Restructured loan 1073741823;#System Account 7/6/16 12:45 PM 4/25/19 2:03 AM 21300
SQ1-000082508 609 SQ1 82508 Payoff Date 7/31/17 NULL 7/31/17 Fully charged off loan 1073741823;#System Account 1/4/18 9:33 PM 4/25/19 6:39 AM 22144
SQ1-000085264 1708 SQ1 85264 Days Delinquent 3/31/19 NULL 12/31/99 Correction 40;#Ekaterina Lyubimova 4/3/19 10:38 AM 4/25/19 2:03 AM 22732
SQ1-000087111 556 SQ1 87111 Non Accrual Date 3/31/17 NULL 2/1/17 Consistent with loan status 1073741823;#System Account 4/7/17 4:44 PM 4/25/19 6:39 AM 23120
SQ1-00005383 1697 SQ1 90466 Call Report Code 3/31/19 4/15/19 9a The CRC should not have been changed from 9a to 4a 40;#Ekaterina Lyubimova 4/2/19 1:34 PM 4/25/19 2:03 AM 24969
SQ1-000102336 687 SQ1 102336 Payoff Date 12/29/17 NULL 12/29/17 removing from CAP - entered under new loan # 1073741823;#System Account 1/4/18 9:16 PM 4/25/19 6:39 AM 38481
SQ1-001116142 1696 SQ1 1116142 Call Report Code 3/31/19 4/15/19 9a The CRC should not have been changed from 9a to 4a 40;#Ekaterina Lyubimova 4/2/19 1:34 PM 4/25/19 2:03 AM 43545
SQ1-100985 696 SQ1 100985 Non Accrual Date 3/1/18 NULL 3/1/18 Add non-accrual to unfunded commitment 1073741823;#System Account 4/2/18 12:29 PM 4/25/19 6:39 AM 32917
SQ1-20597 563 SQ1 20597 Non Accrual Date 3/31/17 NULL 2/1/17 Consistent with loan status 1073741823;#System Account 4/7/17 4:45 PM 4/25/19 6:39 AM 23841
SQ1-21138 682 SQ1 21138 Non Accrual Date 12/11/17 NULL 12/11/17 Match status to funded loan 1073741823;#System Account 1/3/18 1:17 PM 4/25/19 6:39 AM 23852

Notes

Insert screenshots here:
CAP - Step 4:
Recon - Step n:

Rubric

Excel Project - Grading Rubric
ACCT 307 - Spring 2020
Preparation: (1 point) CAP: (1 point) Recon: (8 points) Difference: (5 points)
Formatting, font size, etc
Formula error or inappropriate formula
Missing step or incomplete answer
Poor presentation
Hardcoded referencing
Inadequate/unsupported argument
Category Total 1 1 8 5
Project Final Grade 15