Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following financial data shows the unadjusted trial balance of the Hilal Company as of December 31, 1998: Hilal Company Worksheet Dec. 31, 1998 Cr.

image text in transcribed
The following financial data shows the unadjusted trial balance of the Hilal Company as of December 31, 1998: Hilal Company Worksheet Dec. 31, 1998 Cr. Dr. 11000 7100 4000 3200 9500 15600 Account Titles Cash A/R Prepaid Insurance Inventory 1/1/1998 Land Building Accumulated Depreciation A/P Common Stock Retained Earnings Dividends distribution Sales Rental Income Purchases Purchases Returns Salaries Expense Utilities Expense Administration Expenses Totals 8790 7000 15000 9500 2900 29000 1580 12700 1500 2000 1320 3050 72370 72370 If you know the following additional information: 1. Expired insurance equals JD3550. 2. Ending inventory on Dec. 31, 1998 equals JD3500. 3. Estimated depreciation on buildings is JD610. 4. Rental income, JD750 for December is earned, but it's not received. 5. Utilities expenses, JD400 are not paid and not recorded yet. Required: Prepare the worksheet by using the Microsoft Excel program

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Auditing Assurance And Consulting Services

Authors: Kurt Reding, Paul Sobel, Michael Head, Sridhar Ramamoorti, Urton Anderson

2nd Edition

0894136437, 978-0894136436

More Books

Students also viewed these Accounting questions