The XYZ Company is planning to request a line of credit from its bank. The following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The XYZ Company is planning to request a line of credit from its bank. The following sale forecasts have been made for 2024 and 2025: May 2024 June July August September October. November $1,000,000 1,000,000 1,500,000 2250,000 3,000,000 1,500,000 1.500.000 December January 2025 375,000 750,000 Collection estimates were obtained from the credit and collection department as follows: collected within the month of sale, 5%; collected the month following the sale, 80%; collected the second month following the sale, 15%. Payments for labour and raw materials are typically made during the month following the month in which these costs are incurred. Total labour and raw materials costs are estimated for each month as follows: May 2024 June July August September October November $ 500,000 500,000 525,000 3,675,000 1,275,000 975,000 675,000 December 375,000 General and administrative salaries amount to approximately $112,500 a month; lease payments under long-term contracts are $37,500 a month; depreciation charges are $150,000 a month; miscellaneous expenses are $11,500 a month; income tax payments of $262,500 are due in both August and November; and a progress payment of $750,000 on a new research laboratory must be paid in September. Cash on hand on 1 July will amount to $550,000, and a minimum cash balance of $375,000 should be maintained throughout the cash budget period. (a) (b) (c) Prepare a monthly cash budget for the last six months of 2024. For each month during the same period, determine the required financing (or excess funds) -- that is, the amount of money that the Wilson Company must borrow (or have available to invest) each month. Suppose you show a surplus of $538,500 at the end of July. Suggest some alternative investments for this money. Be sure to consider long-term bonds versus short-term debt instruments and the appropriateness of investing in common shares. (d) 3 Would your choice of securities in part (c) be affected if the cash budget showed continuous cash surpluses versus alternating surpluses and deficits? The XYZ Company is planning to request a line of credit from its bank. The following sale forecasts have been made for 2024 and 2025: May 2024 June July August September October. November $1,000,000 1,000,000 1,500,000 2250,000 3,000,000 1,500,000 1.500.000 December January 2025 375,000 750,000 Collection estimates were obtained from the credit and collection department as follows: collected within the month of sale, 5%; collected the month following the sale, 80%; collected the second month following the sale, 15%. Payments for labour and raw materials are typically made during the month following the month in which these costs are incurred. Total labour and raw materials costs are estimated for each month as follows: May 2024 June July August September October November $ 500,000 500,000 525,000 3,675,000 1,275,000 975,000 675,000 December 375,000 General and administrative salaries amount to approximately $112,500 a month; lease payments under long-term contracts are $37,500 a month; depreciation charges are $150,000 a month; miscellaneous expenses are $11,500 a month; income tax payments of $262,500 are due in both August and November; and a progress payment of $750,000 on a new research laboratory must be paid in September. Cash on hand on 1 July will amount to $550,000, and a minimum cash balance of $375,000 should be maintained throughout the cash budget period. (a) (b) (c) Prepare a monthly cash budget for the last six months of 2024. For each month during the same period, determine the required financing (or excess funds) -- that is, the amount of money that the Wilson Company must borrow (or have available to invest) each month. Suppose you show a surplus of $538,500 at the end of July. Suggest some alternative investments for this money. Be sure to consider long-term bonds versus short-term debt instruments and the appropriateness of investing in common shares. (d) 3 Would your choice of securities in part (c) be affected if the cash budget showed continuous cash surpluses versus alternating surpluses and deficits?
Expert Answer:
Answer rating: 100% (QA)
XYZ Company Cash Budget for July December 2024 July Item Amount Cash receipts from sales May sales 50000 June sales 1200000 Total cash receipts 125000... View the full answer
Related Book For
Fundamentals Of Financial Management
ISBN: 9780357517574
16th Edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these accounting questions
-
Question 30 of 58. Grace is a 67-year-old widow. Her net income on Line 23600 is $45,000, of which $20,000 is a prior work pension. How much age amount can she claim on Line 30100 in Step 5 Part B?...
-
Start with the partial model in the file Ch16 P18 Build a Model.xls on the textbook's Web site.Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank....
-
The ZYX Corporation is planning to request a line of credit from its bank and wants to estimate its cash needs for the month of September. The following sales forecasts have been made for 2014: July...
-
Give parametric equations and parameter intervals for the motion of a particle in the xy-plane. Identify the particles path by finding a Cartesian equation for it. Graph the Cartesian equation....
-
Harley Krane purchased a side-by-side duplex in 20X0 for $120,000 (land $20,000, building $100,000). The units were designed and previously used for residential use but Krane used them for his...
-
The diagram on the right depicts the revenues and costs of a firm producing vodka. a. What will the firm's profit be if it decides to produce 20 units of output? 120 units? b. Suppose the firm is...
-
The management control systems framework has been criticized on the grounds that all managerial activity (e.g., planning, decision making, intelligence gathering) is seen as control activity. To what...
-
Restate the following question component of the issue in a persuasive manner. A. "should the evidence be suppressed when . . . ?" In the case, the police failed to obtain a search warrant prior to...
-
Create a spreadsheet model for the following scenario. Put all input values and constants in labeled cells. Formulas should use cell references to those cells rather than typing a constant into the...
-
Conduct triple bottom line assessment of allowing the use of e-scooters in Melbourne, Yarra and Port Phillip initially. Will you recommend its implementation in the whole of Victoria? Provide a...
-
Insert an element at kth position from the end of linked list. Return true if success and if list is not long enough, then return -1. Take a pointer of head and then advance it by K steps forward,...
-
Organizational ethics describes the ethics of an organization and how it responds to internal or external circumstances affecting the organizations mission. The SarbanesOxley Act of 2002 was enacted...
-
Intentional wrongdoing involves a willful act that violates another persons interests. Not only must the action be intentional, but the perpetrator must realize that the action will result in harm....
-
State the null and alternative hypotheses. Two cyclists are comparing the variances of their overall paces going uphill. Each cyclist records his or her speeds going up 35 hills. The first cyclist...
-
The contents of inpatient medical records provide evidence of a patients care from admission to discharge (e.g., admission record, authorization for treatment forms, advance directives, history and...
-
Sage 50/Simply Accounting - General Ledger Setup Exercise Use the following information to setup a GL in Sage 50. Specific Requirements 1. Create a folder called "CDS GLSetup" in your flash drive to...
-
Explain the term global capital markets. This chapter primarily discusses global equity markets. What other types of financial instruments are traded in these markets? How important are global...
-
Core Petroleum started its oil and gas exploration and production business in 2015. During the years 2015 and 2016, the company provided the following information relating to leases located both in...
-
The Clarence Oil Company provides the following information for the year ended December 31, 2017: REQUIRED: a. Prepare a ceiling test and an entry, if necessary, for the write-off of capitalized...
-
The Jumper Oil Corporation incurs unproved property (Lease A) costs of $60,000 on April 1, 2015. An 8% loan is obtained on April 1, 2015 for $500,000 to finance a drilling program. Jumper started a...
Study smarter with the SolutionInn App