Garden Sales, Inc. | |||||
Cash Budget | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year | |
Cash balance, beginning | $34,000.00 | $10,000.00 | $94,950.00 | $105,950.00 | $244,900.00 |
Add collections from sales | $250,000.00 | $400,000.00 | $280,000.00 | $300,000.00 | $1,230,000.00 |
Total cash available | $284,000.00 | $410,000.00 | $374,950.00 | $405,950.00 | $1,474,900.00 |
Total disbursements | $309,000.00 | $279,000.00 | $269,000.00 | $289,000.00 | $1,146,000.00 |
Excess (deficiency) of cash | -$25,000.00 | $131,000.00 | $105,950.00 | $116,950.00 | $328,900.00 |
Financing: | |||||
Borrowings | $35,000.00 | $0.00 | $0.00 | $0.00 | $35,000.00 |
Repayments | $0.00 | -$35,000.00 | $0.00 | $0.00 | -$35,000.00 |
Interest (35000 x 3%) | $0.00 | -$1,050.00 | $0.00 | $0.00 | -$1,050.00 |
Total financing | $35,000.00 | -$36,050.00 | $0.00 | $0.00 | -$1,050.00 |
Cash balance, ending | $10,000.00 | $94,950.00 | $105,950.00 | $116,950.00 | $327,850.00 |
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $290,000 337,000 $ 340,000 $ 317,000 $ 440,000 $ 307,000 $ 320,000 $ 297,000 Total cash receipts Total cash disbursements The company's beginning cash balance for the upcoming fiscal year will be $42,000. The company requires a minimum cash balance of $10,000 and may borrow any...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 250,000 $ 400,000 $ 280,000 $300,000 $ 309,000 $ 279,000 $ 269,000 $289,000 The company's beginning cash balance for the upcoming fiscal year will be $34,000. The company requires a minimum cash balance of $10,000 and may borrow any...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter $ 220,000 $ 370,000 $ 250,000 $ 288,000 $ 258,000 $ 248,000 4th Quarter $ 270,000 $ 268,000 The company's beginning cash balance for the upcoming fiscal year will be $28,000. The company requires a minimum cash balance of $10,000 and may...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 200,000 $ 350,000 $ 230,000 $ 250,000 $ 274,000 $ 244,000 $ 234,000 $ 254,000 The company's beginning cash balance for the upcoming fiscal year will be $24,000. The company requires a minimum cash balance of $10,000 and may...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 210,000 $360,000 $ 240,000 $ 260,000 $ 281,000 $ 251,000 $ 241,000 $ 261,000 The company's beginning cash balance for the upcoming fiscal year will be $26,000. The company requires a minimum cash balance of $10,000 and may borrow...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursementa 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 200,000 $ 350,000 $ 230,000 $250,000 $ 274,000 $244,000 $234,000 $ 254,000 The company's beginning cash balance for the upcoming fiscal year will be $24,000. The company requires a minimum cash balance of $10,000 and may borrow any amount...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 290,000 $ 410,000 $ 351,000 $ 321,000 3rd Quarter $ 340,000 $ 311,000 4th Quarter $360,000 $ 331,000 The company's beginning cash balance for the upcoming fiscal year will be $47,000. The company requires a minimum cash balance of $10,000 and may borrow...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 280,000 $ 400,000 $ 330,000 $ 350,000 $ 344,000 $ 314,000 $ 304,000 $ 324,000 The company's beginning cash balance for the upcoming fiscal year will be $45,000. The company requires a minimum cash balance of $10,000 and may...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 190,000 $ 340,000 $ 220,000 $ 240,000 $ 267,000 $ 237,000 $ 227,000 $ 247,000 The company's beginning cash balance for the upcoming fiscal year will be $22,000. The company requires a minimum cash balance of $10,000 and may...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter $ 220,000 $ 370,000 $ 250,000 $ 288,000 $ 258,000 $ 248,000 4th Quarter $ 270,000 $ 268,000 The company's beginning cash balance for the upcoming fiscal year will be $28,000. The company requires a minimum cash balance of $10,000 and may...