Prepare the companys income statement and balance sheet

Assignment Help Financial Accounting
Reference no: EM131491532

Assignment

Make a balance sheet and income statement in Excel

Using the following data in the attached PDF, create a Balance Sheet and an Income Statement

Post your completed financial statements as an excel spreadsheet (one tab for the Balance Sheet, one tab for the Income Statement).

PREPARING FINANCIAL STATEMENTS

As the accountant for Wheatley International, it is your job to prepare the company's income statement and balance sheet. Use the accounts listed below to construct the statements. Assume that the tax rate is 25%.

List of Accounts for
WHEATLEY INTERNATIONAL

Accounts Receivable

$ 120,600

Land

1,500,000

Notes Receivable

61,200

Insurance Expenses

54,000

Accounts Payable

45,000

Interest Expenses

24,600

Common Stock

1,896,000

Depreciation

400,000

Net Sales

1,053,000

Ending Inventory

126,600

Notes Payable (Long-Term)

210,000

Beginning Inventory

154,800

Retained Earnings

1,459,800

Advertising Expense

90,000

Cash

72,000

Salaries

180,000

Short-Term Notes Payable

15,600

Merchandise Purchased (for Inventory)

316,800

Buildings

1,050,000

Rent

13,800

Utilities

8,400

Equipment & Vehicles

1,066,000

Goodwill

90,000

Bonds Payable

60,000

Reference no: EM131491532

Questions Cloud

Unification of germany into one country : Please write 1-3 paragraphs explaining why the unification of Germany into one country (combining East and West Germany) proved.
What amount would they be able to withdraw from this account : If a person is given $1 and invests that $1 for 100 years at 5%, what amount would they be able to withdraw from this account after the 100-year period?
Total compensation-the job evaluation process : Discuss the purpose of job evaluation and the main steps in conducting job evaluation. Discuss the advantages and pitfalls of job analysis.
Classify the costs as variable costs or fixed costs : Classify the costs as variable costs or fixed costs. Explain the importance of distinguishing between variable and fixed costs.
Prepare the companys income statement and balance sheet : PREPARING FINANCIAL STATEMENTS- As the accountant for Wheatley International, it is your job to prepare the company's income statement and balance sheet.
What are the unique psychological perspectives : What are the unique psychological perspectives an industrial-organizational psychologist might consider when applying Theory X and Theory Y
Formulating reward and compensation strategies : Discuss specific considerations in deciding the firm's different choices for compensation-level strategy (a lead, lag, or match compensation level).
Name and describe the language areas in the brain : List three structural/functional differences between the left and right cerebral hemispheres. Name and describe the language areas in the brain
Aspect of a business-related subject area : Aspect of a business-related subject area appropriate to their award. They will apply a range of secondary research skills covered in the Research Methods subject.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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