The most recent financial statements for Bradley, Inc., are shown here (assuming no income taxes):
Income Statement | ||||||
Sales | $ | 9,000 | ||||
Costs | (6,750 | ) | ||||
Net income | $ | 2,250 | ||||
Balance Sheet | |||||||
Assets | $ | 28,800 | Debt | $ | 10,200 | ||
Equity | 18,600 | ||||||
Total | $ | 28,800 | Total | $ | 28,800 | ||
Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $10,350. What is the external financing needed? (A negative value should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest whole number.)
Projected sale is $10,350 which is $1350 [$10,350-$9,000] more than recent year sales of $9,000
%change in sales = (change in sales / recent year sales)×100
%change in sales = ($1350/$9000)×100=15%
pro-forma for projected income statement
Particulars | current year($) | Projected($) |
Sales | 9,000 | 10,350 |
Costs | (6750) | (7,762.5)...[working note 1] |
Net Income | 2250 | 2,587.5 |
Working note 1- costs change according to sales
Here in this case sales changes with 15%,so cost would also increase by 15%
$6,750×15% = $6,750×15/100= $1,012.5
Estimated Cost would be $6,750+$1,012.5 =$7,762.5
pro-forma of balance sheet
Assets | Current Year($) | Projected($) | Labilities | Current Year($) | Projected($) |
Assets | 28,800 | 33,120...(working note 2) | Debt | 10,200 | 10,200 |
Equity | 18,600 | 21,187.5....(working note 3) | |||
External financing | 1,732.5(working note 4) | ||||
28,800 | 33,120 | 28,800 | 33,120 |
Working Notes:
2) Projected assets is to be changed according to sales proportion(15%) calculated in working note 1
So 15%change in assets = $28,800×15% =$28,800×15/100=$4,320
Projected assets = $28,800+$4,320=$33,120
3) New Equity = beginning equity + projected net income + Dividend
New Equity =$18,600+$2,587.5+0
New Equity =$21,187.5
4) External financing needed
Projected Assets = projected Liabilities
$33,120= $10,200+$21,187.5+ external finance
External finance = $33,120-($10,200+$21,187.5)
External financing = $33,120- $31,387.5= $1732.5
hence External financing needed is $1,732.5
The most recent financial statements for Bradley, Inc., are shown here (assuming no income taxes): Income...
The most recent financial statements for Marpole Inc., are shown here (assuming no income taxes): Statement of Comprehensive Income Statement of Financial Position Sales $ 6,700 Assets $ 15,800 Debt $ 6,300 Costs 4,610 Equity 9,500 Net income $ 2,090 Total $ 15,800 Total $ 15,800 Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $9,075. What is the external financing needed? (Do not round intermediate...
The most recent financial statements for Williamson, Inc., are shown here (assuming no income taxes): Income Statement Balance Sheet Sales $ 8,400 Assets $ 14,000 Debt $ 6,000 Costs 6,390 Equity 8,000 Net income $ 2,010 Total $ 14,000 Total $ 14,000 Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $9,996. What is the external financing needed? (Do not round intermediate calculations and round your...
The most recent financial statements for Williamson, Inc., are shown here (assuming no income taxes): Income Statement Balance Sheet Sales $ 8,600 Assets $ 16,100 Debt $ 6,400 Costs 5,630 Equity 9,700 Net income $ 2,970 Total $ 16,100 Total $ 16,100 Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $10,578. What is the external financing needed? (Do not round intermediate calculations and round your...
Exercises #2-#5 – The most recent financial statements for Bradley, Inc. are shown below (assuming no income taxes) see attachment. Income Statement Balance Sheet Sales 6,500 Assets 17,400 Debt 8,400 Costs 5,320 Equity 9,000 NI 1,180 Total 17,400 Total 17,400 Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $7,280. Construct the pro forma statements and answer the following questions based on the pro-formas: Exercise #2...
The most recent financial statements for Kerch, Inc., are shown here (assuming no income taxes): Income Statement Balance Sheet Sales $ 7,200 Assets $ 21,700 Debt $ 9,100 Costs 4,730 Equity 12,600 Net income $ 2,470 Total $ 21,700 Total $ 21,700 Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $8,424. What is the external financing needed? (Do not round intermediate calculations and round your...
The most recent financial statements for Williamson, Inc., are shown here (assuming no income taxes): Income Statement Balance Sheet Sales $ 9,300 Assets $ 20,000 Debt $ 8,000 Costs 7,330 Equity 12,000 Net income $ 1,970 Total $ 20,000 Total $ 20,000 Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $10,788. What is the external financing needed? (Do not round intermediate calculations and round your...
The most recent financial statements for Marpole Inc., are shown here (assuming no income taxes): Statement of Comprehensive Income Sales $ 6,500 Costs 4,610 Net income $ 1,890 Assets Statement of Financial Position $ 26,500 Debt Equity $ 26,500 Total $12,500 14,000 $26,500 Total Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year's sales are projected to be $7,150. What is the external financing needed? (Do not round intermediate calculations and...
The most recent financial statements for Heine, Inc., are shown here: Income Statement Balance Sheet Sales $ 28,200 Assets $ 57,500 Debt $ 25,300 Costs 20,100 Equity 32,200 Taxable income $ 8,100 Total $ 57,500 Total $ 57,500 Taxes (40%) 3,240 Net income $ 4,860 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,600 was paid, and the company wishes to maintain a constant payout ratio. Next year’s...
The most recent financial statements for Heine, Inc., are shown here: Income Statement Balance Sheet Sales $ 30,000 Assets $ 56,100 Debt $ 20,500 Costs 22,000 Equity 35,600 Taxable income $ 8,000 Total $ 56,100 Total $ 56,100 Taxes (40%) 3,200 Net income $ 4,800 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,200 was paid, and the company wishes to maintain a constant payout ratio. Next year’s...
The most recent financial statements for Bello, Inc., are shown here: Income Statement Balance Sheet Sales $ 40,800 Assets $ 151,000 Debt $ 45,000 Costs 27,600 Equity 106,000 Taxable income $ 13,200 Total $ 151,000 Total $ 151,000 Taxes (21%) 2,772 Net income $ 10,428 Assets and costs are proportional to sales; debt and equity are not. A dividend of $3,600 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected...