Can you also provide step by step please.
Solution
Garden Depot | |||||
Cash budget | |||||
Q1 | Q2 | Q3 | Q4 | Year | |
Beginning Cash balance | $ 22,000.00 | $ 10,000.00 | $ 71,780.00 | $ 112,780.00 | $ 22,000.00 |
Total cash receipt | $ 330,000.00 | $ 450,000.00 | $ 380,000.00 | $ 400,000.00 | $ 1,560,000.00 |
Total cash available | $ 352,000.00 | $ 460,000.00 | $ 451,780.00 | $ 512,780.00 | $ 1,582,000.00 |
Less: Total cash disbursement | $ 379,000.00 | $ 349,000.00 | $ 339,000.00 | $ 359,000.00 | $ 1,426,000.00 |
Excess of cash available over disbursement | $ (27,000.00) | $ 111,000.00 | $ 112,780.00 | $ 153,780.00 | $ 156,000.00 |
Financing: | |||||
Borrowings | $ 37,000.00 | $ 37,000.00 | |||
Repayments | $ - | $ (37,000.00) | $ - | $ - | $ (37,000.00) |
Interest | $ - | $ (2,220.00) | $ - | $ - | $ (2,220.00) |
Total financing | $ 37,000.00 | $ (39,220.00) | $ - | $ - | $ (2,220.00) |
Ending cash balance | $ 10,000.00 | $ 71,780.00 | $ 112,780.00 | $ 153,780.00 | $ 153,780.00 |
.
Loan is taken at the beginning of the quarter and paid at the end of second . This means Loan of 27000 is taken at beginning of Q1 and repaid at End of Q2 so 2 Quarters interest will be paid on $27000. | |
Beginning cash of Quarter 1 is the beginning cash of Year. |
Can you also provide step by step please. Exercise 8-7 (Algo) Cash Budget (LO8-8] Garden Depot...
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...
Exercise 8-7 Cash Budget [LO8-8] 5 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 S 280,000 S 330,000 10 $ 310,000 $ 290,000 $ 330,000 310,000 $ 430,000 $ 300,000 points Total cash receipts Total cash disbursements Skipped The company's beginning cash balance for the upcoming fiscal year will be $40,000 The company requires...
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...
7. value: 1.50 points 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: 3rd Quarter $240,000 $241,000 4th Quarter 1st Quarter $210,000 $281,000 2nd Quarter $360,000 $251,000 Total cash receipts Total cash disbursements $260,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 any amount needed...
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 $ 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 $ 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 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: 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...