1st qtr | 2nd qtr | 3rd quarter | 4 th qtr | year | ||||
Beginning cash balance | 40,000 | 10,000 | 118,800 | 138,800 | 40,000 | |||
total cash receipts | 280,000 | 430,000 | 310,000 | 330,000 | 1,350,000 | |||
total cash available | 320,000 | 440000 | 428800 | 468800 | 1,390,000 | |||
total cash disbursements | 330,000 | 300,000 | 290,000 | 310,000 | 1,230,000 | |||
Excess of cash available over disbursement | -10,000 | 140,000 | 138,800 | 158,800 | 160,000 | |||
Financing: | ||||||||
Borrowings | 20,000 | 0 | 0 | 0 | 20,000 | |||
Repayments | 0 | -20,000 | 0 | 0 | -20,000 | |||
Interest | 0 | -1,200 | 0 | 0 | -1,200 | |||
total financing | 20,000 | -21,200 | 0 | 0 | -1,200 | |||
Ending cash balance | 10,000 | 118,800 | 138,800 | 158,800 | 158,800 | |||
interest = 20000*3%*2 qtrs | ||||||||
1200 | ||||||||
Exercise 8-7 Cash Budget [LO8-8] 5 Garden Depot is a retailer that is preparing its budget...
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 $ 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 Total cash receipts $280,000 $400,000 $330,000 $350,000 Total cash disbursements $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: 3rd Quarter $ 210,000 220,000 1st Quarter Quarter $ 180,000 $330,000 260,000 230,000 4th Quarter $ 230,000 240,000 Total cash receipts Total cash disbursements 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 and may borrow any amount needed from a...
Can you also provide step by step please. Exercise 8-7 (Algo) 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: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 330,000 $ 450,000 $ 380,000 $ 400,000 $ 379,000 $ 349,000 $ 339,000 $ 359,000 The company's beginning cash balance for the upcoming fiscal year...
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...