Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock

In the books of ABC company Income statement for the y... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The General Social Survey asked the following two questions of randomly selected individuals. Do you favor or oppose the death penalty for persons convicted of murder? Should it be possible for a...

The following two questions appear on an employee survey questionnaire. Each answer is chosen from the five point scale 1 (never), 2, 3, 4, 5 (always).

solve the following two questions in detail step by step. 1. (10x - 2secx) dx 2. 2xy dxdy

Excerpts from Crozier Industries' financial record as of December 31, 2012, follow: The amount shown do not include any tax effects. Crozier's tax rate is 35 percent. Assume that all items are...

This trial balance of Michels Co. does not balance. Each of the listed accounts has a normal balance per the general ledger. An examination of the ledger and journal reveals the following errors:1....

Aardvark Consulting is a consulting firm owned and operated by Jan Sullivan. The following end-of-period spreadsheet (work sheet) was prepared for the year ended November 30, 2010. Based upon the...

The trial balance of Kinnear Dry Cleaners on June 30 is given here. The July transactions were as follows.July 8 Received $5,189 in cash on June 30 accounts receivable.9 Paid employee salaries...

The trial balance of Terry Manning Fashion Center contained the following accounts at November 30, the end of the companys fiscal year. Adjustment data: 1. Store supplies on hand totaled $2,500. 2....

The adjusted trial balance of Daddys Music Company at April 30, 2012, follows: Requirements 1. Journalize Daddys closing entries. 2. Prepare Daddys single-step income statement for the year. 3....

Luol Deng CPA, was retained by Acie Cable to prepare financial statements for April 2012. Deng accumulated all the ledger balances per Acie?s records and found the following. Luol Deng reviewed the...

Complete the mechanism for the following reaction by adding the missing bonds, charges, nonbonding electrons, and curved arrows. 0: 1+ H :8-H H 1L 1/ +H2O H-8: 8: 0 -H Draw only one curved arrow....

Explain the difference between cash and profit.

Response 1 of 2 : Yes, it indicates a company's core business cannot sustain its every day expenses.Yes, it indicates a company's core business cannot sustain its every day expenses.Response 2 of 2 :...

what is the importance of managerial Finance?

Which test on the reagent strip can indicates the presence of liver disease? a. Bilirubin O b. Urobilinogen C. Blood d. Glucose

A patient had an elevated cortisol after low dose Dexamethosone test. Which of the following may explain this result? a. Addison's disease b. Cushing's syndrome c. Cushing's disease d. A normal...

write a paragraph about how to convince your parents to go camping with your friends ?

Which of the following statements best describes Cushing's syndrome? a. Cushing's syndrome refers to a disease process caused by abnormally low levels of aldosterone b. Cushing's syndrome refers to a...

What is one common international law system? Negligence Democratic Islamic law Freedom

Hello I've attached an Excel file and I need help with answering the questions in Excel sheets 6-10. Please let me know if you can help me, thank you. NZ1832 I SEE THE LIGHT www.cybertext.com, The...

Please find attached assignment and see if you can help me in that and provide me the main points (in the article of spencer and web (2015) as attached) that need to be criticized, also I need an...

I need, I am working on GENERAL ELECTRIC AND UNITED TECHNOLOGIES CORP, I need help GE and UTC Financial Statements Forecast for the next 5 year using the attachment. Throughout this course you will...

***PLEASE READ THIS FIRST*** I just need the following 3 questions answered. The answers for Questions 1 and 2 must be well-written, detailed, and must answer each question fully with examples from...

Could someone please assist me with the following project? You are required to prepare the following financial statements using Excel. USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT...

Instructions 1.The due date for this assignment is Friday 16 July (Session 10) at 5pm via the online LMS portal under Session 10. Late submission will not be accepted. 2.This assignment is designed...