Pickup Trucks Company Cash Budget For the Year 20X1

Pickup Trucks Company Cash Budget For the Year 20X1 - 6...

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

View Full Document Right Arrow Icon
Pickup Trucks Company Cash Budget For the Year 20X1 # A Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Beginning Balance 1 $ 20,000 $ 85,351 $ 28,712 $ 20,588 $ 20,000 Cash Inflows Collections from Customers 2 319,500 246,000 370,500 546,000 1,482,000 Proceeds fromland sale 3 15,000 15,000 Total Receipts 319,500 246,000 385,500 546,000 1,497,000 Cash Available 339,500 331,351 414,212 566,588 1,517,000 Cash Outflows Raw Materials Purchases 4,5 43,624 36,226 52,374 65,787 198,011 Direct Labor 6 107,100 130,550 208,600 255,325 701,575 Manufacturing Overhead ( B ) 6 45,675 53,213 78,300 93,319 270,507 Selling Expenses 6 23,000 24,400 32,100 40,500 120,000 Administrative Expenses
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: 6 20,250 20,250 20,250 20,250 81,000 Purchases of Machinery 7 20,000 56,000 76,000 Income Taxes 8 14,500 18,000 18,000 18,000 68,500 # A Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Total Outflows 254,149 302,639 465,624 493,181 1,515,593 Cash Balance before financing 85,351 28,712 (51,412) 73,407 1,407 Financing Borrowings 9 72,000 72,000 Principal Repayments 9 (50,000) (50,000) Interest Payments 9 (2,880) (2,880) Net Borrowing Costs 72,000 (52,880) 19,120 Ending Cash Balance 9 $ 85,351 $ 28,712 $ 20,588 20,527 $ 20,527...
View Full Document

This note was uploaded on 11/16/2011 for the course ACCT 2310 taught by Professor Staff during the Spring '09 term at Texas State.

Page1 / 2

Pickup Trucks Company Cash Budget For the Year 20X1 - 6...

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