Reference no: EM1355790
I have completed this assignment, but I wish to make sure I did everything correctly. The grade I will receive for this assignment is very important, because it will make me either pass this class with a good grade, or it will make me fail the class. Please help.
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.
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
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.
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.
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
6. (2 points)
Congratulations! 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.)
7. (2 points)
Table 8.1
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. (See Table 8.1.)