A company has the following excess (deficiency) of cash receipts over cash disbursements projected for the next year on a quarterly basis. It will not have any cash at the start of the year. The quarterly interest rate is 2%, and any borrowing and repayment of principal must be in round $1.000 amounts. There is no cash reserve requirement. Assume borrowings and repayments of principal are in round $1,000 amounts Exoess (deficiency) of cash available s (121,140) (41,680) 177,680 2,160 $ 17,020 Prepare a cash budget by quarter and for the year. (Any " indicated by a minus sign.) Repayments" and "Interest" should be Cash Budget For the Year Ended December 31, 20x1 Cash balance, beginning Excess (deficiency) of cash available over disbursements Cash balance before reserve requirement Balance available for repayment (required borrowing) S sso Amount borrowed eegmng of penod Principal repaid nterest paid Total fnancing (or repayments for the period) Cash balance after financing-Free cash balance Cash balance, ending MacBook 20 2 4