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 MB, Problem 1M

The general ledger of Jay Consulting shows the following balances at July 31:

Chapter MB, Problem 1M, The general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to , example  1

Jay has asked you to develop a worksheet that will serve as a trial balance (file name PTB). Use the data provided as input for your model.

Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, $17,731.

To test your model, use the following balances at August 31:

Chapter MB, Problem 1M, The general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to , example  2

Print the worksheet when done. Check figure: Total debits, $18,810.

CHART (optional)

Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.

Expert Solution & Answer
Check Mark
To determine

Prepare a trial balance in a worksheet for the month ended July 31, and August 31.

Explanation of Solution

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Liability?
Solve this question financial accounting
Production Efficiency

Chapter MB Solutions

Excel Applications for Accounting Principles

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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
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
Quickbooks Online Accounting
Accounting
ISBN:9780357391693
Author:Owen
Publisher:Cengage
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License