Purchase Solution

Cornell Inc. Case Study: Calculating Cash Budget

Not what you're looking for?

Ask Custom Question

Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2007:

April May June
Credit sales $380,000 $396,000 $438,000
Credit purchases 147,000 175,500 200,500
Cash disbursements
Wages, taxes, and expenses 39,750 48,210 50,300
Interest 11,400 11,400 11,400
Equipment purchases 83,000 91,000 0

The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2007, credit sales were $210,000, and credit purchases were $156,000. Using this
information, complete the following cash budget:

April May June
Beginning cash balance $280,000
Cash receipts
Cash collections from credit sales
Total cash available
Cash disbursements
Purchases
Wages, taxes, and expenses
Interest
Equipment purchases
Total cash disbursements
Ending cash balance

Purchase this Solution

Solution Summary

The solution calculates the cash budgets for Cornell, Inc. The credit sales and credit purchases are determined.

Solution provided by:
Education
  • BA, Ain Shams University, Cairo Egypt
  • MBA, California State University, Sacramento
Recent Feedback
  • "ty i have more need help with"
  • "ty i have jmore i need help with"
  • "great help"
  • "excellent help"
  • "Very helpful and easy to understand."
Purchase this Solution


Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.