Reference no: EM131048285
Option #1: Creating Financial Statements
In this assignment, you will create a Balance Sheet and Income Statement for a bank. Below are accounts and balances for 2014 year-end of ABC Bank, Inc.
Note that the Retained Earnings account has not yet been adjusted for 2014 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
|
1. 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.
2. Go to sec.gov 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 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 assignment.
Your paper must meet the following requirements:
- Be 3-4 paragraphs in length.
- Follow the CSU-Global Guide to Writing and APA Requirements. Each paper should include an introduction, a body with at least two fully developed paragraphs, and a conclusion.
- Be clearly and well written using excellent grammar and style techniques. Be concise. Be logical. You are being graded in part on the quality of your writing. If you need assistance with your writing style, start with Tools for Effective Writing at the CSU-Global Library, accessible from the Library's homepage.
Refer to the Critical Thinking Rubric in the Module 3 Folder for more information on expectations for this assignment.
Hooded rats social play counts
: Hooded rats: social play counts. In Exercise 29.13 you carried out two-way ANOVA for a study of the effect of social isolation on hooded rats. The response variable is the count of social play episodes during an observation period. Start your work..
|
Calculate the sustainable growth rate for webb
: You have located the following information on Webb’s Heating & Air Conditioning: debt ratio is 54 percent, capital intensity is 1.10 times, profit margin is 12.5 percent, and the dividend payout is 25 percent. Calculate the sustainable growth rate fo..
|
A study of the effect of social isolation
: Hooded rats: social play times. In Exercise 29.12 you carried out two-way ANOVA for a study of the effect of social isolation on hooded rats. The response variable is the time (in seconds) that a rat devoted to social play during an observation pe..
|
Elements of intention and agreement required for formation
: Using the 4 step process, discuss the whether the elements of intention and agreement required for the formation of a legally enforceable contract are present in the scenario
|
Prepare a formal income statement and balance sheet
: 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.
|
Perform critical analysis of the system design process in
: Perform Critical Analysis of the System Design Process in Mines in your words.
|
During a critical developmental period affect the behavior
: Hooded rats: social play times. How does social isolation during a critical developmental period affect the behavior of hooded rats? Psychology students assigned 24 young female rats at random to either isolated or group housing, then similarly as..
|
Effective communication in the context of project management
: Identify the problems and/or issues that you''ll need to include in your analysis. Document this information, and con - Recognize and manage for constraints and limited availability of human resources and Employ interpersonal and management skills to..
|
Prepare an outline of how you would choose to communicate
: U.S. President-and prepare an outline of how you would choose to communicate that figure's relevance to today. This is not a biography. Your argument should highlight how society remembers your historical figure now.
|