Bulldog Merchandise started a new business in January and had following transactions:

Jan. $1$ Issued common stock in exchange for $$103,000$ cash.

$2$ Purchased inventory on account for $$38,000($the perpetual inventory system is used$).$

$4$ Paid an insurance company $$2,760$ for a one$-$year insurance policy.

$10$ Sold merchandise on account for $$12,300.$ The cost of the merchandise was $$7,300.$

$15$ Borrowed $$33,000$ from a local bank and signed a note. Principal and interest at $10\%$ is to be repaid in six months.

$20$ Paid employees $$6,300$ salaries and wages for the first half of the month.

$22$ Sold merchandise for $$10,300$ cash. The cost of the merchandise was $$6,300.$

$23$ Purchased $$1,200$ office supplies on account.

$24$ Paid $$15,300$ to suppliers for the merchandise purchased on January $2.$

$26$ Collected $$6,150$ on account from customers.

$28$ Paid $$1,000$ to the local utility company for January gas and electricity.

$30$ Paid $$4,300$ rent for the building. $$2,150$ was for January rent, and $$2,150$ for February rent

$31$ There was $$800$ worth of office supplies available at the end of January $31.$

Required:

$1-$ Record the above transactions in an Excel sheet using the Accounting Equation similar to what we practiced in class, that includes end of period adjusting entries, if any

$2-$ Prepare income statement as of January $31$ similar to what we practiced in class.

$3-$ Prepare balance sheet as of January $31$ similar to what we practiced in class.

The last question was answered as an outline, please make income statements, balance sheets, and any entries required. Please provide them in table format so I can replicate it into Excel. This needs to be speicifc, not a template.