Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare the following two questions on excel sheets Question one: 1. Based on the discussed future businesses of each one of you, prepare a

Prepare the following two questions on excel sheets Question one: 1. Based on the discussed future businesses of each one of you, prepare a list of 20 transactions of your future business 2. use the same 20 transactions to prepare the following requirements on an excel sheet: a. The general journal b. The ledger c. The trial balance Question two: 3. the following transactions are taken from the ABC company on 31 December 2019, prepare on excel: a. the balance sheet and b. Income statement for the debit credit Sales 40000 Purchases 18500 Wages and salaries Repairs and maintenance Heating and lighting General expenses 5100 1300 900 1200 Insurance 800 Cash at bank 2200 Cash in hand 1300 Trade receivable Trade payable Premises Fixture and fitting Motor vehicle Capital at 1st January 2019 drawings 4100 3400 30000 10000 8000 52000 12000 95400 95400

Step by Step Solution

There are 3 Steps involved in it

Step: 1

In the books of ABC company Income statement for the y... 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

Fundamentals Of Statistics

Authors: Michael Sullivan III

4th Edition

978-032184460, 032183870X, 321844602, 9780321838704, 978-0321844606

More Books

Students also viewed these Accounting questions