FI_515_Cash_Budget_15-4(1)

FI_515_Cash_Budget_15-4(1) - Cash Budget First Quarter...

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

View Full Document Right Arrow Icon
Table 15-4 Cash Budget First Quarter December January February March Assumptions Sales $540,000 $500,000 $550,000 $620,000 Credit Sales: 90% Of current month sales Projected Cash Balance, $61,000 $50,700 $50,000 Purchases: 55% Of following month sales Beginning of Month Minimum Cash Balance: $50,000 Receipts: Cash Sales $50,000 $55,000 $62,000 Collection of A/R $475,200 $463,500 $513,900 Total Cash Available $586,200 $569,200 $625,900 Disbursements: Payment of A/P $275,000 $302,500 $341,000 Wages and Salaries $158,000 $154,500 $145,500 Rent $17,000 $17,000 $17,000 Other Expenses $4,500 $7,000 $8,000 Taxes $81,000 $- $- Dividends on Common Stock $- $- $30,000 Purchases of New Equipment $- $70,000 $- Total Disbursements $535,500 $551,000 $541,500 Excess of available cash over disbursement $50,700 $18,200 $84,400 Cash loans needed to maintain minimum balance. $- $31,800 $- Loan Repayment $(31,800) Projected Cash Balance, end of month $50,700 $50,000 $52,600
Background image of page 1

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

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

Unformatted text preview: Cash Budget First Quarter Decembe January February March Assumptions Sales ### $500,000 $550,000 $620,000 Credit Sales:### Of current month sales Projected Cash Balance $61,000 $50,700 $50,000 Purchases: ### Of following month sales Beginning of Month Minimum Cas### Receipts: Cash Sales $50,000 $55,000 $62,000 Collection of A/R $475,200 $463,500 $513,900 Total Cash Available $586,200 $569,200 $625,900 Disbursements: Payment of A/P $275,000 $302,500 $341,000 Wages and Salaries $158,000 $154,500 $145,500 Rent $17,000 $17,000 $17,000 Other Expenses $4,500 $7,000 $8,000 Taxes $81,000 $- $- Dividends on Common $- $- $30,000 Purchases of New Equ $- $70,000 $- Total Disbursements $535,500 $551,000 $541,500 Excess of available cash over disbursement $50,700 $18,200 $84,400 Cash loans needed to maintain minimum balance. $- $31,800 $- Loan Repayment $(31,800) Projected Cash Balance, end of month $50,700 $50,000 $52,600...
View Full Document

This note was uploaded on 11/15/2010 for the course FINANCE FI515 taught by Professor Haertel during the Spring '10 term at DeVry Denver.

Page1 / 2

FI_515_Cash_Budget_15-4(1) - Cash Budget First Quarter...

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