Jacks Bottleshop Ltd is a business selling liquor. The company has two shareholders, Mr Daniels and Ms

Bourbon. The shareholding in the company is as follows:

31 March 2022 31 March 2023

Mr Daniels 60,000 ordinary shares 80,000 ordinary shares

Ms Bourbon 30,000 ordinary shares 40,000 ordinary shares

You have been asked to prepare special purpose financial reports for Jacks Bottleshop Ltd for the year

ended 31 March 2023.

You have been provided with an Unadjusted Trial Balance (refer Pages 4 and 5) for the year ended 31

March 2023 along with the supplementary information set out below.

Supplementary information:

i) An invoice for Rates of $700, relating to the quarter ending 31 March 2023, has not yet been

received.

ii) In late February 2023 the business decided to rent out an unused storage space in their building. So

far, the company has received rental income covering the entire months of March and April 2023.

iii) The ASB loan was taken out on 1 May 2022 and accrues interest at 6% per annum. The current

portion of the loan as at 31 March 2023 was $10,000.

iv) Insurance expense relates to insurance of the business assets. The policy runs from 1 July 2022 to 30

June 2023.

v) Advertising expenses relates to a radio contract that runs from 1 June 2022 to 31 May 2023.

vi) A dividend of $800 was declared on 14 March 2023 in respect of the companys investment in Folly

Wines Ltd. The dividend is expected to be received by the company on 12 April 2023.

vii) The company wants to claim Depreciation on its property, plant and equipment calculated at the

following annual rates:

Land 0%

Building 2% Diminishing Value

Equipment 30% Diminishing value

Fixtures and Fittings Straight line method over 10 years with a residual value of $7,600

Motor Vehicle 20% Diminishing Value. The motor vehicle was purchased on 15 October

2022.

viii) During the year, a dividend of $50,000 was paid out of the companys Retained Earnings. This has

already been accounted for in the Unadjusted Trial Balance.

ix) In March 2023 the company contracted Able Valuers Ltd to provide a formal valuation of the Land.

As a result of the exercise, it was determined that the Land should be revalued upwards by $160,000.

REQUIRED:

a) Complete the Worksheet - Trial Balance to prepare an Adjusted Trial Balance for Jacks Bottleshop

Ltd as at 31 March 2023, taking into account all of the relevant supplementary information

provided above.

Jacks Bottleshop Limited Worksheet Trial Balance as at 31 March 2023

Unadjusted Trial Balance

Adjustment Reference Adjustments Adjusted Trial Balance DR CR DR CR DR CR Accounts Receivable 15,000 Inventory 4,600 Land at cost 460,000 Buildings - at cost 260,000 Accumulated Depreciation Building 5,200 Equipment - at cost 124,000 Accumulated Depreciation Equipment 39,800 Fixtures and Fittings at cost 47,600 Accumulated Depreciation Fixtures and Fittings

8,000 Motor Vehicle 75,000 Investment Shares in Folly Wines Ltd 5,000 Accounts Payable 30,700 Bank Overdraft 1,900 ASB Loan (Repayable 1/4/2028) 60,000 Share Capital 120,000 Retained Earnings 61,800 Asset Revaluation Reserve 0 Sales Beer and Cider 1,324,000 Sales - Other 258,000 Rental Income 4,000 Cost of Sales 585,200 Advertising expense 14,400 Bank fees 800 Motor Vehicle Expenses 3,600 Sales and Delivery expenses 2,200 General Expenses 41,200 Insurance Expense 36,000 Interest Expense 2,700

Rates 2,100 Salaries and Wages 234,000

1,913,400 1,913,400