Need yellow shaded cells solved.

$ 8,000 6,000 $ $ $ $ Bank Assets Cash Treasury Securities Municipal Bonds Single Family Home Mortgages Retail/Consumer Loans Commercial Loans Agricultural Loans Past due consumer loans Bank Buildings Total Short Term Loan Commitments 1,000 1,700 1,500 2,700 2,300 1,500 2,100 500 2,000 15,300 Risk Weight Bank Liabilities 0% Deposits $ 0% Hot Money $ 20% 50% Common Stock $ 50% Retained Earnings $ 100% Surplus $ 100% 150% 100% $ 50% 600 400 300 $ $ $ $ $ 15,300 $ $ $ Bank Assets Cash Treasury Securities Municipal Bonds Single Family Home Mortgages Retail/Consumer Loans Commercial Loans Agricultural Loans Past due consumer loans Bank Buildings Total $ $ $ 1,000 1,700 1,500 2,700 2,300 1,500 2,100 500 2,000 15,300 Risk Weight Risk-Adjusted Assets 0% 0% 20% 50% 50% 100% 100% 150% 100% $ $ $ $ Short Term Loan Commitments 50% Tier 1 capital ratio Risk-weighted capital ratio RWC if add short-term Commitments totalling 1,000 and a 50% risk weighting Explore the Uniform Bank Performance Report (UBPR) for State Bank & Trust (cert 15651) FFIEC UBPR Reports hint: page 2 and page 7 For the calender Year 2019: How much was the provision from the income statement? What was the depth of the pool at the beginning of the year? How much in loans were charged-off against the pool? Value of previously charged-off loans recovered? What was the depth of the pool at the end of the year? What % of loans is represented by the pool $ 8,000 6,000 $ $ $ $ Bank Assets Cash Treasury Securities Municipal Bonds Single Family Home Mortgages Retail/Consumer Loans Commercial Loans Agricultural Loans Past due consumer loans Bank Buildings Total Short Term Loan Commitments 1,000 1,700 1,500 2,700 2,300 1,500 2,100 500 2,000 15,300 Risk Weight Bank Liabilities 0% Deposits $ 0% Hot Money $ 20% 50% Common Stock $ 50% Retained Earnings $ 100% Surplus $ 100% 150% 100% $ 50% 600 400 300 $ $ $ $ $ 15,300 $ $ $ Bank Assets Cash Treasury Securities Municipal Bonds Single Family Home Mortgages Retail/Consumer Loans Commercial Loans Agricultural Loans Past due consumer loans Bank Buildings Total $ $ $ 1,000 1,700 1,500 2,700 2,300 1,500 2,100 500 2,000 15,300 Risk Weight Risk-Adjusted Assets 0% 0% 20% 50% 50% 100% 100% 150% 100% $ $ $ $ Short Term Loan Commitments 50% Tier 1 capital ratio Risk-weighted capital ratio RWC if add short-term Commitments totalling 1,000 and a 50% risk weighting Explore the Uniform Bank Performance Report (UBPR) for State Bank & Trust (cert 15651) FFIEC UBPR Reports hint: page 2 and page 7 For the calender Year 2019: How much was the provision from the income statement? What was the depth of the pool at the beginning of the year? How much in loans were charged-off against the pool? Value of previously charged-off loans recovered? What was the depth of the pool at the end of the year? What % of loans is represented by the pool