Question

financial statement analysis

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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.

Add a comment
Know the answer?
Add Answer to:
financial statement analysis
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • When it comes to finance and financial statement analysis, the term “profitability”….

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

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

  • Accounting, financial statement analysis

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

  • Accounting, financial statement analysis

    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          &n

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

    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?

  • Accounting, financial statement analysis

    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?

    Explain the structure of the financial statement analysis?

  • Financial Statement Analysis The financial statements for Nike, Inc., are presented in Appendix D. Use the...

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

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

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT