need yellow shaded cells solved
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 $ 8,000 0% Hot Money $ 6,000 20% 50% Common Stock $ 600 50% Retained Earnings $ 400 100% Surplus $ 300 100% 150% 100% $ 15,300 50% 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 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 $ 8,000 0% Hot Money $ 6,000 20% 50% Common Stock $ 600 50% Retained Earnings $ 400 100% Surplus $ 300 100% 150% 100% $ 15,300 50% 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