Using excel prepare a multi-step and single-step income


You have been presented with the following information from the books of Sanders and Company for the year ended Dec 31, 2011. Use this information to help you complete each of the steps below.

Sales=$3,000,000

Office Salaries=$15,000

Rental Revenue=$85,000

COGS=$1,500,000

Utilities Expense=$25,000

Dividend Revenue=$65,000

Advertising Expense=$30,000

Insurance Expense=$10000

Interest on Bonds=$12,000

Depreciation of Sales Equipment=$24,000

Officers Salaries=28,000

Travel and Entertainment=$29000

Legal Fees=$32,000

Misc Office Expense=$8,000

Freight Out=$5000

  1. Using Excel, prepare a Multi-Step and Single-Step Income Statement. Income Tax for the year is $50,000 and Common Shares=150,000
  2. At the bottom of one of the income statements you prepare, explain which statement you feel is the most informative for a company? Explain your reasoning.

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: Using excel prepare a multi-step and single-step income
Reference No:- TGS01036578

Expected delivery within 24 Hours