Question: Given the following information, construct Mark Finance Co . s cash budget for the given months and answer the questions. All sales are for credit
Given the following information, construct Mark Finance Cos cash budget for the given months and answer the questions.
All sales are for credit and collections occur after days.
A $ Treasury bill matures in March.
Monthly fixed disbursements are $
Variable disbursements are percent of sales and occur one month prior to sales. Variable cash disbursements are given for April.
A tax payment of $ is due in April.
A payment of $ is to be received in February.
The initial cash is $
The minimum required cash balance is $
January February March April
Sales $ $ $
Cash Sales
Collections
Other Receipts
Total Cash Receipts
Variable Disbursements $
Fixed Disbursements
Other Disbursements
Total Cash Disbursements
Net Change During the Month
Beginning Cash $
Ending Cash
Required Cash $
Excess Cash to Invest
Cash Borrowed
a At the end of March, what are the firms accounts receivable, marketable securities and accounts payable?
b What is the maximum amount that the firm may have to borrow? If your answer is None give a reason that verifies your answer.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
