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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6653b276e6214_2066653b2766f932.jpg)
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 1st Quarter 2nd Quarter 3rd Quarter $ 260,000 4th Quarter $ 410,000 $ 286,000 $ 290,000 $ 276,000 $ 310,000 $ 296,000 Total cash disbursements $ 316,000 The company's beginning cash balance for the upcoming fiscal year will be $36,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 and interest 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 1st Quarter 2nd Quarter 3rd Quarter $ 260,000 4th Quarter $ 410,000 $ 286,000 $ 290,000 $ 276,000 $ 310,000 $ 296,000 Total cash disbursements $ 316,000 The company's beginning cash balance for the upcoming fiscal year will be $36,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 and interest 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
-
Tandy, Incorporated, was issued a charter on January 15, 2014, that authorized the following capital stock: Common stock , no-par, 103,000 shares Preferred stock, 9 percent, par value $8 per share,...
-
The following two companies Alpha Industries and Beta Industries operate in the same industrial sector. You have extracted the following ratios from their accounts. Alpha Return on capital employed...
-
Beene Distributing is considering a project that will return $150,000 annually at the end of each year for six years. If Beene demands an annual return of 7% and pays for the project immediately, how...
-
In month 9 the following project information is available: actual cost is $2,000, earned value is $2,100, and planned cost is $2,400. Compute the SV and CV for the project.
-
Alpha Corporation manufactures car tyres. Alpha Corporationss accounting records show: $300 000 direct labour for the month to 31 January 2020 $400 000 direct materials purchased for the month to 31...
-
Article: https://bmcnurs.biomedcentral.com/articles/10.1186/s12912-023-01443-1 Questions List the statistical procedures performed to describe the sample or demographic variables. List the...
-
2.11.2Project:Performance Task: The Parallax Problem Project Geometry Sem 1 (S3537251) Julio Duenas Points possible:120 Date: ____________ The Scenario:You're looking for a sponsor to pay for you to...
-
If the most common treatment of assigning overapplied overhead was used, the final balance in Cost of Goods Sold would have been * (1 Point) At the end of the last fiscal year, BREAD Company had the...
-
Angelina received new word processing software for her birthday. She also received a cheque with which she intends to purchase a new computer. Angelina's UNILUS Professor assigned a paper due in two...
-
At date t, the portfolio P to be hedged is a portfolio of Treasury bonds with various possible maturities. Its characteristics are as follows: Value YTM MD Convexity $1,450 6% 4.25 55 We consider...
-
A playground merry-go-round with an axis at the center (radius R = 1.3 m and rotational inertia | = 1.2 x 103 kgm2) is initially rotating at angular velocity w = 0.21 rad/s clockwise). A girl of mass...
-
Benson Auto Repair, Inc. is evaluating a project to purchase equipment that will not only expand the companys capacity but also improve the quality of its repair services. The board of directors...
-
Show how the results for CARA utility and CRRA utility stated in Section 7.5 generalize to economies with more than two individuals.
-
(Use a spreadsheet or similar computational tool.) Consider a one-period economy with 5 possible states and 5 assets traded. The state-contingent dividends and prices of the assets and the state...
-
George and John live in a continuous-time economy in which the relevant uncertainty is generated by a one-dimensional standard Brownian motion z = (zt)t[0,T]. Both have time-additive utility of their...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App