i just need help with the spreadsheet part. the company has been in biz for 5 years. at the end of the previous year they had total assets of 620,000 and total liabilities of 260,000. durring the current year the following events occured.

a. issued additional shares of common stock for $130,000 cash

B. Borrowed 167,000 from the bank and signed a 10 year note

C. built an additon on the buildings for 264,000 and paid cash to the contracter

D. purchased equipment for the new addition for $36,500, paying $3650 in cash and signing a note for the balance due in 2 years.

E. Returned a $3650 piece of equipment from D because it proved to be defective, recieved a reduction of the notes payable.

F. purchased a delivery truck for $14,500; paid 10,150 cash and signed a two year note for the remainder

G, a stockholder sold $6,550 of his stock to a neighbor

Required: 1. Complete the spreadsheet that follows. The first transaction is used as an example. 3. Based on beginning balances plus the completed spreadsheet, provide the Total assets, liabilities and stockholde end of year. 4. As of the current year-end, has the financing for Mallard Incorporated's (MI's) investment in assets primarily come stockholders' equity? Complete this question by entering your answers in the tabs below. Complete the spreadsheet that follows. The first transaction is used as an example. (Enter any decreases to account balar with a minus sign.)