Cash Budget - Sales June Sales July Sales April 1.000 0.600...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Cash Budgeting Desired Minimum Balance $100,000 February March April May Sales $400,000 $500,000 $600,000 $700,000 Cash Receipts Collections (current) 20% $120,000 $140,000 Collections (previous month) 50% $250,000 $300,000 Collections (2nd month previous) 30% $120,000 $150,000 Total Cash Receipts $490,000 $590,000 Cash Disbursements Purchases $420,000 $480,000 Wages and Salaries $72,000 $84,000 Rent $10,000 $10,000 Cash Operating Expenses $30,000 $30,000 Tax Installments $20,000 Capital Expenditure Mortgage Payment $60,000 Total Cash Disbursements $552,000 $664,000 Ending Cash Balance Net Cash Flow $(62,000) $(74,000) Beginning Cash Balance $150,000 $100,000 Available Balance $88,000 $26,000 Monthly Borrowing $12,000 $74,000 Monthly Repayment $- $- Ending Cash Balance $150,000 $100,000 $100,000 Cumulative Loan Balance $- $12,000 $86,000 Correlation Matrix Sales April Sales May
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sales June Sales July Sales April 1.000 0.600 Sales May 1.000 0.600 Sales June 1.000 0.600 Sales July 1.000 Sales August Sales September October June July August September October $800,000 $800,000 $700,000 $600,000 $500,000 $160,000 $160,000 $140,000 $120,000 $350,000 $400,000 $400,000 $350,000 $180,000 $210,000 $240,000 $240,000 $690,000 $770,000 $780,000 $710,000 $480,000 $420,000 $360,000 $300,000 $96,000 $96,000 $84,000 $72,000 $10,000 $10,000 $10,000 $10,000 $30,000 $30,000 $25,000 $25,000 $30,000 $150,000 $766,000 $586,000 $479,000 $407,000 $(76,000) $184,000 $301,000 $303,000 $100,000 $100,000 $122,000 $423,000 $24,000 $284,000 $423,000 $726,000 $76,000 $- $- $- $- $162,000 $- $- $100,000 $122,000 $423,000 $726,000 $162,000 $- $- $- Sales August Sales September October 0.600 1.000 0.600 1.000 0.600 1.000...
View Full Document

This note was uploaded on 09/21/2011 for the course BITM 215 taught by Professor Ross during the Spring '08 term at SUNY Albany.

Page1 / 2

Cash Budget - Sales June Sales July Sales April 1.000 0.600...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online