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