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

  How firms are delivering value with data analytics

How firms are delivering value with data analytics? When Ed Wilkins, CPA, talks to audit committees about adding data analytics to the audit process

  Details on legislated payments on termination of employment

Provide the details on all legislated payments on termination of employment required for each jurisdiction.-  In addition to the required payments on termination, include any employer costs related to the employees' statutory deductions.

  What journal entry to record replenishment include credit

If a petty cash fund is established in amount, When it is replenished, the journal entry to record replenishment should include credit to the following accounts

  Sketch a cvp analysis graphs for the clinic with number

Sketch a CVP analysis graphs for the clinic with number of visits on the x -axis. Grandview Clinic has fixed costs of $2 million and an average variable cost.

  Human resourcemanagement and personnelmanagementis

The difference between human resourcemanagement and personnelmanagementis

  What are the two most frequently used methods

What are the two most frequently used methods to record the changes that occur in the composition of an association and what do they consist of?

  Explain how were these obligations violated in hp case

The original lawsuit filed in the HP case claimed that the executives breached their fiduciary responsibilities. What are the fiduciary responsibilities of executives and members of the board of directors to shareholder? Explain how were these obl..

  Who should be involve in setting standard for cost component

When Annette designs the standard costing system for Cabanarama, who should be involved in setting the standards for each cost component?

  Calculate the variance for March

Calculate the variance for March from the available information and use them to reconcile the budgeted and actual profit figures

  Discuss the impacts of the COVID pandemic

Discuss the impacts of the COVID-19 pandemic when applying FRS 115 Revenue from Contracts with Customers for Singapore companies

  What is the stock current value per share

Hemsworth Brothers is expected to pay $0.50 per share dividend at the end of the year. What is the stock's current value per share

  How much inventory should be reported on december

On December 31, 2021, how much inventory should be reported? Goods shipped FOB shipping point from a vendor to Violet Company on December

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