Purchase Solution

ABC Co Master Budget: Quarterly Cash Flows

Not what you're looking for?

Ask Custom Question

You will be required to develop a schedule of quarterly cash flows.
The company wants to maintain minimum cash balance at the end of each quarter at >>>>> $150,000
Money can be borrowed or repaid in multiples of $5,000 at an interest rate of 10% annually.
Management does not want to borrow any more cash than is necessary and wants to repay as
promptly as possible. Loans may not extend beyond four quarters. Interest expense is computed
and paid when the principal is repaid. Assume that borrowing of funds takes place at the beginning
and repayments at the end of each of the quarters. Compute interest expense to the nearest dollar.

The following information is based on the cash effects of the operations in the Schedules you developed
in Part A of this case.

1 2 3 4

Collections from customers $1,250,000 $1,500,000 $1,600,000 $2,210,000
For direct materials $200,000 $350,000 $350,000 $542,000
For other costs and expenses $250,000 $200,000 $200,000 $170,000
For payroll $900,000 $950,000 $950,000 $1,092,000
For income taxes $50,000 $0 $0 $0
For machinery purchases $0 $0 $0 $200,000

NOTE: To develop the cash budget, you will need to refer to additional data from the
schedules you developed in Part A.


(A) Prepare the quarterly and annual cash budget for 2008. Show cash receipts
and disbursements including details of borrowings, repayments, and interest expense.
(check figures: 1st Quarter ending cash = $150,000; Year-end cash = $238,250)

(B) Prepare budgeted income statement, including effects of interest expense and
assumed income taxes for 2008 as >>>>>> $200,000
Check figure: Net Income >>>>>>>>>>>> $445,250

( C ) Prepare a budgeted year-end balance sheet. Start with last year's balance sheet.
Show supporting calculations for each account in the balance sheet.

NOTE: The schedules/statements should be prepared as linked spreadsheets,
except for financing and borrowing calculations.

Purchase this Solution

Solution Summary

Your tutorial is attached in excel with all the cells linked. This required an analysis of accounts payable so that the cell would not have a formula so complicated that you could not easily follow the work and study and learn this process.

Solution provided by:
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
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.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

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.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.