Answer-
Garden Depot | |||||
Cash Budget | |||||
Quarter | |||||
Particulars | 1st | 2nd | 3rd | 4th | Year |
$ | $ | $ | $ | ||
Beginning cash balance | 34000 | 10000 | 93900 | 104900 | 34000 |
Total cash receipts | 250000 | 400000 | 280000 | 300000 | 1230000 |
Total cash available | 284000 | 410000 | 373900 | 404900 | 1264000 |
Total cash disbursements | 309000 | 279000 | 269000 | 289000 | 1146000 |
Excess of cash available over disbursements | -25000 | 131000 | 104900 | 115900 | 118000 |
Financing:- | |||||
Borrowings | 35000 | 0 | 0 | 0 | 35000 |
Repayments | 0 | -35000 | 0 | 0 | -35000 |
Interest | 0 | -2100 | 0 | 0 | -2100 |
Total financing | 35000 | -37100 | 0 | 0 | -37100 |
Ending cash balance | 10000 | 93900 | 104900 | 115900 | 115900 |
Where - Interest = $35000*3%*2 quarter
= $2100
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: 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...
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 $ 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...