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 $8 Accounts payable $6
Accounts receivable 12 Accrued wages 5
Inventory 21 Accrued taxes 4
Current assets $41 Current liabilities $15
Capital assets 41 Long-term debt 15
Common stock 20
Retained earnings 32
Total assets $82 Total liabilities and shareholder's equity $82

The firm has an aftertax profit margin of 3 percent and a dividend payout ratio of 20 percent.

a. If sales grow by 10 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)  Accounts receivable  Prepaid expenses  Cash  Capital Asset  Inventory $ (Click to select)  Common stock  Accrued taxes  Retained earnings  Accrued wages  Accounts payable $
(Click to select)  Prepaid expenses  Cash  Accounts receivable  Inventory  Capital Asset (Click to select)  Accrued wages  Retained earnings  Accounts payable  Common stock  Long-term debt
(Click to select)  Cash  Gross plant  Prepaid expenses  Accounts receivable  Inventory (Click to select)  Accrued taxes  Retained earnings  Accounts payable  Common stock  Long-term debt
Current assets $ Current liabilities $
(Click to select)  Accrued wages  Cash  Capital Assets  Accounts Receivable  Inventory (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 $5 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