Current Attempt in Progress Two accountants for the firm of Elwes and Wright are arguing about the merits of presenting an income statement in a multiple-step versus a single-step format. The discussion involves the following 2020 information related to Sunland Company ($000 omitted). Administrative expense Officers' salaries $5,593 Depreciation of office furniture and equipment 4,653 Cost of goods sold 61,263 Rent revenue 17,923 Selling expense Delivery expense 3,383 Sales commissions 8,673 Depreciation of sales equipment 7,173 Sales revenue 97,193 Income tax 9,763 Interest expense 2,553

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.