Principles of Managerial Finance (14th Edition) (Pearson Series in Finance)
14th Edition
ISBN: 9780133507690
Author: Lawrence J. Gitman, Chad J. Zutter
Publisher: PEARSON
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
You are provided with the following information taken from Sage Hill Inc's March 31, 2027, balance sheet.
Cash
Accounts receivable
Inventory
Property, plant, and equipment, net of depreciation
Accounts payable
Common stock
Retained earnings
1
2
3.
5.
6.
7.
Additional information concerning Sage Hill Inc. is as follows.
Gross profit is 24% of sales.
Actual and budgeted sales data:
March (actual)
April (budgeted)
March
April
$18.840
$47.100
$62460
$12,280
72.700
23.120
37,100
123,400
22,910
Sales are both cash and credit, Cash collections expected in April are:
152.900
12.320
(40% of $47.100)
(60% of $72,700)
Half of a month's purchases are paid for in the month of purchase and half in the following month Cash disbursements expecte
Purchases March
Purchases April
$22,910
28,910
$51820
Cash operating costs are anticipated to be $12,110 for the month of April.
Equipment costing $2,530 will be purchased for cash in April.
The company wishes to maintain a minimum cash balance of $12,240. An…
A company has the following items for the fiscal year 2020:
Cash = 2 million
Marketable securities = 3 million
Account receivables (A/R) = 1.5 million
Inventories = 8.5 million
Total current liabilities = 8 million
Calculate the company’s current ratio and quick ratio
A firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions.
NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios.
You may use the tables below
BALANCE SHEET
2021
Cash and cash equivalents
280
Receivables
2588
Inventory
2516
Other
189
TOTAL CA
5573
Fixed assets
5024
TOTAL ASSETS
10597
Accounts payable
4713
Short term debt
78
TOTAL CL
4790
LT debt
921
Shareh. Equity
4886
TOTAL LIAB. AND SHARH. EQUITY
10597
INCOME STATEMENT
2021
Sales
19418
COGS
13136
Depreciation
354
SG&A
4952
EBIT
976
Interest Expenses
52
Tax
268
Net income
656
Decompose the return on equity for the FY 2021…
Chapter 4 Solutions
Principles of Managerial Finance (14th Edition) (Pearson Series in 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
- Suppose these selected condensed data are taken from recent balance sheets of Tyson Farms (in thousands). Compute the current ratio for each year and comment on your results. 2020 2019 Cash $13,606 $7,669 Accounts receivable 23,045 19,951 Inventory 31,087 31,345 Other current assets 12,522 11,909 Total current assets $80,000 $70,874 Total current liabilities $245,805 $326,203 Current ratio:arrow_forwardA firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. You may use the tables below BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Determine the NLF, NSF and the liquidity ratio…arrow_forwardProblem Solving. Raymar Alison Trading has the following transactions during the fiscal year 2021. Cash sales 100,0000. Credit Sales 200,000. Total Sales 300,000. Cost of Goods Sold 150,000. Gross Margin 150,000. Beg. Accounts Receivable 25,000. End. Accounts Receivable 15,000. Beg. Inventory 35,000. End. Inventory 25,000. Total Expenses 50,000. 30. What is Return on Income? 16.67% 33.33% 50.00% 66.67%arrow_forward
- Caspian is a manufacturer of water filters. Its management has projected values for the following account balances for the period ending on June 30, 2022 including a projected net profit of $10. Required: Prepare a classified Balance Sheet for Caspian as at June 30, 2022. Account titles Projected balance ($) Account titles Projected balance ($) Accum. Dep. – Equipment 13,500 Inventory 5,200 Bank Loan (due in 5 years) 17,100 Equipment 49,800 GST Collected 7,900 Bank overdraft 3,560 Bank Loan (due in 5 months) 2,900 GST Paid 4,700 Share Capital 40,300 PAYG Withheld 6,530 Distributions to owners 16,000 Prepaid Rent 7,100 Accounts Payable 24,000 Accounts Receivable 29,700 Prepaid Insurance 6,500 Wages Payable 3,200 Classified Balance Sheet for Caspian as at June 30, 2022 Assets ($) ($) Liabilities + OE ($) ($)…arrow_forwardA firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Determine the managerial balance sheet for the FY 2021.arrow_forwardYou are considering two possible companies for investment purposes. The following data is available for each company. Company A Net credit sales, Dec. 31, 2019 $540,000 Net Accounts receivable, Dec 31, 2018 $120,000 Net accounts receivable, Dec 31, 2019 $180,000 Number of days sales in receivables ratio, 2018 103 days Net Income, Dec. 31, 2018 $250,000 Company B Net credit sales, Dec. 31, 2019 $620,000 Net Accounts receivable, Dec 31, 2018 $145,000 Net accounts receivable, Dec 31, 2019 $175,000 Number of days sales in receivables ratio, 2018 110 days Net Income, Dec. 31, 2018 $350,000 Additional Information: Company A: Bad debt estimation percentage using the income statement method is 6%, and the balance sheet…arrow_forward
- 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_forwardAssume that it is now July of Year 1 and that the brothers are developing projected financial statements for the following year. Further, assume that sales and collections in the first half-year matched the predicted levels. Use the Year-2 sales forecasts shown in the following table to estimate next year’s receivables levels for the end of March and for the end of June.arrow_forwardUsing the following select financial statement information from Mover Supply Depot, compute the number of days sales in receivables ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Mover Supply Depot if the competition collects in approximately 65 days?arrow_forward
- Problem Solving. Raymar Alison Trading has the following transactions during the fiscal year 2021. Cash sales 100,0000. Credit Sales 200,000. Total Sales 300,000. Cost of Goods Sold 150,000. Gross Margin 150,000. Beg. Accounts Receivable 25,000. End. Accounts Receivable 15,000. Beg. Inventory 35,000. End. Inventory 25,000. Total Expenses 50,000. For question no. 26, what is the AR Turnover? * 5 10 15 20arrow_forwardDon Williams received a memo requesting that he complete a trend analysis of the following numbers using 2018 as the base year. 2019 $420,000 340,000 40,000 Sales Gross profit Net income 2021 $340,000 180,000 70,000 Sales Gross profit Net income Could you help Don with the request? (Round your answers to the nearest whole percent.) 2021 2020 $400,000 240,000 90,000 % % % 2020 % % % 2019 2018 $500,000 400,000 50,000 % % % 2018 Check my work 100 % 100 % 100 %arrow_forwardLiquidity management Bauman Company's total current assets, total current liabilities, and inventory for each of the past 4 years follow Item 2019 2020 2021 Total current assets $17,440 $21,630 $22,920 Total current liabilities 12,890 9,090 5.270 Inventory 6,560 Hem a. Calculate the firm's current and quick ratios for each year. Compare the resulting time series for these measures of liquidity b. Comment on the firm's liquidity over the 2019-2022 period c. If you were told that Bauman Company's inventory turnover for each year in the 2019-2022 penod and the industry averages were as follows, would this information support or conflict with your evaluation in part (b)? Why? 2019 2020 12,630 7,230 a. Calculate the firm's current and quick ratios for each year. 2022 $26,480 16,920 7,510 2021 2022 LLLarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College