Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

Grenoble Enterprises had sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July.

1) The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale.

2) The firm receives other income of $2,000 per month.

3) The firm's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively.

4) Rent is $3,000 per month.

5) Wages and salaries are 10% of the previous month's sales.

6) Cash dividends of $3,000 will be paid in June.

7) Payment of principal and interest of $4,000 is due in June.

8) A cash purchase of equipment costing $6,000 is scheduled in July.

9) Taxes of $6,000 are due in June.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M940661

Have any Question? 


Related Questions in Basic Finance

In using the balanced scorecard as a strategic management

In "Using the Balanced Scorecard as a Strategic Management System" by Robert S. Kaplan and David P. Norton (Harvard Business Review, January-February 1996), the following appeared on page 2 of the article: Managers using ...

1 should demand characteristics be eliminated or

1. Should demand characteristics be eliminated or strengthened in an experiment? Explain. 2. How do researchers detect and eliminate placebo effects? 3. What effect does error variance have on the results of an experimen ...

Suppose that you are a wheat farmer answer the following

Suppose that you are a wheat farmer. Answer the following questions. a. It is September, and you intend to have 50,000 bushels of wheat harvested and ready to sell in November. The current spot market price of wheat is $ ...

You have the following information on universe it ts inc

You have the following information on Universe It Ts, Inc.: sales to working capital = 19 times, profit margin = 26.9%, net income available to common stockholders = $4.9 million, and current liabilities = $1.9 million. ...

Sunshine farms withering since naftasunshine farms incis a

SUNSHINE FARMS WITHERING SINCE NAFTA Sunshine Farms Inc.is a fourth-generation family business located in south Florida. Sunshine began as a small farm devoted to citrus fruits and vegetables, and over the years the comp ...

What is the major concern construction lenders express

What is the major concern construction lenders express about the income approach to estimating value? Why do they prefer to use the cost approach when possible? In the latter case, if the developer has owned the land for ...

Excel assignment you are going to purchase a new house

Excel Assignment You are going to purchase a new house valued at $250,000 by making the down payment of 20% and borrowing the rest as a 30-year fixed rate mortgage of 5.25%. Solve the problem by creating an Excel spreads ...

Gork musical instruments produces several products one of

Gork Musical Instruments produces several products, one of which is facing increasing competition from cheaper, plastic alternatives. It expects that in coming years the number of units sold will fall by 10% pa. In the y ...

Go to yahoo and download recent balance sheets for

Go to Yahoo! and download recent balance sheets for Microsoft, Merck, Archer Daniels Midland, and General Mills (ticker symbols MSFT, MRK, ADM, and GIS, respectively). Calculate several debt ratios for each company and c ...

1 why is a costbenefit evaluation important to logistical

1. Why is a cost/benefit evaluation important to logistical systems design efforts? 2. What is the key objective in freight lane analysis? 3. In a general sense, what are the essential differences between analytic and si ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro