Question
In: Accounting
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? (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
| Income Statement | % | Balance Sheet | ||||
| Sales | 73,802 | 100% | Assets | 209,087 | Debt | 38,278 |
| Costs | 44,281 | 60% | Equity | 170,809 | ||
| EBIT | 29,521 | 40% | ||||
| Taxes @ 38% | 11,218 | 15.20% | Total | 209,087 | Total | 209,087 |
| Net Income | 18,303 | 24.80% | ||||
| Dividend | 2,907 | |||||
| Payout ratio | 15.88264% | Asset T/O | 35.297269% | |||
| (sales/TA) | ||||||
| Assuming costs and assets increase proportionally, the pro forma financial statements will look like this: | ||||||
| Proforma | Proforma | |||||
| Income Statement | balance sheet | |||||
| Sales (73802 x 125%) | $ 92,252.50 | Assets (92252.50/35.297269%) | $261,358.75 | Debt (261358.75-190053.89) |
71,304.86 | |
| Costs (60% of sales) | 55,351.50 | Equity | 190,053.89 | |||
| EBIT | $ 36,901.00 | (170809+19244.89) | ||||
| Taxes @ 38% | 14,022.38 | Total | 261,358.75 | Total | 261,358.75 | |
| Net Income | $ 22,878.62 | |||||
| Dividend (15.88264%) | 3,633.73 | |||||
| Addition to Equity | $ 19,244.89 | EFN Needed | 33026.86 | |||
| (71304.86-38278) | ||||||
| Internal Growth rate = (ROA x b) / [1-(ROA xb) | ||||||
| ROA = NI/TA | 18303/209087 | |||||
| 0.087537724 | ||||||
| b = 1-payout ratio | 84.117358% | |||||
| Internal Growth rate = | (.087537724 x 84.117358%) / [1-(.087537724 x 84.117358%)] | |||||
| 7.95% | ||||||
| Sustainable Growth rate = (ROE x b) / [1-(ROE xb) | ||||||
| ROE = NI/TE | 18303/170809 | |||||
| 0.107154775 | ||||||
| b = 1-payout ratio | 84.117358% | |||||
| Sustainable Growth rate = | (.107154775 x 84.117358%) / [1-(.087537724 x 84.117358%)] | |||||
| 9.73% | ||||||
| Ans. | ||||||
| a. | 190,053.89 | |||||
| b. | 33026.86 | |||||
| c. | 7.95% | |||||
| d. | 9.73% | |||||
| Note: I have tried my best for correct solution, still you need any further help or answer mismatch | ||||||
| Please ask in comment, I appreciate your feedback, Thank you. | ||||||
ekkarill92 answered 2 years agoRelated Solutions
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?...
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
- 38. A contract with an illegal principal objective is typically which of the following? Answers: A....
- Explain how advances in technology can force a software subsystem to undergo change or run the...
- Discuss whether you agree or disagree on whether you think E-mails need to be managed and...
- b. Do any unions represent employees in Microsoft? Describe which unions are involved. c. Have there been...
- Look up and use each of these Linux commands. (Each command will have two parts) Summarize...
- What was Lincoln 10 percent plan and what problems did it present?
- A cantilever beam 4m long carries a uniform load of 3.5 kN/m over a portion 1.5m...
ADVERTISEMENT