The excel file contains the balance sheet and income statement for Bank of America (Year 2005 and 2006). Calculate the following ratios for each year: interest expense ratio, provision for loan loss ratio, non-interest expense ratio, net interest margin, and bank spread. (HINT: "Other liabilities" do not bear interest)

using these formulas given,

interest expense ratio = total interest expense/ total income

non-interest expense ratio= total non-interest expense / total income

provision for loan loss ratio= provision for loan losses / total income

net interest margin = net interest income / total amount of interest - earning assets

bank spread = interest rate of all interest - earning assets - interest rate of all interest - paying liabilites

Balance Sheet	Year: 2005	Year: 2006	(In million $)
Assets
Cash	36,999	36,429
Short term securities with interest	149,785	135,478
Investment securities with interests	245,315	192,846
Loans	573,791	706,490
Allowance for loans and lease losses	8,045	9,016
Net loans	565,746	697,474
Premises and Equipment	7,786	9,255
Trading account securities	131,707	153,052
Deposits placed in other banks	12,800	13,952
Intangible assets	51,354	75,084
other assets	90,311	146,167
Total Assets	1,291,803	1,459,737
Liabilities
Non-interest bearing deposits	186,736	184,808
Interest bearing deposits	447,934	508,689
Short term debt (Standard, with interest)	116,269	141,300
Other liabilities without interest	97,828	126,141
Short term securities with interest sold	240,655	217,527
Long term debt (Standard, with interest)	100,848	146,000
Total Liabilities	1,190,270	1,324,465
Total Equity	101,533	135,272
Income Statement	Year: 2005	Year: 2006
Total interest income	58,626	78,585
Total interest expense	27,889	43,994
Total non-interest income	26,438	37,989
Total non-interest expense	28,269	34,792
Provision for loan losses	4,014	5,010
Income Taxes	8,015	10,840
Special items	(412)	(805)
Net income from continuing operations	16,465	21,133
Net income from total operations	16,465	21,133
Net Income	16,465	21,133