Aero Inc. had the following balance sheet at December 31, 2016.

LANSBURY INC.

BALANCE SHEET

DECEMBER 31, 2016

Cash

\(20,000

Account payable

\)30,000

Accounts receivables

21,200

Bond payable

41,000

Investment

32,000

Common stock

100,000

Plant assets (net)

81,000

Retained earnings

23,200

Land

40,000

\(194,200

\)194,200

During 2017, the following occurred.

1. Aero liquidated its available-for-sale debt investment portfolio at a loss of \(5,000.

2. A tract of land was purchased for \)38,000.

3. An additional \(30,000 in common stock was issued at par.

4. Dividends totaling \)10,000 were declared and paid to stockholders.

5. Net income for 2017 was \(35,000, including \)12,000 in depreciation expense.

6. Land was purchased through the issuance of \(30,000 in additional bonds.

7. At December 31, 2017, Cash was \)70,200, Accounts Receivable was \(42,000, and Accounts Payable was \)40,000.

Instructions

(a) Prepare a statement of cash flows for the year 2017 for Aero.

(b) Prepare the unclassified balance sheet as it would appear at December 31, 2017.

(c) Compute Aero’s free cash flow and current cash debt coverage for 2017.

(d) Use the analysis of Aero to illustrate how information in the balance sheet and statement of cash flows helps the user of the financial statements.

Short Answer

Expert verified

The net increase in the cash balance is equal to$50,200.

Step by step solution

01

Definition of Free Cash Flow

A business entity's cash flow after all the outflows regarding the operating activities and capital assets is known as free cash flow.

02

Statement of Cash Flow

Particular

Amount $

Amount $

Opening Cash balance

Cash flow from operations:

Net income

$35,000

Add: Adjustment for reconciling net income to net cash.

Depreciation expenses

12,000

Increase in accounts payable

10,000

Loss on sale of investment

5,000

Increase in accounts receivables

(20,800)

Net Cash flow from operation

$41,200

Cash flow from investing activities:

Land purchased for cash

(38,000)

Sale of available for sale investment

27,000

Net cash flow from investing

(11,000)

Cash flow from financing activities:

Cash dividend

(10,000)

Issue of common stock

30,000

Net cash flow from finance

20,000

Net increase or decrease in cash

50,200

Add: opening cash balance

20,000

Ending cash balance

$70,200

03

Unclassified Balance sheet

LANSBURY INC.
BALANCE SHEET
DECEMBER 31, 2016

Cash

$70,200

Account payable

$40,000

Accounts receivables

42,000

Bond payable

71,000

Investment

0

Common stock

130,000

Plant assets (net)

69,000

Retained earnings

48,200

Land

108,000

$289,200

$289,200

04

Cash Flow Ratios

Free cash flow

Particular

Amount $

Cash flow from operations

$41,200

Less: Dividend

(10,000)

Less: Capital expenditure

(38,000)

Free Cash Flow

($6,800)

Currentcashdebtcoverage=CashflowfromoperatingactivitiesAveragecurrentliabilities=$41,200$40,000+$30,0002=1.18

05

Importance of Information Provided by the Balance Sheet and Statement of Cash Flow

The balance sheet and cash flow statement provide information to help the users predict financial flexibility and performance. It helps the users determine all the inflows and outflows of cash. It also helps the business entity in determining liquidity and solvency.

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 Vaia!

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

BE5-2 (L03) Koch Corporation’s adjusted trial balance contained the following asset accounts at December 31, 2017: Cash \(7,000, Land \)40,000, Patents \(12,500, Accounts Receivable \)90,000, Prepaid Insurance \(5,200, Inventory \)30,000, Allowance for Doubtful Accounts \(4,000, and Equity Investments (trading) \)11,000. Prepare the current assets section of the balance sheet, listing the accounts in proper sequence.

Early in January 2018, Hopkins Company is preparing for a meeting with its bankers to discuss a loan request. Its bookkeeper provided the following accounts and balances at December 31, 2017.

Debit \(

Credit \)

Cash

\(75,000

Accounts receivable (net)

38,500

Inventory (net)

65,300

Equipment (net)

84,000

Patent

15,000

Notes and Accounts payable

\)52,000

Note payable (due 2019)

75,000

Common stock

100,000

Retained earnings

50,800

\(277,800

\)277,800

Except for the following items, Hopkins has recorded all adjustments in its accounts.

1. Cash includes \(500 petty cash and \)15,000 in a bond sinking fund.

2. Net accounts receivable is comprised of \(52,000 in accounts receivable and \)13,500 in allowance for doubtful accounts.

3. Equipment had a cost of \(112,000 and accumulated depreciation of \)28,000.

4. On January 8, 2018, one of Hopkins’ customers declared bankruptcy. At December 31, 2017, this customer owed Hopkins \(9,000.

Accounting

Prepare a corrected December 31, 2017, balance sheet for Hopkins Company.

Analysis

Hopkins’ bank is considering granting an additional loan in the amount of \)45,000, which will be due December 31, 2018. How can the information in the balance sheet provide useful information to the bank about Hopkins’ ability to repay the loan?

Principles

In the upcoming meeting with the bank, Hopkins plans to provide additional information about the fair value of its equipment and some internally generated intangible assets related to its customer lists. This information indicates that Hopkins has significant unrealized gains on these assets, which are not reflected on the balance sheet. What objections is the bank likely to raise about the usefulness of this information in evaluating Hopkins for the loan renewal?

(Classification of Balance Sheet Accounts) Assume that Fielder Enterprises uses the following headings on its balance sheet.

(a) Current assets

(g) Long-term liabilities

(b) Investments

(h) Capital stock

(c) Property, plant, and equipment

(i) Equity attribute to non-controlling interest

(d) Intangible assets

(i) paid-in-capital in excess of par

(e) Other assets

(k) Retained earnings

(f) Current liabilities

Instructions

Indicate by letter how each of the following usually should be classified. If an item should appear in a note to the financial statements, use the letter “N” to indicate this fact. If an item need not be reported at all on the balance sheet, use the letter “X.”

1. Prepaid insurance.

2. Stock owned in affiliated companies.

3. Unearned service revenue.

4. Advances to suppliers.

5. Unearned rent revenue.

6. Preferred stock.

7. Additional paid-in capital on preferred stock.

8. Copyrights.

9. Petty cash fund.

10. Sales taxes payable.

11. Accrued interest on notes receivable.

12. Twenty-year issue of bonds payable that will mature within the next year. (No sinking fund exists, and refunding is not planned.)

13. Machinery retired from use and held for sale.

14. Fully depreciated machine still in use.

15. Accrued interest on bonds payable.

16. Salaries that company budget shows will be paid to employees within the next year.

17. Discount on bonds payable. (Assume related to bonds payable in item 12.)

18. Accumulated depreciation—buildings.

19. Shares held by non-controlling stockholders.

Case 2: Sherwin-Williams Company Sherwin-Williams, based in Cleveland, Ohio, manufactures a wide variety of paint and other coatings, which are marketed through its specialty stores and in other retail outlets. The company also manufactures paint for automobiles. The Automotive Division has had financial difficulty. During a recent year, five branch locations of the Automotive Division were closed, and new management was put in place for the remaining branches.

The following titles were shown on Sherwin-Williams’s balance sheet for that year.

Account payable

Machinery and Equipment

Accounts receivable, less allowance

Other accruals

Accrued taxes

Other capital

Building

Other current assets

Cash and Cash equivalents

Other long term liabilities

Common stock

Postretirement obligation other than pension

Employee compensation payable

Retained earnings

Finished good inventories

Short-term investment

Intangible and other assets

Taxes payable

Land

Work in process and raw material inventories.

Long-term debt

Instructions

(a) Organize the accounts in the general order in which they would have been presented in a classified balance sheet.

(b) When several of the branch locations of the Automotive Division were closed, what balance sheet accounts were most likely affected? Did the balance in those accounts decrease or increase?

Case 1: Uniroyal Technology Corporation

Uniroyal Technology Corporation (UTC), with corporate offices in Sarasota, Florida, is organized into three operating segments. The high-performance plastics segment is responsible for research, development, and manufacture of a wide variety of products, including orthopedic braces, graffiti-resistant seats for buses and airplanes, and a static-resistant plastic used in the central processing units of microcomputers. The coated fabrics segment manufactures products such as automobile seating, door and instrument panels, and specialty items such as waterproof seats for personal watercraft and stain-resistant, easy-cleaning upholstery fabrics. The foams and adhesives segment develops and manufactures products used in commercial roofing applications.

The following items relate to operations in a recent year.

1. Serious pressure was placed on profitability by sharply increasing raw material prices. Some raw materials increased in price 50% during the past year. Cost containment programs were instituted and product prices were increased whenever possible, which resulted in profit margins actually improving over the course of the year.

2. The company entered into a revolving credit agreement, under which UTC may borrow the lesser of \(15,000,000 or 80% of eligible accounts receivable. At the end of the year, approximately \)4,000,000 was outstanding under this agreement. The company plans to use this line of credit in the upcoming year to finance operations and expansion.

Instructions

(a) Should investors be informed of raw materials price increase, such as described in item 1? Does the fact that the company successfully met the challenge of higher prices affect the answer? Explain.

(b) How should the information in item 2 be presented in the financial statements of UTC?

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.

Sign-up for free