Mallard Incorporated (MI) is a small manufacturing company that makes model trains to sell to toy stores. It has a small service department that repairs customers' trains for a fee. The company has been in business for five years. At the end of the previous year, the accounting records reflected total assets of $500,000 and total liabilities of $200,000. During the current year, the following summarized events occurred: a. Issued additional shares of common stock for $100,000 cash. b. Borrowed $120,000 cash from the bank and signed a 10-year note. c. Built an addition on the buildings for $200,000 and paid cash to the contractor. d. Purchased equipment for the new addition for $30,000, paying $3,000 in cash and signing a note for the balance due in two years. e. Returned a $3,000 piece of equipment, from (d), because it proved to be defective; received a reduction of the notes payable. f. Purchased a delivery truck (equipment) for $10,000; paid $7,000 cash and signed a two-year note for the remainder. g. A stockholder sold $5,000 of his stock in Mallard Incorporated to his 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 stockholders' equity at the end of year. 4. As of the current year-end, has the financing for Ml's investment in assets primarily come from liabilities or stockholders' equity? Complete this question by entering your answers in the tabs below. Required 1 Required 3 Required 4 Complete the spreadsheet that follows. The first transaction is used as an example. (Enter any decreases to account balances with a minus sign.) Assets Equipment Buildings Cash Liabilities Notes Payable Stockholders' Equity Common Retained Stock Earnings 100,000 a. 100,000 b. C. d. e. f. g . End. Required 1 Required 3 > Complete this question by entering your answers in the tabs below. Required 1 Required 3 Required 4 Based on beginning balances plus the completed spreadsheet, provide the Total assets, liabilities and stockholders' equity at the end of year. Amount a. Total assets at the end of the year. b. Total liabilities at the end of the year. C. Total stockholders' equity at the end of the year.