AutoSave OFF AAA2G ... Q Cost of Funds HW (1) (1) 1 View Tell me Home Insert Draw Page Layout Formulas Data Review Le Share Comments Insert v = Calibri (Body) V A v 11 Ov General Ayu O LC DX Delete v F NN Analyze Data Paste BI U A = v $ % Y Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Find & Select H13 fx . A B C D E F H I J L M N 0 P Q R S T U Using the following bank's funding structure, calculate its cost of funds 6 Processing & Acquisition Cost $ 7.20% 5.00% S $ Funding Source Demand Deposits Interest Checking Money Mkt. Accts. . . Other Savings Accts. Small Time Deposits Large Time Deposits TOTAL DEPOSITS Fed Funds Purchased Other Liabilities TOTAL LIABILITIES Stockholders' Equity TOTAL FINANCING Average Amount 44,500 69,900 49,800 25,100 187,600 63,000 439,900 18,000 7,500 465,400 34,600 500.000 Interest Cost 0.00% 2.10% 2.80% 3.00% 4.10% % 4.80% S $ Nonearning Percentage 17.00% 14.00% 3.00% 2.00% 2.00% 3.00% 3.20% 1.00% 1.50% 0.30% $ $ S 2.00% 2.50% 0.00% 0.00% D.DOX 5.00% S $ S $ 15.08% 0.00% 5.00% 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Sheet1 + Ready 1B 100%