Copy of wk 3 IND Assign. FIN370 cash budget

Copy of wk 3 IND Assign. FIN370 cash budget - Month March...

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

View Full Document Right Arrow Icon
The Sharpe Corporation Cash Budget Worksheet NovemberDecember January February Sales $220,000 $175,000 $90,000 $120,000 Collections: Month of Sale (10%) $9,000 $12,000 First Month (60%) $105,000 $54,000 Second Month (30%) $66,000 $52,500 Total Collections $180,000 $118,500 Purchases $72,000 $81,000 $144,000 Payments (one month lag) $72,000 $81,000 Cash Receipts: Collections $180,000 $118,500 Cash Disbursements: Purchases $72,000 $81,000 Rent $10,000 $10,000 Other Expenditures $20,000 $20,000 Tax Deposits Interest on Short-term Borrowing Total Disbursements $102,000 $111,000 Net Monthly Change $78,000 $7,500 Beginning Cash Balance $22,000 $100,000 Additional Financing Needed (Repayments) $0 Ending Cash Balance $100,000 $107,500 Cumulative Borrowing b) The firm will have sufficient funds to cover the $200,000 note payable due in July. The firm estimates show they will have $222,009 in cash by the end of July.
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: Month March April May June July August $135,000 $240,000 $300,000 $270,000 $225,000 $150,000 $13,500 $24,000 $30,000 $27,000 $22,500 $72,000 $81,000 $144,000 $180,000 $162,000 $27,000 $36,000 $40,500 $72,000 $90,000 $112,500 $141,000 $214,500 $279,000 $274,500 $180,000 $162,000 $135,000 $90,000 $144,000 $180,000 $162,000 $135,000 $90,000 $112,500 $141,000 $214,500 $279,000 $274,500 $144,000 $180,000 $162,000 $135,000 $90,000 $10,000 $10,000 $10,000 $10,000 $10,000 $20,000 $20,000 $20,000 $20,000 $20,000 $22,500 $22,500 $605 $386 $196,500 $210,000 $192,605 $187,886 $120,000 ($84,000) ($69,000) $21,895 $91,114 $154,500 $107,500 $23,500 $15,000 $15,000 $67,509 $60,500 ($21,895) ($38,605) $0 $23,500 $15,000 $15,000 $67,509 $222,009 $60,500 $38,605 s...
View Full Document

This note was uploaded on 08/13/2011 for the course FIN 370 taught by Professor Unknown during the Spring '08 term at University of Phoenix.

Page1 / 2

Copy of wk 3 IND Assign. FIN370 cash budget - Month March...

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