| 1. Explain what the formula in cell E6 is doing. |
| 2. Explain what the formula in cell E9 is doing. |
| Account Number |
FY 2023 1 - 9 |
| 1000/100560 CASH - BOFA - 3401 |
16,209,411.03 |
| Assets |
146,953,238.84 |
| 1000/100561 BOFA - OCC |
(430,295.59) |
| Liabilities |
(19,364,867.31) |
| 1000/100562 BOFA - OEC |
(8,271,694.22) |
| Equity |
(127,588,371.53) |
| 1000/100565 BOFA - ILC |
(6,963.74) |
| Net Income/Loss |
(14,056,976.74) |
| 1000/100567 BOFA - IEC |
9,112.25 |
| 1000/100568 BOFA - IECC |
34,492.90 |
| 1000/104810 MM FUND-STOCK TRADE |
243,935.30 |
| 1000/104820 MM FUND-BOND TRADING |
1,798,536.72 |
| 1000/104830 MM CASH - STOCK |
(3.05) |
| 1000/104840 MM CASH - BOND |
787.50 |
| 1000/108110 INVEST- RESTRICTED |
210,000.00 |
| 1000/108210 INVESTMENTS - STOCKS |
19,780,753.73 |
| 1000/108220 INVESTMENTS - BONDS |
98,555,000.00 |
| 1000/108410 AMORT OF PREM/(DISC) |
(693,400.91) |
| 1000/108510 UNREALIZED G/(L) INV |
8,110,079.31 |
| 1000/110010 ACCOUNTS RECEIVABLE |
(130,389.72) |
| 1000/110010 ACCOUNTS RECEIVABLE |
(29,845.97) |
| 1000/110210 A/R - PREPAID |
(521.54) |
| 1000/110210 A/R - PREPAID |
(4,706,257.92) |
| 1000/110210 A/R - PREPAID |
(2,570.04) |
| 1000/110210 A/R - PREPAID |
11,061,536.20 |
| 1000/110250 A/R - ASP |
(5.26) |
| 1000/110250 A/R - ASP |
11.24 |
| 1000/110250 A/R - ASP |
4,334,723.14 |
| 1000/110840 A/R - LBOX CLEARING |
(1,518.60) |
| 1000/110841 A/R - LBOX CLEAR-CB |
(905,029.07) |
| 1000/110980 A/R-MANUAL ADJUST |
907,074.47 |
| 1000/110980 A/R-MANUAL ADJUST |
(1,283,763.67) |
| 1000/130950 PREPAID EXP - OTHER |
(0.01) |
| 1000/131010 INTEREST RECEIVABLE |
553,780.54 |
| 1000/131100 DIVIDENDS RECEIVABLE |
18,848.54 |
| 1000/131210 INVEST STL-CASH REC |
(0.47) |
| 1000/131810 MISC RECEIVABLES |
1,435,383.00 |
| 1000/131810 MISC RECEIVABLES |
4,005.90 |
| 1000/131810 MISC RECEIVABLES |
2,125.78 |
| 1000/143010 DTF-REC-ST-IC |
2,207,685.77 |
| 1000/143060 DTF-REC-MAN ADJ-IC |
(1,711,530.87) |
| 1000/180010 DEF TX ASSTS-FED-L/T |
(487,921.78) |
| 1000/180210 DEF TX ASSTS-ST-L/T |
(511,588.25) |
| 1000/180350 DTA-INVEST G/L-L/T |
649,256.20 |
| 1000/200010 IBNR CLAIMS RESERVE |
(10,166,764.00) |
| 1000/210010 ACCOUNTS PAYABLE |
(1,733.72) |
| 1000/210410 A/P-MANUAL ADJUST |
(51,049.53) |
| 1000/210410 A/P-MANUAL ADJUST |
9,963.05 |
| 1000/210910 A/P - CONVERSION |
0.30 |
| 1000/222010 ACCRUED COMMISSIONS |
(295,958.32) |
| 1000/230510 DEFERRED INCOME-S/T |
(2,630,915.38) |
| 1000/230510 DEFERRED INCOME-S/T |
(45,735.14) |
| 1000/230510 DEFERRED INCOME-S/T |
(213,394.32) |
| 1000/230590 DEF INC-S/T-MAN ADJ |
1,781,307.81 |
| 1000/231010 FED INC TAX PAYABLE |
(2,256,401.32) |
| 1000/231110 ST INC TAX PAYABLE |
(325,414.88) |
| 1000/232010 PREMIUM TAX PAYABLE |
(576,888.50) |
| 1000/232010 PREMIUM TAX PAYABLE |
37,500.00 |
| 1000/235010 DTF-PAYABLE-ST-IC |
(4,430,620.66) |
| 1000/235960 DTF-PAY-MANL ADJ-IC |
1,711,530.87 |
| 1000/236240 CLR ACCT-CAPS INTFC |
48,633.06 |
| 1000/236240 CLR ACCT-CAPS INTFC |
(47,836.64) |
| 1000/236240 CLR ACCT-CAPS INTFC |
(1,430.88) |
| 1000/236260 CLR ACCT-INTFC BAL |
(452,971.17) |
| 1000/236260 CLR ACCT-INTFC BAL |
150,293.63 |
| 1000/236260 CLR ACCT-INTFC BAL |
48,297.62 |
| 1000/236730 UNCLAIMED PROP-ST |
(279,351.24) |
| 1000/236950 ACCRUED LIAB-OTHER |
(14,249.55) |
| 1000/236990 LIAB UNALL DEP-STAT |
(907,074.47) |
| 1000/270010 ADV FROM CLIENT/CUST |
(422,776.85) |
| 1000/270020 ADV FROM CLIENT-ADJ |
(31,827.08) |
| 1000/310010 ADDTL PD-IN-CAPITAL |
(786,602.34) |
| 1000/320010 RETAINED EARNINGS |
(108,488,362.47) |
| 1000/330510 INV-UNREALIZD (G)/L |
(4,256,429.98) |
| 1000/400010 REVENUE |
(1,136,686.23) |
| 1000/400030 REVENUE - DR CHARGES |
(19,319,698.96) |
| 1000/400030 REVENUE - DR CHARGES |
(4,868,790.36) |
| 1000/400035 REV-NCOV OPT-ASC606 |
19,125,584.00 |
| 1000/400310 REVENUE - ADMIN |
(21,708,257.31) |
| 1000/400310 REVENUE - ADMIN |
(4,243,377.14) |
| 1000/400310 REVENUE - ADMIN |
(448,294.85) |
| 1000/400410 REVENUE - CLAIMS |
(111,862,389.13) |
| 1000/400410 REVENUE - CLAIMS |
(37,872,237.43) |
| 1000/400410 REVENUE - CLAIMS |
(1,179,215.11) |
| 1000/400675 REV-LENS ADMIN-ASC60 |
(1,325,444.00) |
| 1000/422010 DISCOUNTS - CASH |
195,058.37 |
| 1000/422010 DISCOUNTS - CASH |
7,914.30 |
| 1000/422010 DISCOUNTS - CASH |
1.60 |
| 1000/440010 INTEREST INCOME |
(2,498,948.72) |
| 1000/440410 DIVIDEND INCOME |
(341,950.50) |
| 1000/440610 (G)/L ON INVS-RLZD |
(260,901.43) |
| 1000/440710 (G)/L EQY INV-UNRLZD |
(2,315,836.81) |
| 1000/500010 COST OF SALES |
111,304,177.08 |
| 1000/500010 COST OF SALES |
37,751,097.00 |
| 1000/500010 COST OF SALES |
15,222,467.24 |
| 1000/500020 COS-ASP DR-ASC606 |
37,751,097.00 |
| 1000/500030 COS-ASP CR-ASC606 |
(37,751,097.00) |
| 1000/500040 COS-NON COV-ASC606 |
(19,125,584.00) |
| 1000/500850 COS-LENS RISK-ASC606 |
(5,249,419.00) |
| 1000/500860 COS-LENS OTHER-ASC60 |
6,574,863.00 |
| 1000/501030 COS-WRITE OFFS |
(104,100.97) |
| 1000/501090 COS-DR INITIATIVES |
392,010.00 |
| 1000/501990 COS-OTHER |
(2,515,850.90) |
| 1000/610010 COMMISSION EXPENSE |
2,675,000.38 |
| 1000/667010 ACCOUNTING FEES |
2,250.00 |
| 1000/682510 BAD DEBT EXPENSE |
37,483.97 |
| 1000/686940 LICENSES & PERMITS |
688.35 |
| 1000/690010 TAX EXP-PREMIUM |
603,864.00 |
| 1000/730950 MISCELLANEOUS INCOME |
(7,079.24) |
| 1000/800010 TAX - FEDERAL INCOME |
3,067,568.11 |
| 1000/800050 DEF TAX EXP-FEDERAL |
626,524.00 |
| 1000/801010 TAX - STATE INCOME |
2,550,111.95 |
| 1000/801050 DEF TAX EXP-STATE |
230,115.00 |
| 1000/910700 ALLOC-G&A-MAN CAL |
21,960,307.00 |
jess22
BlankExcelTest1.xlsx
