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

  Prepare a country risk analysis

Prepare a country risk analysis to evaluate if senior management at MNC should support the proposal for the company to enter the market in India with a major presence.

  Find the goals and objectives for the company

If someone believes they can easily double the value of a business within two years, but the financial forecast shown in business plan show business can not create enough cash to increase the growth.

  Nbspthe price in the market to day fairly reasonable to buy

nbspthe price in the market to day fairly reasonable to buy using capmnbspcapm capital asset pricing model and expected

  Question 1 when pricing bonds if a bonds coupon rate is

question 1. when pricing bonds if a bonds coupon rate is less than the required rate of return thena. the bond sells at

  Find what is the irr of the investment

Evaluate what is the NPV of the investment when the cost of capital is 5% and what is the IRR of the investment?

  Explain the difference between the two methods

Explain the difference between the two methods and which method is required by the Australian Accounting standards?

  Prepare a monthly cash budget for capers inc

Prepare a monthly cash budget for Capers Inc. covering the first 7 months of 2010 - Borrowing to meet estimated monthly cash needs takes place at the beginning of the month

  How can a firm measure the post-acquisition performance

While comparables provide a useful starting point, whether this acquisition is a successful investment for KKP depends on Ideko's post-acquisition performance." What does this statement mean?

  What is the name and business of each company

What is the name and business of each company? What is the outstanding number of shares for each company? Make a presentable excel sheet to list monthly share prices for last 3 Years for both companies.

  Evaluate the payback period and npv

You are considering a project that will require an initial outlay of $54,200 - Evaluate the payback period, NPV, PI, and IRR.

  Market value debt i would like to do disney if possible the

i would like to do disney if possible. the assignment is on the market value of debt for an sampp 500 company.

  Sources of revenue received by hospitals

Determine the sources of revenue received by hospitals and what sources are the most stable? What are some of the major public and private revenue sources?

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