Prepare a schedule of budgeted and cash budget, Business Economics


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:






$ 50,000



Merchandise purchase








Rent payment




Other Cash payments








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.


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 external constraints on government action less developed countries? External Constraints on Government Action LDCs face external factors beyond their control are:

How can trade agreements assist development? A trade agreement is while two or more countries to by decrease or abolish tariffs, non-trade and quotas barriers which are establ

Pick a corporation.  Create the same return column for the same 60 months for this corporation. For this 60-month period what is the correlation coefficient between the monthly ret

two political party called hawks show apoint ppf that the hawks might choose and a point the doves might choose

Do you agree with what Dick Brandon said regarding sex? Do not take this question too seriously! Even though the quotation had a humorous intention, this does highlight a serio

in the banking systems, when clearing checks, the difference between the Federal Reserve''s credits and debits is the

What is meant by the term the triple constraint? What are the three elements of the triple constraint and why is an understanding of their relative weight significant in exercising

How does resource enhancement improve development? Enhancements in the quantity and quality of resources increases productivity hence incomes. Enhanced management raises outpu

Changes frequently bedevil IS projects. What steps are needed to make sure that proper change control is exercised onto a project? An effective change control system involves t

Suppose an oligopoly consists of three identical firms. Industry demand is P = 100 - 2Q and MC = AC = 20. What is the Cournot–Nash equilibrium output in this industry