I need help in understanding how to form a debit/credit balance sheet format in Excel for the following problem and explain how you got there. I am having trouble getting started.

Use the horizontal model, or write the journal entry, for each of the following transactions and adjustments the occurred during the first year of operations at Kissick Co.

a. Issued 100,000 shares of $5-par-value common stock for $500,000 in cash.

b. Barrowed $250,000 from Oglesby National Bank and signed a 12% note due in three years.

c. Incurred and paid $190,000 in salaries for the year

d. Purchased $320,000 of merchandise inventory on account during the year

e. Sold inventory costing $290,000 for a total of $455,000, all on credit

f. Paid rent of $55,000 on the sales facilities during the first 11 months of the year

g. Purchased $75,000 of store equipment, paying $25,000 in cash and agreeing to pay the difference within 90 days

h. Paid the entire $50,000 owed for the store equipment and $310,000 of the amount due to suppliers for credit purchases previously recorded

I. Incurred and paid utilities expense of $18,000 during the year

j. Collected $412,000 in cash from customers during the year for credit sales previously recorded

k. At year-end, accrued $30,000 of interest on the note due to Oglesby National Bank

l. At year-end, accrued $5,000 of past-due December rent on the sales facilities.