Melissa Young had always been encouraged by her accounting professor to apply her accounting skills as much as possible. When her uncle asked her to prepare his accounting records for a company he owns, called Uncle Bob's Repairs Ltd., she readily agreed.

Th e company has two employees who repair and service all computers used by four large companies in the area. Melissa spoke to her professor who suggested that, due to the size of the business, she could record the company's transactions on a spreadsheet with the column headings representing the names of accounts that would appear in order on the income statement and statement of financial position. Each row of the spreadsheet could act like a journal entry. In addition, each column could act like a T account showing all debit and credit entries to an account. Melissa could add up the columns on the spreadsheet to determine the balance in each account at the end of the year. She could then build her fi nancial statements on the spreadsheet by referencing the amounts for each item or category on the financial statements from the column totals.

Her uncle gave her the following information regarding its fi rst year of operations, ending August 31, 2015:

1. When the corporation was formed on September 1, 2014, common shares were sold to Uncle Bob for $10,000 cash.

2. Uncle Bob added up all of the invoices the company issued to its customers and the total came to $229,400. All of these were issued on credit.

3. Th e company received $190,000 cash from customers when they paid their invoices.

4. Th e company rents a small repair shop for $3,500 per month. Th e shop was rented for the full year and all rent was paid in cash. In addition, the landlord required the company to pay one month's rent in advance.

5. Salaries to employees totalled $120,000 for the year and were paid in cash.

6. Uncle Bob determined from a review of numerous invoices that the offi ce expenses for the year were $36,400. Of these, all were paid except $4,000 that was still owing.

7. In late August 2015, a new customer approached the company and signed a contract for service to be done to its computers starting in October 2015. Th e customer paid the company $2,000 in advance to secure the service.

8. Uncle Bob estimated that given the profi t earned by the company this year, income tax expense should be $6,200 but this would not have to be paid for another two months.

9. Th e company paid Uncle Bob a dividend amounting to $1,000 at the end of the year.

Instructions

(a) Prepare a tabular analysis of the effects of the above transactions on the expanded accounting equation. If you have access to spreadsheet soft ware, prepare the analysis on a spreadsheet as suggested. If not, prepare the analysis manually as shown in the chapter.

(b) Do you think that a spreadsheet could be used as described above and replace the requirement to journalize and post transactions? Explain.

(c) Prepare an income statement, statement of changes in equity, and statement of fi nancial position for the year.

(d) Th ere were seven transactions that aff ected cash. Which of these related to operating activities? What was their total effect? What would Uncle Bob think about the operating cash flow? Which cash flows would be considered financing

activities? Did the company need these cash flows?

(e) Th e company could not borrow any money from a bank to help start operations. Why do you think this happened?

(f) If the income taxes were due next week, would the company be able to pay them?

(g) Why does the company have to pay income tax? Should Uncle Bob pay tax on any of the profit earned by the company?