Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
15th Edition
ISBN: 9780134476315
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 4.15P
Learning Goal 4
P4-15 Multiple cash budgets: Scenario analysis Brownstein Inc expects sales of $100,000 during each of the next 3 months. It will make monthly purchases of 560,000 during this time. Wages and salaries are $10,000 per month plus 5% of sales. Brownstein expects to make a tax payment of $20,000 in the next month and a $15,000 purchase of fixed assets in the second month and to receive $8,000 in cash from the sale of an asset in the third month. All sales and purchases are for cash. Beginning cash and the minimum cash balance are assumed to be zero.
- a. Construct a cash budget for the next 3 months.
- b. Brownstein is unsure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is $80,000 per month and the most optimistic is $120,000 per month, what are the monthly minimum and maximum ending cash balances that the firm can expect for each of the 1-month periods?
- c. Briefly discuss how the
financial manager can use the data in parts a and b to plan for financing needs.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Multiple cash budgets-Scenario analysis Brownstein, Inc., expects sales of $96,000 during each of the next 3 months. It will make monthly purchases of $58,000
during this time. Wages and salaries are $12,000 per month plus 6% of sales. Brownstein expects to make a tax payment of $17,000 in the next month and a $20,000
purchase of fixed assets in the second month and to receive $8,000 in cash from the sale of an asset in the third month. All sales and purchases are for cash. Beginning
cash and the minimum cash balance are assumed to be zero.
a. Construct a cash budget for the next 3 months.
b. Brownstein is unsure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is $77,000 per month and the most optimistic is $124,000
per month, what are the monthly minimum and maximum ending cash balances that the firm can expect for each of the 1-month periods?
c. Briefly discuss how the financial manager can use the data in parts a. and b. to plan for…
Dev
problem p4-12
(Principles of Managerial Finance Zutter Smart 15th Edition)
Chapter 4 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in 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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- A company has the following budgeted sales in each quarter of the year 2024: Expected Sales Q1 Q2 Q3 Q4 Cash collection information is as follows: $240,000 $280,000 $300,000 $420,000 1. Of all sales, 70% are on credit REMBRA 2. 60% of credit sales are collected in the quarter in which the sale is made; 30% are collected in the following quarter, and 10% are collected in the second quarter after the sale. 3. Accounts Receivable is estimated to be $63,000 on December 31,2023. The company expects to collect all outstanding receivabl in the first quarter of 2024. Q. What is the total cash collection for the second quarter of 2024? Answer. (Click to select) (Click to select) None of the answers are correct $231,000 $168,000 $252,000 $315,000arrow_forwardCapital Budgeting 1. Knight Company has found that 30% of its sales are collected in the month of the sale and the remainder of the sales are collected in the next month. If sales are expected to be $100,000 in April, $120,000 in May, and $80,000 in June, what is the estimated amount of cash receipts for May?A. $114,000B. $106,000C. $92,000D. $108,000 2. In recent years, Princess Company has collected 20% of its sales in the month of the sale and the other 80% in the following month. During the first three months of 2002, Princess is anticipating sales of $350,000; $403,000; and $389,000, respectively. What is the amount of cash receipts budgeted for March?A. $301,200B. $360,600C. $400,200D. $391,800arrow_forwardProblem 1: ABC Corporation is preparing its sales and receivable budget for the year 2022. Details are as follows: • The sales during the 4" quarter of 2021 is 30,000 units and the selling price per unit is Ps00 per unit. Units to be sold is forecasted to increase by 5% per quarter while the sales price for 2022 will be 2% higher than the previous PS00 per unit. • Of the sales per quarter, S5% are cash sales while the remaining credit sales. The credit sales are expected to be settled as follows: 5/9 will be collected during month of sales, 3/9 will be collected the month after month of sales, and the remaining will be written off two months after month of sale. The forecasted receivable balance on Jan. 1, 2022 is P3,500,000, 90% of which is expected to be collected during the first quarter while the remaining will be written off during the second quarter of 2022. Required: 1" Quarter 2nd Quarter 3 Quarter 4th Quarter Sales 1. 2. 3. 4. Receivable balance as of the end of 5. 6. 7. 8.…arrow_forward
- develop a dynamic 12-month cash flow budgeting/forecasting tool. Initial sales of $1,000,000 with forecasted monthly growth 2% 20% of sales are collected in month of sale. 40% of sales are collected the following month. 25% collected 2 months later 18% collected 3 months later 2% never collected Initial cash balance of $300,000arrow_forwardQUESTION 1You are required to prepare a cash budget for the third quarter of 2020 for STS Corporation.Month Total sales(RM)March 170,000April 100,000May 140,000June 180,000July 200,000AugustSeptemberOctober220,000195,000180,000i) The company makes 10 percent cash sales, and the balance are collected as follows; 60percent is collected one month after sales, 30 percent is collected two months after sales,and 10 percent is collected three months after sales.ii) Purchase of raw materials is 50 percent of sales and are made one month prior to sales.Payment are made equally in the two months after the purchases.iii) Wages and salaries amounting to 10 percent of the last month’s sales. The company fixedmonthly expenses are RM3,000 for rent, RM2,000 for utilities, RM10,000 for depreciation,and RM1,500 for insurance.iv) A quarterly dividend of RM50,000 will be paid at the end of each quarter.v) The company plans to pay RM70,500 in cash for a new machinery installed in August.vi) Ending cash…arrow_forwardCapital Budgeting Methods Project S has a cost of $11,000 and is expected to produce benefits (cash flows) of $3,400 per year for 5 years. Project L costs $23,000 and is expected to produce cash flows of $6,900 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 14%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $ Project L: $ Which project would be selected, assuming they are mutually exclusive? Based on the NPV values, Project S/Project L would be selected. Calculate the two projects' IRRs. Do not round intermediate calculations. Round your answers to two decimal places. Project S: % Project L: % Which project would be selected, assuming they are mutually exclusive? Based on the IRR values, Project S/Project L would be selected. Calculate the two projects' MIRRs, assuming a cost of capital of 14%. Do not round intermediate calculations. Round your answers to two decimal places. Project S: %…arrow_forward
- Capital budgeting 21. An investment of $894,168 promises to return $180,000 each year for the next eight years. If taxes are ignored, what is the internal rate of return?A. less than 9%B. 10%C. 12%D. more than 14% 22. An investment is expected to generate returns of $60,000 per year for each of the next six years. If the initial amount invested is $240,000 and taxes are ignored, which of the following is closest to the internal rate of return?A. 15%B. 13%C. 10%D. 7%arrow_forwardCapital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $ Project L: $ Which project would be selected, assuming they are mutually exclusive? Calculate the two projects' IRRs. Do not round intermediate calculations. Round your answers to two decimal places. Project S: % Project L: % Which project would be selected, assuming they are mutually exclusive? Calculate the two projects' MIRRs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to two decimal places. Project S: % Project L: % Calculate the two projects' PIs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your…arrow_forwardCapital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $ Project L: $ Which project would be selected, assuming they are mutually exclusive? Based on the NPV values, would be selected. Calculate the two projects' IRRs. Do not round intermediate calculations. Round your answers to two decimal places. Project S: % Project L: % Which project would be selected, assuming they are mutually exclusive? Based on the IRR values, would be selected. Calculate the two projects' MIRRs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to two decimal places. Project S: % Project L: % Which project would be…arrow_forward
- Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $ Project L: $ Which project would be selected, assuming they are mutually exclusive? Based on the NPV values, would be selected. Calculate the two projects' IRRs. Do not round intermediate calculations. Round your answers to two decimal places. Project S: % Project L: % Which project would be selected, assuming they are mutually exclusive? Based on the IRR values, would be selected. Calculate the two projects' MIRRs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to two decimal places. Project S: % Project L: % Which project would be…arrow_forwardCAPITAL BUDGETING 3. How much will you need to invest today at 10% to have $10,000 six years from today?A. $7,050B. $17,715C. $5,645D. $5,584 4. Calculate the present value of $216,000 to be received in seven years if the discountrate is 16%.A. $73,159B. $61,051C. $241,920D. $76,421 5. Use an interest rate of 14% to calculate the present value of $829,000 which will bereceived in 15 years.A. $116,143B. $60,601C. $773,733D. $552,667arrow_forwardProblem 1: ABC Corporation is preparing its sales and receivable budget for the year 2022. Details are as follows: • The sales during the 4th quarter of 2021 is 30,000 units and the selling price per unit is PS00 per unit. Units to be sold is forecasted to increase by 5% per quarter while the sales price for 2022 will be 2% higher than the previous PS00 per unit. Of the sales per quarter, 55% are cash sales while the remaining credit sales. The credit sales are expected to be settled as follows: 5/9 will be collected during month of sales, 3/9 will be collected the month after month of sales, and the remaining will be written off two months after month of sale. The forecasted receivable balance on Jan. 1, 2022 is P3,500,000, 90% of which is expected to be collected during the first quarter while the remaining will be written off during the second quarter of 2022. Required: 2d Quarter 3d Quarter 4 Quarter 1 Quarter 1. Sales 2. 3. 4. Receivable balance as of the end of 5. 6. 7. 8. Cash…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY