Finance and Accounting for Economic Development

Question 1 - 82 marks

BBI is an economic development corporation situated on B First Nation. BBI has formed a company called Band Limited and requires the financial statements to be prepared and analyzed for the year ended December 31, 2019.

The following are the balances in the accounts at December 31 2018:

• Cash $602,900;
• Accounts receivable $10,000;
• Merchandise inventory $3,000;
• Prepaid rent $3,150;
• Equipment $55,000;
• Accumulated depreciation $13,750;
• Land $40,000;
• Accounts payable $0;
• Long-term note payable $200,000;
• Common shares $440,000;
• Retained earnings $60,300.

The following transactions and events occurred in 2019.

Jan. 1 Issued $50,000 of 5% preferred shares for cash.

Jan. 1 Sold the equipment at its written-down value (book value) for cash.

Jan. 1 Acquired new equipment for $150,000 cash. The new equipment has an estimated useful life of 15 years and no expected residual value.

Apr. 1 Purchased inventory for $80,000 cash from ordinary suppliers.

July 1 Paid rent in advance of $3,200 on a six-month office lease.

Aug. 1 Made cash sales of $150,000. The related cost of goods sold was $65,000.

Sept. 1 Purchased additional land for cash of $20,000.

Oct. 31 All remaining accounts receivable were collected.

Dec. 30 Various operating expenses totaled $40,000. All were paid in cash except for $5,000 for utilities, which will be paid in January.

Dec. 31 Paid the annual dividend on the preferred shares, and a 5-cent dividend per common share.

Dec. 31 Paid the interest on the bank loan.

Dec. 31 Recorded depreciation for the new equipment.

Dec. 31 Recorded rent expense for 2019.

Dec. 31 Paid cash of $3,800 for income taxes.

Required

(a) Using either journal entries or the transactions-based approach (tabular analysis), record the above transactions and events for 2019. (28 marks)

(b) Prepare an income statement for the year 2019.(11 marks)

(c) Prepare a statement of changes in equity for the year 2019. (5 marks)

(d) Prepare a balance sheet as at December 31, 2019. (10 marks)

(e) Using the financial statements you prepared, calculate the following: (28 marks)

(i) Return on assets ratio

(ii) Return on equity ratio

(iii) Gross profit percentage

(iv) Return on sales ratio

(v) Net income to sales ratio

(vi) Earnings per share

(vii) Dividend payout ratio

(viii) Receivables turnover ratio

(ix) Inventory turnover ratio

(x) Asset turnover ratio

(xi) Current ratio

(xii) Quick ratio

(xiii) Debt to equity ratio

(xiv) Debt to assets ratio