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 $570,000 and total liabilities of $235,000. During the current year, the following summarized events occurred:

1. Issued additional shares of common stock for $105,000 cash.
2. Borrowed $159,000 cash from the bank and signed a 10-year note.
3. Built an addition on the buildings for $240,000 and paid cash to the contractor.
4. Purchased equipment for the new addition for $35,500, paying $3,550 in cash and signing a note for the balance due in two years.
5. Returned a $3,550 piece of equipment, from (d), because it proved to be defective; received a reduction of the notes payable.
6. Purchased a delivery truck (equipment) for $21,750; paid $15,225 cash and signed a two-year note for the remainder.
7. A stockholder sold $9,350 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.