The Lyon Corporation is a merchandising company. Prepare a short-term cash forecast for July of Year 6

Question:

The Lyon Corporation is a merchandising company. Prepare a short-term cash forecast for July of Year 6 following the format of Exhibit 9A.4. Selected financial data from Lyon Corporation as of July 1 of Year 6 are reproduced below ($ thousands):

Cash, July 1, Year 6 . . . . . . . . . . . . . . . . . . . . . . . . $ 20

Accounts receivable, July 1, Year 6. . . . . . . . . . . . . 20

Forecasted sales for July. . . . . . . . . . . . . . . . . . . . . 150

Forecasted accounts receivable, July 31, Year 6. . . 21

Inventory, July 1, Year 6. . . . . . . . . . . . . . . . . . . . . . 25

Desired inventory, July 31, Year 6 . . . . . . . . . . . . . . 15

Depreciation expense for July . . . . . . . . . . . . . . . . . 4

Miscellaneous outlays for July. . . . . . . . . . . . . . . . . 11

Minimum cash balance desired . . . . . . . . . . . . . . . 30

Accounts payable, July 1, Year 6. . . . . . . . . . . . . . . 18


Additional Information:

1. Gross profit equals 20% of cost of goods sold.

2. Lyon purchases all inventory on the second day of the month and receives it the following week.

3. Lyon pays 75% of payables within the month of purchase and the balance in the following month.

4. Lyons pays all remaining expenses in cash.


Corporation
A Corporation is a legal form of business that is separate from its owner. In other words, a corporation is a business or organization formed by a group of people, and its right and liabilities separate from those of the individuals involved. It may...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Statement Analysis

ISBN: 978-0078110962

11th edition

Authors: K. R. Subramanyam, John Wild

Question Posted: