Question
L&L SkinCare's ending cash balance as of January 31, 2012 (the end of its fiscal year 2011) was $10,000. Its expected cash collections and payments
L&L SkinCare's ending cash balance as of January 31, 2012 (the end of its fiscal year 2011) was $10,000. Its expected cash collections and payments for the next six months are given in the following table.
Month | Collections | Payments |
February | $16,500 | $19,400 |
March | 18,300 | 20,800 |
April | 22,700 | 21,600 |
May | 29,100 | 24,300 |
June | 32,500 | 26,700 |
July | 36,000 | 27,200 |
a. Calculate the firm's expected ending cash balance for each month.
b. Assuming that the firm must maintain an ending cash balance of at least $9,000, how much must they borrow during each month?
c. If the firm must pay 5% annual interest on its short-term borrowing, how does this affect your ending cash balance calculations?
d. Finally, how would your ending cash balance change if the firm uses any cash in excess of the minimum to pay off its short-term borrowing in each month?
Please attach excel sheet with data/formulas and answer the short ended questions. Thanks!
Step 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