Solution
Garden Depot | |||||
Cash budget | |||||
Q1 | Q2 | Q3 | Q4 | Year | |
Beginning Cash balance | $ 26,000.00 | $ 10,000.00 | $ 60,700.00 | $ 59,700.00 | $ 26,000.00 |
Total cash receipt | $ 210,000.00 | $ 360,000.00 | $ 240,000.00 | $ 260,000.00 | $ 1,070,000.00 |
Total cash available | $ 236,000.00 | $ 370,000.00 | $ 300,700.00 | $ 319,700.00 | $ 1,096,000.00 |
Less: Total cash disbursement | $ 281,000.00 | $ 251,000.00 | $ 241,000.00 | $ 261,000.00 | $ 1,034,000.00 |
Excess of cash available over disbursement | $ (45,000.00) | $ 119,000.00 | $ 59,700.00 | $ 58,700.00 | $ 62,000.00 |
Financing: | |||||
Borrowings | $ 55,000.00 | $ 55,000.00 | |||
Repayments | $ - | $ (55,000.00) | $ - | $ - | $ (55,000.00) |
Interest | $ - | $ (3,300.00) | $ - | $ - | $ (3,300.00) |
Total financing | $ 55,000.00 | $ (58,300.00) | $ - | $ - | $ (3,300.00) |
Ending cash balance | $ 10,000.00 | $ 60,700.00 | $ 59,700.00 | $ 58,700.00 | $ 58,700.00 |
.Loan is taken at the beginning of the quarter and paid at the end of second . This means Loan of $55,000 is taken at beginning of Q1 and repaid at End of Q2 so 2 Quarters interest will be paid on $55,000.
7. value: 1.50 points Garden Depot is a retailer that is preparing its budget for the...
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 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...
Exercise 8-7 Cash Budget [LO8-8] 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 $350, eee Total cash receipts Total cash disbursements 2nd Quarter $478,000 $363,000 3rd Quarter $400, eee $353, eee 4th Quarter $420,000 $373, 800 $393, eee The company's beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000...
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...