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 $690,000 and total liabilities of $295,000. During the current year, the following summarized events occurred: a. Issued additional shares of common stock for $165,000 cash. b. Borrowed $120,500 cash from the bank and signed a 10-year note. c. Built an addition on the buildings for $261,000 and paid cash to the contractor. d. Purchased equipment for the new addition for $39,750, paying $3.975 in cash and signing a note for the balance due in two years. e. Returned a $3,975 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.750: paid $7.525 cash and signed a two-year note for the remainder. g. A stockholder sold $5,550 of his stock in Mallard Incorporated to his neighbor. Required: 1. 1. Complete the spreadsheet that follows. The first transaction is used as an example. 2. 3. 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 Mallard Incorporated's (MI'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 Liabilities Stockholders' Equity Cash Equipment Buildings Notes Payable Common Retained Stock Earnings b 165.000 120 500 165.000 120 500 c (261,000) 261,000 d (3.975 39.750 35.775 (3975) (3975) (7.525 10.750 3225+ Change in Balances 13.000 46.525 261.000 155.525+ 165.000 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 asse the end of year. 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. Amount