Prepare a monthly cash budget for citizens produce co-op

Assignment Help Corporate Finance
Reference no: EM13889922

Citizens Produce Co-op is one of the biggest produce operations in northern Texas. Credit sales to retailers in the area constitute 80 percent of Citizens Produce's business; cash sales to customers at the company's retail outlet make up the other 20 percent. Collection records indicate that Citizens Produce collects payment on 50 per- cent of all credit sales during the month of sale, 30 percent in the month after the sale, and 20 percent in the second month after the sale.

The company's total sales in May were $60,000; in June, they were $70,000. Antic- ipated sales in July are $75,000; in August, $80,000; and in September, $90,000. The company's produce purchases are expected to total $45,000 in July, $51,000 in August, and $60,000 in September. The company pays for all purchases in cash.

Projected monthly costs for the quarter include $1,000 for heat, light, and power; $400 for bank fees; $2,000 for rent; $1,120 for supplies; $1,705 for depreciation of equipment; $1,285 for equipment repairs; and $500 for miscellaneous expenses. Other projected costs for the quarter are salaries and wages of $18,700 in July, $19,500 in August, and $20,600 in September.

The company's cash balance at June 30 was $2,000. Effective July 1, the company has a new policy of maintaining a minimum monthly cash balance of $3,000 and can borrow from the bank in multiples of $100.

1. Prepare a monthly cash budget for Citizens Produce Co-op for the quarter ended September 30.

2. Should Citizens Produce anticipate taking out a loan during the quarter? If so, how much should it borrow, and when?

Reference no: EM13889922

Questions Cloud

Kinetic energy and gravitational potential energy : Energy [define work and energy; kinetic energy and gravitational potential energy (incl. trends); (total) energy; law of Conservation of Energy (LCE); dropping object as illustration of LCE (detail ); energy transformation
What other factors mitigate the dangers of nonperformance : What other factors mitigate the dangers of nonperformance in sequential trading relationships besides contracts?
Determining the primary action : Evaluated three scenarios described by determining the primary action(s) that you should take to limit liability and impact on operations; thoroughly specified which ethical theory best supports your decision.
Demands, along with selling price and material costs : The Morning Brew Coffee Shop sells Regular, Cappuccino, and Vienna blends of coffee. The shop's current daily labor cost is $320, the equipment cost is $125, and the overhead cost is $225.
Prepare a monthly cash budget for citizens produce co-op : Prepare a monthly cash budget for Citizens Produce Co-op for the quarter ended September 30. Should Citizens Produce anticipate taking out a loan during the quarter? If so, how much should it borrow, and when?
Focus of future developments in the business : This is a prediction of the focus of future developments in the Business Law course 10 years from the present. It includes how it will apply to a student's current or future career, including rationale, research, and if there are any alternative p..
Set fs script before processing records : Set FS script before processing records. This is also a good place to set up an array of month names in chronological order - you want to try sorting the catagory section.
Why might you expect there to be economies of scale : Why might you expect there to be economies of scale in airline transportation? How are the development of hub-and-spoke networks related to economies of scale and scope?
Describe an example of political tides : Describe an example of political tides having sway over public administration decisions. Is a public administrator who alters his/ her position due to political pressures merely responding to the will of the people or neglecting his/ her duties as..

Reviews

Write a Review

Corporate Finance Questions & Answers

  Determine whether the company should undertake the project

The corporate tax rate is 30 percent. Using the adjusted present value method, determine whether the company should undertake the project.

  Determine the market value of the debt

What can you conclude from the above tables - determine the market value of the debt and determine the market value of the debt.

  Bay path cranberry products

Bay Path Cranberry Products is a leading producer of cranberry juice, canned cranberry sauce, fresh berries, and sweetened dried cranberries, with production and processing facilities in Massachusetts and Wisconsin. Sales of traditional products such..

  Find the yield on treasury note

The real risk-free rate is 2.5%. Inflation is expected to be 2% this year, 2.5% next year, and 3% thereafter. The maturity risk premium is .07

  What is internal rate of return - payback period

What is the net present value, internal rate of return, payback period, discounted payback period, and profitability index of the proposed project.

  Wisconsin corporation was organized on january 12012 witht

wisconsin corporation was organized on january 12012 witht he invesatment of 400000 in cash by its stockholders. the

  Question 1what we know-balance sheet as of dec 31st 2012

question 1what we know-balance sheet as of dec 31st 2012 shown in millions cash3.5accounts

  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

  Find the growth rate of dividends

Metatrend's stock will create receivings of $6 each share this year. The rebate rate for the stock is 15%. and the rate of return on reinvested earning also is 5 percent.

  The lakeside inn had operating cash flow of 48450

the lakeside inn had operating cash flow of 48450. depreciation was 6700 and interest paid was 2480. a net total of

  Market price of the stock affected by the announcement

Some companies' debt-equity targets are expressed not as a debt ratio, but as a target debt rating on a firm's outstanding bonds. What are the pros and cons of setting a target rating, rather than a target ratio - How is the market price of the sto..

  The cost of capital1 why is the firms weighted average

the cost of capital1. why is the firms weighted average cost of capital wacc considered a hurdle rate?2. explain 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