What is maximum amount of short-term loan the firm

Assignment Help Financial Management

Reference no: EM131521989

A firm estimates sales of $150,000 in December, $175,000 in January; $125,000 in February, $200,000 in March, $250,000 in April; $180,000 in May; and $200,000 in June. November sales were $125,000. The firm typically collect 20% of its sales in cash; 50% are accounts receivable paid the month after the sale; and 30% are accounts receivable paid two months after the sale. The firm’s cost of goods sold (raw materials) amounts to 70% of its sales. The raw materials are ordered two months in advance of expected sales, but are paid for one month after they are ordered. The firm has fixed costs of $3,000 per month for rent and $12,000 per month for other fixed operating costs. The firm has $30,000 per month in salary expense. Assume a starting cash balance of $0 but a minimum cash balance of $10,000 going forward. Prepare the cash budget for January through April. What is the maximum amount of short-term loan the firm will need during the relevant time period?

Reference no: EM131521989

Questions Cloud

Describe self-managed work groups : Describe self-managed work groups and the situations for which they are best suited. Discuss Deming's influence on this approach

Compare strengths and weaknesses of analytical approaches : Compare and contrast the strengths and weaknesses of the engineering and analytical approaches to hazard avoidance.

Respect to glucose homeostasis : How do liver and muscle cells differ with respect to glucose homeostasis and their ability to breakdown and utilize "stored glycogen."

Excluding any unemployment taxes : Total payroll costs to the company for this pay period, excluding any unemployment taxes, was:

What is maximum amount of short-term loan the firm : What is the maximum amount of short-term loan the firm will need during the relevant time period?

Find out what microbe is causing a disease outbreak : What data would you want to include? How would you control your variables? Find out what microbe is causing a disease outbreak.

Describe the current state of labor : Describe the current state of labor (for example, shortage, surplus). Identify and describe the recruiting policies

Discuss the components of content marketing : Discuss the components of content marketing and how each component contributes to the integrated marketing communications (IMC).

Why is it more sensible for phosphofructokinase : 1. Why is it more sensible for phosphofructokinase, rather than hexokinase, to be an important control step?

User Account

All Pages