Prepare a trial balance and a balance sheet

Assignment Help Financial Accounting
Reference no: EM131089728

Financial Accounting and Reporting

Learning Outcomes

1 Understand the regulatory framework for financial reporting

2 Be able to prepare financial statements from complete or incomplete records

3 Be able to present financial information in accepted formats for publication

4 Be able to interpret financial statements.

BUSINESS SCENARIO

You are a newly appointed consultant in XYZ Financial Consultant Company.

You provide financial consultancy to multiple different companies.

Below are financial statements of different clients and your Manager has requested you to provide suitable financial statements for different types of companies.

The types of companies vary from sole trader, partnership and limited liability.

TASK 1:

Individual Report -

The senior management of the company have requested you to provide a report on the following

LO 1.1 Select one or more companies that you want to invest in Dubai stock exchange.

Provide justification as to WHY you want to invest in this company or companies

Who will be the company's stakeholders?

Why would they be interested in this company?

LO 1.1-1 Describe the different users of financial statements and their needs LO 1.2 Explain the legal and regulatory influences on financial statements

LO 1.3 Assess the implications for users.
What are the advantages for this global harmonisation?

LO 1.4 Explain how different laws/regulations are dealt with by accounting and reporting standards. Please provide examples.

TASK 2: - IN CLASS ASSESSMENT

LO - 2.1 Prepare financial statements for a variety of businesses from trial balance, making appropriate adjustments

Q - 1 As at 30.3.20X7 ABC Ltd has the following balances on the ledger account

Account

Balance in $

Bank Loan

12,000

Cash

11,700

Capital

13,000

Rent

1,880

Trade Payables

11,200

Purchases

12,400

Sales

14,600

Sundry Payable

1,620

Receivables

12,000

Interest on Bank loan

1,400

Other expense

11,020

Vehicles

2,020

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

L.O 2.1 - Draw up a trial balance showing the balances as at the end of 31.3. 20x7

L.O 2.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

L.O 2.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

N Ltd

Non - current assets

50,000

25,000

Investment in Minor Ltd at cost

15,000

 

Inventory

13,000

7,000

Other current assets

10,000

6,000

Total assets

88,000

38,000

Share capital - 1$ shares

45,000

20,000

Retained earnings

30,000

15,000

Current liabilities

13,000

3,000

Total equity and liabilities

88,000

38,000

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 - LO3

Consolidated Financial Statements

LO 3.1- Explain how the information needs of different user groups vary

LO - 3.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

NICO

Trial balance as at 31 July 20x9 is given below

 

Debit

Credit

Capital

 

100,000

Plant and Machinery Cost

155,000

 

Accumulated Deprecation to 1 Aug 20x8

 

50,000

Trade Receivables

15,000

 

trade Payables

 

3,000

Inventories 1 Aug 20x8

10,000

 

Cash at bank

3,400

 

Sales

 

150,000

Drawings

35,000

 

Allowance for receivables at 1 Aug 20x8

 

2,000

Bank loan repayable 2015

 

20,000

Purchases

40,000

 

Selling and Distribution

50,000

 

Admin expenses

15,000

 

Interest

1,600

 

Total

325,000 325,000

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

Paul's Guitar Shop, Inc.
Adjusted Trial Balance
December 31, 2015

 

Paul's Guitar Shop, Inc.
Adjusted Trial Balance
December 31, 2015

Account

Debit Credit

Cash

$32,800

 

Accounts Receivable

300

 

Prepaid Rent

1,000

 

Inventory

39,800

 

Leasehold Improvements

100,000

 

Accumulated Depreciation

 

2,000

Accounts Payable

 

$49,000

Accrued Expenses

 

450

Unearned Income

 

1,000

Long-term Liabilities

 

99,500

Common Stock

 

10,000

Dividends

1,000

 

Revenues

 

27,800

Cost of Goods Sold

10,200

 

Depreciation Expense

2,000

 

Rent Expense

500

 

Supplies Expense

500

 

Utilities Expense

400

 

Wages Expense

750

 

Interest Expense

500

 

Totals

$189,750 $ (189,750)

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


Capital Current        
Crossly 24,000 2,000
Steel   18,000 1000
Nabs    13,000 1500

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

LO 3.2 - 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

 

P company

S company

Revenue

75,000

38,000

Cost of sales

30,000

20,000

Gross profit

xxxxx

xxxxx

Distribution and Admin

14,000

9,000

Income tax expenses

10,000

2,000

Net Profit

xxxx

xxx

 

 

 

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

TASK 4:

Interpretation of Financial Statements

Individual Report - submission due: 29 May 2016

calculate accounting ratios to assess the performance and position of a business

prepare a report incorporating and interpreting accounting ratios, including suitable comparisons.

Statements of Financial Position and Profit or Loss for Marks and Spencer are given below

(4.1, 4.2) You are required to calculate accounting ratios which reflect profitability, liquidity, efficiency, and gearing of the company for the financial years 2013, 2014 and 2015 Compare the ratios between two accounting periods and comment on the company's performance.

In millions of GBP (except for per share items)

 

Annual data  Interim data

Fluid data as 41 Mar 28 2015

2015

2014

2013

REVENUE AND GROSS PROFIT

 

 

 

Total revenue

10,311

10,310

10,027

OPERATING EXPENSES

 

 

 

Cost of revenue total

6,326

6,439

6,230

Selling, general and admin. expenses, total

2,755

2,747

2.647

Depredation/amortization

550

478

463

Unusual expense(income)

61

47

101

Other operating expenses, total

(82)

(96)

(92)

Total operating expense

9,610

9,615

9,349

Operating income

701

695

678

Other, net

(6.50)

(1.40)

(11)

INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS

 

 

Net income before taxes

600

580

547

Provision for income taxes

118

74

102

Net income after taxes

482

506

445

Minority interest

4.80

19

8.70

Net income before extra. Items

487

525

454

Total extraordinary items

-

-

-

Net income

487

525

454

Inc.avail. to common excl. extra. Items

487

525

454

Inc.avail. to common incl. extra. Items

487

525

454

Balance Sheet

In millions of GBP (except for per share items)

 

Annual data  Interim data

Fiscal data as of Mar 28 2015

2015

2014

2013

ASSETS

 

 

 

Cash And Short Term Investments

218

200

210

Total Receivables, Net

177

181

141

Total Inventory

798

846

767

Prepaid expenses

145

129

108

Other current assets. total

118

14

43

Total current assets

1,455

1,369

1,268

Property, plant & equipment, net

5,031

5,140

5,034

Goodwill, net

95

95

93

Intangibles, net

763

713

602

Long term investments

31

31

34

Note receivable - long term

57

83

30

Other long term assets

76

41

65

Total assets

8,196

7,903

7,611

LIABILITIES

 

 

 

Accounts payable

968

929

973

Accrued expenses

675

764

531

Notes payable/shod-term debt

0

0

0

Current portion long-term debt/capital leases

279

449

559

Other current liabilities, total

190

208

176

Total current liabilities

2,112

2,349

2,238

Total long term debt

1.746

1,655

1,727

Total debt

2,025

2,104

2.286

Deferred income tax

315

243

241

Minority interest

(0.80)

(0.60)

(19)

Other liabilities, total

825

949

885

Total liabilities

4,997

5,196

5,072

SHAREHOLDERS EQUITY

Common stock

412

408

404

Additional paid-in capital

392

356

315

Retained earnings (accumulated deficit)

8,873

8,528

8,353

Treasury stock - common

-

-

-

Unrealized gain (loss)

-

-

-

Other equity, total

(6,478)

(6,584)

(6,533)

Total equity

3,200

2,707

2,539

Total liabilities & shareholders' equity

8,196

7,903

7,611

Total common shares outstanding

1,648

1,632

1,614

Treasury shares - common primary issue

0

0

0

Cash flow

In millions of GBP (except for per share items)

 

Annual data - Interim data

Sisal data as of Mu 28 2015

2015

2014

2013

 

 

 

 

OPERATIONS

 

 

 

Net income

482

506

445

Depredation/depletion

550

505

467

Non-Cash items

197

189

339

Cash taxes paid. supplemental

71

46

106

Cash interest paid, supplemental

115

133

135

Changes in working capital

49

(70)

(111)

Total cash from operations

1,278

1,130

1,140

INVESTING

 

 

 

Capital expenditures

(700)

(642)

(830)

Other investing and cash flow items, total

51

27

249

Total cash from investing

(649)

(615)

(580)

FINANCING

 

 

 

Financing cash flow items

(170)

(183)

(207)

Total cash dividends paid

(281)

(274)

(271)

Issuance (retirement) of stock. net

17

44

23

Issuance (retirement) of debt net

(181)

(86)

(140)

Total cash from financing

(615)

(498)

(596)

NET CHANGE IN CASH

 

 

 

Foreign exchange effects

(2.30)

(1.60)

0.90

Net change in cash

12

15

(35)

Net cash-begin balance/reserved for future use

176

161

196

Net cash-end balance/reserved for future use

188

176

161

SUPPLEMENTAL INCOME

 

 

 

Depredation, supplemental

550

505

467

Cash interest paid, supplemental

115

133

135

Cash taxes paid, supplemental

71

46

106

Reference no: EM131089728

Questions Cloud

Describe the procedural history of the case : Read the case and submit a case brief, analyzing the results of the case and explaining the applicable law. In your case brief, describe the procedural history of the case and the relevant facts of the case;
What is the probability that four cards : Four cards are chosen from a 52-card deck. What is the probability that four cards are either face cards or aces? There are 12 face cards and four aces in a deck of cards.
Statistical terminology and health care data : a. Statistics is a numerical fact. b. Descriptive statistics analyzes a specific group. c. Decisions made on the basis of scientific methods are pure guesses.
Write the response of the given discussion : Reply: Reply to 2 other classmates by offering 1 new piece of information to add to their discussion of family systems. As you provide feedback to peers, you are not grading their assignment, but you are enlarging the conversation to prod a bit mor..
Prepare a trial balance and a balance sheet : You are a newly appointed consultant in XYZ Financial Consultant Company - You provide financial consultancy to multiple different companies.
Represent the total area of the square : The other piece will be bent into the shape of a circle. Let A represent the total area of the square and the circle. What is the circumference of the circle when A is a minimum?
How the micro structure of sample c wasaltered : Explain how the microstructure of sample C wasaltered to give sample D.
Determine the tension in the cable : Given that the beam has length 10m and mass of 175kg, determine a) the tension in the cable and b) the reaction at the ground. Please show working out.
Interest rate on deposits will generate the best profit : For instance, if they pay 3% they will generate $3 million in deposits. If they can load all the money they take in at 10% interest, what interest rate on deposits will generate the best profit.

Reviews

Write a Review

Financial Accounting Questions & Answers

  What is the selling percale

Sue Bee Honey is one of the largest processors of its product for the retail market. Assume that one of its plants has annual fixed costs totaling $8,000,000 of which $300,000 is for administrative and selling efforts. Sales are anticipated to be 800..

  Stone interior decorating company

Established an enterprise called the STONE INTERIOR DECORATING COMPANY

  What will accounts receivable be at end

Evaluate what will Accounts Receivable be at end of February and find what will cash payment for administrative and selling expenses be in February including fixed and variable cash expenses?

  Make an income statement for the company

Prepare a schedule of cost of goods sold - prepare an income statement for the company and prepare an income statement for the company

  Why is it important to track inventory

What activities should you perform to correctly account for your inventory at year-end? Why is it important to track inventory? What does this information tell you about your business?

  Discuss risks of material misstatement

Identify and discuss those risks of material misstatement at the financial statement level that are significant in directing the engagement team's audit procedures for the 2009 audit of New Era Computers Ltd; and

  What is the price variance for direct materials

Downward Inc. manufactures and sells a product, Z30. The per unit standards for the direct costs of product Z30 are as follows.

  What is the selling price per unit

What operating profit percentage on revenues is needed to attain the target return on investment of 20%? What is the selling price per unit?

  What is contribution margin-evaluating the margin of safety

What is contribution margin? A company has contribution margin per unit of $60 and a contribution margin ratio of 40%. What is the unit selling price? Which statement is true when evaluating the margin of safety? What is contribution margin?

  Complete the cash budget for the first quarter

Nemani wants to maintain a balance of at least $25,000 cash at the end of each quarter and complete the cash budget for the first quarter.

  What is the present worth of the bonus package

A small internet company plans to offer its employees a salary enhancement package which has revenue sharing as its main component. Specifically, the company will set aside 1% of total sales for yearend bonuses for all of its employees. The sales are..

  Describe the journal entry

Which of the following does not correctly describe the following journal entry?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd