BAS Sept 2022 Case Study
BBA
Inventory: Muni Tax Exempt - Fixed Rate Sunny State Bank
As Of 12/31/2018
Page 3 of 4 Book Value Market Value Gain/(Loss) Pledged Face
CUSIP
Description
Fitch S & P Moody
Par Value
Mkt Price
Book Price Acctg Yld Tax Equiv Yld
TEFRA State Exempt Escr to Maty
Issued
Coupon Maturity
Proj Avg Life Mod Dur
ASC 320 Safekeep
Type BQ State Next Call/PreRefund
Capital Req Risk Factor
Pur Date Pur Price Purchase Cost
90 Day Rule**
General Obligation AFS
232291XP4 CUYAHOGA FALLS-REF OH 36
Aa2
472,369.20 410,000.00
Post-TEFRA
112.235769
108.614000
460,166.65 445,317.40
%
20
7.92 6.84
AFS UBB
11/03/16
12/01/36
GO BQ OH 12/01/26 @ 100.0000
2.300 2.887
11/03/16
4.0000
6,560
0.00
115.212000
(14,849.25)
Market Pricing :
As of 12/19/18 - Intercontinental Exchange(Level 2)
431614WT9 HILLIARD OH OH 36
Aa1
327,420.00 300,000.00
Post-TEFRA
107.767905
108.001000
323,303.72 324,003.00
%
20
8.42 7.15
AFS UBB
4/11/17
12/01/36
GO BQ OH 6/01/27 @ 100.0000
2.951 3.710
4/11/17
4.0000
4,800
0.00
109.140000
699.28
Market Pricing :
As of 12/19/18 - Intercontinental Exchange(Level 2)
851347SQ8 SPRINGFIELD PA SCH DI PA 37
301,416.00 300,000.00
Post-TEFRA
100.334780
95.466000
301,004.34 286,398.00
%
20
AA
18.17 13.39
AFS UBB
6/14/17
3.3500 3/01/37
GO BQ PA 9/01/22 @ 100.0000
3.252 4.091
6/14/17
4,800
0.00
100.472000
(14,606.34)
Market Pricing :
Insd-State Aid
As of 12/19/18 - Intercontinental Exchange(Level 2)
3960288Z8 GREENVILLE CNTY SC SC 37
330,000.00 330,000.00
Post-TEFRA
100.000000
97.956000
330,000.00 323,254.80
%
20
AAA
AFS UBB
6/08/17
3.0000 4/01/37
GO BQ SC 4/01/27 @ 100.0000
3.000 3.772
17.76 13.59
6/08/17
0.00
5,280
100.000000
(6,745.20)
Market Pricing :
As of 12/19/18 - Intercontinental Exchange(Level 2)
100.653803
Aa2
342,611.20 340,000.00
Post-TEFRA
94.619000
925088VD5 VERONA-A-STREET-IMPT WI 37
342,222.93 321,704.60
%
20
18.42 13.88
AFS UBB
7/20/17
3.1500 6/01/37
GO BQ WI 6/01/26 @ 100.0000
3.051 3.837
7/25/17
5,440
0.00
100.768000
(20,518.33)
Market Pricing :
As of 12/19/18 - Intercontinental Exchange(Level 2)
** 90 Day rule -Reference ASC320, Standards of Financial Accounting and Reporting, Held to Maturity Securities,11. b. (page 7). * 4% is a calculated value: 80% is attributed with zero Risk Factor, while the remaining is attributed with 20% Risk Factor
Market prices represent approximate values and do not constitute actual bids.Tax related yields based on 21.00% Federal tax rate, 8.00% state tax rate, and 0.47% cost of funds. Weighted average Yields, Avg Life, and Mod Dur are weighted by Market Value. *** Not eligible for ratings based approach. Risk Weight and Capital Required are excluded from totals .
Although the information in this report has been obtained from sources believed to be reliable, its accuracy cannot be guaranteed.
BBA - Baker Bond Accounting ®
7 of 22
The Baker Group Software Solutions, Inc.
12/24/2018 2:07 PM - JWP / SOME
Made with FlippingBook Learn more on our blog