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 $ 410,000 $ 321,000 $ 340,000 $ 311,000 $ 360,000 $ 331,000 $ 290,000 $ 351,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 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.) Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 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 $ 410,000 $ 321,000 $ 340,000 $ 311,000 $ 360,000 $ 331,000 $ 290,000 $ 351,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 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.) Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year
Expert Answer:
Answer rating: 100% (QA)
Garden Depot Cash Budget Heres the cash budget for Garden Depot for the upcoming fiscal year Line Item 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter ... 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
-
HW #2 A four-stage process must produce 500 units per day. Units progress in order (stage 1, then stage 2, stage 3, then stage 4). At each stage, a percentage of the units are defective, and a...
-
Why are Operational Mission Variables important and how understanding this concept a Sergeant Major could apply this concept in leader development?
-
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...
-
What problems may be encountered in making a comparative study of remuneration reports?
-
Storage tanks to hold a highly corrosive chemical are currently made of material Z26. The capital investment in a tank is $30,000, and its useful life is eight years. Your company manufactures...
-
How does penicillin kill bacteria?
-
What consumer credit counseling services are available?
-
Calculating acquisition costs of long-lived assets. Outback Steakhouse opened a new restaurant on the site of an existing building. It paid the owner $260,000 for the land and building, of which it...
-
The management accountant of Bridgetown Lid is finding it difficult to cope with increasing demands for information and has asked for your help. You have been asked to prepare variance analysis...
-
The earth could have sustained more population if all the people would have been ? Pure vegetarians Milk drinker and vegetarian Non-vegetarians Dependent upon milk, egg and vegetarian habit
-
Managing a company for over a century requires effective management techniques. Using examples from this case explain how leaders at Harley-Davidson demonstrate the four functions of management (i.e....
-
In depth, explain How do these authors writings relate to economic policy today? How do they relate to political economics? What are key takeaways from these authors? Include one in text bible verse....
-
2. a. b. C. d. Consider the following Autoregressive Distributed Lagged, ARDL (1, 1,0) model for three variables Yt, Xt, and Zt is as follows: Yt Bo + B1Yt-1 + BX1 + B3Xt-1 + B4Zt + et Define the...
-
Rent-A-Reck Incorporated finds that it can rent 80 cars if it charges $60 for a weekend. It estimates that for each $5 price increase it will rent two fewer cars. What price should it charge to...
-
Assume Acme Corporation is a typical monopoly: If the economy moves into a recession and the demand for Acme's product falls, describe the impact of the recession on equilibrium price, output, and...
-
-16+25 6 (Simplify your answer. Type an exact answer, using radicals as needed. Use integers or fractions for any numbers in the expression.)
-
You purchase a bond with a coupon rate of 6.7 percent, a par value $1,000, and a clean price of $905. Assume a par value of $1,000. If the next semiannual coupon payment is due in two months, what is...
-
Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a...
-
Huron Company produces a commercial cleaning compound known as Zoom. The direct materials and direct labor standards for one unit of Zoom are given below: During the most recent month, the following...
-
If a product line is generating a loss, then it should be discontinued. Do you agree? Explain.
-
What is kiting? How can one spot a kiting scheme?
-
What is not especially helpful for spotting kiting a. Confirming accounts receivables. b. Look for frequent deposits and checks in the same amount. c. Check for large deposits on Fridays. d. Look for...
-
What is a land flip?
Study smarter with the SolutionInn App