Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Include HST on all purchase and Sales. No HST on Salary and Rent. a) On Jan1st, Sam put $50 000 cash into a checking account

Include HST on all purchase and Sales. No HST on Salary and Rent.

a) On Jan1st, Sam put $50000 cash into a checking account for his new clothing and tailoring business.
b) On Jan2, he paid $2000 cash to rent a space in the mall
c) On Jan3, Sam bought furniture in the shop for $3500 on terms 2/10, n30
d) Jan 5, He bought 500 Belt at $5 each on terms 2/10, n30
e) Jan 6, Sam returned 50 Belts due to defects
f) Jan7, He sold 200 Belts at $25 each on account 2/15,n15
g) Jan7, he paid cash $2000 in salaries to his staff
h) Jan 9, Sam bought 200 Belts for $4 each for Cash
i) Jan 10, Sam sold 100 Belts for $20 each on cash
j) Jan 11, he bought a truck for business use for $10000 on terms 5/5, n15
k) Jan 11, He made the payment for Jan 03rd purchase
l) Jan 11, He paid in full for the purchase made on Jan 05th
m) Jan 12, He received cash in full for the sale made on Jan 7th
n) Jan 20, he paid $1200 for next 12 months of grass cutting.
o) Jan 21, he withdrew $1000 for his personal use.
p) Jan 22, received $1000 money for tailoring services to be provided later from JJ entertainment

Following is additional information provided for the month just ended 31st January 2023

q) Depreciation of $100 per month is calculated on the furniture
r) Grass cutting expenses for the month of January needed to be calculated
s) Provided services for JJ entertainment, worth $500 for the advance payment made earlier

Required:

Prepare a trial balance in excel

Prepare Income statement

Prepare statement of Owners Equity

Prepare balance sheet

Calcualte current ratio

Calculate GP and NP margins

Calcualte the ROI

What will you reccomened as an advisor to an investor who wants to invest in this company

need every step in excel

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

Auditing A Practical Approach

Authors: Robyn Moroney, Fiona Campbell, Jane Hamilton

4th Edition

0730382648, 978-0730382645

More Books

Students also viewed these Accounting questions

Question

Evaluate the impact of technology on HR employee services.

Answered: 1 week ago

Question

Identify three ways to manage an intergenerational workforce.

Answered: 1 week ago

Question

Prepare a Porters Five Forces analysis.

Answered: 1 week ago