In: Finance
Using the income statement from Folder Factory Financials Folder Factory Financials , prepare a pro forma income statement for 2016 if the company projects sales to be $60,000 in 2016.
Balance Sheet |
|||||||
2015 |
2014 |
||||||
Assets |
|||||||
Cash |
$ 1,000 |
$ 500 |
|||||
Accounts receivable |
5,000 |
4,500 |
|||||
Inventory |
7,000 |
6,000 |
|||||
Total current assets |
$13,000 |
$11,000 |
|||||
Gross fixed assets |
$20,000 |
$15,000 |
|||||
Less: Accumulated depreciation |
10,000 |
9,000 |
|||||
Net fixed assets |
$10,000 |
$ 6,000 |
|||||
Total assets |
$23,000 |
$17,000 |
|||||
Liabilities and stockholders’ equity |
|||||||
Accounts payable |
$ 2,000 |
$ 1,500 |
|||||
Notes payable |
3,000 |
2,500 |
|||||
Accruals |
500 |
500 |
|||||
Long-term debt |
10,000 |
6,000 |
|||||
Common stock at par ($1 par) |
500 |
500 |
|||||
Paid-in capital in excess of par |
5,500 |
5,500 |
|||||
Retained earnings |
1,500 |
500 |
|||||
Total liabilities and stockholders’ equity |
$23,000 |
$17,000 |
Income Statement |
|
Sales |
$40,000 |
Cost of goods sold |
21,000 |
Gross profits |
$19,000 |
Operating expenses |
13,000 |
Operating profits |
$ 6,000 |
Interest expense |
2,000 |
Net profits before taxes |
$ 4,000 |
Taxes (40%) |
1,600 |
Net profits after taxes |
$ 2,400 |
Other information (2015):
Depreciation Expense $1000
Tax rate 40%
Operating Profits = Earnings before interest and taxes
Income Statement | ||
Folder Factory, Inc. | ||
for the Year Ended December 31 | 2015 | 2016 |
Sales | $40,000 | 60000 |
Cost of goods sold | 21,000 | $31,500 |
Gross profits | $19,000 | $28,500 |
Operating expenses | 13,000 | $19,000 |
Operating profits | $6,000 | $9,500 |
Interest expense | 2000 | 2000 |
Net profits before taxes | $4,000 | $7,500 |
Taxes 40% | 1600 | $3,000 |
Net profits after taxes | $2,400 | $4,500 |
NOTES
Cost of goods sold = 2015 COGS * sales of 2016/sales of 2015
Depreciation assumed to remain constant
Other operating expenses = 12000*sales of 2016/sales of 2015
Interest assumed to be constant
WORKINGS