Matador Inc. provided the following information for the first quarter of $2024.$

$1.$ Jan. $1$st $$ Issued common stock for $$2,000,000$ cash

$2.$ Jan. $1$st $-$ Borrowed $$500,000$ from the Texas State bank by signing a $9$ mo$.,8\mathrm{.}5\%$ interest note

$3.$ Jan. $1$st $-$ Purchased building and land for $$1,000,000$ total. Land appraised for $$250,000$ and building appraised for $$1,000,000$ by issuing a $15-$year, $3\mathrm{.}5\%$ note. Interest is paid quarterly. Building is expected to have a useful life of $20$ years. The salvage value of the building is estimated to be $$200,000.$

$4.$ Jan. $1$st $-$ Purchased office equipment by signing a note payable. Terms of note: Matador will pay $$30,000$ semi$-$annually for $5$ years. The office equipment is expected to be useful for $10$ years and will have no salvage value.

$5.$ Jan. $15$th $$ Matador purchased $1,000$ units of inventory on account for $$100$ each.

$6.$ Feb. $1$ Issued Bonds $$250,000(5$ year; Stated rate $=6\%$; Interest compounds annually$)$ at $102.$

$7.$ Feb. $1$st $-$ Purchased Inventory on Account; $500$ units for $$120$ each

$8.$ Feb. $15$th $$ Sold $800$ units for $$150,000$ of which $$50,000$ was cash and $$100,000$ was on account

$9.$ Mar. $1$st $$ Received $$35,000$ from sales on account

$10.$ Mar. $5$th $$ Matador determined that a $$1,500$ account should be written$-$off as the customer filed for bankruptcy

$11.$ Mar. $15$th $$ Paid cash for the following expenses that were incurred:

a$.$ $$6,500$ Utilities

b$.$ $$12,000$ Wages

c$.$ $$2,500$ Advertising

$12.$ Mar. $31$st $$ Paid interest due on the building note

Additional Information:

$$ Uncollectible Accounts $-$ Matador estimated that $5\%$ of A$/$R $($as of $3/31)$ would be uncollectible

$$ Inventory methods $-$ Perpetual method; Last$-$in$,$ First$-$out cost flow assumption

$$ Depreciation method $-$ Straight$-$line

Prepare the following for the first quarter of the year using the provided Excel template:

$$ JEs

$$ Post to Ledger

$$ Unadjusted Trial Balance

$$ AJEs

$$ Adjusted Trial Balance

$$ Financial Statements

$$ Closing JEs

$$ Post$-$Closing TB

In order to receive full credit you must use formulas and cell referencing on your spreadsheet.

Please provide all journal entries for the obove statements.