Since every item is increasing by 20%, we have:
Sales = 1.2 x 33600 = $40320
Costs = 1.2 x 27800 = 33360
Net income = 1.2 x 5800 = 6960
Assets = 1.2 x 24350 = 29220 = Total
Debt = 6850 x 1.2 = 8220.
We can't increase all the items on the balance sheet. This is because if we increase the debt and equity both, it will lead to the assets not being equal to the liability. Hence, we need a plug variable which we choose as the Equity number. A plug variable varies to ensure that the balance sheet balances and to ensure that the pro forma balance sheet figures are consistent with the pro forma income statement figures. That is, the growth assumptions cannot concern all items on the statements.
We choose Equity as the plug variable here. Since we have the net income = $6960 in the proforma balance sheet, our equity will increase by this amount already. Hence, calculating the equity we can have (so that assets = liabilities + equity): Equity = 29220 - 8220 = 21000. Out of this, $6960 comes from the net income, hence it reduces the net increase to 21000 - 6960 = 14040.
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement...
Consider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): Balance Sheet Income Statement Sales Costs $33,600 Assets $24,350 Debt 6,850 17,500 27,800 Equity Net income 5,800 Total $24,350 Total $24,350 The company has predicted a sales increase of 20 percent. Assume Yoo pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not Prepare the pro forma statements. (Input all amounts...
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $ 38,000 Assets $ 27,300 Debt $ 6,700 Costs 32,600 Equity 20,600 Net income $ 5,400 Total $ 27,300 Total $ 27,300 The company has predicted a sales increase of 15 percent. It has predicted that every item on the balance sheet will increase by 15 percent as well. Create the pro forma statements and reconcile them. (Input all amounts as...
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $ 30,100 Assets $ 21,050 Debt $ 6,550 Costs 24,380 Equity 14,500 Net income $ 5,720 Total $ 21,050 Total $ 21,050 The company has predicted a sales increase of 14 percent. It has predicted that every item on the balance sheet will increase by 14 percent as well. Create the pro forma statements and reconcile them. (Input all answers as...
S04-01 Pro Forma Statements [LO1] Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes) Income Statement Sales $38,000 Balance Sheet Assets $27,300 Debt 6,700 Equity 20,600 Costs 32,600 Net income 5,400 Total $27,300 Total $27,300 The company has predicted a sales increase of 15 percent. It has predicted that every item on the balance sheet will increase by 15 percent as well Create the pro forma statements and reconcile them. (Input all amounts as positive...
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): The company has predicted a sales increase of 15 percent. Assume Wims pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not. Prepare the pro forma statements. (Input all amounts as positive values. Do not round intermediate calculations.) Determine the external financing needed. (Do not round intermediate calculations. A negative answer...
1.Forma Statements [LO1] Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $38,000 Assets $27,300 Debt $ 6,700 Costs 32,600 Equity 20,600 Net income $ 5,400 Total $27,300 Total $27,300 The company has predicted a sales increase of 15 percent. It has predicted that every item on the balance sheet will increase by 15 percent as well. Create the pro forma statements and reconcile them. What is the plug variable...
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $ 34,000 Assets $ 26,500 Debt $ 7,000 Costs 27,330 Equity 19,500 Net income $ 6,670 Total $ 26,500 Total $ 26,500 The company has predicted a sales increase of 15 percent. Assume the company pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not. Prepare...
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Sales $34,000 Costs 27,330 Assets Balance Sheet $26,500 Debt Equity $ 7.000 19,500 Net income $ 6,670 Total $26,500 Total $26,500 The company has predicted a sales increase of 15 percent. Assume the company pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not. Prepare the pro forma statements....
Consider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): Income Statement Sales Costs Balance Sheet $40,000 Assets $26,000 Debt $ 7,000 Equity 19,000 34,160 Net income 5,840 Tot$26,000 Total $26,000 The company has predicted a sales increase of 20 percent. It has predicted that every item on the balance sheet will increase by 20 percent as well. Create the pro forma statements and reconcile them. (Input all amounts as positive values. Do not round intermediate...
Consider the following simplified financial statements for the Fire Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $ 46,900 Assets $ 22,700 Debt $ 6,700 Costs 41,140 Equity 16,000 Net income $ 5,760 Total $ 22,700 Total $ 22,700 The company has predicted a sales increase of 18 percent. Assume Fire pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not. Prepare the...