Prepare a cash budget for the months from january to june

Assignment Help Financial Accounting
Reference no: EM133334763

Financial Accounting

SECTION A

QUESTION 1
This assignment requires each student to work on the published financial statements of ASOS PLC for two years from 2020 to 2021.

The figures below are extracted from ASOS 2020 and 2021 annual reports.

 

2021

2020

Income statement

£m

£m

Sales revenue

3,911

3,264

Cost of sales

2,134

1,716

Gross profit

1,777

1,548

Operating profit (use for PBIT)

190

151

Interest paid

13

10

 

 

 

Balance sheet

£m

£m

Non-current assets

1,325

970

Current assets

1,560

1,020

Inventories

807

532

Trade and other receivables

58

60

Current assets less inventories

753

488

Current liabilities

998

818

Trade and other payables

956

770

Non-current liabilities

1,034

810

Total equity

1,034

810

Capital employed

2,068

1,620

You are required:

Write a brief report on the performance of ASOS over the financial periods 2020 to 2021.You should use the financial statements provided above to calculate the required accounting ratios shown below and use any other information relevant for your comments.

Information can be accessed from the annual report and accounts and any other source of evidence that you believe helps to explain the company's performance and position.

Calculate the following ratios. Show all your working out Long term financing ratio
1. 1 Gearing

Working capital Ratios

1. 2 Inventory days
2. 3 Receivable days
3. 4 Payable days Liquidity Ratios
1. 5 Current ratio
2. 6 Acid test Profitability Ratios
1. 7 Return on capital employed
2. 8 Net profit margin
3. 9 Asset turnover Interpretation
Interpret the ratios above by making comparative relevant comments with clear demonstration of understanding applied in context

SECTION B

Question 2

Ana-maria Tial Balance

The following balances were extracted from the accounting records of Ma- maria Plc
Trial Balance as of 31 November 2022

Purchases

DR

372,000

CR

Trade payables

 

10,000

Salaries and wages

54,000

 

Directors' remuneration

10,000

 

Audit fees

3,000

 

Heat and light

30,000

 

Inventory, 01 April 2021

130,000

 

Debenture Interest

27,000

 

Interim dividend paid

120,000

 

Building at cost

500,000

 

Building - accumulated depreciation 01 Dec 2021

 

50,000

Fixtures and fittings at cost

150,000

 

Fixtures and fittings - accumulated depreciation, 01 Dec 2021

 

20,000

10% Debentures

 

220,000

Ordinary share capital (fully paid)

 

800,000

Trade receivables

120,000

 

Bank

260,000

 

Sales

 

940,000

Share premium account

 

150,000

Retained earnings

 

120,000

Communications expenses

20,000

 

General reserve

 

57,000

Long-term investments

571,000

 

  2,367,000
 2,367,000

The following additional information as of 31 December 2022 should be taken into account:

(i) Inventory was valued at £150,000

(ii) Audit fees of £1000 were outstanding

(iii) Prepaid debenture interest is to be accounted for

(iv) Depreciation is to charge on buildings at 10% on the straight-line basis and on fixtures and fittings at 20% on the reducing balance basis
(v) The directors decided to transfer £70,000 to the general reserve account Required:
Prepare for Ana - Maria Plc:

(a) the statement of profit or loss for the year ended 31 December 2022

(b) the statement of changes in equity for the year ended 31 December 2022

(c) the statement of financial position for the year ended 31 December 2022

Question 3
Elena Ltd, a new business, starts trading in sports shoes on 1st January 2021 and expects to make the following transactions for the 6 months ending 30th June2021:

i. Sales are expected to be 500 units (sports shoes) per month for the 4months from January to April then 300 units per month from May to June.

ii. The selling price will be £60 per unit.

iii. All sales will be cash sales with cash received in the same month the sale takes place.

iv. Payment for Purchases of inventory (sports shoes) will take place on the month after receiving the inventory. Each unit of inventory will cost £40.

v. Wages are expected to be £1000 per month and will be paid in the month in which they are incurred.

vi. Rent will be £2000 per month to be paid quarterly in advance (i.e., the rent payment for January, February and March 2021 will be made on 1st January 2021).

vii. General overheads are expected to cost £1000 per month and will be paid in the month in which they are incurred.

viii. Bought a laptop for the business in April for £1,500

Required
a) Prepare a cash budget for the 6 months from January to June 2021. Show the cash receipts and cash payments the business expects to have each month and the cash balance at the end of each month.

b) Prepare a profit budget for the 6 months ending 30th June 2021.

Verified Expert

"The assessment is performed to have an in-depth understanding of the concept of financial accounting and for exploring its organizational scope, its implication is assessed in the context of case studies. Initially, the financial performance of ASOS Plc is assessed for 2020 and 2021 using accounting ratios including solvency, profitability, liquidity, and efficiency and this has helped in understanding whether its economic competence is enhanced or not. The financial competence of ASOS Plc is enhanced in 2021 over 2020 in terms of liquidity, solvency, and net profit margin management but it is decreased in terms of cost, payable, and asset turnover management. Further, the implication of budgeting is explored by developing a cash and profit budget for a hypothetical company, Elena Ltd for the next six months using instructions of future sales and expense information."

Reference no: EM133334763

Questions Cloud

Evaluate how analysing a vacancy within your organisation : evaluate how analysing a vacancy within your organisation informs your overall recruitment strategy exploring the implications surrounding the decisions made
Describe the risk and protective factors : Describe the condition in terms of magnitude, person, place and time. Describe the risk and protective factors. Describe the population at-risk.
Discuss strengths and weaknesses of michael business plan : Michael's business plan has been an invaluable asset in the development and assessment of his entrepreneurial idea and opportunity, as well as enabling
Is this patient hot-cold or both. which signs and symptoms : Is this patient excess, deficient or both? Which signs and symptoms support this? How would you diagnose this patient? What would your treatment principle be?
Prepare a cash budget for the months from january to june : AC4052QA Financial Accounting, London Metropolitan University Prepare a cash budget for the 6 months from January to June 2021. Show the cash receipts and cash
Explain the hidden cost of turnover : List and Briefly Explain the 3 Main Factors that predict whether people are willing to invest themselves in their work role.
Concern with medication in specific patient : A 20-year-old female comes into your clinic today informing you she is ready to have a baby. What is your concern with this medication in this specific patient.
Identify the impact of pay-for-performance on the healthcare : Identify the impact of Pay-for-Performance on the healthcare organization and discuss the impact of Value Based Purchasing on the organization.
How did harriet green have used lewins change model : How did Harriet Green have used Lewin's Change Model when she was the CEO of Thomas Cook? The Lewin's model with 3 stages, unfreeze, change and freeze.

Reviews

len3334763

2/9/2023 11:58:30 PM

Answer all questions, show all working out, you may use excel but must show formula for the excel calculations.

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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