Calculate the firm''s expected ending cash balance

Reference no: EM131368396

Lakewood Laser 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.

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?

Reference no: EM131368396

Questions Cloud

Explain whether you agree with frankls opinion : Explain whether you agree with Frankl's opinion that it is important for a person to have the freedom to choose one's attitude in a given set of circumstances and to choose one's own way.

Summarize an article on muslim tourist perceived value : You need sumarry of an article on Muslim Tourist Perceived Value in the Hospitality and Tourism Industry

How do you think the five stages of group development : How do you think the five stages of group development (forming, storming, norming, performing, adjourning) will be different for virtual teams as compared to traditional teams?

Example of poor commenting : Identify the methods within the example program you believe are not sufficiently documented. Examine the control flow statements to determine what they do and if their purpose is clearly documented.

Calculate the firm''s expected ending cash balance : 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?

Analyze the inverted pyramid and its implications : Write the given essay assignment.- Analyze the inverted pyramid and its implications.

Demonstrate your knowledge and understanding of materials : Demonstrate your knowledge and understanding of the materials cited on the Background page. Supplement these with relevant sources you locate on the Web.

Create a cash budget for june to october 2012 : Create a cash budget for June to October 2012. The cash budget should account for short-term borrowing and payback of outstanding loans as well as the interest expense. The firm ended May with a $30,000 unadjusted cash balance.

Purpose and value to using arrays and functions : Describe the purpose and value to using arrays and functions in C++ programming.

User Account

All Pages