Cash-Budget

Cash-Budget - Assumptions: Long-term borrowing rate (bonds)...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Assumptions: Long-term borrowing rate (bonds) 0.67% Long-term bonds outstanding $100,000.00 Short-term borrowing rate (bank loan) 1.0% monthly Short-term investing rate (marketable securities) 0.5% monthly Percent of sales for cash 40.0% Percent of sales collected 1 month after sale 35.0% Percent of sales collected 2 months after sale 25.0% COGS/Sales 55.0% (used to calculate purc Percent of purchases for cash 50.0% Percent of purchases paid 1 month after purchase 30.0% Percent of A/P paid 2 months after purchase 20.0% Monthly dividend $500.00 Minimum acceptable cash balance $2,000.00 Maximum acceptable cash balance $3,000.00 Rent $1,000.00 Utilities $500.00 Commissions (% of month's sales) 20% Monthly dividend $1,000.00 Sales Growth Rate 0% ` CASH BUDGET Prior year's sales -> Collections and Purchases Worksheet Nov Dec Sales 12,000.00 10,000.00 Collections: For cash A/R collected 1 month after sale A/R collected 2 months after sale Total collections Purchases of inventory 5,500.00 6,600.00 Payments Cash A/P paid 1 month after purchase A/P paid 2 months after purchase Total payments for inventory Net Cash Flow Calculations Total collections Interest received on short-term investments Total cash receipts Less Disbursements: Payments for inventory Purchase of fixed assets Rent Utilities A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Interest paid on long-term borrowing Interest paid on short-term borrowing Estimated tax payments Commissions Dividend Total disbursements Net cash flow Cash Surplus or Borrowing Requirement Beginning Cash Balance Plus: Net cash flow Equals: Ending cash if no borrowing or repayment 2,000.00 Minimum acceptable cash balance Maximum acceptable cash balance Cumulative surplus (marketable securities) Cumulative short-term borrowing Ending cash balance after borrowing or investing A B C 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 hases of raw materials) Jan Feb Mar Apr May Jun 12,000.00 14,400.00 17,280.00 20,736.00 24,883.20 29,859.84 Jan Feb Mar Apr May Jun 12,000.00 14,400.00 17,280.00 20,736.00 24,883.20 29,859.84 4,800.00 5,760.00 6,912.00 8,294.40 9,953.28 11,943.94 3,500.00 4,200.00 5,040.00 6,048.00 7,257.60 8,709.12 3,000.00 2,500.00 3,000.00 3,600.00 4,320.00 5,184.00 11,300.00 12,460.00 14,952.00 17,942.40 21,530.88 25,837.06 7,920.00 9,504.00 11,404.80 13,685.76 16,422.91 13,685.76 3,960.00 4,752.00 5,702.40 6,842.88 8,211.46 6,842.88 1,980.00 2,376.00 2,851.20 3,421.44 4,105.73 4,926.87 1,100.00 1,320.00 1,584.00 1,900.80 2,280.96 2,737.15 7,040.00 8,448.00 10,137.60 12,165.12 14,598.14 14,506.91 Jan Feb Mar Apr May Jun 11,300.00 12,460.00 14,952.00 17,942.40 21,530.88 25,837.06 0.00 0.00 0.00 0.00 0.00 0.00 11,300.00 12,460.00 14,952.00 17,942.40 21,530.88 25,837.06 7,040.00 8,448.00 10,137.60 12,165.12 14,598.14 14,506.91 10,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 500.00 500.00 500.00500....
View Full Document

This note was uploaded on 10/22/2010 for the course FIN 340 taught by Professor Davidallen during the Spring '10 term at N. Arizona.

Page1 / 35

Cash-Budget - Assumptions: Long-term borrowing rate (bonds)...

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

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