tis a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary ed cash flows: receipts disbursements 1st Quarter $ 180,000 $ 260,000 ash balance eceipts vailable 2nd Quarter $ 330,000 $ 230,000 's beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance nd may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any e beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments ny principal at the time it is repaid. For simplicity, assume that interest is not compounded. lisbursements iciency) of cash available over disbursements 3rd Quarter $ 210,000 $ 220,000 company's cash budget for the upcoming fiscal year. (Repayments, interest, and cash deficiencies should be indicated sign.) 4th Quarter $ 230,000 $ 240,000 Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ $ 20,000 $ 180,000 200,000 60,000 140,000 10,000 $ 330,000 340,000 230,000 110,000 35,800 210,000 245,800 220,000 25,800 25,800 230,000 255.800 240,000 15,800 $ Year 20,000 950,000 970.000 950,000 20,000

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It…

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future…