Garden Depot is a retailer that provided the following budgeted cash flows for next year: 3rd Quarter $ 220,000 $ 227,000 Total cash receipts Total cash disbursements 1st Quarter $ 190,000 $ 267,000 2nd Quarter $ 340,000 $ 237,000 The company's beginning cash balance for next year will be $22,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, interest, and cash deficiencies should be indicated by a minus sign. 4th Quarter $ 240,000 $ 247,000 Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Garden Depot is a retailer that provided the following budgeted cash flows for next year:
3rd Quarter
$ 220,000
$ 227,000
Total cash receipts
Total cash disbursements
1st Quarter 2nd Quarter
$ 190,000 $ 340,000
$ 267,000 $ 237,000
The company's beginning cash balance for next year will be $22,000. The company requires a minimum cash balance of $10,000 and
may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments,
based on a quarterly interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not
compounded.
Required:
Prepare the company's cash budget for next 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
4th Quarter
$ 240,000
$ 247,000
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Year
Transcribed Image Text:Garden Depot is a retailer that provided the following budgeted cash flows for next year: 3rd Quarter $ 220,000 $ 227,000 Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 190,000 $ 340,000 $ 267,000 $ 237,000 The company's beginning cash balance for next year will be $22,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded. Required: Prepare the company's cash budget for next 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 4th Quarter $ 240,000 $ 247,000 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education