Question

Brandywine Clinic (a not-for-profit provider) has the following balance sheet (in millions): Cash $20 Accounts payable...

Brandywine Clinic (a not-for-profit provider) has the following balance sheet (in millions): Cash $20 Accounts payable $20 Receivables 20 Notes payable 40 Inventory 20 Long-term debt 80 Plant/Equipment 180 Equity (fund) capital 100 Total assets $240 Total claims $240 Revenues for the past year were $400, and fixed assets were used at 100 percent of capacity. Revenues are expected to grow by 10 percent in the coming year, and the clinic is expected to have a 5 percent profit margin. What is the clinic’s forecasted external financing requirement (in millions)?

Homework Answers

Answer #1

External Funds Needed = (A0/S0*(S1-S0)) - (L0/S0*(S1-S0)) - (PM*S1*b)

where

Ao - Assets (at time 0) which vary directly with Sales = 240 millions

Lo - Liabilities (at time 0) which vary directly with Sales=20 millions ( Accounts payable)

So - Current Sales = 400 millions

S1 - Projected Sales = 400 millions *1.1 = 440 millions

b - Retention ratio = 100% (as the clinic is a not-for-profit provider)

PM - Profit Margin = 5%

External Funds Needed = (240/400*(440-400)) - (20/400*(440-400)) - (.05*440*1)

= 24-2-22

= 0 millions

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
For the next two questions suppose the following balance sheet: Cash $20 Accounts payable $30 Short-term...
For the next two questions suppose the following balance sheet: Cash $20 Accounts payable $30 Short-term inevstments 20 Accruals 50 Accounts receivable 50 Notes payable 10 Inventory 60      Current liabilities 100      Current assets 160 Long-term debt 70 Net fixed assets 100 Common equity 30 Retained earnings 60 Total assets 250 Total liab. & equity $250 What is its total net operating working capital? $40 $50 $60 $130 $160 What is its total net operating capital? $140 $150 $160...
#4. Profit margin a). Your company had the following balance sheet and income statement information for...
#4. Profit margin a). Your company had the following balance sheet and income statement information for 2002: Balance Sheet: Cash $ 20 A/R 1,000 Inventories 5,000 Total current assets $6,020 Debt $4,000 Net fixed assets 2,980 Equity 5,000 Total assets $9,000 Total claims $9,000 Income Statement: Sales $10,000 Cost of goods sold 9,200 EBIT $ 800 Interest (10%) 400 EBT $ 400 Taxes (40%) 160 Net income $ 240 \ The industry average inventory turnover is 5. You think you...
Balance Sheet Cash&MS- 30,000 Accruals- 20,000 Receivables- 70,000 Accounts Payable- 60,000 Inventories- 120,000 Notes Payable- 80,000...
Balance Sheet Cash&MS- 30,000 Accruals- 20,000 Receivables- 70,000 Accounts Payable- 60,000 Inventories- 120,000 Notes Payable- 80,000 Fixed Assets- 480,000 L-T Liabilities- 140,000 Total Assets= 700,000 Common Equity- 400,000 Annual Sales- 1,400,000 Cost of Goods Sold- 960,000 Net Income- 63,000 Number of Shares Outstanding- 30,000 What is the current ratio, debt ratio, total asset turnover ratio of the firm? What is the days sales outstanding (DSO) of the firm? (Use a 360-day year.) What is the profit margin of the firm?...
Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed...
Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed assets 1,875,000 Notes payable 750,000 Subordinated debentures 750,000 Total debt $1,875,000 Common equity 1,875,000 Total assets $3,750,000 Total liabilities and equity $3,750,000 The trustee's costs total $239,500, and the firm has no accrued taxes or wages. Southwestern has no unfunded pension liabilities. The debentures are subordinated only to the notes payable. If the firm goes bankrupt and liquidates, how much will each class of...
Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed...
Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed assets 1,875,000 Notes payable 750,000 Subordinated debentures 750,000 Total debt $1,875,000 Common equity 1,875,000 Total assets $3,750,000 Total liabilities and equity $3,750,000 The trustee's costs total $296,250, and the firm has no accrued taxes or wages. Southwestern has no unfunded pension liabilities. The debentures are subordinated only to the notes payable. If the firm goes bankrupt and liquidates, how much will each class of...
Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed...
Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed assets 1,875,000 Notes payable 750,000 Subordinated debentures 750,000 Total debt $1,875,000 Common equity 1,875,000 Total assets $3,750,000 Total liabilities and equity $3,750,000 The trustee's costs total $221,500, and the firm has no accrued taxes or wages. Southwestern has no unfunded pension liabilities. The debentures are subordinated only to the notes payable. If the firm goes bankrupt and liquidates, how much will each class of...
Problem 24-01 Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable...
Problem 24-01 Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed assets 1,875,000 Notes payable 750,000 Subordinated debentures 750,000 Total debt $1,875,000 Common equity 1,875,000 Total assets $3,750,000 Total liabilities and equity $3,750,000 The trustee's costs total $250,750, and the firm has no accrued taxes or wages. Southwestern has no unfunded pension liabilities. The debentures are subordinated only to the notes payable. If the firm goes bankrupt and liquidates, how much will each...
Problem 24-01 Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable...
Problem 24-01 Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed assets 1,875,000 Notes payable 750,000 Subordinated debentures 750,000 Total debt $1,875,000 Common equity 1,875,000 Total assets $3,750,000 Total liabilities and equity $3,750,000 The trustee's costs total $209,500, and the firm has no accrued taxes or wages. Southwestern has no unfunded pension liabilities. The debentures are subordinated only to the notes payable. If the firm goes bankrupt and liquidates, how much will each...
Problem 24-01 Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable...
Problem 24-01 Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed assets 1,875,000 Notes payable 750,000 Subordinated debentures 750,000 Total debt $1,875,000 Common equity 1,875,000 Total assets $3,750,000 Total liabilities and equity $3,750,000 The trustee's costs total $324,000, and the firm has no accrued taxes or wages. Southwestern has no unfunded pension liabilities. The debentures are subordinated only to the notes payable. If the firm goes bankrupt and liquidates, how much will each...
Problem 24-01 Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable...
Problem 24-01 Liquidation Southwestern Wear Inc. has the following balance sheet: Current assets $1,875,000 Accounts payable $375,000 Fixed assets 1,875,000 Notes payable 750,000 Subordinated debentures 750,000 Total debt $1,875,000 Common equity 1,875,000 Total assets $3,750,000 Total liabilities and equity $3,750,000 The trustee's costs total $285,750, and the firm has no accrued taxes or wages. Southwestern has no unfunded pension liabilities. The debentures are subordinated only to the notes payable. If the firm goes bankrupt and liquidates, how much will each...