Need yellow shaded cells solved. All the info is here, don't want to hear you don't have enough. Need this done in the next few hours.

Name FIN330 Homework 40 Points Fall 2020 $ $ $ $ $ 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 Risk Weight Risk-Adjusted Assets 0% 0% 20% 50% 50% 100% 100% 150% 100% 1,000 1,700 1,500 2,700 2,300 1,500 2,100 500 2,000 15,300 $ $ $ $ $ $ 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