/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} 16E A comparative balance sheet for ... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

A comparative balance sheet for Shabbona Corporation is presented below.

Particular

December 31

2017

2016

Assets

Cash

\(73,000

\)22,000

Accounts receivable

82,000

66,000

Inventory

180,000

189,000

Land

71,000

110,000

Equipment

260,000

200,000

Accumulated depreciation – Equipment

(69,000)

(42,000)

Total

\(597,000

\)545,000

Liabilities and stockholder’s equity

Account payable

\(34,000

\)47,000

Bonds payable

150,000

200,000

Common stock (\(1 par)

214,000

164,000

Retained earnings

199,000

134,000

Total

\)597,000

\(545,000

Additional information:

1. Net income for 2017 was \)125,000. No gains or losses were recorded in 2017.

2. Cash dividends of \(60,000 were declared and paid.

3. Bonds payable amounting to \)50,000 were retired through issuance of common stock.

Instructions

(a) Prepare a statement of cash flows for 2017 for Shabbona Corporation.

(b) Determine Shabbona Corporation’s current cash debt coverage, cash debt coverage, and free cash flow. Comment on its liquidity and financial flexibility.

Short Answer

Expert verified

Net increase in the cash is equal to$51,000.

Step by step solution

01

Definition of Cash Debt Coverage

Cash debt coverage is the financial metric used to determine the ability of the company to pay off all the liabilities using the cash generated from the general business operations.

02

Statement of Cash Flow

Particular

Amount $

Amount $

Cash flow from operations:

Net income

$125,000

Add or less: Adjustments to net income

Depreciation expenses

27,000

Increase in accounts receivable

(16,000)

Decrease in inventory

9,000

Decrease in accounts payable

(13,000)

Cash flow from operation

132,000

Cash flow from investing activities:

Sale of land

39,000

Purchase of equipment

(60,000)

Cash flow used in investing activities

(21,000)

Cash flow from financing activities:

Cash Dividend

(60,000)

Cash flow used financing activities

(60,000)

Net increase or decrease in cash

51,000

Add: opening cash balance

22,000

Ending cash balance

$73,000

03

Cash Flow Ratios and Interpretation

Free cash flow:

Particular

Amount $

Cash flow from operations

$132,000

Less: Cash dividend

(60,000)

Less: Capital expenditure

(60,000)

Free Cash Flow

$12,000

Cash debt coverage:

CashDebtCoverage=CashflowfromoperatingactivtiesTotalliabilities=$132,000$184,000=0.72

Current cash debt coverage:

CurrentCashDebtCoverage=CashflowfromoperatingactivitiesAveragecurrentliabilities=$132,000$47,000+$34,0002=3.26

Liquidity: Current cash debt coverage reflects the business’s liquidity, which is 3.26 times. That means the business entity can cover its current liabilities using the cash generated from operation.

Flexibility: Financial flexibility is reflected by cash debt coverage, and it is 0.72. It means the business entity cannot pay off all liabilities using the cash generated from operations.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

(Reporting the Financial Effects of Varied Transactions) In an examination of Arenes Corporation as of 31 Dec, 2017, you have learned that the following situations exist. No entries have been made in the accounting records for these items.

1. The corporation erected its present factory building in 2001. Depreciation was calculated by the straight-line method, using an estimated life of 35 years. Early in 2017, the board of directors conducted a careful survey and estimated that the factory building had a remaining useful life of 25 years as of 1 Jan, 2017.

2. An additional assessment of 2016 income taxes was levied and paid in 2017.

3. When calculating the accrual for officers’ salaries at 31 Dec, 2017, it was discovered that the accrual for officers’ salaries for 31 Dec, 2016, had been overstated.

4. On 15 Dec, 2017, Arenes Corporation declared a cash dividend on its common stock outstanding, payable 1 Feb, 2018, to the common stockholders of record 31 Dec, 2017.

Instructions

Describe fully how each of the items above should be reported in the financial statements of Arenes Corporation for the year 2017.

The partner in charge of the Kappeler Corporation audit comes by your desk and leaves a letter he has started to the CEO and a copy of the cash flow statement for the year ended December 31, 2017. Because he must leave on an emergency, he asks you to finish the letter by explaining: (1) the disparity between net income and cash flow, (2) the importance of operating cash flow, (3) the renewable source(s) of cash flow, and (4) possible suggestions to improve the cash position.

Date

President Kappeler, CEO

Kappeler Corporation

125 Wall Street

Middleton, Kansas 67458

Dear Mr. Kappeler:

I have good news and bad news about the financial statements for the year ended December 31, 2017. The good news is that net income of $100,000 is close to what we predicted in the strategic plan last year, indicating strong performance this year. The bad news is that the cash balance is seriously low. Enclosed is the Statement of Cash Flows, which best illustrates how both of these situations occurred simultaneously . . .

Instructions

Complete the letter to the CEO, including the four components requested by your boss.

E5-11 (L03) EXCEL (Balance Sheet Preparation) Presented below is the adjusted trial balance of Kelly Corporation at December 31, 2017.

Particular

Debit

Credit

Cash

\(?

Supplies

1,200

Prepaid insurance

1,000

Equipment

48,000

Accumulated depreciation – Equipment

\)4,000

Trademarks

950

Accounts payable

10,000

Salaries and wages payable

500

Unearned service revenue

2,000

Bonds payable (due 2024)

9,000

Common stock

10,000

Retained earnings

25,000

Service revenue

10,000

Salaries and wages expenses

9,000

Insurance expenses

1,400

Rent expenses

1,200

Interest expenses

900

Total

\(?

\)?

Additional information:

1. Net loss for the year was $2,500.

2. No dividends were declared during 2017.

Instructions

Prepare a classified balance sheet as of December 31, 2017.

The major classifications of activities reported in the statement of cash flows are operating, investing, and financing. Classify each of the transactions listed below as:

1. Operating activity—add to net income.

2. Operating activity—deduct from net income.

3. Investing activity.

4. Financing activity.

5. Reported as significant noncash activity.

The transactions are as follows.

(a) Issuance of common stock.

(h) Payment of cash dividends.

(b) Purchase of land and building.

(i) Exchange of furniture for office equipment.

(c) Redemption of bonds

(j) Purchase of treasury stock.

(d) Sale of equipment.

(k) Loss on sale of equipment.

(e) Depreciation of machinery.

(l) Increase in accounts receivable during the year.

(f) Amortization of patent.

(m) Decrease in accounts payable during the year.

(g) Issuance of bonds for plant assets.

IFRS5-3 Briefly describe the convergence efforts related to financial statement presentation.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.