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

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

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