Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare and analyze the cash flow statement of the company (Exhibit TN-1). EXHIBIT 1: INCOME STATEMENT, APRIL 1 TO MARCH 31 (IN THOUSANDS) 201213

Prepare and analyze the cash flow statement of the company (Exhibit TN-1).

EXHIBIT 1: INCOME STATEMENT, APRIL 1 TO MARCH 31 (IN ₹ THOUSANDS)

2012–13

2013–14

2014–15

Sales

Cash

Credit

200

1,800

480

4,320

800

7,200

Total sales

2,000

4,800

8,000

Cost of goods sold

1,240

2,832

4,800

Gross profit

Operating expenses:

General, administration, and selling expenses

Depreciation

Interest expenses (on borrowings)

80

100

60

450

400

158

1,000

660

340

Profit before tax (PBT)

520

960

1,200

Tax @ 30%

156

288

360

Profit after tax (PAT)

364

672

840

EXHIBIT 2: BALANCE SHEET (IN ₹ THOUSANDS)

2012–13

2013–14

2014–15

Assets:

Fixed assets (net of depreciation) Current assets

Cash and cash equivalents

Accounts receivable

Inventories

1,900

40

300

2,500

100

1,500

4,700

106

2,100

Total

2,560

5,600

9,156

Equity & Liabilities:

Equity share capital (shares of ₹10 each)

Reserve & surplus

Long-term borrowings

Current liabilities

1,200

364

736

260

1,600

1,036

1,236

1,728

2,000

1,876

2,500

2,780

Total

2,560

5,600

9,156

EXHIBIT 3: INDUSTRY AVERAGE OF KEY RATIOS

Ratio

Sector Average

Current ratio

2.30:1

Acid test ratio (quick ratio)

1.20:1

Receivable turnover ratio

7 times

Receivable days

52 days

Inventory turnover ratio

4.85 times

Inventory days

75 days

Long-term debt to total debt

24%

Debt-to-equity ratio

35%

Gross profit ratio

40%

Net profit ratio

18%

Return on equity

22%

Return on total assets

10%

Total asset turnover ratio

1.1

Fixed asset turnover ratio

2

Current asset turnover ratio

3

Interest coverage ratio (times interest earned)

10

Working capital turnover ratio

8

Return on fixed assets

24%

Step by Step Solution

3.40 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

Sales Cash Credit Total Sales COGS Gross profit Operating Expenses Genadm sellexp Profit before tax ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Core Concepts of Accounting

Authors: Cecily A. Raiborn

2nd edition

470499478, 978-0470499474

More Books

Students also viewed these Accounting questions