Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Garden Depot is a retailer that provided the following budgeted cash flows for next year: 3rd Quarter $ 350,000 $ 318,000 Total cash receipts Total

Garden Depot is a retailer that provided the following budgeted cash flows for next year: 3rd Quarter $ 350,000 $ 318,000 Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 300,000 $ 420,000 $ 358,000 $ 328,000 The company's beginning cash balance for next year will be $35,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 1st Quarter $ 0 0 0 0 4th Quarter $ 370,000 $ 338,000 $ 2nd Quarter 0 0 0 0 $ 3rd Quarter 0 0 0 0 $ 4th Quarter 0 0 0 0 Year
image text in transcribed
image text in transcribed
Garden Depot is a retailer that provided the following budgeted cash flows for next year: The company's beginning cash balance for next year will be $35,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. Garden Depot is a retailer that provided the following budgeted cash flows for next year: The company's beginning cash balance for next year will be $35,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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

My Adventures As An Auditor

Authors: Michael Quoter

1st Edition

1079508821, 978-1079508826

More Books

Students also viewed these Accounting questions

Question

Compare the different types of employee separation actions.

Answered: 1 week ago

Question

Assess alternative dispute resolution methods.

Answered: 1 week ago

Question

Distinguish between intrinsic and extrinsic rewards.

Answered: 1 week ago