Cash budget-Advanced The actual sales and purchases for Xenocore, Inc., for September and October 2019, along...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6655111e0e9b4_9746655111e096d1.jpg)
Transcribed Image Text:
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 April 2020, follow. The firm makes 18% of all sales for cash and collects on 41% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $14,000 in September and April, $15,000 in January and March, and $25,000 in February. The firm pays cash for 9% of its purchases. It pays for 55% of its purchases in the following month and for 38% of its purchases 2 months later. Wages and salaries amount to 21% of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $9,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 $75,000 are due in April. The firm also intends to make a $24,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. b. Assuming that the firm wishes to maintain a $13,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. 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. a. Assuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. Complete the November cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Sept Xenocore, Inc. Oct Nov Forecast sales S 208,000 $ 245,000 $ S 173,000 Cash sales Collections Lag 1 month Lag 2 month Other cash receipts S S Total cash receipts S Forecast Purchases S 125,000 $ 152,000 $ 137,000 Cash purchases S Payments Lag 1 month S Lag 2 month S Salaries and wages $ Rent $ Interest payments $ Principal payments $ Dividends $ Taxes $ Purchases of fixed assets $ Total each diebuscamente 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 April 2020, follow. The firm makes 18% of all sales for cash and collects on 41% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $14,000 in September and April, $15,000 in January and March, and $25,000 in February. The firm pays cash for 9% of its purchases. It pays for 55% of its purchases in the following month and for 38% of its purchases 2 months later. Wages and salaries amount to 21% of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $9,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 $75,000 are due in April. The firm also intends to make a $24,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. b. Assuming that the firm wishes to maintain a $13,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. 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. a. Assuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. Complete the November cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Sept Xenocore, Inc. Oct Nov Forecast sales S 208,000 $ 245,000 $ S 173,000 Cash sales Collections Lag 1 month Lag 2 month Other cash receipts S S Total cash receipts S Forecast Purchases S 125,000 $ 152,000 $ 137,000 Cash purchases S Payments Lag 1 month S Lag 2 month S Salaries and wages $ Rent $ Interest payments $ Principal payments $ Dividends $ Taxes $ Purchases of fixed assets $ Total each diebuscamente
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
On March 1, 2008, Peluso Hotels had retained earnings of $690,000. During the year, Peluso had the following selected transactions: 1. Declared cash dividends $155,000. 2. Corrected understatement of...
-
Inventory Costing Methods - Perpetual Method Using the data below, assume that Portet Corporation uses the perpetual inventory system. Calculate the value of ending inventory and cost of goods sold...
-
Journalize entries for employee fringe benefits, including vacation pay and pensions. AppendixLO1
-
Determining and interpreting fixed cost variances Sloan Company established a predetermined fixed overhead cost rate of $29 per unit of product. The company planned to make 7,000 units of product but...
-
Part 1 Natural pulp Ltd, a manufacturer of paper and paper board had a flood that destroyed the company's work in process and finished goods inventories on 1 July, 2014. All raw materials escaped...
-
Problem 8 At t=0, A and B are 400 m from each other on a straight line and they start to move toward each other. Suppose at t = 0, A starts from rest and moves toward B with constant acceleration of...
-
Prove that Eq. (19.34) gives the simplest multi-gluon and gluon-quark states that contain an \(\mathrm{SU}(3)\) color singlet in the decomposition. Data from Eq. 19.34 (GG)1: (88)1 (Gqq) : [8 (383)8]...
-
In question 70, what is the probability that of the 100 cars test-driven, more than 35 cars get more than 45 miles per gallon? How many of the 100 cars tested would you expect to get more than 45...
-
Construct the braid group products (a) (b) using the algorithm of Fig. 29.16 . Data from Fig. 29.16
-
Worksheet The adjusted trial balance columns of a worksheet for Bond Corporation are shown below. The worksheet is prepared for the year ended December 31. Complete the worksheet by (a) entering the...
-
The Healthy Catering Service had the following transactions in July, its first month of operations: 1 Kelly Foster contributed \(\$ 18,000\) of personal funds to the business in exchange for common...
-
Which of the following sets of factors BEST describes what a t-shirt company would need to do to restructure their business and minimize the amount of competition? Group of answer choices Location...
-
6. From an employer perspective, how are ISOs treated differently from NQOs for tax purposes? In general, for a given number of options, which type of stock option should employers prefer?
-
5. From an employee perspective, how are ISOs treated differently from NQOs for tax purposes? In general, for a given number of options, which type of stock option should employees prefer?
-
11. Matt just started work with Boom Zoom Inc., a manufacturer of credit-card-sized devices for storing and playing back music. Due to the popularity of its devices, analysts expect Boom Zooms stock...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App