Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 2, Problem 3R

The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as follows:

Chapter 2, Problem 3R, The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as

Information for the adjusting entries is as follows:

  1. a. Cleaning supplies on hand on December 31, 2012, $18,750.
  2. b. Insurance premiums expired during the year, $1,800.
  3. c. Depreciation on equipment during the year, $21,600.
  4. d. Wages accrued but not paid at December 31, 2012, $1,830.

Complete the income statement and balance sheet columns by entering formulas in columns J, K, L, and M that reference the appropriate cells in columns H or I. Net income will be automatically calculated for the income statement and balance sheet. Check to be sure that these numbers are the same. Enter your name in cell A1. Save the completed file as F1WORK3. Print the worksheet. Also print your formulas using landscape orientation and fit-to-1 page scaling. Check figure: Net income (cell J30), $71,320.

Blurred answer
Students have asked these similar questions
General Accounting
Solve this question
Given answer general Accounting
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Text book image
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Text book image
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY