Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The first step of this assessment is to review the scenario and detailed information provided below, about a company titled Banco Extrusion Inc. All required

The first step of this assessment is to review the scenario and detailed information provided below, about a company titled Banco Extrusion Inc. All required information to complete the bookkeeping for this company using Excel is included there. Produce the following:

  • Using an excel file, you are required to complete the set of books for Banco Extrusion Inc.
  • You are required to post the journal entries for the transactions listed below.
  • You are required to create a general ledger and trial balance based on the journal entries.
  • Use account names you are familiar with in your program of study.
    • NOTE: Use only the HST Payable account and HST paid on expenses account.
  • Ignore decimal places. Round to the nearest dollar. Use all Excel functions where reasonable.
  • Record all prepaid expenses to prepaid accounts.
  • You must provide a short description for each journal entry. Ignore HST unless otherwise explicitly stated
  • Once you have completed the required set of books for this first assignment, ensure that you save it so that you can use it for Part II.

During the first month of operations, the Banco Extrusion Inc, located in Ontario Canada, which specializes in auto component manufacturing completed the following transactions.
Date 2023
1 George Leblanc started the business by making a deposit into company bank account for $35,000, in exchange for 3,500 shares of $10 par value common stock.
1 Banco acquired a small machinist shop for $25,000 cash which represented- Computer - $5,800, Furniture, - $6,500 and Store equipment $12,700.
2 Received bank loan for $100,000, 6% annual interest. Payments are due on the last day of each month in the amount of $4,000.
2 Paid rent for the 3-month quarter January to March in the amount of $3,000 per month.
2 Paid the premium on a 1-year insurance policy, $5,000.
3 Purchased $800 in office supplies
5 Purchased inventory on account for $60,000 + 13% HST. Terms 2/10, n30.
13 Hired two full-time staff members, Lan and Liz, both who earn $36,000 a year and are paid bi-weekly beginning Jan 24.. Assume basic payroll deductions for Ontario. They work five days a week (Mon-Fri).
17 Record cash sales for the week in the amount of $10,000 + 13% HST. Cost of Goods Sold amounted to $5,500.
17 Purchased extrusion machine and equipment from Patel Inc. for $6,000. Paid $1,500 down and the balance was placed on account. Payments will be $375.00 per month for 12 months. The first payment is due Feb 1. Note: Use accounts payable for the balance due. Ignore HST and interest.
17 Record sales on account for the week in the amount of $12,000 + HST. Cost of goods sold was $8,000.
24 Paid both Lan and Liz their bi-weekly pay. Calculate deductions for CPP, EI and Ontario tax. Record employee portion only.
24 Record cash sales for the week in the amount of $15,000 + 13% HST. Cost of Goods Sold amounted to $10,000.
27 Record sales on account for the week in the amount of $15,000 + HST. Cost of goods sold was $8000.
28 Paid accounts payable in full from January 5.
30 Record collection on outstanding accounts receivable for January in the amount of $20,000 + HST.
30 Purchased inventory on account in the amount of $6,000 + HST.
30 Paid loan payment of $4,000 plus interest of $500.

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

Human Resource Management

Authors: Robert L. Mathis, John H. Jackson

13th Edition

053845315X, 978-0538453158

More Books

Students also viewed these Accounting questions

Question

Cite common obstacles to reaching your goals.

Answered: 1 week ago

Question

How is quantitative research different from qualitative research?

Answered: 1 week ago

Question

Why do experiments allow cause-and-effect inferences?

Answered: 1 week ago

Question

How can bias in experimental research be prevented?

Answered: 1 week ago