Get the best answers to your questions with the help of IDNLearn.com's experts. Join our Q&A platform to access reliable and detailed answers from experts in various fields.
Sagot :
Answer:
Mike's Motors Corp.
Cash Budget
July August September
Beginning balance $41,000 $30,000 $30,000
Cash receipts 92,000 118,000 157,000
Total cash available $133,000 $148,000 $187,000
Cash payments 120,000 106,900 134,400
Interest/Loan repayment 11,100 6,602
Cash balance 13,000 30,000 45,998
Cash to borrow 17,000 0 0
Minimum cash balance $30,000 $30,000 $30,000
Explanation:
a) Data and Calculations:
Minimum cash balance = $30,000
Interest rate on borrowings = 3% per month
Beginning cash balance = $41,000
Cash Budget
July August September
Beginning balance $41,000 $30,000 $30,000
Cash receipts 92,000 118,000 157,000
Total cash available $133,000 $148,000 $187,000
Cash payments 120,000 106,900 134,400
Interest/Loan repayment 11,100 6,602
Cash balance 13,000 30,000 45,998
Cash to borrow 17,000 0 0
Minimum cash balance 30,000 30,000 30,000
Loan repayment:
In August:
Interest is paid = $510 ($17,000 * 3%)
Loan is repaid = 10,590
Total paid = $11,100
Balance of loan unpaid = $6,410 ($17,000 - 10,590)
In September:
Interest on loan = $192 ($6,410 * 3%)
Loan repaid = 6,602 ($6,410 + 192)
Thank you for using this platform to share and learn. Don't hesitate to keep asking and answering. We value every contribution you make. Thank you for visiting IDNLearn.com. We’re here to provide accurate and reliable answers, so visit us again soon.