Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Garden Depot in a rutaler that is preparing to budget for the upcoming focal year. Management has prepared the following ummary of to budgeted can

image text in transcribed
Garden Depot in a rutaler that is preparing to budget for the upcoming focal year. Management has prepared the following ummary of to budgeted can fows: Tuter $210.000 50.000 241.000 121.000 3.100.000 1240.000 $2618 The company's begiving cash balance for the upcoming focal year will be $20.000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank ata quarterly ime is repaid. For simplicity sure that interest is not compounded interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its or any part of its loans of the end of any quarter interest payments we due on any principal at the Required: Complete the company's cash budget for the upcoming fracal year. Cuah deficiency, repayments, and interest, should be indicated toy a minus sign.) Garden Depot Cash Budget tuturor 2nd Quarter Sed Quarter eth Quarter Year Beginning cashbance $ 26,000 $0.00 50,00 5.700 156,400 210,000 360 000 240.000 260,000 1.070.000 Total have 238.000 370.000 300.700 319,700 1.226.400 Less to cash disbursements 281.000 251.000 241.000 1,034.000 Excess deficiency of cash avbe over disbursements (45,000) 119,000 59.700 192.400 58.700 Borrowing Repayment 55.000 55,000 55.000 55.000 3,300 3.300 55,000 58,300 0 113.300 $10.000 $ 177300 $59.700 $ 58.700 505,700 Ending cash balance

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

Count Down The Past, Present And Uncertain Future Of The Big Four Accounting Firms

Authors: Jim Peterson

2nd Edition

1787147010, 9781787147010

More Books

Students also viewed these Accounting questions

Question

What is one of the skills required for independent learning?Explain

Answered: 1 week ago