Please show formulas

86 Question 4 87 88 Your banks is expecting the following demand schedule of new funds at these interest rate offers 89 90 91 92 Expected Volume of New Rate Offered on New Deposits Funds 1 9,999,000 3.0000% 2 11,998,800 3.2500% 3 21,997,800 3.7500% 4 34,996,500 4.2500% 5 54,994,500 5.0000% 93 94 95 5.50% 96 97 Expected yield on new loans 98 99 100 Please calculate the following numbers 101 for each tranche of funds raised Total Interest Cost Marginal Cost of New Deposit Money Exp. Diff. In Marg. Rev and Cost Total Profits Earned 102 Marginal Cost Rate Grade 103 1 0 104 2 105 3 4 o o od 106 107 5 108 86 Question 4 87 88 Your banks is expecting the following demand schedule of new funds at these interest rate offers 89 90 91 92 Expected Volume of New Rate Offered on New Deposits Funds 1 9,999,000 3.0000% 2 11,998,800 3.2500% 3 21,997,800 3.7500% 4 34,996,500 4.2500% 5 54,994,500 5.0000% 93 94 95 5.50% 96 97 Expected yield on new loans 98 99 100 Please calculate the following numbers 101 for each tranche of funds raised Total Interest Cost Marginal Cost of New Deposit Money Exp. Diff. In Marg. Rev and Cost Total Profits Earned 102 Marginal Cost Rate Grade 103 1 0 104 2 105 3 4 o o od 106 107 5 108