Get a unique, high-quality and non-plagiarized paper from us today at the most affordable price
Email us :

Principles of Accounting

Assignment 4: Excel Problems

At the end of each module, you will apply the module’s concepts by completing a comprehensive assignment from the textbook.

Complete these problems from your text book: (P1-44B  page 47 & P2-46B page 111) related to transaction analysis, journal entries for typical business transactions, adjusting entries and preparation of the trial balance and adjusted trial balance.

Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.

By Wednesday, April 23, 2014 deliver your assignment to the M1: Assignment 4 Dropbox.




Preparing financial statements and evaluating business performance.


Accent Photography works weddings and prom-type parties. The balance of capital was $20,000 at December 31, 2010. At December 31, 2011, the business’ accounting records show these balances:


Insurance expense         $8,000


Cash                                      $31,000


Accounts payable            $6,000


Advertising Expense       $1,000


Service revenue                               $81,000


Owner withdrawal          $15,000


Accounts receivable       $10,000


Note payable                     $12,000


Owner equity                    ?


Salary expense                 $27,000


Equipment                          $60,000


Owner Investment         $33,000




Prepare the following statements for Accent Photography for the year end December 31, 2011:


  1. Income statement
  2. Statement of owner’s equity
  3. Balance sheet








Analyzing and journalizing transactions, posting, and preparing trial balance.


Warren Smith practices medicine under the business title Warren Smith, M.D. During April, the medical practice completed the following transactions:


Apr 1                                     Smith deposited $78,000 cash in the business bank account. The business gave capital to Smith.


Apr 5                                     Paid monthly rent on medical equipment, $780.


Apr 9                                     Paid $18,000 cash to purchase land for an office site.


Apr 10                                   Purchased supplies on account, $1,200.


Apr 19                                   Borrowed $20,000 from the bank for business use. Smith signed a note to the bank in the name of the business.


Apr 22                                   Paid $800 on the account.


Apr 30                                   Revenue earned during the month included $5,900 cash and $4,900 on account.


Apr 30                                   Paid employees’ salaries $2,000, office rent$1,800, and utilities $420. Make a single compound entry.


Apr 30                                   Owner withdrew $9,000.




The business uses the following accounts:


Cash; Accounts receivable; supplies; Land; Accounts payable; Notes payable; Warren Smith, capital; Warren Smith, withdrawals; Service revenue; Salary expense; rent expense; Utility expense.


  1. Journalize each transaction, as shown for April. Explanations are not required


For a custom paper on the above topic, place your order now!

What We Offer:

• On-time delivery guarantee

• PhD-level writers

• Automatic plagiarism check

• 100% money-back guarantee

• 100% Privacy and Confidentiality

• High Quality custom-written paper

How to Place an Order 

Send the assignment details such as the instructions, due date/deadline, number of pages and college level to the customer support agent online on live chat,  fill in the assignment details at place an order or send the information to our email address and a customer support agent will respond to you immediately. 

Once you place your order, we choose for you the best and competent writer for your assignment based on each writer’s competence in handling a subject. 

When the homework is completed, we have a quality assurance team that proofreads the assignment to ensure it meets the required rubric instructions from your professor.

After thorough review of your assignment, we send the paper to the client. In case you need any changes at this point, you can let us know so that we can handle it for you at no extra charge. 

Homework Help Website

Why we should write your Paper 

  1. Money Return guarantee
  2. 0% Plagiarism Rate
  3. Guaranteed Privacy
  4. Written from scratch by highly qualified writers 
  5. Communication at Any Time (24/7)
  6. Flexible Pricing and Great Discount Programs
  7. Timely Deliveries
  8. Free Amendments
Looking for a similar assignment and in urgent need for help? Place your order and have excellent work written by our team of professionals to ensure you acquire the best grades.

  We are here to assist you.


Statistics about Us

130 New Projects
235 Projects in Progress
315 Inquiries
420 Repeat clients

© 2021 Premiered Tutorials
All rights reserved. We provide online custom written papers, such as term papers, research papers, thesis papers, essays, dissertations and other custom writing services.

All papers inclusive of research material are strictly intended to be used for research and study purposes only. Premiered Tutorials does not support or condone plagiarism in any form. These custom papers should be used with proper reference.

Place an Order
error: Content is protected !!