Income Statement: |
Horizontal analysis |
Common Statement |
||||
2019 |
2018 |
Inc. / Dec. |
% |
2019 |
2018 |
|
Gross rev. |
5000000 |
3000000 |
2000000 |
67 |
100 |
100 |
COS |
3000000 |
1500000 |
1500000 |
100 |
60 |
50 |
Gross profit |
2000000 |
1500000 |
500000 |
33 |
40 |
50 |
Add:Int. income |
100000 |
90000 |
10000 |
11 |
2 |
3 |
Total Gross Profit |
2100000 |
1590000 |
510000 |
32 |
42 |
53 |
Less: Expenses: |
0 |
0 |
||||
compu. Software |
50000 |
20000 |
30000 |
150 |
1 |
0.7 |
bad debts |
295000 |
50000 |
245000 |
490 |
5.9 |
1.7 |
Advertising |
120000 |
60000 |
60000 |
100 |
2.4 |
2.0 |
Salaries and wages |
90000 |
40000 |
50000 |
125 |
1.8 |
1.3 |
Insurance |
200000 |
100000 |
100000 |
100 |
4 |
3.3 |
Depreciation |
45000 |
20000 |
25000 |
125 |
0.9 |
0.7 |
total expenses |
800000 |
290000 |
510000 |
176 |
16 |
9.7 |
Profit from operations |
1300000 |
1300000 |
0 |
26 |
43.3 |
|
Less:Finance charges |
100000 |
10000 |
90000 |
900 |
2 |
0.3 |
Profit before tax |
1200000 |
1290000 |
-90000 |
-7 |
24 |
43.0 |
taxation exp. |
440000 |
645000 |
-205000 |
-32 |
8.8 |
21.5 |
Profit for the period |
760000 |
645000 |
115000 |
18 |
15.2 |
21.5 |
Other comprehensive income |
0 |
0 |
0 |
0 |
0.0 |
|
total Comprehensive income |
760000 |
645000 |
115000 |
18 |
15.2 |
21.5 |
Market price per share |
115 |
105 |
10 |
10 |
||
Ratios analysis: |
Formula |
Calculation |
Result |
|||
Yr 2019 |
Yr 2018 |
Yr 2019 |
Yr 2018 |
|||
Gross profit ratio |
GP/Revenues |
2.1m/5m |
1.59m/3m |
0.42 |
0.53 |
|
Operating profit ratio |
OP/Revenues |
1.3m/5m |
1.3m/3m |
0.26 |
0.43 |
|
Net profit ratio |
NP/Revenues |
0.76m/5m |
0.645m/3m |
0.15 |
0.22 |
|
Interest coverage ratio |
OP/Finance charges |
1.3m/0.1m |
1.3m/0.01m |
13 |
130 |
Analysis and Appraisal of performance of company:
a) Gross profit : The company’s gross margin has reduced since 2018.
b) Operating expenses: The operating expenses of the company has increased three folds, specially the bad debts in the year 2019.
c) Operating profit : The company has been maintaining the operating profit amount-wise. Comparing to the sales, the operating profit has reduced.
d) Finance expenses : The company’s finance charges has increased 9 times of year 2018.
e) Taxation expenses: The company’s taxes has reduced 32% even though the Revenue increased 67%.
f) Net Profit : Net Profit margin has reduced from 22% to 15% in the year 2019.
g) Interest coverage : The interest coverage has reduced from 130 times to 13 in the year 2019. So, it become risky to finance the company’s operation.
h) Overall performance: The company’s overall performance is worse except the growth in the Revenue in the year 2019.
i) Share Price: The price of the company’s share has increased 10% since year 2018.
j) Investment opportunity: The company’s offers good investment opportunities as long as market price of the shares are concerned, but performance-wise investment in the company is not recommended.
When it comes to finance and financial statement analysis, the term “profitability”….
Financial Statement Analysis Identify the tools used for Financial Statement Analysis Horizontal Trend Analysis It is also known as trend analysis. And it evaluates a series of financial statement data over a period. It is used primarily in intra company comparisons. Financial statements facilitate this type of comparison because: Each of the basic financial statements show a minimum of a year Summary of selected data will show 5-10 years. Vertical Common Size Analysis It evaluates financial statement data...
IMG_8457.JPGIMG_8455.JPGIMG_8456.JPGCASE 3–4 Leasing in the Airline Industrya. Compute key liquidity, solvency, and return on investment ratios for 1998 (current ratio, total debt to equity, long-term debt to equity, times interest earned, return on assets, return on equity). Comment on the financial performance, financial position, and risk of these three companies—both as a group and individually. b. To understand the effect of high operating leverage on the volatility of airlines’ earnings, prepare the following sensitivity analysis: Assume that 25% of airline costs...
Westfield Capital Management Co.'s equity investment strategy is to invest in companies with low price-to-book ratios, while considering differences in solvency and asset utilization. Westfield is considering investing in the shares of either Jerry's Departmental Stores (JDS) or Miller Stores (MLS). Selected financial data for both companies follow:SELECTED FINANCIAL DATA AS OF MARCH 31, 2006($ millions)JDSMLSSales$21,250$18,500Fixed assets5,7005,500Short-term debt 1,000Long-term debt2,7002,500Equity6,0007,500Outstanding shares (in millions)250400Stock price ($ per share)51.5049.50Required:a. Compute each of the following ratios for both JDS and MLS:(1) Price-to-book ratio(2) Total-debt-to-equity...
Financial Statement Analysis Identify the tools used for Financial Statement Analysis Horizontal Trend Analysis Vertical Common Size Analysis Ratio Analysis Performance Liquidity Solvency Identify the comparison and use of the tools above Intra Company Inter company Industry
Let’s discuss the interim or final results of the financial statement analysis paper that you're working on for this week. Be sure to indicate the company you selected and discuss at least one of the ratios you analyzed. What was the result, and what does it tell us about the financial health of the organization?
CASE 3–2 Analyzing and Interpreting LiabilitiesRefer to the annual report of Campbell Soup Company in Appendix A.Required:a. Identify Campbell Soup’s major categories of liabilities. Identify which of these liabilities require recognition of interest expense. b. Reconcile activity in the long-term borrowing account for Year 11. c. Describe the composition of Campbell Soup’s long-term liabilities account using its note 19.IMG_8454.JPG
Explain the structure of the financial statement analysis?
Financial Statement Analysis The financial statements for Nike, Inc., are presented in Appendix D. Use the following additional information (in thousands): Accounts receivable at May 31, 2014: $3,117 Inventories at May 31, 2014: 3,947 Total assets at May 31, 2014: 18,594 Stockholders' equity at May 31, 2014: 12,000 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Do not round interim calculations. Round the working capital amount in part (a) to the...
MG770- Financial Reporting, Financial Statement Analysis, and Valuation Homework Assignment Week # 3 __________________________________________________________________________ Create the statement of cash-flow with indirect method Interpret the result of the statement of cash flow with percentage Instruction: [1] Please use the balance sheet as follows to classify each activity (operating, investing, and financing) from the column of different. [2] please create a new statement of cash-flow from your classification on balance sheet. [3] The statement of cash flow will be provided to measure...