Prepare a cash budget for the 6 months from January to June

Assignment Help Business Management
Reference no: EM133353074 , Length: 1500 Words

Financial Accounting

QUESTION 1

SECTION A

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
Gearing
Working capital Ratios
Inventory days
Receivable days
Payable days
Liquidity Ratios
Current ratio
Acid test
Profitability Ratios
Return on capital employed
Net profit margin
Asset turnover
Interpretation
Interpret the ratios above by making comparative relevant comments with clear demonstration of understanding applied in context

Question 2

SECTION B

Ana-maria Tial Balance

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

 

DR

CR

Purchases

372,000

 

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.

Reference no: EM133353074

Questions Cloud

Explain why michaels redefinition of business : Explain why Michael's redefinition of the business is so important by redefining the business what was he trying to accomplish.
What are the most frequently practiced world religions today : What are the most frequently practiced world religions today list in numerical order. Cite your source. What are the most frequently practiced religions
Define the five dimensions of service quality : What is customer satisfaction, and why is it so important? List and define the five dimensions of service quality.
How important do you think it is for policy makers : How important do you think it is for policy makers to have an understanding of the difference between working with an individual and working with a community
Prepare a cash budget for the 6 months from January to June : Prepare a profit budget for the 6 months ending 30th June 2021 and General overheads are expected to cost £1000 per month and will be paid in the month
What is importance of emotional intelligence : What is the importance of emotional intelligence? What have you learned about your own EI?
What does the nclb say about para educator training : Why is "Managing the Workplace" an important part of Para educator supervision? How is communication a part of this process? Be specific in your response.
Influence the risk appetite for banks : Boards for banks are made up of members that represent different interest groups, and these tend to influence the risk appetite for banks.
Represent sources of competitive advantage : What are some of BestBuys external and internal factor that could represent sources of competitive advantage? how? explain

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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