Complete the Year 2 income statement data for Blue Hamster, then answer the questions that follow. Be sure to round each dollar value to the nearest whole dollar.

Blue Hamster Manufacturing Inc Income Statement for Year Ending December 31

Year 1 Year 2

Net sales $15,000,000
Less: Operating costs, except depreciation and amortization 9,000,000
Less: Depreciation and amortization expenses 600,000 600,000
Operating income (or EBIT) $5,400,000
Less: Interest expense 540,000
Pre-tax income (or EBT) 4,860,000
Less: Taxes (25%) 1,215,000
Earnings after taxes $3,645,000
Less: Preferred stock dividends 100,000
Earnings available to common shareholders 3,545,000
Less: Common stock dividends 1,458,000
Contribution to retained earnings $2,087,000 $2,539,250

Consider the following scenario:

1. Blue Hamster Manufacturing Inc.'s income statement reports data for its first year of operation. The firm's CEO would like sales to increase by 25% next year. 1, Blue Hamster is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT).
2. The company's operating costs (excluding depreciation and amortization) remain at 60% of net sales, and its depreciation and amortization expenses remain constant from year to year.
3. The company's tax rate remains constant at 40% of its pre-tax income or earnings before taxes (EBT).
4. In Year 2, Blue Hamster expects to pay $100,000 and $1,407,600 of preferred and common stock dividends, respectively.

Note: The data in this question are merged together and there are also some errors in the question. The complete correct question with sorted data are therefore provided before answering the question. See the attached pdf file for the complete correct question with the sorted data.

Also note: See the attached excel file for the complete Year 2 income statement data in bold red color.

Based on the information provided in the question, the following calculations are used in the attached excel file for year 2:

Year 2 Net Sales = Year 1 Net sales + (Year 1 Net Sales * Percentage increase in sales in year 2) = $15,000,000 + ($15,000,000 * 25%) = $15,000,000 + $3,750,000 = $18,750,000

Year 2 Operating costs, except depreciation and amortization = 60% * Year 2 net sales = 60% * $18,750,000 = $11,250,000

Year 2 Operating Income/EBIT = Net Sales - Year 2 Operating costs, except depreciation and amortization - Year 2 Depreciation and amortization expenses = $18,750,000 - $11,250,000 - $600,000 = $6,900,000

Year 2 Interest expense = 15% * Year 2 earnings before interest and taxes (EBIT) = 15% * $6,900,000 = $1,035,000

Year 2 Pre-tax income/EBT = Operating Income/EBIT - Interest expense = $6,900,000 - $1,035,000 = $5,865,000

Year 2 Taxes = 40% * Year 2 Pre-tax income/EBT = 40% * $5,865,000 = $2,346,000

Year 2 Earnings After taxes = Year 2 Pre-tax income/EBT - Year 2 Taxes = $5,865,000 - $2,346,000 = $3,519,000

Year 2 Earnings available to common shareholders = Year 2 Earnings After taxes – Year 2 Preferred Stock Dividends = $3,519,000 - 100,000 = $3,419,000

Year 2 Contribution to retained earnings = Year 2 Earnings available to common shareholders – Year 2 Common Stock dividends = $3,419,000 - $1,407,600 = $2,011,400