Question

In: Accounting

Adjust the Cash Balance We obtain the following 2018 forecasts of selected financial statement line items...

Adjust the Cash Balance
We obtain the following 2018 forecasts of selected financial statement line items for Journey Company.

$ millions 2017 Actual 2018 Est.
Net Sales $688,555 $720,440
Marketable securities 67,096 62,096
Long-term debt 346,558 308,437
Treasury stock (deducted from equity) 51,174 51,174
Cash generated by operations 57,585
Cash used for investing (14,797)
Cash used for financing (54,771)
Total net change in cash (11,983)
Cash at beginning of period 51,141
Cash at end of period $39,158



a. Does forecasted cash deviate from the normal level for this company?
Calculate the company's normal cash level as a percentage of sales.
Round answer to one decimal place.
Answer

%
Using the rounded answer above, compute what should be the normal cash balance for FY2018.
Round answer to the nearest million.
$Answer

million

b. Is the deviation in part a large enough to require adjustment? Explain.

No. the deviation is not large enough to require an adjustment.

Yes, the deviation is large enough to require an adjustment.



c. Identify three ways to adjust the forecasted cash balance.
Which option would least likely be used to adjust the cash balance?  

Sell marketable securities

Decrease capital expenditures

Increase long-term debt

Sell treasury stock

d. Fill in the blanks in the following statement of cash flows assuming long-term debt is used to adjust the forecasted cash balance.

Use negative signs with answers, when appropriate.

Cash generated by operations $Answer
Cash used for investing Answer
Cash used for financing Answer
Total change in cash Answer
Cash at beginning of period Answer
Cash at end of period $Answer

e. Fill in the blanks in the following statement of cash flows assuming marketable securities are used to adjust the forecasted cash balance.

Use negative signs with answers, when appropriate.

Cash generated by operations $Answer
Cash used for investing Answer
Cash used for financing Answer
Total change in cash Answer
Cash at beginning of period Answer
Cash at end of period $Answer

Solutions

Expert Solution


Related Solutions

Problem 13-10 The following are line items included in the 2018 statement of cash flows prepared...
Problem 13-10 The following are line items included in the 2018 statement of cash flows prepared by Uli’s Clothing Company: Depreciation expense $ 5,220 Increase in accounts receivable 1,790 Increase in accounts payable 12,700 Increase in accrued salaries payable 3,800 Increase in inventories 11,500 Gain on disposal of long-term assets 100 Increase in income taxes payable 2,060 Net income 15,700 Prepare the operating cash flow section of Uli’s statement of cash flows using the indirect method. (Enter amounts that decrease...
Prepare a balance sheet and cash flow statement using the selected financial statement information and additional...
Prepare a balance sheet and cash flow statement using the selected financial statement information and additional data for Stanislaus Co. presented below. Balance sheet    December 31 2015                                                                                                                                                       Cash..........................................................     $52,000                                                Accounts receivable (net)...........................       64,000                                                Inventory..................................................     178,000                                                Land..........................................................       78,800                                                Equipment.................................................     504,000                                                    TOTAL............................................ $876,800                                                Accumulated depreciation..........................     $94,000                                                Accounts payable.......................................       50,400                                                Notes payable - short-term........................       67,200                                                Notes payable - long-term..........................     178,000                                                Common stock...........................................     420,000                                                Retained earnings......................................       67,200                                                TOTAL............................................ $876,800                         ...
Financial Statement Items Identify the financial statement (or statements) in which each of the following items...
Financial Statement Items Identify the financial statement (or statements) in which each of the following items would appear: income statement (IS), statement of stockholders’ equity (SSC), balance sheet (BS), or statement of cash flow (SCF). Assets Revenue Cashflow from investing activities Stockholders’ equity Expenses Net change in cash Net Income Liabilities
All of the following items are reported on a Statement of Financial Position (Balance Sheet). How...
All of the following items are reported on a Statement of Financial Position (Balance Sheet). How would each of the above items be reported on the Statement of Financial Position balance sheet according to ASPE? If you identify an item as a liability, indicate whether or not it is a financial liability. a) Accrued vacation pay b) Income tax instalments paid in excess of the income tax liability on the year’s c) A bank overdraft, with no other accounts at...
Which of the following items are listed as separate line items on an income statement in...
Which of the following items are listed as separate line items on an income statement in order to facilitate analysis and understanding? (Select all that apply.) A gain on sale of a major division of a company An increase in the sale price by more than 20% The effect on prior years of change in depreciation method A loss due to fire
Firm A had the following selected items on its balance sheet: Cash $ 32,000,000 Common stock...
Firm A had the following selected items on its balance sheet: Cash $ 32,000,000 Common stock ($60 par; 2,400,000 shares outstanding) 144,000,000 Additional paid-in capital 14,400,000 Retained earnings 68,000,000 How would each of these accounts appear after: a cash dividend of $2 per share? Round the number of shares outstanding to the nearest whole number and the other answers to the nearest dollar. Cash $   Common stock ($   par; shares outstanding) $   Additional paid-in capital $   Retained earnings $   a...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 20,862 $ 19,014 Cost of sales 11,354 10,214 Gross profit 9,508 8,800 Demand creation expense 2,448 2,356 Operating overhead expense 4,245 3,970 Total selling and administrative expense 6,693 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,844 2,517 Income taxes...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 20,862 $ 19,014 Cost of sales 11,354 10,214 Gross profit 9,508 8,800 Demand creation expense 2,448 2,356 Operating overhead expense 4,245 3,970 Total selling and administrative expense 6,693 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,844 2,517 Income taxes...
The following items were included as cash on the statement of financial position Lawton Company. How...
The following items were included as cash on the statement of financial position Lawton Company. How should each of the items have been reported? Write your answer on the space after each item. The lists of possible answers are as follows: Cash, Notes Receivable, Accounts Receivable, Advances to Employees, Office Supplies and Other Noncurrent Asset Demand deposits with bank Bank account used for payment of salaries and wages Cash in special cash account to be used currently for the construction...
For the FY 2018, Dorchester Company's balance sheet included the following current items: cash $51,000, accounts...
For the FY 2018, Dorchester Company's balance sheet included the following current items: cash $51,000, accounts receivable $138,000, inventories $91,000, prepaid expenses $21,000, accounts payable $72,000, and accrued expenses $68,000. Use this information to determine the Current Ratio. (Round & enter your answers to one decimal place.)Your answer : For the FY 2018, Frederick Company had net sales of $1,150,000 and net income of $85,000, paid income taxes of $27,500, and had before tax interest expense of $20,000. Use this...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT