Adjust the Cash BalanceWe obtain the following 2020 forecasts of selected financial statement line items for Journey Company.2019Actual 2020 Est.$535,667 $559,77250,725 46,945261,998 233,17838,688 38,68843,618(11,270)(41,323)$ millionsNet SalesMarketable securitiesLong-term debtTreasury stock (deducted from equity)Cash generated by operationsCash used for investingCash used for financingTotal net change in cashCash at beginning of periodCash at end of periodNote: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places.a. Does forecasted cash deviate from the normal level for this company?Calculate the company's normal cash level as a percentage of sales.Normal cash as a % of sales0%$Using the answer above, compute what should be the normal cash balance for FY2020.Normal cash balance for FY20200b. Is the deviation in part a large enough to require adjustment? Explain.(8,975)38,663$29,688c. Identify three ways to adjust the forecasted cash balance.Which option would least likely be used to adjust the cash balance?Sell marketable securitiesDecrease capital expendituresIncrease long-term debtSell treasury stockCash used for financingnt of cash flows assuming long-term debt is used to adjust the forecasted cash balance.000 d. Complete the following statement of cash flows assuming long-term debt is used to adjust the forecasted cash balance.Statement of Cash FlowsCash generated by operations $Cash used for investingCash used for financingTotal change in cashCash at beginning of periodCash at end of period$0$OO000O O00e. Complete the following statement of cash flows assuming marketable securities are used to adjust the forecasted cash balance.Statement of Cash FlowsCash generated by operations $Cash used for investingCash used for financingTotal change in cashCash at beginning of periodCash at end of period000000Please answer all parts of the question.

"Since you have asked a question with sub-parts more than three, as per guidelines, the first three sub-parts are answered for you. If you want the remaining sub-parts to be answered, please post the remaining sub-parts separately".Cash Flow Statement:The cash flow statement is prepared at the end of the period to know the cash position. It reflects all cash inflows and outflows and also which activities generated cash and which activities used cash. The important thing is that a business must generate cash from operating activities. The statement of cash flow can be prepared using either direct or indirect method. (1) Calculate the company's normal cash level as a percentage of sales: Particulars Amount ($ millions) Cash at beginning of period (a) 38,663Net Sales (2019 Actual) (b) 535,667Company's normal cash level as a percentage of sales (a / b)7.2%(2) Compute what should be the normal cash balance for FY2020: Particulars Amount ($ millions) Company's normal cash level as a percentage of sales (a)7.2%Estimated sales for 2020 (b) 559,772Normal cash balance for FY2020 (a x b) 40,403Step 1: Determine the deviation in percentage terms: Particulars Amount ($ millions) Normal cash balance for FY2020 (a) 40,403Forecasted cash balance for FY2020 (b) 29,688Increase in normal cash balance (c = a - b) 10,715Percentage of increase (c / a)26.52%Step 2: Determine if the deviation in part a large enough to require adjustment:Yes, the deviation is a significant percentage of the historical cash balance.The following are the three ways to adjust the forecasted cash balance:(1) Sell marketable securities. (2) Increase long-term debt by that amount, or(3) Sell some treasury stock on the open market.The firm is likely to take these actions before decreasing capital expenditures.(a) Normal cash level as a percentage of sales - 7.2%. Normal cash balance for FY2020 - $40,403(b) Yes. The deviation is large enough to require an adjustment. (c) The following are the three ways to adjust the forecasted cash balance: (1) Sell marketable securities. (2) Increase long-term debt by that amount, or (3) Sell some treasury stock on the open market. The firm is likely to take these actions before decreasing capital expenditures.

Business

Accounting

We obtain the following 2020 forecasts of selected financial statement line items for Journey Company. 2019 Actual 2020 Est. $535,667 $559,772 50,725 46,945 261,998 233,178 38,688 38,688 43,618 (11,270) (41,323) $ millions Net Sales Marketable securities Long-term debt Treasury stock (deducted from equity) Cash generated by operations Cash used for investing Cash used for financing Total net change in cash Cash at beginning of period Cash at end of period (8,975) 38,663 $29,688

We obtain the following 2020 forecasts of selected financial statement line items for Journey Company. 2019 Actual 2020 Est. $535,667 $559,772 50,725 46,945 261,998 233,178 38,688 38,688 43,618 (11,270) (41,323) $ millions Net Sales Marketable securities Long-term debt Treasury stock (deducted from equity) Cash generated by operations Cash used for investing Cash used for financing Total net change in cash Cash at beginning of period Cash at end of period (8,975) 38,663 $29,688

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

What is the Retained earnings - 2020 (restated)?
Question: The following selected data for ABC Corporation for the year ended December 31, 2020, is available to you for preparing the cash flow statement: Cost of goods sold $56,500 Sales revenue $97,300 Amortization expense 14,100 Interest revenue 4,100 Income tax expense 2,300 Dividend revenue
What is the firm's cash flow from financing?
reparing a Cash Flow Worksheet Guccii Corporation’s recent comparative balance sheet and income statement follow: Balance Sheets, December 31 2019 2020 Assets Cash and cash equivalents $63,000 $90,300 Investments, short-term 0 12,600 Accounts receivable, net 71,400 88,200 Merchandise inventory 42,000 63,000 Investments, long-term 0 42,000 Plant assets, net 252,000 247,800 Patents 12,600 11,340 Other assets 29,400 29,400 Total assets $470,400 $584,640 Liabilities and Stockholders’ Equity Accounts payable $50,400 $92,400 Accrued expenses payable 0 36,540 Bonds payable 168,000 84,000 Common stock, par $10 147,000 168,000 Additional paid-in capital 0 18,900 Retained earnings 105,000 184,800 Total liabilities and stockholders’ equity $470,400 $584,640 Income Statement,For Year Ended December 31 2020 Sales revenue $436,800 Cost of goods sold (231,000) Depreciation expense (33,600) Patent amortization (1,260) Other…
The balance sheet data of Flounder Company at the end of 2020 and 2019 are shown below. Cash Accounts receivable (net) Inventory Prepaid expenses Equipment Accumulated depreciation-equipment Land Accounts payable Accrued expenses Notes payable-bank, long-term Bonds payable Common stock, $10 par Retained earnings (a) (b) (c) Net Cash Net Cash 2020 $29,800 55,100 65,400 15,200 89,200 (17,840) 70,700 $307,560 Net Cash $65,500 15,100 -0- 30,000 188,100 8.860 $307,560 ✓by operating activities Land was acquired for $30,300 in exchange for common stock, par $30,300, during the year, all equipment purchased was for cash. Equipment costing $12.900 was sold for $3,000, book value of the equipment was $6,100 Cash dividends of $10,000 were declare and paid during the year. Compute net cash provided (used) by: (Show amounts that decrease cash flow with either a-sign eg-12.000 or in parenthesis es (12.00 V by investing activities 2019 $34,800 44,800 ✓by financing activities 45,100 25,100 74,200…
What is Declan's Designs' 2022 total "Common Stock Issuance" to be reported on its Statement of Cash Flows? Question 29 options: $6,000 $8,000 $10,000 $2,000
How would you prepare a statement of Cash Flows using the following information? Maple Group Ltd Comparative Balance Sheet December 31, 2020 and 2019 2020 2019 Increase/Decrease Assets Cash and cash Equivalent $ 51,500.00 $ 45,400.00 $ 6,100.00 Accounts Receivable $ 51,100.00 $ 61,400.00 $ 10,000.00 Inventories $ 61,400.00 $ 51,900.00 $ 9,500.00 Fixed Assets, net $ 160,000.00 $ 110,000.00 $ 50,000.00 Total Assets $ 324,000.00 $ 268,700.00 $ 55,600.00 Liabilities Accounts Payable $ 35,450.00 $ 27,800.00 $ 7,650.00 Accrued liabilities $ 31,000.00 $ 37,550.00 -$ 6,550.00 Long-term notes payable $ 60,000.00 $ 78,540.00 -$ 18,540.00 Stockholders Equity: Common Stock $ 143,050.00 $ 105,110.00 $ 37,940.00 Retained Earnings $ 54,800.00 $ 19,700.00 $…
Current Attempt in Progress Vaughn Corporation had the following activities in 2020. 1. Payment of accounts payable $774,000 Issuance of common stock $270,000 Payment of dividends $384,000 2. 3. 4. Net cash 5. 6. Compute the amount Vaughn should report as net cash provided (used) by financing activities in its 2020 statement of cash flows. (Show amounts that decrease cash flow with either a-sign e.g. -15,000 or in parenthesis e.g. (15,000).) by financing activities $ Collection of note receivable $92,000 Issuance of bonds payable $548,000 Purchase of treasury stock $43,000 LA
Return on Assets Calculate the company's return on assets for 2020 and compare the result to the industry average.
Based on GROUP's current ratio, quick ratio and debt ratio, evaluate the company’s financial stability in 2020 as compared to 2019. Provide your comment as well to support the answer.
Question: Amount of Free Cash Flows? (Round to the nearest 2 decimal places)
STATEMENT OF CASH FLOW EXAMPLE Kerby Company has prepared the following Balance Sheets for 2023 and 2022. Cash 12/31/23 $ 56 12/31/22 $ 40 Accounts receivable 41 42 Fixed assets 579 465 Accumulated depreciation (170) (140) $506 $407 Accounts payable Mortgage payable Preferred stock $ 74 $ 60 20 181 Additional Paid-In Capital - preferred 70 Common stock Retained earnings 100 61 ២៩៩៩88 100 100 $506 $407 1. On 8/1/23, Kerby sold a fixed asset with a cost of $91 and book value of $66 for $67. 2. Retained Earnings was adjusted by dividends and net income only. 3. Net Income in 2023 was $80. a. Net Cash Provided by Operations is $ b. Net Cash Used by Investments is $ c. Net Cash Provided by Financing is $