Prepare a schedule of budgeted and cash budget, Business Economics

Question:

Yamba Home Products is just beginning its fourth quarter, in which peak sales occur. The company has requested a $12,000, 90-day loan from its bank to help meet cash requirements during the quarter. The loan officer has asked for a cash budget for the quarter to help determine whether the loan should be made.

The following data are available for the quarter:

1. On April 1, the start of the quarter, the company had a cash balance of $6,000. Accounts receivable on April 1 totalled $31,500, of which $29,500 will be collected during April and $1,600 will be collected during May. The remainder will be uncollectable.

2. Past experience shows that 25 percent of a month's sales are collected in the month of sale, 70 percent in the month following sale, and 4 percent in the second month following sale. Budgeted sales and expenses for the fourth quarter follow:

 

April

May

June

Sales

$ 50,000

$60,000

$45,000

Merchandise purchase

36,000

27,000

24,000

Payroll

6,500

6,750

6,000

Rent payment

4,500

4,500

4,500

Other Cash payments

8,500

9,100

7,500

Depreciation

2,500

2,500

2,500

3. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases on March 31, which will be paid during April, totalled $30,000.

4. In preparing a cash budget, assume that the loan is made in April and repaid in June. Interest on the loan will total $450.

Required:

a.  Prepare a schedule of budgeted cash collections for April, May and June and for the quarter in total.

b.  Prepare a cash budget, by month and in total, for the quarter.

c.  If the company needs a minimum cash balance of $5,000 to start each month, can the loan be repaid as planned? Explain.

Posted Date: 2/15/2013 12:29:33 AM | Location : United States







Related Discussions:- Prepare a schedule of budgeted and cash budget, Assignment Help, Ask Question on Prepare a schedule of budgeted and cash budget, Get Answer, Expert's Help, Prepare a schedule of budgeted and cash budget Discussions

Write discussion on Prepare a schedule of budgeted and cash budget
Your posts are moderated
Related Questions
What are the limits of development theories? Theories are generalisations: • When LDCs share similarities, each country is unique economic, cultural, social and historical

Your student union has decided to support a local charity by fund-raising on a Rag Day to be held in the town. Key events include a fancy dress relay race with teams sponsored by l

Define three methods than could be utilized to exercise quality control and describe the advantages and disadvantages of all. Methods comprise: • Self-checking:   Rapid, ch

Question: There are currently some 421 Regional Trade Agreements (RTAs) around the world. These RTAs normally provide preferential treatment to member countries, which is again

Problem 1: (a) Suppose the government decides to implement a minimum wage to help low-income workers. How will the minimum wage affect the demand for labor and what does this i

Mercier Corporation's stock is selling for $95. It has just paid a dividend of $5 s share. The expected growth rate in dividends is 8 percent. a. What is the needed rate of retu

Define the balance of payments problem in international capital flows. Balance of payments (BoP): It inflows capital as like: • Foreign direct investment (FDI) into machiner

QUESTION (a) Use graphical methods to distinguish between cost push and demand pull inflation. (b) Explain how a budget deficit of the government can cause inflation. (c)

Explain the mixed economy system. Mixed economy: Several resources are owned through the public sector (government) and several resources are owned through the private sector o

QUESTION (a) Explain the relationship between scarcity, choice and opportunity cost. (b) What is market failure and why does it occur in an economy? (c) Differentiate, us