FIN 660 Computational HW 4

xlsx

School

University of Maryland Global Campus (UMGC) *

*We aren’t endorsed by this school

Course

660

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

12

Uploaded by MajorMoleMaster406

Report
1 income statement sales $4,700.00 assets costs $3,470.00 net income $1,230.00 total sales projected $5,963.00 growth in sales $0.27 proj costs $4,402.47 net income $1,560.53 total equity $6,260.53 proj assets $19,284.60 external financing needed $2,524.07 2 income statement sales $22,600.00 assets costs $17,100.00 taxable income $5,500.00 total tax rate 21.00% taxes $1,155.00 net income $4,345.00 dividend paid $1,560.00 sales projected $29,600.00 dividend payout ratio 0.36 proj assets $148,000.00 change in assets $35,000.00 proj costs $22,396.46 taxable income $7,203.54 proj taxes $1,512.74 proj net income $5,690.80 retained earnings $3,647.61 external financing needed $31,352.39 3 income statement sales $3,500.00current assets What is the external financing needed? What is the external financing needed? What is the internal growth rate?
costs $2,310.00 fixed assets taxable income $1,190.00 total tax rate 24.00% taxes $285.60 net income $904.40 dividend payout ratio 32.00% return on assets 7.05% retention ratio 68.00% internal growth rate 5.04% 4 income statement sales $15,000.00current assets costs $9,000.00 fixed assets taxable income $6,000.00 total tax rate 24.00% taxes $1,440.00 net income $4,560.00 dividend payout ratio 18.00% retention ratio 82.00% return on equity 19.74% sustainable growth rate 19.31% 5 income statement sales $40,000.00current assets costs $25,600.00 fixed assets taxable income $14,400.00 total tax rate 22.00% taxes $3,168.00 net income $11,232.00 dividend payout ratio 18.00% return on equity 20.80% plow back ratio 82.00% What is the sustainable growth rate? What is the maximum increase in sales that can be sustained assumi
sustainable growth rate 20.56% ax sustainable increase in sales $8,225.31 6 If A7X Company has an ROA of 14 percent and a payout ratio of 20 pe return on assets 14% payout ratio 20% retention rate 80.00% internal growth rate 12.61% 7 If the Synyster Corporation has an ROE of 20 percent and a payout ra return on assets 20% payout ratio 17% retained earning ratio 83.00% sustainable growth rate 19.90% 8 profit margin 8.40% capital intensity ratio 0.55 debt-equity ratio 0.61 net income $27,000.00 dividends $14,850.00 asset turnover 1.82 equity multiplier 1.61 retention ratio 45.00% return on equity 24.59% substantial growth rate 12.44% 9 total asset turnover 1.41 Dividends $ 14,850 What is the sustainable growth rate?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
profit margin 6.30% equity multiplier 1.30 payout ratio 61.00% return on assets 8.88% return on equity 11.55% retention ratio 39.00% substantial growth rate 4.72% 10 sustainable growth rate 11.00% dividend payout ratio 56.00% assets to sales 0.90 profit margin 8.10% retention ratio 44.00% return on equity 22.52% asset turnover 1.11 equity multiplier 2.50 constant debt to equity ratio 1.50
balance sheet $15,200.00 debt $10,500.00 equity $4,700.00 $15,200.00 total $15,200.00 balance sheet $113,000.00 debt $31,600.00 equity $81,400.00 $113,000.00 total $113,000.00 balance sheet $3,720.00 debt $7,438.00
$9,108.00 equity $5,390.00 $12,828.00 total $12,828.00 balance sheet $32,345.00 debt $31,878.00 $22,633.00 equity $23,100.00 $54,978.00 total $54,978.00 balance sheet $62,640.00 long-term debt $43,200.00 $34,560.00 equity $54,000.00 $97,200.00 total $97,200.00 ing no new equity is issued?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ercent, what is its internal growth rate? atio of 17 percent, what is its sustainable growth rate?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help