|
Louisiana Grill |
|||||
|
Cash flow statement from the year 2016 to 2020 |
|||||
|
2020 |
2019 |
2018 |
2017 |
||
|
$ |
$ |
$ |
$ |
||
|
Reported profit before tax |
348,538 |
176,443 |
175,349 |
78,528 |
|
|
Add |
|||||
|
Depreciation & Amortization |
83,608 |
103,405 |
129,664 |
164,871 |
|
|
432,146 |
279,848 |
305,013 |
243,399 |
||
|
cash flow from operating activities |
|||||
|
Accounts receivable |
(31,472) |
(24,133) |
43,230 |
(38,688) |
|
|
Inventory |
24,680 |
(38,222) |
53,272 |
(22,016) |
|
|
prepaid expense |
(10,147) |
(4,682) |
5,856 |
3,005 |
|
|
bad indebtness |
(74,100) |
||||
|
deffered revenue |
13,675 |
3,526 |
11,126 |
4,160 |
|
|
payables & accruals |
1,092 |
53,659 |
25,560 |
(57,306) |
|
|
Tax paid |
34,419 |
219 |
19,364 |
(1,365) |
|
|
32,247 |
9,633 |
158,408 |
(186,310) |
||
|
cash flow from investing activities |
– |
– |
– |
– |
|
|
cash flow from financing activities |
|||||
|
Retained earnings |
238,831 |
101,154 |
100,278 |
22,822 |
|
|
238,831 |
101,154 |
100,278 |
22,822 |
||
|
Net cash and cash equivalent |
703,224 |
390,635 |
563,699 |
79,911 |
|
|
Cash and cash equivalent b/f |
76,969 |
53,297 |
0 |
0 |
|
|
Cash and cash equivalent c/f |
780,193 |
443,932 |
563,699 |
79,911 |
For the five year period the cash flows of the business has been increasing. This is an indication that the business liquidity position is good. The retained earnings has also been on a rising trend showing that the profits from the business has been increasing. This is supported by the increasing profits before taxation as shown by the income statement. Depreciation and amortization has been on a declining trend showing that the value of the assets is decreasing as well as the outstanding loan to be paid by the business.
Common Size Statements therefore helps in the process of analysis of the major aspects related to the information production process.
|
2020 |
2019 |
2018 |
2017 |
2016 |
|
|
Sales/Revenue |
4229192 |
3964108 |
3943656 |
3675730 |
3579208 |
|
Cost of goods sold |
2579807 |
2497388 |
2464785 |
2315710 |
2290693 |
|
Gross income |
1649385 |
1466720 |
1478871 |
1360020 |
1288515 |
|
Pretax income |
348538 |
176443 |
175349 |
78528 |
85354 |
|
Sales/Revenue |
100% |
100% |
100% |
100% |
100% |
|
Cost of goods sold |
60.9% |
62.9% |
62.5% |
63.0% |
63.99% |
|
Gross income |
29% |
32.7% |
33.8% |
34.9% |
35% |
|
Pretax income |
8.2% |
4.4% |
3.7% |
2.1% |
1.0% |
From the analysis above pretax income has been increasing significantly since 2016. This could be attributed to strategies put in place by the organization which seem to be working for them. The cost of generating revenue has also been declining showing that the business has been putting in place cost cutting measures to enhance profits. It is also notable that the sales has been increasing as from 2016 to 2020.
The following financial ratios can be used to analyses a firm;
Gearing ratios which measures the financial risk of the firm. It is computed as = total liabilities / total assets and expressed as a ratio. The gearing ratio of Louisiana Grill for the year 2020 is
= 662691/1164059
= 0.57
The financial risk is average.
Return on Investment (ROI) = Net profit/Total Asset x 100. The ratio is used to compute the return on profit from the total investment made by Louisiana Grill. The higher the return the more the come is efficiently using its investment to generate income and vice versa. Therefore encouraging investors to invest more into the company and vice versa.
ROI of Louisiana Grill for the year 2020 = 278830/1164059 x 100
= 24%
Acid test ratio computed by dividing (Current Asset – Inventory)/Current liabilities.
Louisiana Grill ratio for 2020= (487395-139310)/466620
= 0.74:1
The firm is therefore liquid.
Gross profit margin which is computed as = Gross profit/Sales x 100 . For the year 2020 gross profit margin is= 1649385/4229192×100
= 39.0 %
Valuation of common shares
This can be achieved by increasing company’s price-to-earnings (P/E) ratio of Louisiana Grill.
This is computed as = 1/ (40000/1000)
= 0.25
Value of conversion feature over the value of the bond
This can be computed by multiplication of price of common stock with the conversion ratio.
Comparison of debt financing and equity financing
Debt
1000000 x 5% = 50000
Equity
10000 x 50% = 5000x 10 = 50000
Both yield equal returns but it’s better to use debt financing since it is interest on debt is tax allowable.
References
https://www.investopedia.com/terms/c/conversion-value.asp
https://study.com/academy/lesson/conversion-valuation-definition-formula-calculation.html
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
