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 $ 340,000 $ 386,000 $ 460,000 $ 356,000 3rd Quarter 4th Quarter $ 410,000 $ 390,000 $ 366,000 $ 346,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 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 $ 340,000 $ 386,000 $ 460,000 $ 356,000 3rd Quarter 4th Quarter $ 410,000 $ 390,000 $ 366,000 $ 346,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 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:
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?
-
Which diagramming method is used by most of the popular project management software? Question 4 options: Activities on arrows ( AOA ) network Gantt charts PERT network Activities on nodes ( AON )...
-
What would a profile look like across a restraining bend? Releasing bend?
-
Given the coordinates of three points (x1,y1), (x2,y2) , and (x3,y3) it is possible to find the coordinates of the center of the circle (Cx, Cy) that passes through the three points by solving the...
-
Why would the cold rolling of shaped product not be an attractive means to produce a small amount of prototype product?
-
Carolyn is breeding two pea plants, and notes that 8 of the 25 offspring plants have yellow peas. So, she concludes that there's a \(32 \%\) chance that an offspring of these two plants will have...
-
A risky $400,000 investment is expected to generate the following cash flows: a. If the firms cost of capital is 10 percent, should the investment be made? b. An alternative use for the $400,000 is a...
-
*#12.) The circumference of circle Z is 124 inches. Determine the diameter of the circle to the nearest whole number. a. 124 b. 39 C. 20 d. 19
-
To: All Employees From: B. A. Cartwright < [emailprotected] > Subject: Your Excessive Use of E-Mail! Attached: E-Mail and Internet Policy Once again I have the decidedly unpleasant task of rem...
-
igor's sister Olga wanted to help Igor so she invested $30,000 in the business. Olga wanted to participate in the profits but did not want to be involved in running the business. This is what kind of...
-
To oxidize acetaldehyde to acetic acid, the following reaction is carried out: 2CH3COH + O2 ---> 2CH3COOH. The reactor is fed with a stream of 62mol/h of CH3COH and the O2 is administered with a 120%...
-
TopMan sold of wood-based furniture to Kahn Design, Inc. a British firm, for 2,000,000. The Company has no other current foreign customers, so the currency risk of this sale is of particular concern....
-
Sharon was hired by the Beauty Mark Company to sell beauty products house to house in a certain town. Unknown to either Sharon or Beauty Mark, there is an ordinance required all salespersons to...
-
GIve the definition of all the following : cultural values, personal values, ethical principles, autonomy, integrity, social justice, human dignity, nonmaleficence, beneficence, justice, and veracity...
-
Explain Further and Give examples. Time-based strategies focus on reducing the time needed to conduct the various activities in a process. The rationale is that by reducing time, costs are generally...
-
Give the structural formulas of the alkenes that, on ozonolysis, give: a. (CH3)2C=O and CH2=O b. Only (CH3CH2)2C=O c. CH3CH=O and CH3CH2CH=O d. O=CHCH2CH2CH2CH=O
-
A company often test-markets a proposed product in a specific area or location. Suppose that you wish to test-market your new, revolutionary SuperWax car wax, which requires only one application for...
-
The idea for New Belgium Brewing Company began with a bicycling trip through Belgium, where some of the worlds finest ales have been brewed for centuries. As Jeff Lebesch, a U.S. electrical engineer,...
-
It is helpful to think of a total product offering as having a combination of three interdependent elements: the core product itself, its supplemental features, and its symbolic or experiential...
Study smarter with the SolutionInn App