Question
calculation of 3 quarters Jul, Aug, Sep Suppose if the excess balance for July under cash budget is 255242, August is 665832 and September is
calculation of 3 quarters Jul, Aug, Sep
Suppose if the excess balance for July under cash budget is 255242, August is 665832 and September is 714536
and according to the above adjustment it says the bank should have 1000000 minimum bank balance and all borrowings should be in multiples of 5000
so now using just these information can you help me in calculating just borrowings.( As per my calculation $1000000- 255242= 744758 but for borrowing should take in multiples of $5000 so 744758+5000= 749758 so should take only 749000 and remaining will go to cash balance)
Im not sure about this calculation whether I have to add $5000 or not can you help me in this?
For cash budget- under Borrowings
11. The company wants to maintain at the end of each month a minimum bank balance of $1,000,000. In case the company has a deficiency of money or is not able to reach this minimum bank balance, the company can borrow from a line of credit at the rate of 12% per annum. All borrowing is considered to happen on the first day of the month, and repayments are on the last day of the month. All borrowings and repayments from the bank should be in multiples of $5,000. It pays interest monthly. The cash balance on June 30 is $184,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started