Question

In: Accounting

Cholesterol Dairy Products has plants in five provinces and operates a very large home delivery service....

Cholesterol Dairy Products has plants in five provinces and operates a very large home delivery service. Sales last year were $100 million, and the balance sheet at year-end is similar in percent of sales to that of previous years (and this will continue in the future). All assets and current liabilities will vary directly with sales. Assume the firm is already using capital assets at full capacity.

Balance Sheet
(in $ millions)
Assets Liabilities and Shareholders' Equity
Cash $5 Accounts payable $6
Accounts receivable 10 Accrued wages 4
Inventory 25 Accrued taxes 2
Current assets $40 Current liabilities $12
Capital assets 40 Long-term debt 15
Common stock 20
Retained earnings 33
Total assets $80 Total liabilities and shareholder's equity $80

The firm has an aftertax profit margin of 8 percent and a dividend payout ratio of 25 percent.

a. If sales grow by 20 percent next year, determine how many dollars of new funds are needed to finance the expansion. (Enter the answer in millions. Round the final answer to 3 decimal places.)

The firm needs $  million in external funds.

b. Prepare a pro forma balance sheet with any financing adjustment made to long term debt. (Input all answers as positive values. Be sure to list the assets and liabilities in order of their liquidity. Enter the answers in millions. Round the final answers to 3 decimal places.)

Balance Sheet
($ millions)
Assets Liabilities and Shareholders' Equity
Current assets Current liabilities
  (Click to select)   Inventory   Capital Asset   Cash   Accounts receivable   Prepaid expenses $   (Click to select)   Retained earnings   Accounts payable   Common stock   Accrued wages   Accrued taxes $
  (Click to select)   Inventory   Accounts receivable   Cash   Capital Asset   Prepaid expenses   (Click to select)   Accrued wages   Retained earnings   Accounts payable   Common stock   Long-term debt
  (Click to select)   Prepaid expenses   Cash   Accounts receivable   Inventory   Gross plant   (Click to select)   Accrued taxes   Retained earnings   Accounts payable   Common stock   Long-term debt
Current assets $ Current liabilities $
  (Click to select)   Accrued wages   Accounts Receivable   Inventory   Capital Assets   Cash   (Click to select)   Long-term debt   Accrued wages   Accounts payable   Accrued taxes
  (Click to select)   Common stock   Accrued wages   Accounts payable   Accrued taxes $
  (Click to select)   Retained earnings   Accrued wages   Accounts payable   Accrued taxes
Total assets $

Total liabilities and shareholders' equity

$

c. Calculate the current ratio and total debt to assets ratio for each year. (Round the final answers to 2 decimal places.)

Year 1 Year 2
Current ratio X X
Total debt / assets % %

Solutions

Expert Solution


Related Solutions

Cholesterol Dairy Products has plants in five provinces and operates a very large home delivery service....
Cholesterol Dairy Products has plants in five provinces and operates a very large home delivery service. Sales last year were $100 million, and the balance sheet at year-end is similar in percent of sales to that of previous years (and this will continue in the future). All assets and current liabilities will vary directly with sales. Assume the firm is already using capital assets at full capacity. Balance Sheet (in $ millions) Assets Liabilities and Shareholders' Equity Cash $8 Accounts...
Cholesterol Dairy Products has plants in five provinces and operates a very large home delivery service....
Cholesterol Dairy Products has plants in five provinces and operates a very large home delivery service. Sales last year were $100 million, and the balance sheet at year-end is similar in percent of sales to that of previous years (and this will continue in the future). All assets and current liabilities will vary directly with sales. Assume the firm is already using capital assets at full capacity. Balance Sheet (in $ millions) Assets Liabilities and Shareholders' Equity Cash $5 Accounts...
Cassius Clay operates a bituminous coal home heating and delivery service in Dauphin and Center counties....
Cassius Clay operates a bituminous coal home heating and delivery service in Dauphin and Center counties. He must have a supply of bituminous coal on hand so customers may get the coal they need to heat their homes. As a convenience to his customers, and to prevent high bills over the winter and low bills in the summer, he allows them to buy coal in advance at set prices and to pay for the coal ratably over a calendar year....
Cassius Clay operates a bituminous coal home heating and delivery service in Dauphin and Center counties....
Cassius Clay operates a bituminous coal home heating and delivery service in Dauphin and Center counties. He must have a supply of bituminous coal on hand so customers may get the coal they need to heat their homes. As a convenience to his customers, and to prevent high bills over the winter and low bills in the summer, he allows them to buy coal in advance at set prices and to pay for the coal ratably over a calendar year....
Rostand Inc. operates a delivery service for over 70 restaurants. The corporation has a fleet of...
Rostand Inc. operates a delivery service for over 70 restaurants. The corporation has a fleet of vehicles and has invested in a sophisticated, computerized communications system to coordinate its deliveries. Rostand has gathered the following actual data on last year’s delivery operations: Deliveries made 38,600 Direct labor 31,000 direct labor hours @ $14.00 Actual variable overhead $157,700 Rostand employs a standard costing system. During the year, a variable overhead rate of $5.10 per hour was used. The labor standard requires...
(TCO C) John operates a small business out of his home and has very little in...
(TCO C) John operates a small business out of his home and has very little in terms of fixed costs. Answer the next questions (Parts A and B) on the basis of the following cost data for John’s firm operating in pure competition. (20 points) Output TFC TVC 0 $30.00 0.00 1 $30.00 70.00 2 $30.00 120.00 3 $30.00 150.00 4 $30.00 200.00 5 $30.00 270.00 6 $30.00 360.00 (Part A) Refer to the above data. If the product price...
Fixed Overhead Variances Rostand Inc. operates a delivery service for over 70 restaurants. The corporation has...
Fixed Overhead Variances Rostand Inc. operates a delivery service for over 70 restaurants. The corporation has a fleet of vehicles and has invested in a sophisticated, computerized communications system to coordinate its deliveries. Rostand has gathered the following actual data on last year’s delivery operations: Deliveries made 38,600 Direct labor 31,000 direct labor hours @ $14.00 Actual variable overhead $157,700 Rostand employs a standard costing system. During the year, a variable overhead rate of $5.10 per hour was used. The...
Manzeck Company operates a snow-removal service. The company owns five trucks, each of which has a...
Manzeck Company operates a snow-removal service. The company owns five trucks, each of which has a snow plow in the front to plow driveways and a snow thrower in the back to clear sidewalks. Because plowing snow is very tough on trucks, the company incurs significant maintenance costs. Truck depreciation and maintenance represents a significant portion of the company’s overhead. The company removes snow at residential locations, in which case the drivers spend the bulk of their time walking behind...
Name five (5) principles of person-centered care (PCC) service delivery
Name five (5) principles of person-centered care (PCC) service delivery
The Versatech Corporation has decided to produce three new products. Five branch plants now have excess...
The Versatech Corporation has decided to produce three new products. Five branch plants now have excess production capacity. The unit manufacturing cost of the first product would be $31, $29, $32, $28, and $29 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the second product would be $45, $41, $46, $42, and $43 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the third product would be $38, $35,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT