Total cash receipts Total cash disbursements 1st Quarter $ 350,000 $ 393,000 2nd Quarter $ 470,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Total cash receipts Total cash disbursements 1st Quarter $ 350,000 $ 393,000 2nd Quarter $ 470,000 $ 363,000 3rd Quarter $ 400,000 4th Quarter $ 420,000 $ 353,000 $ 373,000 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 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. Note: 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 Total cash receipts Total cash disbursements 1st Quarter $ 350,000 $ 393,000 2nd Quarter $ 470,000 $ 363,000 3rd Quarter $ 400,000 4th Quarter $ 420,000 $ 353,000 $ 373,000 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 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. Note: 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
-
Indigo Corporation is a diversified company that operates in five different industries: A, B, C, D, and E. The following information relating to each segment is available for 2026. A B C D E Sales...
-
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...
-
(4 points) Tom Cruise Company has provided the following information for the year ended December 31, 2023: Cash proceeds from loan from bank, $29,000 Cash purchase of treasury stock, $11,000 Cash...
-
Scott and Associates, Inc., is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on the different backgrounds and experiences of the leaders,...
-
Technology Parts Inc. is a wholesaler of computer hardware components. The company purchases inventory items in bulk directly from parts manufacturers and sells the parts to computer and other...
-
Is a countrys culture more likely to be reflected in its art museums or its television commercials? Why?
-
PA Chemical currently discharges liquid waste into Pittsburghs municipal sewer system. However, the Pittsburgh municipal government has informed PA that a surcharge of \($5\) per thousand cubic...
-
Refer to the financial statements for Gilsig Inc. in Problem 12-77A. In problem Gilsig Inc. owns and operates a small chain of sportswear stores located near colleges and universities. Gilsig has...
-
Decision on Transfer Pricing Materials used by the Instrument Division of XPort Industries are currently purchased from outside suppliers at a cost of $359 per unit. However, the same materials are...
-
Describe the term Unified Modeling Language (UML) and explain its benefits and challenges. Choose a class example and draft a UML diagram that shows the inheritance relationship.
-
QUESTION ASSETS Cash Accounts Receivable Inventory Property, plant & equipment Total Assets Notes 1. 2. 3. 4. Hawthorn Manufacturing Company Ltd Balance Sheet as at 31/12/19 6. 150 200 640 1.120...
-
Consider the following pool of mortgages: 100 mortgages with initial balance of $118,580, interest rate 4.7%, issued for 30 years with monthly payments 80 mortgages with initial balance of $354,365,...
-
Write the program in c + + ?using include iostream and namespace and do not use global varients. Explain your code and use comments and write the code in simple terms to understand and easy to read....
-
Providing mental health services is an important component of any effort to reduce gun violence in a healthcare facility, what are the prevention the facility can take in order to reduce gun violence...
-
The last thing you need is the values of penalty you are trying. This can be created using grid _ regular ( ) which creates a grid of evenly spaces parameter values. You use the penalty ( ) function...
-
Find an interesting article that concerns a case where a high profile individual was found inadmissible when seeking entry to a country (doesn't have to be Canada). Discuss the merits of the refusal...
-
In Exercises discuss the continuity of each function. f(x) -3 1 x - 4 y 3 2 -1 -2 -3+ 3 X
-
Lieberman Clothing Company manufactures its own designed and labeled sports attire and sells its products through catalog sales and retail outlets. While Lieberman has for years used activity-based...
-
Alpha-Alpha Inc. produces meat products. Suppose one of the companys plants processes beef cattle into various products. For simplicity, assume that there are only three productssteak, hamburger, and...
-
A cable television network is considering cancelling the program Law and Order because it is watched by only 2.3 percent of the audience in its Monday evening time slot. It would be replaced by...
Study smarter with the SolutionInn App