Home Designs Ltd: Financial Statements, Inventory, and Ratio Analysis

This assignment solution addresses key aspects of business accounting and finance, including the preparation of financial statements (income statement and balance sheet) for Home Designs Ltd., and the analysis of its financial performance. It demonstrates the application of inventory costing methods (FIFO, LIFO, and weighted average) to determine the cost of goods sold and gross profit. Ratio analysis is performed for three companies to evaluate profitability and liquidity, and the use of ratios for investment decisions is explored. The importance of working capital management is identified, and the concept of economic order quantity (EOQ) is explained and calculated. The assignment also examines the afterpay service, considering its benefits and disadvantages. The solution includes calculations, memo, and recommendations, providing a comprehensive overview of the financial concepts covered.

1
Business Accounting & Finance

2
Executive summary
The assignment has covered various aspects in relation to the accounts and finances. There is the
making of the financial statements in relation to a company from the available information. By
that, the position and performance of the company are evaluated. The use of cash flow statement
is also identified and taken into consideration. There are three methods which have been used
and by that the cost of the inventory has been ascertained. That has also helped in identifying the
cost of goods sold and the profits which are made under each of the methods. The analyses of the
business are made and for that ratio have been calculated in respect of three companies and it
was done by using their profitability and liquidity. Further the ratios which are to be used for the
making of investment decisions have also been determined. The importance of having working
capital management for the business is identified. With that an explanation of the economic order
quantity is given which helps in understanding the concept in effective manner. The calculations
for the same have also been performed. The after pay service, which is offered is also understood
and the benefits and disadvantages associated with it have also been taken into consideration.

3
Table of Contents
Executive summary.........................................................................................................................2
Question 1........................................................................................................................................4
i)...................................................................................................................................................4
ii)..................................................................................................................................................5
Question 2........................................................................................................................................6
i)...................................................................................................................................................6
ii)................................................................................................................................................11
Question 3......................................................................................................................................12
i).................................................................................................................................................12
ii)................................................................................................................................................12
iii)...............................................................................................................................................13
Question 4......................................................................................................................................13
i).................................................................................................................................................13
ii)................................................................................................................................................14
iii)...............................................................................................................................................16
Conclusion and recommendations.................................................................................................17
References......................................................................................................................................18

4
Question 1
i)
Income statement of Home designs ltd
For the year ending 30 June 2019
Particulars Amount
Sales revenue 2,205,000
Interest income 3,100
Total income 2,208,100
Cost of goods sold 780,000
Gross profit 1,428,100
Advertising expense 46,000
Annual leave expense 25,000
Depreciation expense 60,000
Dividends paid 200,000
Doubtful debts expense 2,000
Income tax expense 274,000
Interest expense 22,000
Other expenses 36,000
Salaries and wages 286,000
Warranty expense 41,000
Total expenses 992,000
Net profit 436,100
Balance sheet of Home designs ltd
As at 30 June 2019
Particulars Amount Amount
Current assets:
Bank account 143,000
Finished goods inventory 322,000
Raw materials inventory 126,000
Trade receivables 183,400 774,400

5
Non-current assets:
Buildings 780,000
Land 609,000
Plant and equipment 860,000 2,249,000
Total assets 3,023,400
Current liabilities:
Accounts payable 56,300
Bank loan 20,000
Current tax liability 274,000
Provision for annual leave 23,000
Provision for warranty 34,000 407,300
Non-current liabilities:
Bank loan 180,000 180,000
Total Liabilities 587,300
Net assets 2,436,100
Equity
Share capital 2,000,000
Net profit 436,100
Total equity 2,436,100
ii)
Memo
From:
To: The directors of Home Designs Ltd
Date: 25 August 2019
Subject: the purpose of the statement of cash flows
The cash flow statement is also part of the financial statement of an entity and is prepared to
measure the cash performance of the company. In this all the transactions related to cash for

6
particular periods are recorded (Williams & Dobelman, 2017). The main purpose of this
statement is to provide the audience with the data in relation to the cash receipts, payments and
net change which has taken place. This is the report which is classified into three sections which
include the cash from operating, investing and financing activities (Gupta et al., 2014). The
overall knowledge about the cash position of the company will be attained with the help of this.
This statement is different from the income statement and balance sheet as in them all the
information about the assets, liabilities, income, and expenses are entered whether they are in
cash or non-cash form. In contrast to this the cash flow statement covers only the cash related
transactions. In balance sheet the final balances are shown whereas cash flow involves the
changes which have occurred in the year (Call et al., 2013). By the help of cash flow only cash
position of the business will be accessed but by other statements the overall financial position of
the company is taken into account.
Question 2
i)
FIFO method
Date Purchase Sales Balance
Particular Uni
ts
Rat
e
Amou
nt
Unit
s
Rat
e
Amount Unit Rate Amou
nt
1-Jul Opening
inventory
20 120
0
24000 20 1200 24000
5-Jul Purchase 4 125
0
5000 20 1200 24000
4 1250 5000
8-Jul Sales 6 290
0
17400 14 1200 16800
4 1250 5000
11-Jul Sales 2 290
0
5800 12 1200 14400
4 1250 5000

7
20-
Jul-19
Purchase 5 123
0
6150 12 1200 14400
4 1250 5000
5 1230 6150
4-Aug Sales 4 295
0
11800 8 1200 9600
4 1250 5000
5 1230 6150
7-Aug Sales 8 295
0
23600 4 1250 5000
5 1230 6150
20-
Aug
Purchase 10 126
0
12600 4 1250 5000
5 1230 6150
10 1260 12600
27-
Aug
Sales 2 295
0
6150 2 1250 2500
5 1230 6150
10 1260 12600
5-Sep Sales 6 299
0
17940 1 1230 1230
10 1260 12600
12-
Sep
Sales 2 299
0
5980 9 1260 11340
16-
Sep
Purchase 12 130
0
15600 9 1260 11340
12 1300 15600
26-
Sep
Sales 3 299
0
8970 6 1260 7560
12 1300 15600
51 63350 33 97640 18 23160

8
Calculation of cost of goods sold
and gross profit
Particulars Amount
Sales 97640
Cost of goods sold:
Opening stock +
purchases
63350
Less: Closing stock 23160
Cost of goods sold 40190
Gross profit 57450
LIFO Method
Date Purchase Sales Balance
Particular Uni
ts
Rat
e
Amou
nt
Unit
s
Rat
e
Amount Unit Rate Amou
nt
1-Jul Opening
inventory
20 120
0
24000 20 1200 24000
5-Jul Purchase 4 125
0
5000 20 1200 24000
4 1250 5000
8-Jul Sales 6 290
0
17400 18 1200 21600
11-Jul Sales 2 290
0
5800 16 1200 19200
20-
Jul-19
Purchase 5 123
0
6150 16 1200 19200
5 1230 6150
4-Aug Sales 4 295
0
11800 16 1200 19200
1 1230 1230

9
7-Aug Sales 8 295
0
23600 9 1200 10800
20-
Aug
Purchase 10 126
0
12600 9 1200 10800
10 1260 12600
27-
Aug
Sales 2 295
0
6150 9 1200 10800
8 1260 10080
5-Sep Sales 6 299
0
17940 9 1200 10800
2 1260 2520
12-
Sep
Sales 2 299
0
5980 9 1200 10800
16-
Sep
Purchase 12 130
0
15600 9 1200 10800
12 1300 15600
26-
Sep
Sales 3 299
0
8970 9 1200 10800
9 1300 11700
51 63350 33 97640 18 22500
Calculation of cost of goods sold
and gross profit
Particulars Amount
Sales 97640
Cost of goods sold:
Opening stock +
purchases
63350
Less: Closing stock 22500
Cost of goods sold 40850
Gross profit 56790

10
Weighted average method
Date Purchase Sales Balance
Particular Uni
ts
Ra
te
Amo
unt
Uni
ts
Ra
te
Amou
nt
Un
it
Rate Amo
unt
Averag
e rate
1-Jul Opening
inventory
20 12
00
2400
0
20 1200 2400
0
5-Jul Purchase 4 12
50
5000 20 1200 2400
0
4 1250 5000 1208.33
3
8-Jul Sales 6 290
0
17400 18 1208.3
3
2175
0
11-
Jul
Sales 2 290
0
5800 16 1208.3
3
1933
3.3
20-
Jul-
19
Purchase 5 12
30
6150 16 1208.3
3
1933
3.3
5 1230 6150 1213.49
2
4-
Aug
Sales 4 295
0
11800 17 1213.4
9
2062
9.4
7-
Aug
Sales 8 295
0
23600 9 1213.4
9
1092
1.4
20-
Aug
Purchase 10 12
60
1260
0
9 1213.4
9
1092
1.4
10 1260 1260
0
1237.96
9
27-
Aug
Sales 2 295
0
6150 17 1237.9
7
2104
5.5
5-
Sep
Sales 6 299
0
17940 11 1237.9
7
1361
7.7

11
12-
Sep
Sales 2 299
0
5980 9 1237.9
7
1114
1.7
16-
Sep
Purchase 12 13
00
1560
0
9 1237.9
7
1114
1.7
12 1300 1560
0
1273.41
6
26-
Sep
Sales 3 299
0
8970 18 1273.4
2
2292
1.5
51 6335
0
33 97640 18 2292
1.5
Calculation of cost of goods sold
and gross profit
Particulars Amount
Sales 97640
Cost of goods sold:
Opening stock +
purchases
63350
Less: Closing stock 22921.48
Cost of goods sold 40428.52
Gross profit 57211.48
ii)
To,
Director
The identification of the cost of inventory is done by using various methods which are available
(Nisha, 2015). In that, there is a different concept which is used and the best position will be
reflected by the weighted average method. By the help of this the cost of various categories of
inventory is taken on the basis of the weights provided to them (Krishnan & Lin, 2012). The
answers which will be attained with the help of this are most reliable and used in the long term.

12
The LIFO method will be best for the income tax purpose as in that there is the least income
which is calculated and so the amount of the tax which will have to be paid will also be lower
(Tenovici, 2012). This will be saving the income of the company which they can use for any
other purpose as the tax saving will be involved.
Question 3
i)
Calculation of ratios
Particulars Formula Accor Marriott Mantra
Return on total
assets
Net income/Total assets
*100
2.01% 4.22% 0.98%
Return on equity Net income/Total equity
*100
3.62% 14.62% 1.39%
Debt to equity total debt/ Total equity 0.80 2.46 0.42
ii)
The calculation of the ratios is performed in the above part and that represents the position of the
companies. It can be noted that in terms of profitability the Marriott is performing best as it is
having the highest rate of return on total assets and equity. After this Accor maintains the
position and at last is the mantra (Babalola & Abiola, 2013). If liquidity is to be considered then
Mantra is having the best position as it has the least debt to equity ratio of 0.42. This shows that
the company has the least obligation which is required to be met by them in every period.
Overall the position of Accor can be said to be appropriate with the limited return and average
debt ratio.
iii)
As an investment, the main focus is on the profitability of the business as if the company will be
having higher earnings then it will be able to pay the dividends. It can be seen that although the
debt-equity ratio of Marriott is high then also it is maintaining the high profitability (Williams &