MyLab Finance with Pearson eText -- Access Card -- for Principles of Managerial Finance
15th Edition
ISBN: 9780134479903
Author: Chad J. Zutter, Scott B. Smart
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…
From the following data, Forecast the cash position at the end
October, November and December 2020
Month
Sales(RO)
Purchases (RO)
Salaries
Miscellancot
August
60,000
42,000
5,000
3,500
September
65,000
50,000
6,000
4,000
October
40,000
52,000
4,000
3,000
November
58,000
53,000
5,000
6,000
December
44,000
40,000
4,000
3,000
Additional Information
1. Sales: 10% realized in the month of sales, balance realised equally in two
subsequent months.
2. Purchases are paid in the month following the month of supply.
3. 10% of the wages are paid in the following month.
4. Miscellaneous expenses paid a month in arrears.
5. Rent of RO 500 per month paid quarterly in advance due in October.
6. First Instalment of Income Tax of RO 15,000 due on or before 15 December.
7. Income from Investment RO 3,000 received quarterly in October 2020 and Janu:
2021.
8. Cash in hand RO 3,000 on 1" October 2020.
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
Chapter 4 Solutions
MyLab Finance with Pearson eText -- Access Card -- for Principles of Managerial Finance
Ch. 4.1 - Prob. 4.1RQCh. 4.1 - Prob. 4.2RQCh. 4.2 - Briefly describe the first four modified...Ch. 4.2 - Describe the overall cash flow through the firm in...Ch. 4.2 - Prob. 4.5RQCh. 4.2 - 4-B Why is depreciation (as well as amortization...Ch. 4.2 - 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 - Learning Goal 5 E4-5 Rimier Corp. forecasts sales...Ch. 4 - Prob. 4.1PCh. 4 - Learning Goal 2 P4-2 Depreciation In early 2019,...Ch. 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.11PCh. 4 - Learning Goal 4 P4-12 Cash budget: Advanced The...Ch. 4 - Prob. 4.13PCh. 4 - Prob. 4.14PCh. 4 - Learning Goal 4 P4-15 Multiple cash budgets:...Ch. 4 - Learning Goal 5 P4-16 Pro forma income statement...Ch. 4 - Learning Goal 5 P4-17 Pro forma income statement:...Ch. 4 - Learning Goal 5 P4-18 Pro forma balance sheet:...Ch. 4 - Learning Goal 5 P4-19 Pro forma balance sheet...Ch. 4 - Learning Goal 5 P4-20 Integrative: Pro forma...Ch. 4 - Learning Goal 5 P4-21 Integrative: Pro forma...Ch. 4 - Prob. 4.22PCh. 4 - Prob. 1SE
Knowledge Booster
Similar questions
- Here is a forecast of sales by National Bromide for the first four months of 2019 (figures in $ thousands): Month 1 Month 2 Month 3 Month 4 Cash sales 17 26 20 16 Sales on credit 120 140 110 90 On the average 52% of credit sales are paid for in the current month, 32% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? (Do not round intermediate calculations. Enter your answers in thousands rounded to the nearest whole number.)arrow_forwardWhat would a cash flow forecast for Viggio for the next six months look like? Please create a forecast based on the following estimates belowarrow_forwardWhat is the total gross sales for November 2020?arrow_forward
- I need help with last problem " return on Equilty" I need rounding it.arrow_forwardCCC practice exercise: The COGS of a company is 600,000. Opening inventory is 15,000 and the closing inventory is 85,000. Particular 2018 Annual Credit Sales 500,000 Annual credit purchases 300,000 Creditors in the beginning 65000 Creditors at the end 45000 Debtors in the beginning 80,000 Debtors at the end 100,000 You are requested to calculate the cash conversion cyclearrow_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_forwardHere is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Cash sales Sales on credit 16 110 25 130 Month 3 Month 4 19 100 15 80 On average, 51% of credit sales are paid for in the current month, 31% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place. Items Month 3 Month 4 Expected Cash Inflow from Operations (in $ thousands)arrow_forward
- The following information relates to Jhon Co.’s accounts receivable for 2020:Accounts receivable, 1/1/20 650,000Credit sales for 2020 2,700,000Sales returns for 2020 75,000Accounts written off during 2020 40,000Collections from customers during 2020 2,150,000Estimated future sales returns at 12/31/20 50,000Estimated uncollectible accounts at 12/31/20 110,000 What amount should Jay report for accounts receivable, before allowances for sales returns and uncollectible accounts, at December 31, 2020? __________arrow_forwardHere is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands). Month 1 Month 2 25 34 200 220 Month 3 28 Month 4 24 190 170 Cash sales Sales on credit On average, 45% of credit sales are paid for in the current month, 25% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in whole dollars and not in thousands rounded to the nearest whole number. Answer is complete but not entirely correct. Expected Cash Inflow from Operations (in S thousands) Items Month 3 Month 4 $ 391 360arrow_forwardHow can this be worked out ?arrow_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