bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 4, Problem 4.12P

Learning Goal 4

P4-12 Cash budget: Advanced The actual sales and purchases for Xenocore Inc. for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April2020, follow. The firm makes 20% of all sales for cash and collects on 40% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $12,000 in September and April, $15,000 in January and March, and $27,000 in February. The firm pays cash for 10% of its purchases. It pays for 50% of its purchases in the following month and for 40% of its purchases 2 months later.

Chapter 4, Problem 4.12P, Learning Goal 4 P4-12 Cash budget: Advanced The actual sales and purchases for Xenocore Inc. for , example  1

Chapter 4, Problem 4.12P, Learning Goal 4 P4-12 Cash budget: Advanced The actual sales and purchases for Xenocore Inc. for , example  2

Wages and salaries amount to 20% of the preceding month’s sales. Rent of $20,000 per month must be paid. Interest payments of $10,000 are due in January and April. A principal payment of $30,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $80,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December.

  1. a. Assuming that the firm has a cash balance of $22,000 at the beginning of November, determine the end-of- month cash balances for each month, November through April.
  2. b. Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April.
  3. c. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer.
Blurred answer
Students have asked these similar questions
Mary decides to buy a Treasury note futures contract for delivery of $100,000 face amount in September, at a price of 120′24.0. At the same time, Eric decides to sell a Treasury note futures contract if he can get a price of 120′24.0 or higher. The exchange, in turn, agrees to sell one Treasury note contract to Mary at 120′24.0 and to buy one contract from Eric at 120′24.0. The price of the Treasury note decreases to 120′10.5. Calculate Eric's balance on margin account.  Assume that initial margin is $1,890.         Please note that loss should be entered with minus sign.   Round the answer to two decimal places.
Don't used hand raiting and don't used Ai solution
(2x76m A = + S) Waterfront Inc. wishes to borrow on a short-term basis without reducing its current ratio below 1.25. At present its current assets and current liabilities are $1,600 and $1,000 respectively. How much can Waterfront Inc. borrow?

Chapter 4 Solutions

Principles of Managerial Finance, Student Value Edition Plus MyLab Finance with Pearson eText - Access Card Package (15th Edition) (Pearson Series in Finance)

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
Background pattern image
Finance
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Entrepreneurial Finance
Finance
ISBN:9781337635653
Author:Leach
Publisher:Cengage
Text book image
Quickbooks Online Accounting
Accounting
ISBN:9780357391693
Author:Owen
Publisher:Cengage
Text book image
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Text book image
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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