Calculate the ratios for the two financial years

Assignment Help Accounting Basics
Reference no: EM131074715

Assignment : Financial Statement Analysis

Ace Hardware is a leading family business that specialises in the manufacturing and wholesale distribution of floor tile products. Over the past two years Ace Hardware has experienced difficult operating conditions. John, the company accountant, has prepared the income statement and balance sheet for the prior two years for a management meeting. The owners of Ace Hardward have asked John to evaluate the financial statements and prepare an evaluation of operating capability to present to senior management. 60 percent of sales are made on credit.

Profit and Loss

 

201X

 

 

 

201Y

 

Total Income

 

14,543,837

 

 

11,981,782

Less Cost of Sales

 

10,752,813

73.9%

 

8,967,229

77.1%

Gross Profit (Loss)

 

3,791,024

26.1%

 

3,014,553

22.9%

Total Other Income

 

86,363

0.6%

 

-

3.3%

Less Expenses

Administrative Staff Costs

 

 

2,385,760

 

16.40%

 

 

1,719,171

 

14.35%

Advertising and Marketing Support

 

140,470

0.97%

 

75,500

0.63%

Bad Debts

 

68,534

0.47%

 

63,057

0.53%

Administrative Overhead

 

280,600

1.93%

 

290,238

2.42%

Freight and Cartage

 

10,210

0.07%

 

21,681

0.18%

Hire of Plant and  Equipment

 

103,828

0.71%

 

118,016

0.98%

Bank Charges

 

25,573

0.18%

 

20,749

0.17%

Light and Power

 

49,176

0.34%

 

42,017

0.35%

Lease of MV

 

28,160

0.19%

 

2,201

0.02%

MV Running Costs

 

332,103

2.28%

 

249,192

2.08%

Rent

 

328,307

2.26%

 

321,177

2.68%

Repairs and Maint

 

35,367

0.24%

 

18,875

0.16%

Telephone

 

67,899

0.47%

 

63,170

0.53%

Travel

 

21,398

0.15%

 

8,516

0.07%

Total Operating Expenses

 

3,877,386

26.7%

 

3,013,560

25.2%

Net Operating Profit (Loss)

 

1

 

 

993

 

Balance Sheets 201X 201Y
Current Assets    

Cash at Bank

-

-

Trade Debtors

1,116,467

875,607

Stock on Hand

1,697,220

1,231,111

Total Current Assets

2,813,687

2,106,718

Fixed Asets    

Furniture & Fitting - At Cost

43,511

43,511

Less Accum Depn Frn & Fitting

(36,606)

(37,543)

Plant & Equip - At Cost

1,329,334

1,329,334

Less Accum Depn - Plant & Equip

(1,045,363)

(1,096,991)

Motor Vehicle - At Cost

863,042

840,728

Less Accum Depn - Motor Vehicle

(707,518)

(720,326)

Office Equipment - At Cost

368,650

368,650

Less Accum Depn - Office Equip

(302,075)

(319,537)

Total Fixed Assets

512,975

407,826

Investments    

Shares in Listed Company

96,788

96,788

Loans & Deposits

153,782

153,782

Total Investments

250,570

250,570

 Intangible Assets

 

 

Trademarks & Patents

867

27,958

Goodwill - At Cost

5,430

5,430

Formation Expense - At Cost

1,000

1,000

Total Investments

7,297

34,388

 Total Non Current Assets

 770,842

 692,784

Total Assets

3,584,529

2,799,502

Current Liabilities

Bank Overdraft

 

98,917

 

116,643

Trade Creditors

1,394,198

1,181,797

Loan At Call - To Directors

149,354

137,586

Total Current Liabilities

1,642,469

1,436,026

Deferred Liabilities    
Loan - Unsecured - business Partner

1,819,577

1,326,934

 Total Deferred Liabilities

1,819,577

1,326,934

Total Liabilities

3,462,046

2,762,960

Equity    

Profit B/F

1

993

Settled Capital

50

50

Accumulated Trust Funds

31,027

31,027

Retained Profits

91,405

4,472

Total Equity

122,483

36,542

Questions:

1. Calculate the following ratio's for the two financial years:

a. Current

b. Quick

c. Debt

d. Inventory Turnover for year Y only

e. Accounts Receivable Turnover for year Y only

f. Gross Profit Percentage

g. Profit Margin

h. Return on Total Assets for year Y only

i. Return on Owner's Equity for year Y only

2. Write a short report that compares the business' performance in 201X with that in 20XY regarding its liquidity, financial flexibility, operating capability and profitability.

You are required to take the trial balance and information provided and create the adjusted trial balance. Using the adjusted trial balance you are then required to construct a Statement of Financial Position (balance sheet) and a Statement of Income (profit and loss). You may use and present your solutions in excel or word.

The report must be presented in essay format with an introduction, body and conclusion and all external references must be referenced using APA 6th edition referencing style. Word count should not exceed 1,000 words.

Verified Expert

The solutions are provided keeping in mind the standard literary and theoretical practices in mind. The necessary literary referencing is done to support the workings.

Reference no: EM131074715

Questions Cloud

Paying a series of five constant-dollar : You are paying a series of five constant-dollar (or real-dollar) uniform payments of $1195.38 beginning at the end of first year. Assume that the general inflation rate is 13.24% and the market interest rate is 13.24% during this inflationary peri..
Determine what changes are occurring in the economy : The cover page and the reference page are not included in the required assignment page length.
Why choose medical billing and coding : List of useful job search sources including working web page links (Minimum 10). A summary of your own job search should be included and included a list of pros and cons of the jobs found in Maryland and the type of experience required.
Fixed costs per period of production : Four companies calculate their fixed costs per period of production, and their variable costs per unit of product during the period. Each company sets a selling price and calculates the number of units of product that must be manufactured and sold..
Calculate the ratios for the two financial years : Write a short report that compares the business performance in 201X with that in 20XY regarding its liquidity, financial flexibility, operating capability and profitability.
To consider in preparing for this new line of work : 3-15. Describe two options for handling the staffing levels for this new line of work. What issues and complications are likely to surface with the new amount of work for Jill's department?
Describe the market process : Describe the market process that should occur if the price of a product is below its equilibrium price, and then describe what would occur if the price is above its equilibrium price, assuming that there is no market interference.
Diminishing marginal product : Is it possible to have diminishing marginal product for each input (of production function, Q=AK^aL^b and yet still have increasing returns to scale? Please explain.
Economies of scale in transportation : Explaining why Economies of Scale in transportation might encourage a producer to include a regional merchant wholesaler in the channel of distribution for its consumer product.

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  A point charge 10 c is a distance 5 cm directly above the

a point charge 10 ?c is a distance 5 cm directly above the centre of a square of side 10 cm as shown in fig. 1.34. what

  What is the total cost to be allocated to city department

Sanilac County has a lease on a lawn mower for $2500 per month and $.02 per minute of operation. Operating costs for fuel, oil, technicians, and so on are all variable at $.03 per minute. Departments had projected a need for 100,000 minutes per mo..

  Assume that you have determined that your company can

a your company is constructing a factory building for its own use and takes out a 2 million loan 10 interest rate from

  Determining losses for tax purposes

In the current year, Teal Corporation becomes insolvent and is declared bankrupt. During the corporation's existence, Emily was paid an annual salary of $60,000. How should she treat her losses for tax purposes?

  Woodland industries manufactures and sells custom-made

woodland industries manufactures and sells custom-made windows. its job costing system was designed using an

  Calculate the estimated cost of workers

Sunny Hills Farm estimated its payroll for the coming year to be $102,000. Its workers' compensation insurance premium rate of 0.6% is paid at the beginning of each quarter. 1. Calculate the estimated cost of workers' compensation insurance for the..

  Scope of the project

Why is quality management important to the scope of the project?

  What is the premium amortization for the first interest

What is the premium amortization for the first interest period?

  U201ci know headquarters wants us to add that new product

u201ci know headquarters wants us to add that new product lineu201d said fred halloway manager of kirsi productsu2019

  Keel companys fixed overhead costs for the year are

keel companys fixed overhead costs for the year are expected to be as follows depreciation 80000 supervisory salaries

  Companies can present comprehensive income

1.Define comprehensive income. What are the two ways companies can present comprehensive income?

  What volume of sales in dollars must be achieved in the

the boxed candys current years net income is 184000. selling price per box 4.00 selling commission per box .40 office

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