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.
|
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.
|