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 $ 330,000 $ 450,000 $ 379,000 $ 349,000 $ 380,000 $ 339,000 $ 400,000 $ 359,000 The company's beginning cash balance for the upcoming fiscal year will be $22,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.) Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Beginning cash balance Total cash receipts $ 22,000 $ 10,000 330,000 450,000 380,000 400,000 Total cash available 352,000 460,000 380,000 400,000 Total cash disbursements 379,000 349,000 339,000 359,000 Excess (deficiency) of cash available over disbursements (27,000) 111,000 41,000 41,000 Financing: Borrowings Repayments Interest Total financing Ending cash balance 0 0 $ (27,000) $ 111,000 $ 69 0 41,000 0 $ 41,000 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 $ 330,000 $ 450,000 $ 379,000 $ 349,000 $ 380,000 $ 339,000 $ 400,000 $ 359,000 The company's beginning cash balance for the upcoming fiscal year will be $22,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.) Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Beginning cash balance Total cash receipts $ 22,000 $ 10,000 330,000 450,000 380,000 400,000 Total cash available 352,000 460,000 380,000 400,000 Total cash disbursements 379,000 349,000 339,000 359,000 Excess (deficiency) of cash available over disbursements (27,000) 111,000 41,000 41,000 Financing: Borrowings Repayments Interest Total financing Ending cash balance 0 0 $ (27,000) $ 111,000 $ 69 0 41,000 0 $ 41,000
Expert Answer:
Answer rating: 100% (QA)
To prepare Garden Depots cash budget for the upcoming fiscal year well start with the beginning cash balance and then calculate the cash receipts 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
-
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...
-
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...
-
(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...
-
Which of the following variables was controlled in Experiment 1? F. Amount of yeast G. Percent of molasses H. Percent of sucrose J. Carbon dioxide levels Experiment 1 Since yeast needs sucrose to...
-
Which of the following ketones has the largest equilibrium constant for the addition of water? CH3O OCH3 O2N NO2
-
Which of the following organizations was tasked to develop and prescribe standards and guidelines that apply to federal information systems? A. NIST B. FISMA C. Congress D. PCI SSC E. U.S. Department...
-
Sigma Energy is an alternative energy company that produces solar energy panels. The company is expected to generate $50 million in after-tax operating income in the next year, but its prospects for...
-
Jeter Co. uses a perpetual inventory system and both an accounts receivable and an accounts payable subsidiary ledger. Balances related to both the general ledger and the subsidiary ledger for Jeter...
-
Could you help with this problem? Step by step instructions would be helpful.. Total costs and expenses $ 1,831 $ Operating Income 279 Interest expense 34 Earnings before Income Taxes $ 245 $...
-
Mags Ltd is an Australian mail-order company. Although the sector in Australia is growing slowly, Mags Ltd has reported significant increases in sales and net income in recent years. Sales increased...
-
Question 1 A propped cantilever beam is loaded by a bending moment of the magnitude MB at the point B as shown in Figure Q1. The cross-section of the beam is a rectangle of the width w and the hight...
-
Did you achieve your goals? Why or why not? What issues covered in this course have been most valuable? What did you learn? Why was it important to you and how has it changed the way you lead or plan...
-
1. Quarterly % change Review the following chart from Statistics Canada. 4 3 2 1 O 1 N -3 -4 -5 6 Figure 1. Hours worked in Canadian businesses, quarterly % change IV-2015 DESCRIBING DATA...
-
B. Yummy Bakery is a small business owned by Puan Anilza operated in Lumut, Perak producing cakes and buns. The owner wants to expand the business at Pangkor Island due to high demand during festive...
-
describe in detail areas identified for future research in the field of health psychology. Describe whether or not these areas of research are related to your future career and why. Next, briefly...
-
Financial statement data for the years 20Y5 and 20Y6 for Black Bull Inc. follow: Net income Preferred dividends Average number of common shares outstanding 20Y5 20Y6 $1,506,000 $2,545,500 $50,000...
-
What is the leadership paradox? Give some reasons why you think a leader can encounter difficulty in newly formed teams or groups using a participative management system. What skills, behaviors, and...
-
An 8.0 kg crate is pulled 5.0 m up a 30 incline by a rope angled 18 above the incline. The tension in the rope is 120 N, and the crates coefficient of kinetic friction on the incline is 0.25. a. How...
-
In eight years, Kent Duncan will retire. He is exploring the possibility of opening a self-service car wash. The car wash could be managed in the free time he has available from his regular...
-
Harrison Company makes two products and uses a traditional costing system in which a single plantwide predetermined overhead rate is computed based on direct labor-hours. Data for the two products...
-
Are selling and administrative expenses treated as product costs or as period costs under variable costing?
-
Explain the difference between a deferred tax liability and a deferred tax asset.
-
How are deferred tax accounts presented on the balance sheet?
-
Suppose Wilson Company has one item that gives rise to a temporary difference and that item is expected to continue indefinitely. Specifically, Wilson prepays the following year's annual rent of \(\$...
Study smarter with the SolutionInn App