Use the adjusted trial balance for Stockton Company below to answer the questions that follow. Stockton Company Adjusted Trial Balance December 31 Cash 7,530 Accounts Receivable 2,100 Prepaid Expenses 700 Equipment 13,700 Accumulated Depreciation 1,100 Accounts Payable 1,900 Notes Payable 4,300 Common Stock 1,000 Retained Earnings 12,940 Dividends 790 Fees Earned 9,250 Wages Expense 2,500 Rent Expense 1,960 Utilities Expense 775 Depreciation Expense 250 Miscellaneous Expense 185 Totals 30,490 30,490 Determine the net income (loss) for the period. net loss $790 net income $3,580 net loss $5,670 net income $9,250

Variable rate cd’s = $90 treasury bills = $150 discount loans = $20 treasury notes = $100 fixed rate cds = $160 money market deposit accts. = $140 savings deposits = $90 fed funds borrowing = $40 variable rate mortgage loans $140 demand deposits = $40 primary reserves = $50 fixed rate loans = $210 fed funds lending = $50 equity capital = $120 a. develop a balance sheet from the above data. be sure to divide your balance sheet into rate-sensitive assets and liabilities as we did in class and in the examples. b. perform a standard gap analysis and a duration analysis using the above data if you have a 1.15% decrease in interest rates and an average duration of assets of 5.4 years and an average duration of liabilities of 3.8 years. c. indicate if this bank will remain solvent after the valuation changes. if so, indicate the new level of equity capital after the valuation changes. if not, indicate the amount of the shortage in equity capital.