Prepare a monthly cash budget for xeriscape nurseries

Assignment Help Corporate Finance
Reference no: EM13889941

Xeriscape Nurseries, Inc., has four divisions. The corporation's controller has been asked to prepare a cash budget for the Northern Division for the first quarter. Projected data supporting this budget follow.

sales (60% on credit)                                Purchases                 November   $160,000 December               $  90,000 December      200,000           January                        98,000

January                      120,000           February                    100,000

February                    160,000           March                        104,000

March                        140,000

Collection records of accounts receivable have shown that 40 percent of all credit sales are collected in the month of sale, 50 percent in the month following the sale, and 8 percent in the second month following the sale; 2 percent of the sales are uncol- lectible. All purchases are paid for in the month of the purchase. Salaries and wages are projected to be $25,000 in January, $33,000 in February, and $21,000 in March. Esti- mated monthly costs are utilities, $4,220; collection fees, $1,700; rent, $5,300; equip- ment depreciation, $5,440; supplies, $2,480; small tools, $3,140; and miscellaneous, $1,900. Each of the corporation's divisions maintains a $10,000 minimum cash balance and can borrow from the bank in multiples of $100, as needed. As of December 31, the Southern Division had a cash balance of $10,000.

Required:

1. Prepare a monthly cash budget for Xeriscape Nurseries' Northern Division for the first quarter.

2. Should Xeriscape Nurseries anticipate taking out a loan for the Northern Division during the quarter? If so, how much should it borrow, and when?

Reference no: EM13889941

Questions Cloud

What is a sole proprietorship : What is a sole proprietorship? Why are sole proprietors held personally liable for the debts of their businesses?
20th percentile of the heights of a group of women : 20th percentile of the heights of a group of women is 60 inches and the 75th percentile is 65.8 inches. The histogram follows the normal curve. Find the 90th percentile.
Define or write information of vector and force vector : Define or write information each item- A Vector: A force Vector: Scalar quantity: The resultant: Equilibrium (Mechanical): "Concurrent" forces: "Coplaner" forces: Forces board apparatus
The owner of a small printing company is considering : The owner of a small printing company is considering the purchase of additional printing equipment to expand her business. If the owner expands the business and sales are high, projected profits (minus the cost of the equipment) should be $90,000; if..
Prepare a monthly cash budget for xeriscape nurseries : Prepare a monthly cash budget for Xeriscape Nurseries' Northern Division for the first quarter. Should Xeriscape Nurseries anticipate taking out a loan for the Northern Division during the quarter?
Describe your selected research issue : Describe your selected research issue, problem, or opportunity.Formulate a hypothesis statement concerning your selected research issue, problem, or opportunity.Determine your population, and describe which sampling method you would use to generate y..
What is the full-information contract : Suppose that your friend cannot observe the effort level of the band. Explain why the full- information contract is not incentive compatible. Why is this called moral hazard?
The fbi is studying bribes to congressment : The FBI is studying bribes to Congressmen. A random sample of 49 bribes is selected. The mean bribe in thousands of dollars is $150 and the standard deviation of the sample is $20. Construct a 95 percent confidence interval for the population mean.
Conceptualise state of environmental planning in australia : Analyse the information presented and conceptualise the state of environmental planning in Australia. Analyse the relationship between urban form, community attitudes to natural processes, resource management and policy development.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Assume you have 1 million now and you have just retired

assume you have 1 million now and you have just retired from your job. you expect to live for 20 years and you want to

  Determine the optimal capital structure

Determine the optimal capital structure, the various financing options available and the debt maturity profile of the project. Discuss the merits and limitations of each form of financing proposed.

  Prepare a cash budget for january and february

Danner Company expects to have a cash balance of $45,000 on January 1, 2014. Prepare a cash budget for January and February.

  Midland telecom provides communication services in iowa

midland telecom provides communication services in iowa nebraska the dakotas and montana. midland purchased goodwill as

  Finance you are required to submit a bid to supply

you are required to submit a bid to supply 200000000 widgets per year to the state of illinois for the next five years.

  Calculation of the total interest expense over the life of

calculation of the total interest expense over the life of the bonds.stacy company issued five-year 10 bonds with a

  Find at least two business process

Find at least two business process and check a grain from each business process

  Findings financial statements and information used in the

findings. financial statements and information used in the analysis including ratios trends and statistics and all

  1 the chief executive officer cfo of a manufacturing

1 the chief executive officer cfo of a manufacturing company that is facing a severe cash crunch has a variety of

  Implications for investment performance in general

What is capital-market efficiency? What are its implications for investment performance in general? What are the implications for fund managers if the market exhibits the characteristics of weak, semi-strong, and strong form efficiency?

  Module 5 you are required to submit a bid to supply

you are required to submit a bid to supply 200000000 widgets per year to the state of illinois for the next five years.

  Determination of source of funds for decision

determination of source of funds for decision making.mckinsee inc. is developing a plan to finance its asset base. the

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd