creating financial statements

Project Description:

in this task, you will create a balance sheet and income statement for a bank. below are accounts and balances for 2013 year-end of abc bank, inc. note that the retained earnings account has not yet been adjusted for 2013 net income and dividends so you will have to compute the year-end balance in retained earnings for the balance sheet.

in $000's
cash & due from banks 21,860
common stock 9,136
dividends paid [2] 20,010
employee expenses 28,804
fed. funds and reverse repurchases 137,313
fee income 23,930
gain from security trading 3,064
goodwill & other assets 141,341
gross loans and leases 846,833
income tax expense 9,104
interest expense 5,161
interest income 48,391
loan loss allowance 17,060
long-term bonds payable 127,379
miscellaneous other income 15,862
other borrowed funds 57,175
other expense 21,594
other liabilities 76,668
preferred stock 12,883
provision for loan losses 7,217
retained earnings [1] 77,733
securities 292,681
surplus 59,802
total deposits 1,002,835
prepare a formal income statement (report of income) and balance sheet (report of condition) for the bank using excel. you do not need to break down assets or liabilities into subsections. note that all values are in thousands of dollars. you can skip adding the zeroes if you note the values correctly.
go to and click on “filings” and you get a drop-down box. click on “company filings search.” in the fast search box (right side), type in all to get the sec filings for allstate corporation (primarily an insurance company). find the most recently filed 10k (interactive data) and then click on “financial statements” and open the firm’s consolidated balance sheet and also the firm’s consolidated statement of income. observe the differences between the statements of an insurance company and those of a bank.
write a short essay (3-4 paragraphs) commenting on those differences. if you do part 1 on an excel sheet, you should put your essay on a new page in the same file so there is only one file submitted for this task.
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $0 to $10
Total Proposals: 4
1 Current viewersl
81 Total views
Project posted by:


Proposals Reputation Price offered
  • 4.9
    2537 Jobs 1261 Reviews
    $50 in 1 Day
  • 4.6
    103 Jobs 52 Reviews
    $1 in 2 Days
  • 4.8
    344 Jobs 237 Reviews
    $15 in 1 Day
  • 4.7
    71 Jobs 33 Reviews
    $35 in 1 Day