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 $ 440,000 1st Quarter 2nd Quarter 3rd Quarter $ 320,000 4th Quarter $ 372,000 $ 342,000 $ 370,000 $ 332,000 $ 390,000 $ 352,000 The company's beginning cash balance for the upcoming fiscal year will be $27,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 Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year 0 0 0 0 Excess (deficiency) of cash available over disbursements 0 0 0 0 Financing: Borrowings Repayments Interest Total financing Ending cash balance 0 0 0 0 $ 0 $ 0 $ 0 $ 0 The management of Mecca Copy, a photocopying center located on University Avenue, has compiled the following data to use in preparing its budgeted balance sheet for next year: Ending Balances Cash Accounts receivable ? $ 9,700 Supplies inventory Equipment Accumulated depreciation Accounts payable Common stock Retained earnings $ 3,800 $ 42,000 $ 17,000 $ 3,400 $ 5,000 ? The beginning balance of retained earnings was $33,000, net income is budgeted to be $16,900, and dividends are budgeted to be $3,500. Required: Prepare the company's budgeted balance sheet. (Amounts to be deducted should be Indicated by a minus sign.) Mecca Copy Budgeted Balance Sheet Current assets: Total current assets Plant and equipment: Assets Plant and equipment, net Total assets Current liabilities: Stockholders' equity: Liabilities and Stockholders' Equity $ 0 $ 0 0 Total stockholders' equity 0 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 $ 440,000 1st Quarter 2nd Quarter 3rd Quarter $ 320,000 4th Quarter $ 372,000 $ 342,000 $ 370,000 $ 332,000 $ 390,000 $ 352,000 The company's beginning cash balance for the upcoming fiscal year will be $27,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 Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year 0 0 0 0 Excess (deficiency) of cash available over disbursements 0 0 0 0 Financing: Borrowings Repayments Interest Total financing Ending cash balance 0 0 0 0 $ 0 $ 0 $ 0 $ 0 The management of Mecca Copy, a photocopying center located on University Avenue, has compiled the following data to use in preparing its budgeted balance sheet for next year: Ending Balances Cash Accounts receivable ? $ 9,700 Supplies inventory Equipment Accumulated depreciation Accounts payable Common stock Retained earnings $ 3,800 $ 42,000 $ 17,000 $ 3,400 $ 5,000 ? The beginning balance of retained earnings was $33,000, net income is budgeted to be $16,900, and dividends are budgeted to be $3,500. Required: Prepare the company's budgeted balance sheet. (Amounts to be deducted should be Indicated by a minus sign.) Mecca Copy Budgeted Balance Sheet Current assets: Total current assets Plant and equipment: Assets Plant and equipment, net Total assets Current liabilities: Stockholders' equity: Liabilities and Stockholders' Equity $ 0 $ 0 0 Total stockholders' equity 0
Expert Answer:
Answer rating: 100% (QA)
To prepare the companys cash budget for the upcoming fiscal year we need to calculate the total cash ... 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
-
Problem 14-15 Finding the WACC [LO3] You are given the following information for Lighting Power Company. Assume the company's tax rate is 25 percent. Debt: Common stock: Preferred stock: Market:...
-
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?
-
Use any method to determine if the series converges or diverges. Give reasons for your answer. n10 10" n=1
-
What aspect of the inventory audit is mandatory?
-
The information is provided regarding a company's December 31, 2010 defined benefit pension plan: Service...
-
Ansara Company sells two products, X and Y. Their unit contribution margins are \($52\) and \($70\). respectively, and their sales mix is 2:1. What is the weighted average unit contribution margin?
-
Assume the same information as in E14-3 except that the securities are classified as available-for-sale. The fair value of the bonds at December 31 of each year-end is as follows. Instructions (a)...
-
2. The demand for your cat paintings, in yearly sales, is q = -5p+140 if the selling price is Sp. You are able to create q = 3p-20 new paintings each year. (a) At what price should you sell your...
-
You, CPA, work as a consultant on various engagements. Your client, Over The Edge Ltd. (OTE), has grown from a small custom snowboard manufacturer servicing the local market to a multinational...
-
Ques-14 Mar 200 Which of the following would not be included in manufacturing overhead Select one O rent on the company's retail store insurance on inventory O rent on the company's factory...
-
Fill in the Blank. The Gaussian density function is a symmetric _____________ -shaped curve about the mean value.
-
An integration method in which the computation of \(x_{i+1}\) is based on the equilibrium equation at \(t_{i}\) is known as a. explicit method b. implicit method c. regular method
-
Fill in the Blanks. Numerical methods that require the use of a time step \((\Delta t)\) smaller than a critical value \(\left(\Delta t_{\text {cri }} ight)\) are said to be ______________ stable.
-
Enid operates an animal shelter as a sole proprietor which generates net revenue of $88,000. Enid has also made a self-employed health insurance payment of $6,000. What is Enids qualified business...
-
Does statelessness exist in wealthy countries such as the United States? How does the status of the "Dreamers" (people who entered the United States illegally as young children) compare with that of...
-
b. Prepare Southside's statement of activities for 2023 and its statement of financial position at December 31, 2023. Use a negative sign with an answer for net assets released from restrictions and...
-
Dan and Diana file a joint return. Dan earned $31,000 during the year before losing his job. Diana received Social Security benefits of $5,000. a. Determine the taxable portion of the Social Security...
-
How can a profitable business fail? a Because it can't pay its bills b Because it has more current liabilities than current assets c Because it has a bank overdraft d Because it has too much cash
-
When adjusting an operating profit to calculate the 'cash flows from operating activities', an increase in inventories over the financial period would be: a Added to operating profit b Ignored c...
-
Cash has been described as: a The lifebuoy of the business b The lifeboat of the business c The lifeline of the business d The lifeblood of the business
Study smarter with the SolutionInn App