EBK PRINCIPLES OF MANAGERIAL FINANCE
14th Edition
ISBN: 9780100666757
Author: ZUTTER
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 1SE
a)
Summary Introduction
To calculate: Cash Budget.
Introduction:
Cash budget can be defined as a money spending plan which estimates the money inflows and outflows for a business over a particular timeframe. It is used to assess whether the firm has adequate money to work.
b)
Summary Introduction
To calculate: Changes in cash balance.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Sample Problem: Use the following data to construct a statement of cash flows using the direct and indirect
methods.
2020
2019
Cash
P4,000
P14,000
Accounts receivable
25,000
32,500
Prepaid insurance
5,000
7,000
Inventory
37,000
34,000
Fixed assets
316,000
270,000
Accumulated Depreciation
Total assets
Accounts payable
P18,000
P16,000
Wages payable
4,000
7,000
Note payable
173,000
160,000
Capital stock
88,000
84,000
Retained earnings
Total Liabilities & Equity
Sales
Cost of goods sold
(123,000)
Depreciation expense
(15,000)
Insurance expense
(11,000)
Wage Expense
Net Income
During 2020 declared and paid dividends of P2,500 During 2020, ABC paid P46,000 in cash to acquire new fixed assets. The accounts payable was used only for inventory. No debt was retired during 2020. Prepare Statement of Cash Flow using;
Direct Method
Indirect Method
Transformers, Inc. prepared cash estimates for the 3rd quarter of 2022 (3-months). The following estimates were developed for certain items:
July
August
September
Cash sales
P 60,000
P 80,000
P 150,000
Credit sales
30,000
60,000
90,000
Purchases
60,000
55,000
75,000
Payroll
40,000
50,000
60,000
Other expenses
20,000
25,000
30,000
In June, credit sales totaled P50,000 and purchases totaled P60,000. May credit sales were P70,000. Accounts receivable collections amount to 50% in the month after the sale and 40% in the second month after the sale; 10% of the receivables are never collected.
Payroll and other expenses are paid in the month incurred. Sixty percent of the purchases are paid in the month incurred and the remainder is paid in the following month. A P20,000 tax payment is due on August 30. The cash balance was P60,000 on July 1 and the company maintain a minimum cash balance of P50,000. Any deficiency in cash can be withdrawn in a multiples of P10,000 from…
a) Calculate the cash operating cycle of Stone Limited for the year ended 30 April, 2018 and 2019.
b) Based on the result of the previous year end and the industry average. Draft a report addressed to the Board of Directors of Stone Limited analysing theperformance of the company for the year 2019
Chapter 4 Solutions
EBK PRINCIPLES OF MANAGERIAL FINANCE
Ch. 4.1 - Briefly describe the first four modified...Ch. 4.1 - Describe the overall cash flow through the firm in...Ch. 4.1 - Prob. 4.3RQCh. 4.1 - 4-B Why is depreciation (as well as amortization...Ch. 4.1 - Prob. 4.5RQCh. 4.1 - Prob. 4.6RQCh. 4.1 - Prob. 4.7RQCh. 4.2 - Prob. 4.8RQCh. 4.2 - Prob. 4.9RQCh. 4.3 - Prob. 4.10RQ
Ch. 4.3 - Prob. 4.11RQCh. 4.3 - Prob. 4.12RQCh. 4.3 - What is the cause of uncertainty in the cash...Ch. 4.4 - Prob. 4.14RQCh. 4.5 - Prob. 4.15RQCh. 4.5 - Prob. 4.16RQCh. 4.6 - Prob. 4.17RQCh. 4.6 - What is the significance of the plug figure,...Ch. 4.7 - Prob. 4.19RQCh. 4.7 - Prob. 4.20RQCh. 4 - Opener-in-Review The chapter opener described a...Ch. 4 - Learning Goals 2, 3 ST4-1 Depreciation and cash...Ch. 4 - Prob. 4.2STPCh. 4 - Prob. 4.3STPCh. 4 - Prob. 4.1WUECh. 4 - Prob. 4.2WUECh. 4 - Learning Goal 3 E4-3 Determine the operating cash...Ch. 4 - Prob. 4.4WUECh. 4 - Prob. 4.5WUECh. 4 - Prob. 4.1PCh. 4 - Prob. 4.2PCh. 4 - Prob. 4.3PCh. 4 - Learning Goals 2, 3 P4-4 Depreciation and...Ch. 4 - Learning Goal 3 P4-5 Classifying inflows and...Ch. 4 - Prob. 4.6PCh. 4 - Learning Goal 4 P4-8 Cash receipts A firm has...Ch. 4 - Learning Goal 4 P4-9 Cash disbursements schedule...Ch. 4 - Learning Goal 4 P4-10 Cash budget: Basic Grenoble...Ch. 4 - Prob. 4.10PCh. 4 - Prob. 4.11PCh. 4 - Prob. 4.12PCh. 4 - Prob. 4.13PCh. 4 - Learning Goal 4 P4-15 Multiple cash budgets:...Ch. 4 - Prob. 4.15PCh. 4 - Prob. 4.16PCh. 4 - Prob. 4.17PCh. 4 - Prob. 4.18PCh. 4 - Prob. 4.19PCh. 4 - Prob. 4.20PCh. 4 - Prob. 4.21PCh. 4 - Prob. 1SE
Knowledge Booster
Similar questions
- Design a spreadsheet for the preparation of projected income statements, balance sheets, and statements of cash flows for MSC for Year 8Year 12. Also forecast the financial statements for each of these years under three scenarios: (1) best case, (2) most likely, and (3) worst case. The following sections describe the assumptions you can make.arrow_forwardFinancing Deficit Stevens Textile Corporation’s 2018 financial statements are shown here: Balance Sheet as of December 31, 2018 (Thousands of Dollars) Income Statement for December 31, 2018 (Thousands of Dollars) Suppose 2019 sales are projected to increase by 15% over 2018 sales. Use the forecasted financial statement method to forecast a balance sheet and income statement for December 31, 2019. The interest rate on all debt is 10%, and cash earns no interest income. Assume that all additional debt in the form of a line of credit is added at the end of the year, which means that you should base the forecasted interest expense on the balance of debt at the beginning of the year. Use the forecasted income statement to determine the addition to retained earnings. Assume that the company was operating at full capacity in 2018, that it cannot sell off any of its fixed assets, and that any required financing will be borrowed as notes payable. Also, assume that assets, spontaneous liabilities, and operating costs are expected to increase by the same percentage as sales. Determine the additional funds needed. What is the resulting total forecasted amount of the line of credit? In your answers to parts a and b, you should not have charged any interest on the additional debt added during 2019 because it was assumed that the new debt was added at the end of the year. But now suppose that the new debt is added throughout the year. Don’t do any calculations, but how would this change the answers to parts a and b?arrow_forwardSchedule of cash payments for service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: Depreciation, insurance, and property taxes represent 9,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. Seventy percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May.arrow_forward
- Ratio Analysis Consider the following information taken from Chicago Water Slides (CWSs) financial statements: Also, CWSs operating cash flows were $25,658 and $29,748 in 2019 and 2018, respectively. Note: Round all answers to two decimal places. Required: 1. Calculate the current ratios for 2019 and 2018. 2. Calculate the quick ratios for 2019 and 2018. 3. Calculate the cash ratios for 2019 and 2018. 4. Calculate the operating cash flow ratios for 2019 and 2018. 5. CONCEPTUAL CONNECTION Provide some reasons why CWSs liquidity may be considered to be improving and some reasons why it may be worsening.arrow_forwardLONG-TERM FINANCING NEEDED At year-end 2019, total assets for Arrington Inc. were 1.8 million and accounts payable were 450,000. Sales, which in 2019 were 3.0 million, are expected to increase by 25% in 2020. Total assets and accounts payable are proportional to sales, and that relationship will be maintained; that is, they will grow at the same rate as sales. Arrington typically uses no current liabilities other than accounts payable. Common stock amounted to 500,000 in 2019, and retained earnings were 475,000. Arrington plans to sell new common stock in the amount of 130,000. The firms profit margin on sates is 5%; 35% of earnings will be retained. a. What were Arringtons total liabilities in 2019? b. How much new long-term debt financing will be needed in 2020? (Hint: AFN - New stock = New long-term debt.)arrow_forwardPreparing a Cash Flow Worksheet Taser Corporation’s recent comparative balance sheet and income statement follow. Balance Sheets, December 31 2019 2020 Assets Cash and cash equivalents $93,600 $153,120 Accounts receivable (net) 163,200 163,200 Merchandise inventory 374,400 408,000 Investments, long-term 48,000 Plant assets 808,800 866,400 Accumulated depreciation (211,200) (163,200) Total assets $1,228,800 $1,475,520 Liabilities and Stockholders’ Equity Accounts payable $100,800 $91,200 Salaries payable 7,200 2,400 Income taxes payable 9,600 16,800 Bonds payable 480,000 480,000 Premium on bonds payable 19,200 17,760 Common stock, no-par 576,000 746,400 Retained earnings 36,000 120,960 Total liabilities andstockholders’ equity $1,228,800 $1,475,520 Income Statement,For Year Ended December 31 2020 Sales revenue $576,000 Cost of goods sold (230,400) Depreciation expense (28,800) Salaries expense (105,600) Income tax…arrow_forward
- 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…arrow_forwardCash purchases of Manila Company for 2020 were 900,000. During the year purchase returns of 150,000 were made and discounts on purchases of 200,000 were granted. The income statement for the year reported gross purchases of 5,000,000. The balance sheet reported a decrease in accounts payable of 250,000. How much cash was paid on accounts payable? P4,400,000 P3,500,000 P4,900,000 P4,000,000arrow_forwardCash purchases of Lowman Company for 2020 were 900,000. During the year purchase returns of 150,000 were made and discounts on purchases of 200,000 were granted. The income statement for the year reported gross purchases of 5,000,000. The balance sheet reported a decrease in accounts payable of 250,000. How much cash was paid on accounts payable? a. P4,400,000 c. P3,500,000 b. P4,900,000 d. P4,000,000arrow_forward
- Adjust the Cash BalanceWe obtain the following 2018 forecasts of selected financial statement line items for Journey Company. $ millions 2017 Actual 2018 Est. Net Sales $747,442 $779,327 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,918 Cash used for investing (15,130) Cash used for financing (54,438) Total net change in cash (11,650) Cash at beginning of period 51,141 Cash at end of period $39,491 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. million C. Complete the following statement of cash flows assuming long-term debt is used to adjust the forecasted cash balance. Use…arrow_forwardPrepare Common-Size financial statements for the income statement and balance sheet for 2021 and 2020 Prepare Statement of Cash Flows for 2021 Finance data of Adams Stores, Inc. for the year ending 2021 and 2020 Items 2021 2020 Sales $6,034,000 $3,432,000 Cash 7,282 57,600 Other Expenses 519,988 358,672 Retained Earnings 32,592 203,768 Long-term debt 723,432 323,432 Cost of goods sold 5,528,000 2,864,000 Depreciation 116,960 18,900 Short-term investments 0 0 Gross Fixed Assets 1,202,950 491,000 Interest Expenses 136,012 43,828 Shares outstanding 100,000 100,000 Market Price of stock 2.25 8.50 Accounts Receivable 632,160 351,200 Accounts payable 524,160 145,600 Inventory 1,287,360 715,200 Notes Payable 636,808 200,000 Accumulated Depreciation 263,160 146,200 Accruals 489,600 136,000 Tax Rate 40% 40% Stock Price $5.50 $7.25arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning