Posted: November 9th, 2015

Comm 210 Financial Accounting Practice Case Mountain Adventures Ltd.

Comm 210
Financial Accounting
Practice Case
Mountain Adventures Ltd.
Fall 2015 Edition
2
Introduction
This practice case has been designed to give introductory-level business students practical experience in the
application of accounting concepts.
This practice case will provide students with an overview of the complete accounting cycle of a merchandising
company located in British Columbia.
Initial transactions are analyzed, journalized in the general journal and recorded in the general ledger,
adjusting entries are required under the accrual concept of recording accounting information which is in
accordance with accounting standards for private enterprises (ASPE) and International accounting standards
(IFRS) in Canada. Financial Statements are prepared and some comments on the solvency and profitability of
the company are requested.
This exercise can be completed with the assistance of a computer software package OR manually using a
spreadsheet software program.
The Company
Mountain Adventures Ltd., located in Prince George, B.C., is a wholesale company selling supplies and
materials for climbing, hiking and other outdoor activities mainly to the retail supply stores in British Columbia.
Mountain Adventures Ltd. is a Canadian controlled private corporation, incorporated under the laws of British
Columbia, and is required to remit GST, Goods and Services Tax, at the rate of 5% on all its sales and must
remit taxes collected to the federal government on a quarterly basis. GST amounts charged by its suppliers
can be deducted from this remittance.
Mountain Adventures Ltd. is required to remit PST, Provincial Sales Tax, at the rate of 7% on all its sales and
must remit taxes collected to the provincial government on a monthly basis.
Mountain Adventures Ltd. is considering an IPO (Initial Public Offering) and listing on the TSX, Toronto Stock
Exchange. Management is discussing the potential to expand into global adventure tourism. Therefore, IFRS
accounting standards are used.
Mountain Adventures Ltd. negotiated with most of its trade suppliers 1% or 2% discount if the company pays its
invoice within 10 days, otherwise the net amount is due within 20 to 30 days. GST is charged on the gross
amount.
Mountain Adventures Ltd. pays its workforce according to the Employment Standards Act of British Columbia.
All regulatory source deductions should be accounted for. The WorkSafe BC assessment rate is 1% of gross
salaries.
Mountain Adventures Ltd. invests excess cash in short term investments, from time to time.
Mountain Adventures Ltd. maintains a general journal and general ledger only.
The Financial Statements, June 30, 2015
The ‘Chart of Accounts’ of Mountain Adventures Ltd. as at June 30, 2015 together with the Balance Sheet as
at June 30, 2015 showing the ‘Opening Balances’ as of this date are as follows:
3
Chart of Accounts- Current Year 2015 Sample Sage/Simply Accounting account set up
ASSETS Current Assets
1060 Cash
1200 Accounts receivable
1205 Allowance for doubtful accounts
Accounts receivable: Net
1300 Prepaid insurance
1301 Prepaid rent
1350 Inventory
1400 Held for trading investments
Total Current Assets
Property, Plant & Equipment
1820 Store equipment
1825 Accumulated Depreciation- Store equipment
Store equipment: Net
1880 Land
Total Property, Plant & Equipment
LIABILITIES Current Liabilities
2100 Accounts payable
2140 Notes payable
2150 Bank loan
2160 Corporate income taxes payable
2170 Worksafe BC payable
2180 PST payable
2215 EI payable
2220 CPP payable
2225 Income tax payable
Total payroll deductions
2380 GST collected on sales
2385 GST paid on purchases
GST payable
2400 Interest payable
Total Current Liabilities
EQUITY
Share Capital
3350 Common shares
Share capital
3500 Retained earnings
3560 Retained earnings, previous year
Total retained earnings
REVENUE
Revenue
4210 Sales revenue
4220 Sales returns
Net Sales
Other Revenue
4300 Dividend revenue
4460 Gain on sale assets
Total Other Revenue
EXPENSE
Cost of Goods Sold
5010 Purchases
5020 Purchases returns
5030 Purchase discounts
5040 Cost of goods sold
Total Cost of Goods Sold
General & Operating Expenses
5620 Bad debts expense
5660 Depreciation expense
5685 Insurance expense
5740 Interest expense
5750 Rent expense
5760 Salaries and benefits expense
5770 Worksafe BC expense
5780 Income tax expense
Total Expenses
4
Mountain Adventures Ltd.
Statement of Financial Position
As at June 30, 2015
ASSETS
Current Assets
Cash $24,100
Held-for-trading investments 10,000
Accounts receivable $5,000
Less: Allowance for doubtful accounts ( 1,000) 4,000
Inventory 20,000
Total Current Assets $58,100
Property, Plant and Equipment
Store equipment $30,000
Less: Accumulated depreciation, equipment (9,000) 21,000
Land 3,000
Total Property, Plant and Equipment $24,000
TOTAL ASSETS $82,100
LIABILITIES & SHAREHOLDERS’ EQUITY
Current Liabilities
Accounts payable $ 7,500
PST payable 1,000
GST payable 500*
Payroll liabilities 2,380**
Total Current Liabilities $11,380
Shareholders’ Equity
Common Shares $10,000
Retained Earnings 60,720
Total Shareholders’ Equity $70,720
TOTAL LIABILITIES & SHAREHOLDERS’ EQUITY $82,100
**post this opening balance to #2380 GST collected on sales
**comprises #2215 EI payable $135; #2220 CPP payable $370; #2225 Incomes tax payable $1675; #2170
Worksafe BC payable $200
5
The Transactions for July, 2015
July 2 – Sold merchandise to East Robson Inc. at invoice price of $15,500 + GST + PST; on
credit; terms, n/20; Invoice No. 1001
July 3 – Received merchandise from Everest Company at invoice cost of $2,000 + GST; credit
terms, 1/10, n /20; Purchase Order No. 5001. No PST since the manager provided the
provincial vendor number to the supplier. There will be no PST paid on any
merchandise purchased.
July 4 – Sold merchandise to West Rupert Co. for $4,500 + GST + PST; on credit terms, n/20;
Invoice No. 1002
July 5 – Received merchandise from Katmandu Ltd. at an invoice cost of $4,000 + GST on
credit; terms, 1/10, n/20; Purchase Order No. 5002
July 6 – Sold merchandise for cash to Tabor Equipment for $7,500 + GST + PST
July 7 – Received merchandise from Colton Manufacturing Company at a cost of $1,500 + GST;
paid cash
July 8 – Purchased a capital asset (store equipment) at a cost of $19,800 + GST + PST; gave a
90-day, 6 percent, interest-bearing note payable for the purchase price; assume date
was July 1, 2015 for interest and depreciation calculations
July 9 – Sold a tract of land for $9,000 + GST which previously was used by the company as a
parking lot and originally cost $3,000; collected cash
July 10- Collected the account receivable from West Rupert Co.; Invoice No. 1002
July 11- Paid $1,200 for a one-year insurance policy on property, plant and equipment starting
July 1, 2015
July 11- Obtained a $5,000 bank loan; signed a one-year, 7 percent, interest-bearing bank loan
agreement. Assume date was July 1, 2015 for interest calculation
July 12- Paid the account payable to Katmandu Ltd. within the discount period. Purchase Order
No. 5002
July 13- Paid monthly rent, $2,500 + GST
July 14- Sold merchandise for cash, $3,500 + GST + PST
July 15- Purchased merchandise for cash, $4,500 + GST
July 15- Paid June 30th source deductions to the Canada Revenue Agency (CRA), payable to
the Receiver General; CPP $370; EI $135; taxes $1675
July 16- Sold merchandise on credit to Purdon Co. for $6,500 + GST + PST; terms, n/20, Invoice
No. 1003
July 17- Received merchandise on credit from Mountain Co-Op at an invoice cost of $7,000 +
GST; terms n/30; Purchase Order No. 5003
6
July 18- Collected the account receivable from East Robson Inc. Invoice No. 1001
July 19- Paid the account payable to Everest Company after the discount period. Purchase
Order No. 5001
July 20- Returned merchandise purchased on account from Logan Ltd. for a credit; amount
$4,500 + GST
July 21- Received dividend revenue of $1,000 from the held-for-trading investments
July 25- Paid June 30th PST payable to the Minister of Finance
July 29- Purchased 600 shares of Ocean Electronics Inc. at $25.00 per share
July 30- Paid June 30th Worksafe BC payable to Worksafe BC, the assessment department of
the Workers’ Compensation Board
July 30- Paid June 30th GST payable to the Receiver General of Canada.
July 31- Paid monthly salaries: gross earnings $8,000 less; CPP $396; EI $140; income taxes
$1,500. Employer portions of CPP and EI and $80 for Worksafe BC premiums are also
recorded.
Adjustments
Data developed by Mountain Adventures Ltd. as a basis for the adjusting entries at July 31, 2015
were:
a) The average loss rate for bad debts is estimated to be 1 percent of net sales. Record for the
month of July.
b) The store equipment is depreciated on the straight-line basis of an estimated 10-year useful
life with no residual value. The equipment purchased in the period can be depreciated for the
entire month. Record one month depreciation.
c) On July 31, 2015, the periodic inventory count of goods remaining on hand reflected $25,000.
Hint: you need to adjust the opening inventory to a new account, Cost of Goods Sold and also
transfer purchases to this account. Thus the following adjusting journal entries will have to be
prepared:
1) Cost of goods sold xxx
Inventory xxx
To transfer the beginning balance to Cost of Goods Sold
2) Inventory xxx
Cost of goods sold xxx
To bring the inventory amount to the value as at July 31, 2015
3) Purchases (Acct.5010), Purchases Returns(Acct.5020) and Purchase Discounts
(Acct.5030) also form part of the Cost of Goods Sold amount
d) Account for the Interest expense on the Note Payable and the Bank Loan. OK to round to the
nearest dollar. Record one month interest expense.
7
e) Uncollectible amounts in accounts receivable total $560, including GST and PST.
f) Account for the Insurance expense, if applicable.
g) Unrecorded corporate income tax expense was $2,500.
h) Fair market value of the held-for-trading investment portfolio is $25,000.
Requirements:
Take the Mountain Adventures Ltd. Balance Sheet, as at June 30, 2015, and continue recording
transactions for the fiscal year end of July 31, 2015 as follows:
1. Analyze each of the July transactions and prepare a journal entry in the General Journal.
Explanations are not required.
2. Post the above journal entries to the General Ledger. Create the General Ledger accounts you
need and fill in the beginning balances before posting the July transactions.
3. Journalize and post the adjusting journal entries.
4. Prepare the July 31, 2015 (Adjusted) Trial Balance. Note: Simply Accounting will call this the ‘Trial
Balance’.
5. Prepare the Income Statement for the month of July and the Statement of Financial
Position/Balance Sheet as at July 31, 2015. (Amounts may be rounded to the nearest dollar)
6. Briefly comment on the financial health of Mountain Adventures Ltd.
Grade Criteria = 20% of 100 marks
Journal entries 30
Adjusting journal entries 20
General ledger 10
(Adjusted) Trial Balance 10
Income Statement 10
Balance Sheet/Statement of Financial Position 10
Comments on financial position 10
Total 100