Question
In: Accounting
Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 63,252 Assets 122,852...
Consider the following recent financials for XYZ Corporation:
|
Income Statement |
Balance Sheet |
||||
|
Sales |
63,252 |
Assets |
122,852 |
Debt |
28,164 |
|
Costs |
37,951 |
Equity |
94,688 |
||
|
EBIT |
25,301 |
||||
|
Taxes @ 38% |
9,614 |
Total |
122,852 |
Total |
122,852 |
|
Net Income |
15,687 |
||||
Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,918 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to grow by 20%.
What is the pro-forma value for equity? (Round answer to 2 decimal places. Do not round intermediate calculations).
What is the external financing needed using the pro-forma approach? (Round answer to 2 decimal places. Do not round intermediate calculations).
What is the internal growth rate? (Report answer in percentage terms and round to 2 decimal places. Do not round intermediate calculations).
What is the sustainable growth rate? (Report answer in percentage terms and round to 2 decimal places. Do not round intermediate calculations).
Solutions
Expert Solution
Proforma value of equity = $110,011
External financing required = $9,076 ($37,240 - $28,164)
Internal growth rate = 11.61%
Sustainable growht rate = 3.52%
Workings:
| Net income | 18824 |
| Dividend (18.60%) | 3501 |
| Net income retained | 15323 |
| Beginning equity | 94688 |
| Ending equity | 110011 |
Sales will increase by 20%. Costs are 60% of sales and assets are 194% of sales. Hence we take these percentages for the proforma workings. The tax rate will be same.
| Proforma financial statement for the next year: | ||||||
| Income Statement | Balance Sheet | |||||
| Sales | 75,902 | Assets | 1,47,251 | Debt | 37,240 | |
| Costs | 45,541 | 60% | 194% | Equity | 1,10,011 | |
| EBIT | 30,361 | |||||
| Taxes @ 38% | 11,537 | Total | 1,47,251 | Total | 1,47,251 | |
| Net Income | 18,824 | |||||
| Recent financial statement: | ||||||
| Income Statement | Balance Sheet | |||||
| Sales | 63,252 | Assets | 1,22,852 | Debt | 28,164 | |
| Costs | 37,951 | 60% | 194% | Equity | 94,688 | |
| EBIT | 25,301 | |||||
| Taxes @ 38% | 9,614 | Total | 1,22,852 | Total | 1,22,852 | |
| Net Income | 15,687 | |||||
| Internal growth rate=ROA xb / (1-ROA x b) | ||||||||
| ROA = Net income / Total assets = 18824/147251 | ||||||||
| 12.78% | ||||||||
| b= 1-dividend payout raio = 1-18.60= 81.40% | ||||||||
| Internal growth rate = 12.78% X 81.40% / (1-12.78%x81.40%) | ||||||||
| =0.104029/0.895971 | ||||||||
| = 0.116108 or 11.61% | ||||||||
| Sustainable growth rate = Asset utilisation rate x profitability rate x financial utilization rate X (1-Dividend rate) | ||||||||
| Asset utilisation rate = Sales / Total assets = 75902/147251 = 0.5155 | ||||||||
| Profitability rate = Net income / Sales = 18824/75902 = 0.2480 | ||||||||
| Financial utilization rate = Total debt / Total equity = 37240 / 110011 = 0.3385 | ||||||||
| Dividend rate = Dividend / Net income = 3501/18824 = 0.1860 | ||||||||
| Sustainable growth rate = 0.5155 x 0.2480 x 0.3385 x (1-0.1860) = 0.352 or 3.52% | ||||||||
ekkarill92 answered 2 years agoRelated Solutions
Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 73,802 Assets 209,087...
Consider the following recent financials for XYZ
Corporation:
Income Statement
Balance Sheet
Sales
73,802
Assets
209,087
Debt
38,278
Costs
44,281
Equity
170,809
EBIT
29,521
Taxes @ 38%
11,218
Total
209,087
Total
209,087
Net Income
18,303
Assets and costs are proportional to sales. Debt and equity are
not. A dividend of $2,907 was paid, and the company wishes to
maintain a constant payout ratio. Next year’s sales are projected
to grow by 25%.
What is the pro-forma value for equity?...
Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below): a)...
Based on the Income Statement and
Balance Sheet for the XYZ Corporation (see below):
a) create the
Pro Forma statement for 2015 given the following
assumptions:
- sales increase by 20%
- all items vary directly with sales
(except for Notes Payable, LTD, Owners Equity)
- the company is currently operating
at 100% capacity
- the dividend payout ratio stays at
50%
Income Statement
2015
Pro Forma 2016
Sales
$3,000,000
Cost of Goods Sold
2,000,000
Depreciation
300,000
EBIT...
Consider recent financials for Ellie's Essentials LLC: Balance Sheet 2018 2017 Current Assets $11,438.00 $10,000.00 Net...
Consider recent financials for Ellie's Essentials LLC:
Balance Sheet
2018
2017
Current Assets
$11,438.00
$10,000.00
Net PPE
$31,000.00
$30,000.00
Total Assets
$42,438.00
$40,000.00
Current Liabilities
$8,736.00
$8,000.00
Long-term debt
$12,728.00
$12,000.00
Total Liabilities
$21,464.00
$20,000.00
Shareholder Equity
$20,974.00
$20,000.00
Liabilities and Equity
$42,438.00
$40,000.00
Income Statement
2018
2017
SALES
$11,000.00
$10,000.00
COGS
$4,400.00
$4,000.00
GROSS PROFIT
$6,600.00
$6,000.00
S&A
$1,100.00
$1,000.00
Depreciation
$550.00
$500.00
EBIT
$4,950.00
$4,500.00
INTEREST
$1,272.00
$1,200.00
EBT
$3,678.00
$3,300.00
TAXES (36.00%)
$1,324.08
$1,188.00
NET INCOME
$2,353.92...
Consider recent financials for Ellie's Essentials LLC: Balance Sheet 2018 2017 Current Assets $11,438.00 $10,000.00 Net...
Consider recent financials for Ellie's Essentials LLC:
Balance Sheet
2018
2017
Current Assets
$11,438.00
$10,000.00
Net PPE
$31,000.00
$30,000.00
Total Assets
$42,438.00
$40,000.00
Current Liabilities
$8,736.00
$8,000.00
Long-term debt
$12,728.00
$12,000.00
Total Liabilities
$21,464.00
$20,000.00
Shareholder Equity
$20,974.00
$20,000.00
Liabilities and Equity
$42,438.00
$40,000.00
Income Statement
2018
2017
SALES
$11,000.00
$10,000.00
COGS
$4,400.00
$4,000.00
GROSS PROFIT
$6,600.00
$6,000.00
S&A
$1,100.00
$1,000.00
Depreciation
$550.00
$500.00
EBIT
$4,950.00
$4,500.00
INTEREST
$1,272.00
$1,200.00
EBT
$3,678.00
$3,300.00
TAXES (36.00%)
$1,324.08
$1,188.00
NET INCOME
$2,353.92...
3. Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets...
3. Megalopolis Bank has the following balance sheet and income
statement.
Balance Sheet (in millions)
Assets | Liabilities and Equity
Cash and due from banks $ 9,000 | Demand deposits $ 19,000
Investment securities 23,000 | NOW accounts 89,000
Repurchase agreements 42,000 | Retail CDs 28,000
Loans 90,000 | Debentures 19,000
Fixed assets 15,000 | Total liabilities $155,000
Other assets 4,000 | Common stock 12,000
Total assets $183,000 | Paid-in capital 4,000
| Retained earnings 12,000
| Total liabilities and...
Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets Liabilities...
Megalopolis Bank has the following balance sheet and income
statement.
Balance Sheet (in millions)
Assets
Liabilities and Equity
Cash and due from banks
$
9,400
Demand deposits
$
23,000
Investment securities
27,000
NOW accounts
93,000
Repurchase agreements
46,000
Retail CDs
32,000
Loans
94,000
Debentures
23,000
Fixed assets
19,000
Total liabilities
$
171,000
Other assets
4,400
Common stock
12,000
Paid-in capital
4,000
Retained earnings
12,800
Total assets
$
199,800
Total liabilities and equity
$
199,800
Income Statement
Interest on fees and...
Prepare balance sheet and an income statement for corp xyz given the following information: Inventory $...
Prepare balance sheet and an income statement for corp xyz given
the following information:
Inventory $ 6,500
Common Stock 45,000
Cash 15,550
Operating expenses 1,350
Short-term notes payable 600
Interest expense 900
depreciation expense 500
sales 12,800
accounts receivable 9,600
Accounts payable 4,800
long-term debt 55,000
Cost of goods sold 5,750
Buildings and equipment 122,000
Accumulated depreciation 34,000
Taxes 1,440
General and Administrative expenses 850
retained earnings?
Using previously worked financial statements, determine the
following financial ratios. Please interpret each...
The following income statement items appeared on the adjusted trial balance of XYZ Corporation for the...
The following income statement items appeared on the
adjusted trial balance of XYZ Corporation for the year ended
December 31, 2021 ($ in 000s): sales revenue, $22,300; dividend
revenue from investments, $200; interest revenue $150; cost of
goods sold, $14,500; selling expense, $2,300; general and
administrative expense, $1,200; interest expense, $300. Income
taxes have not yet been accrued. The company's income tax rate is
20% on all items of income or loss. These revenue and expense items
appear in the...
Consider the following income statement for the Heir Jordan Corporation: HEIR JORDAN CORPORATION Income Statement Sales...
Consider the following income statement for the Heir Jordan
Corporation:
HEIR JORDAN CORPORATION
Income Statement
Sales
$
43,200
Costs
34,000
Taxable income
$
9,200
Taxes (24%)
2,208
Net income
$
6,992
Dividends
$
2,700
Addition to retained
earnings
4,292
The projected sales growth rate is 13 percent.
Prepare a pro forma income statement assuming costs vary with
sales and the dividend payout ratio is constant. (Input all
answers as positive values. Do not round intermediate
calculations.)
What is the projected...
Consider the following income statement for the Heir Jordan Corporation: HEIR JORDAN CORPORATION Income Statement Sales...
Consider the following
income statement for the Heir Jordan Corporation:
HEIR JORDAN CORPORATION
Income Statement
Sales
$
47,900
Costs
33,900
Taxable income
$
14,000
Taxes (21%)
2,940
Net
income
$
11,060
Dividends
$
2,300
Addition to retained earnings
8,760
The projected sales
growth rate is 12 percent.
Prepare a pro forma
income statement assuming costs vary with sales and the dividend
payout ratio is constant.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
ADVERTISEMENT