Create a balance sheet and income statement for a bank

Assignment Help Financial Accounting
Reference no: EM131816602

In this assignment, 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.

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.

Attachment:- table.xlsx

Reference no: EM131816602

Questions Cloud

What is the difference between a good question and a bad one : How do you know when you have a good answer to a question? Consider the three types of questions described here in your answer.
Item limit of the food supermarket express checkout : In "Compliance with the Item Limit of the Food Supermarket Express Checkout Lane: An Informal Look," researcher J. Trinkaus reported, "75 15-min observations
Newspaper article announced caesarean deliveries : In November 2004, a newspaper article announced, "Caesarean Deliveries Hit U.S. Record" and stated that "roughly 1.13 million, or 27.6% [of births]
How do adjust prices to meet market competition : Understanding Pricing Decisions Form teams of three to six students. Each team should contact and meet with a manager responsible for pricing in a company.
Create a balance sheet and income statement for a bank : 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
What is the composition of each payment : The father has a basis of $200,000 and he receives an unsecured promise to pay him $60,000 per year, What is the composition of each payment
Denote the unknown proportion of all people : How do we denote the unknown proportion of all people who would lie when answering such a question?
Which of these programs are dbms products : Microsoft offers free licenses of certain software products to students at colleges and universities that participate in the Microsoft Developer Network.
Briefly explain the colgate strategy : Marketing Decisions at Colgate-Palmolive Managers need information of all types in order to make decisions. Many marketing decisions are strategic.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Format cash flows from operating activities

Prepare the spreadsheet for the 2012 statement of cash flows. Format cash flows from operating activities by the indirect method.

  Prepare an income statement for the cable service division

Prepare an income statement for the Cable Service Division for March. Prepare an income statement for the Phone Division for March. Include a supporting cost of goods manufactured statement.

  How much of the process time is value-added

Shields Manufacturing produces containers for nurseries and landscaping businesses. The company competes based on its low-cost, high-quality products. As the company’s expenses have risen, management has become concerned with the need to streamline v..

  Is the result in the adjusted trial balance debit or credit

The end of period spreadsheet is useful in preparing an Adjusted Trial Balance from which the three Financial Statements can be prepared. Please indicate the results in the adjusted Trial Balance under the following circumstances. An account has a de..

  Determine the direct labor rate variance

Determine the direct labor rate variance? Evaluate the standard direct labor rate?

  How will you help top management team overcome resistance

You are the internal relations manager for Elan, an Irish biotech firm, when it is acquired by Johnson and Johnson. How will you help the top management team overcome resistance to the new ownership

  Preparation of bad debt account and their adjustmentbad

preparation of bad debt account and their adjustment.bad debts analysis allowance account on january 1 2009 the balance

  Prepare the clinic''s flexible budget performance report

Kestner Clinic uses patient-visits as its measure of activity. During September, the clinic budgeted for 3,000 patient-visits, but its actual level of activity was 2,900 patient-visits. The clinic has provided the following data concerning the formul..

  Construction cost of wastewater treatment plant

Construction cost of a wastewater treatment plant is: C=1,300,000*Q^0.65, where Q is the capacity of the plant in million gallons per day, MGD, and C is in dollars. Demand for plant capacity increases linearly from zero today at 1 MGD per year. Which..

  Finished goods inventory under absorption costing method

If Eagle had sold only 9,000 tables in its first year, what total amount of cost would have been assigned to the 1,000 tables in finished goods inventory under absorption costing method?

  Sales must be made to produce the target income

Watson Company has monthly fixed costs of $89,000 and a 40% contribution margin ratio. If the company has set a target monthly income of $15,600, what dollar amount of sales must be made to produce the target income?

  Direct materials-manufacturing overhead and direct labor

Kimm Company has gathered the information shown below about its product. Direct materials. Each unit of product contains 4.30 pounds of materials. The average waste and spoilage per unit produced under normal conditions is 0.50 pounds.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd