Calculate the firm cash conversion cycle


Problem 1:

Key Financial Data

 

Dreamscape, Inc.

Industry Average

Ratio

For the Year Ended

For the Year Ended

(% of Sales)

December 31, 2004

December 31, 2005

Cost of goods sold

74.5%

70.0%

Gross profits

25.5

30.0

Selling expense

8.0

7.0

Gen. & admin. expense

5.1

4.9

Depreciation expense

2.4

2.0

Total operating expense

15.5

13.9

Operating profits

10.0

16.1

Interest expense

1.4

1.0

Net profits before taxes

8.6

15.1

Taxes

2.4

6.0

Net profits after taxes

5.2

9.1

 

Income Statement, Dreamscape, Inc.
For the Year Ended December 31, 2005

Sales revenue

 

$1,000,000

Less: Cost of goods sold

 

750,000

Gross profits

 

$ 250,000

Less: Operating expenses

 

 

Selling Expense

$70,000

 

Gen. & admin. expense

48,000

 

Depreciation expense

20,000

 

Total operating expense

 

$ 138,000

Operating profits

 

$ 112,000

Less: Interest expense

 

$ 20,000

Net profits before taxes

 

$ 92,000

Less: Taxes

 

$ 36,800

Net profits after taxes

 

$ 55,200

Prepare a common size income statement for Dreamscape, Inc. for the year ended December 31, 2005. Evaluate the company’s performance against industry average ratios and against last year’s results.
 
Problem 2.

In an effort to analyze Clockwork Company finances, Jim realized that he was missing the company’s net profits after taxes for the current year. Find the company’s net profits after taxes using the following information.

Return on total assets = 2%
Total Asset Turnover = 0.5
Cost of Goods Sold = $105,000
Gross Profit Margin = 0.30

Problem 3.

Minny Fishing Products is analyzing the performance of its cash management. On the average, the firm holds inventory 65 days, pays its suppliers in 35 days, and collects its receivables in 15 days. The firm has a current annual outlay of $1,960,000 on operating cycle investments. Minny currently pays 10 percent for its negotiated financing. (Assume a 360 day year.)

(a) Calculate the firm’s cash conversion cycle.

(b) Calculate the firm’s operating cycle.

(c) Calculate the daily expenditure and the firm’s annual savings if the operating cycle is reduced by 15 days.

Problem 4.

A firm has arranged for a lockbox system to reduce collection time of accounts receivable. Currently the firm has an average collection period of 43 days, an average age of inventory of 50 days, and an average payment period of 10 days. The lockbox system will reduce the average collection period by three days by reducing processing, mail, and clearing float. The firm has total annual outlays of $15,000,000 and currently pays 9 percent for its negotiated financing.

(a) Calculate the cash conversion cycle before and after the lockbox system.

(b) Calculate the savings in financing costs from the lockbox system.

Problem 5.

You are considering the purchase of new equipment for your company and you have narrowed down the possibilities to two models which perform equally well. However, the method of paying for the two models is different. Model A requires $5,000 per year payment for the next five years. Model B requires the following payment schedule. Which model should you buy if your opportunity cost is 8 percent?

Year

Payment (Model B)

  1

$7,000

  2

6,000

  3

5,000

  4

4,000

  5

3,000


Problem 6.

You have just won the lottery! However, the lottery bureau has just informed you that you can take your winnings in one of two ways. Choice X pays $1,000,000. Choice Y pays $1,750,000 at the end of five years from now. Using a discount rate of 5 percent, based on present values, which would you choose? Using the same discount rate of 5 percent, based on future values, which would you choose? What do your results suggest as a general rule for approaching such problems? (Make your choices based purely on the time value of money.)

Problem 7.

 

Plan 1

Plan 2

Interest Expense

$25,000

$50,000

Preferred Dividend

$3,000

$1,500

Common Shares Outstanding

200,000

100,000


What is the degree of financial leverage at a base level EBIT of $120,000 for both financing plans? The firm has a 40 percent tax rate.

Solution Preview :

Prepared by a verified Expert
Finance Basics: Calculate the firm cash conversion cycle
Reference No:- TGS01837605

Now Priced at $30 (50% Discount)

Recommended (93%)

Rated (4.5/5)