Question

In: Finance

The most recent financial statements for GPS, Inc., are shown here:   Income Statement Balance Sheet   Sales...

The most recent financial statements for GPS, Inc., are shown here:

  Income Statement Balance Sheet
  Sales $23,800     Assets $121,000     Debt $43,600  
  Costs

16,900  

  Equity 77,400  
  Taxable income $6,900       Total

$121,000  

    Total

$121,000  

  Taxes (30%) 2,070  
    Net income

$4,830  

Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,470 was paid, and the company wishes to maintain a constant payout ratio. Next year's sales are projected to be $29,400.

Required:

What is the external financing needed?

Solutions

Expert Solution

Growth rate in sales=(29400-23800)/23800

=23.5294118%(Approx)

Dividend payout ratio=Dividend payout/Net income

=1470/4830

=0.304347826

Sales 29400
Costs(16900*1.235294118) 20876.47
Taxable income 8523.53
Taxes(8523.53*30%) 2557.06
Net income 5966.47
Less:Dividends(5966.47*0.304347826) 1815.88
Addition to retained earnings 4150.59

Total assets would be=121,000*1.235294118

=$149470.59

Total equity would be=77400+Addition to retained earnings

=77400+4150.59=$81550.59

Total assets=Total liabilities+Total equity

Hence external financing needed=149470.59-81550.59-43600

=$24320(Approx)


Related Solutions

The most recent financial statements for GPS, Inc., are shown here:   Income Statement Balance Sheet   Sales...
The most recent financial statements for GPS, Inc., are shown here:   Income Statement Balance Sheet   Sales $22,900     Assets $113,000     Debt $31,600     Costs 16,600     Equity 81,400     Taxable income $6,300       Total $113,000       Total $113,000     Taxes (30%) 1,890       Net income $4,410   Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,500 was paid, and the company wishes to maintain a constant payout ratio. Next year's sales are projected to be $29,200. Required: What is the external financing...
The most recent financial statements for GPS, Inc., are shown here:   Income Statement Balance Sheet   Sales...
The most recent financial statements for GPS, Inc., are shown here:   Income Statement Balance Sheet   Sales $22,300     Assets $105,000     Debt $33,600     Costs 16,000     Equity 71,400     Taxable income $6,300       Total $105,000       Total $105,000     Taxes (30%) 1,890       Net income $4,410   Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,610 was paid, and the company wishes to maintain a constant payout ratio. Next year's sales are projected to be $28,900. Required: What is the external financing...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $23,852 Costs...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $23,852 Costs $11,902 Taxable Income ? Taxes (40%) ? Net Income ? Balance Sheet Assets $56,455 Debt $18,576 Equity ? Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,980 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to be $29,412. What is the external financing needed? (Negative amount should be...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $23,120 Costs...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $23,120 Costs $11,132 Taxable Income ? Taxes (40%) ? Net Income ? Balance Sheet Assets $56,917 Debt $21,193 Equity ? Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,748 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to be $27,881. What is the external financing needed? (Negative amount should be...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $21706 Costs...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $21706 Costs $14096 Taxable Income ? Taxes (40%) ? Net Income ? Balance Sheet Assets $55199 Debt $22015 Equity ? Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1887 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to be $29409. What is the external financing needed? (round 2 decimal places)
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $22,640 Costs...
The most recent financial statements for GPS, Inc., are shown here: Income Statement Sales $22,640 Costs $10,389 Taxable Income ? Taxes (40%) ? Net Income ? Balance Sheet Assets $59,616 Debt $15,043 Equity ? Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,649 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to be $26,534. What is the external financing needed?
The most recent financial statements for Heine, Inc., are shown here: Income Statement Balance Sheet Sales...
The most recent financial statements for Heine, Inc., are shown here: Income Statement Balance Sheet Sales $ 23,500 Assets $ 53,400 Debt $ 20,200 Costs 14,900 Equity 33,200 Taxable income $ 8,600 Total $ 53,400 Total $ 53,400 Taxes (40%) 3,440 Net income $ 5,160 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,100 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to be...
The most recent financial statements for Assouad, Inc., are shown here: Income Statement Balance Sheet   Sales...
The most recent financial statements for Assouad, Inc., are shown here: Income Statement Balance Sheet   Sales $ 8,500 Current assets $ 3,450 Current liabilities $ 2,325   Costs 5,950 Fixed assets 8,900 Long-term debt 3,910   Taxable income $ 2,550 Equity 6,115   Taxes (22%) 561   Total $ 12,350   Total $ 12,350     Net income $ 1,989 Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 45 percent dividend payout ratio. As with...
The most recent financial statements for Cardinal, Inc., are shown here: Income Statement Balance Sheet Sales...
The most recent financial statements for Cardinal, Inc., are shown here: Income Statement Balance Sheet Sales $ 25,400 Assets $ 61,000 Debt $ 26,900 Costs 17,300 Equity 34,100 Taxable income $ 8,100 Total $ 61,000 Total $ 61,000 Taxes (21%) 1,701 Net income $ 6,399 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,100 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to be...
The most recent financial statements for Cornwall, Inc., are shown here: Income Statement Balance Sheet Sales...
The most recent financial statements for Cornwall, Inc., are shown here: Income Statement Balance Sheet Sales $ 7,400 Current assets $ 4,100 Current liabilities $ 2,200 Costs 6,000 Fixed assets 9,800 Long-term debt 3,750 Taxable income $ 1,400 Equity 7,950 Taxes (34%) 476 Total $ 13,900 Total $ 13,900 Net income $ 924 Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 20 percent dividend payout ratio. As with...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT