Reference no: EM131127021

TASK 2

2 Prepare financial statements for a variety of businesses from trial balance, making appropriate adjustments

On 31.3.x7 the business made the following transactions
1. Bought material for $1,000 half for cash and half on credit
2. Made $1,040 sales $800 of which was for credit
3. Paid wages to shop assistants of $260 in cash

Please prepare the following financial statements
1 -  Draw up a trial balance showing the balances as at the end of 31.3. 20x7
2 - Prepare a profit and loss

Q-2 Prepare a statement of financial position for the Ted Hills Hardware Store as at 31 December 20X6, This is a sole trader.
Capital as at 1 January    20X6 $ 47,600
Profit for the year to 31 December    20X6 $8,000
Freehold premises, net book value at 31 December    20X6 $50,000
Motor vehicles, net book value at 31 December    20X6 $9,000
Fixtures and fittings, net book value at 31 December    20X6 $8,000
Long-term loan (mortgage)    $25,000
Bank overdraft*    $2,000
Goods held in inventory for resale    $ 16,000
Receivables    $500
Cash in hand*    $100
Payables    $1,200
Taxation payable    $3,500
Drawings   $4,000
Accrued costs of rent    $600
Prepayment of insurance   $300

* A shop might have cash in its cash registers, but an overdraft at the bank.

Q3 - Prepare a trial balance, P&L and a Balance sheet for Consulting Company
Cash   $7,000
Accounts Receivable   $3,000
Office supplies   $3,000
Office Equipment   $5,000
Bank Loan  $5,000
Accounts payable   $ 1,000
Capital    $10,000
Consulting revenue   $ 7,000
Rent  $600
Salaries   $2,500
Stationery   $1,200
Utilities expenses  $700

3- Prepare consolidated profit or loss and Balance sheet for a company

M Ltd acquired 75% of the share capital of N Ltd on its incorporation. The Balance Sheets of the two entities as at 31 December 20X7 are as follows:

M Ltd had not paid N Ltd for goods purchased therefore the sum of $6,000 is included in M's payables and in N's receivables.
Prepare a Consolidated Balance Sheet at 31 December 20X7. Show all workings.

BUSINESS SCENARIO
You are a newly appointed consultant in XYZ Financial Consultant Company. You provide financial consultancy to multiple different companies.
One of your clients is a very successful retail company that has a company structure. The board is contemplating an adaption of IFRS and more formal reporting as they are expanding the business.
The company is in retail business in the UK and has shops that sell food, clothing and house hold items.

Task 3 -
Consolidated Financial Statements
1- Explain how the information needs of different user groups vary
2 Prepare financial statements in a form suitable for publication by a sole trader, partnership & Limited company
Below is trial balance of a sole trader

NICO is a sole trader
The following final adjustments are required
1. Inventories at 31 July 20x9 were valued at $12,000
2. Selling and distribution expenses of $4,000 are to be accrued
3. Administration expenses of $6,000 were prepaid
4. The allowance for the receivables is to be adjusted to 5% of the receivables
5. Depreciation on the plan and machinery is $15,000 for the year to 31 July 20x9
Prepare the Profit and Loss for the year end 31 Jul 20X9 and the Balance sheet
as at 31 Jul 20x9 in a suitable for publication.
Below is a trial balance of a limited company

Prepare the financial statement suitable for publication

Un-urned income - is where the company collects money from the customer prior to the sale taking place example - deposit
The entries are
DR - Cash
Cr - Unearned income
Partnership accounting
Crossly, Steel and Nabs are partners in a business sharing profits in the ratio 5:3:2 respectively.
Their capital and current account balances on 1 Jan 20X1 were as follows

Crossly
Capital 24,000
Current 2,000
Steel
18,000
(1,000)
Nabs
13,000
1,500

Interest at 10% per annum is given on the fixed capital
Salaries of 8000 per annum per paid to Crossly and Steel
Crossly made a personal loan of 20,000 on the partnership on 1 July 20X1
Above loan to be paid in full on 30 June 20X4 - interest rate for this loan is 15% per annum and was credited to Crossly's account every half year
The partnership profit before charging loan interest for the year ended 31 Dec 20X1 was 63,000 and partners have made the following drawings
Crossly
16,000
Steel
16,500
Nabs
19,000

Prepare appropriate accounts and partner's capital and current accounts and the partnership statements of financial position in the respect of the year ended 31 Dec 20X1

4 P Co. acquired 75% of the ordinary shares of S co on that company's incorporate in 1 Jan 20x3

Q1. The summarised statements of provide and loss of the two companies for the year ended 20X3

Require d to prepare the consolidated statement of profit and loss for the year ending 31 March.

Prepare a excel for answer the task.