Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $ 379,000 $ 349,000 $ 380,000 $ 339,000 $ 400,000 $ 359,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 borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, interest, and cash deficiencies should be indicated by a minus sign.) Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Beginning cash balance Total cash receipts $ 22,000 $ 10,000 330,000 450,000 380,000 400,000 Total cash available 352,000 460,000 380,000 400,000 Total cash disbursements 379,000 349,000 339,000 359,000 Excess (deficiency) of cash available over disbursements (27,000) 111,000 41,000 41,000 Financing: Borrowings Repayments Interest Total financing Ending cash balance 0 0 $ (27,000) $ 111,000 $ 69 0 41,000 0 $ 41,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 $ 330,000 $ 450,000 $ 379,000 $ 349,000 $ 380,000 $ 339,000 $ 400,000 $ 359,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 borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, interest, and cash deficiencies should be indicated by a minus sign.) Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Beginning cash balance Total cash receipts $ 22,000 $ 10,000 330,000 450,000 380,000 400,000 Total cash available 352,000 460,000 380,000 400,000 Total cash disbursements 379,000 349,000 339,000 359,000 Excess (deficiency) of cash available over disbursements (27,000) 111,000 41,000 41,000 Financing: Borrowings Repayments Interest Total financing Ending cash balance 0 0 $ (27,000) $ 111,000 $ 69 0 41,000 0 $ 41,000
Expert Answer:
Answer rating: 100% (QA)
Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Beg... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
Booth Inc. uses three delivery trucks to transport finished parts from its plant to the plants of its customers. The delivery trucks are obtained through a 5-year operating lease that costs $12,000...
-
Which of the following variables was controlled in Experiment 1? F. Amount of yeast G. Percent of molasses H. Percent of sucrose J. Carbon dioxide levels Experiment 1 Since yeast needs sucrose to...
-
a. Would you expect hemiacetals to be stable in basic solutions? Explain your answer. b. Acetal formation must be catalyzed by an acid. Explain why it cannot be catalyzed by CH3O-. c. Can the rate of...
-
An airlines records showed that the percent of on-time flights each day for a 20-day period was as follows: 72, 75, 76, 70, 77, 73, 80, 75, 82, 85, 77, 78, 74, 86, 72, 77, 67, 78, 69, 80 Construct a...
-
Estimate the overall odds ratio of the set of tables in Problem3.6 and test whether the odds ratios are the same across the tables. Problem3.6 is: 3.6 Use the DOS data to test whether there is gender...
-
Matlock Company uses a perpetual inventory system. Its beginning inventory consists of 50 units that cost $34 each. During June, the company purchased 150 units at $34 each, returned 6 units for...
-
Suzanne Michaels from Howie's Pizza was asked to calculate the break-even point for a new line of gourmet pizzas (prebaked, ready to take home). The selling price will be $25 per pizza. The labor...
-
In a random sample of four mobile devices, the mean repair cost was $80.00 and the standard deviation was $13.50. Assume the population is normally distributed and use a t-distribution to find the...
-
Sam Lewis has been operating a 'full service' service station for several years. Although he occasionally has employed students part-time, he has collected the cash and cheques for petrol and repair...
-
Your friend, an avid sports fan, recently purchased a cricket bat from a catalogue. While he was filling out the order form, he noticed the warning, 'Don't send cash!' He asked you, 'Does it seem odd...
-
We mentioned that if Sweet Temptations came up short four boxes of chocolates, it should increase its Cost of Goods Sold account and decrease its Inventory account by the cost of those boxes. Suppose...
-
For the years 1998 to 2009, the number of applicants to U.S. medical schools can be closely approximated by where t is the number of years since 1998. a. Graph the number of applicants on b. Based on...
-
Robert and Gwen are partners in a new superannuation search business called Super Lost and Found. Super Lost and Found, which begins operations in December, finds lost accounts from superannuation...
-
You work at top line manufacturing, and your boss has asked you to confirm a commitment made by a motivational speaker who has agreed to present at an upcoming meeting for the staff. The meeting has...
-
Complete problem P10-21 using ASPE. Data from P10-21 Original cost ................................................................. $7,000,000 Accumulated depreciation...
-
Some credit card issuers are beginning to assess fees and other charges on convenience users. Ask your friends and peers if they think a convenience credit card user should be charged for the...
-
Break into two or three groups to research the use of affinity cards. First, develop a list of affinity cards and their sponsors. Does your university sponsor a card? Next, each group should choose a...
-
Interview individuals who represent the three stages of the financial life cycle about their credit card usage. How many cards do they have? What kind or class of cards (rebate, premium, affinity,...
Study smarter with the SolutionInn App