You have been asked to produce a Profit & Loss Statement for Bayford Fashion for the year to 31 March 2021, a business selling clothing both directly to UK retailers and online direct to consumers. Most of the product is imported from Asia. You have been provided with the information below from which you need to determine how to use for the production of the required statement. Amount & Further Information The company sells an average of 15,400 garments a month to retailers and 6,250 garments a month to online customers. The average selling price of each garment to retailers is £24 (excluding VAT) and £57.60 (including VAT at 20%) to online customers. The average cost of each garment is £9 including all import duties. Delivery and packaging costs to the customers average £0.5 per garment for retailers and £1.50 for online Item Sales Volume Pricing Unit Cost customers. Premises The premises are rented and cost £105,000 a month paid quarterly in advance on the 1st January, 1st April, 1st July and 1st October. The company has 55 employees with an average salary of £28,000 a year. During the year £12,000 in total was loaned to staff for various reasons and the balance was still Salaries outstanding at the year-end.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
You have been asked to produce a Profit & Loss Statement for Bayford Fashion for the year to 31 March
2021, a business selling clothing both directly to UK retailers and online direct to consumers. Most of the
product is imported from Asia. You have been provided with the information below from which you need to
determine how to use for the production of the required statement.
Amount & Further Information
The company sells an average of 15,400 garments a month
to retailers and 6,250 garments a month to online
customers.
The average selling price of each garment to retailers is
£24 (excluding VAT) and £57.60 (including VAT at 20%) to
online customers.
Item
Sales Volume
Pricing
Unit Cost
The average cost of each garment is £9 including all import
duties. Delivery and packaging costs to the customers
average £0.5 per garment for retailers and £1.50 for online
customers.
The premises are rented and cost £105,000 a month paid
quarterly in advance on the 1st January, 1st April, 1st July
and 1st October.
The company has 55 employees with an average salary of
£28,000 a year. During the year £12,000 in total was
Premises
Salaries
loaned to staff for various reasons and the balance was still
outstanding at the year-end.
Transcribed Image Text:You have been asked to produce a Profit & Loss Statement for Bayford Fashion for the year to 31 March 2021, a business selling clothing both directly to UK retailers and online direct to consumers. Most of the product is imported from Asia. You have been provided with the information below from which you need to determine how to use for the production of the required statement. Amount & Further Information The company sells an average of 15,400 garments a month to retailers and 6,250 garments a month to online customers. The average selling price of each garment to retailers is £24 (excluding VAT) and £57.60 (including VAT at 20%) to online customers. Item Sales Volume Pricing Unit Cost The average cost of each garment is £9 including all import duties. Delivery and packaging costs to the customers average £0.5 per garment for retailers and £1.50 for online customers. The premises are rented and cost £105,000 a month paid quarterly in advance on the 1st January, 1st April, 1st July and 1st October. The company has 55 employees with an average salary of £28,000 a year. During the year £12,000 in total was Premises Salaries loaned to staff for various reasons and the balance was still outstanding at the year-end.
The company has two bank loans in place. Loan A had an
average outstanding balance of £1.2m and the interest on
this was a flat rate 7% per annum. Loan B had an average
outstanding balance of £250,000 and the interest on this
was a flat rate 5% per annum. During the year £217,500 of
capital on both these loans was repaid in proportion to the
respective loan sizes.
The Fixed Assets in the business originally cost £820,000 in
total. These are still being depreciated on a Straight Line
basis over 8 years. (Assume the all assets were purchased
at the same time and have not yet been fully depreciated).
The company spent £290,000 marketing to online
consumers and £180,000 marketing to retailers during the
Payments to the Bank
Depreciation
Sales & Marketing
year.
A further £160,000 of various other operating costs were
incurred during the year. In addition, a further £20,000 of
invoices had been received in March 2021 for supplies to
be delivered in April and May 2021.
Other Expenditure
Travel Costs
£146,000 was spent on Travel during the period to 31
March 2021. However, £7,000 of this was an advance
payment for a Business Class flight to Hong Kong for the
CEO to meet the company's main supplier later in June.
Historically this runs at £10,000 a month, although as at
the year-end date, three months of invoices have not been
received from the accountancy supplier despite the
services having been used.
One major retailer customer appears to be in severe
financial difficulty and has an outstanding balance of
£200,000 which is now four months overdue. The Sales
Director, who knows the customer very well, assures you
that the amount will be paid off soon and that you should
definitely not be concerned.
Accountancy
Bad Debts
Using the details shown above:
Create a Profit & Loss Statement for the year to 31 March 2021. You must show Sales, Gross Profit,
and Gross Margin (%) by each sales sector; all relevant cost items in the statement; Total Costs,
EBITDA (Earnings Before Interest Depreciation & Amortisation), Operating Profit (EBIT) as well as
Profit Before Tax, and Profit Before Tax Margin (%).
Transcribed Image Text:The company has two bank loans in place. Loan A had an average outstanding balance of £1.2m and the interest on this was a flat rate 7% per annum. Loan B had an average outstanding balance of £250,000 and the interest on this was a flat rate 5% per annum. During the year £217,500 of capital on both these loans was repaid in proportion to the respective loan sizes. The Fixed Assets in the business originally cost £820,000 in total. These are still being depreciated on a Straight Line basis over 8 years. (Assume the all assets were purchased at the same time and have not yet been fully depreciated). The company spent £290,000 marketing to online consumers and £180,000 marketing to retailers during the Payments to the Bank Depreciation Sales & Marketing year. A further £160,000 of various other operating costs were incurred during the year. In addition, a further £20,000 of invoices had been received in March 2021 for supplies to be delivered in April and May 2021. Other Expenditure Travel Costs £146,000 was spent on Travel during the period to 31 March 2021. However, £7,000 of this was an advance payment for a Business Class flight to Hong Kong for the CEO to meet the company's main supplier later in June. Historically this runs at £10,000 a month, although as at the year-end date, three months of invoices have not been received from the accountancy supplier despite the services having been used. One major retailer customer appears to be in severe financial difficulty and has an outstanding balance of £200,000 which is now four months overdue. The Sales Director, who knows the customer very well, assures you that the amount will be paid off soon and that you should definitely not be concerned. Accountancy Bad Debts Using the details shown above: Create a Profit & Loss Statement for the year to 31 March 2021. You must show Sales, Gross Profit, and Gross Margin (%) by each sales sector; all relevant cost items in the statement; Total Costs, EBITDA (Earnings Before Interest Depreciation & Amortisation), Operating Profit (EBIT) as well as Profit Before Tax, and Profit Before Tax Margin (%).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Pricing Decisions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education