United Healith Products has the following balance sheet:
Business has been slow; therefore, fixed assets are vastly underutilized. Management believes it
can double sales next year with the introduction of a new product. No new fixed assets will be
required, and management expects that there will be no earnings retained next year. What is next
year's external financing requirement?
ANSWER
Here is the forecasted balance sheet:
External financing requirement =
please answer with excel funtions for each highlighted area
United Health Products has the following balance sheet:
Current assets
$5,000
Accounts payable Notes payable Long-term debt Common equity
$1,000 $1,000 $4,000 $4,000
Net fixed assets
$5,000
Total liabilities and equity
Total assets
$10,000
$10,000
Business has been slow; therefore, fixed assets are vastly underutilized. Management believes it
can double sales next year with the introduction of a new product.No new fixed assets will be
required, and management expects that there will be no earnings retained next year. What is next
year's external financing requirement?
ANSWER
Here is the forecasted balance sheet:
Current assets
Accounts payable Notes payable Long-term debt Common equity
Net fixed assets
Total liabilities and equity
Total assets
External financing requirement =
