1. Change the name of the worksheet to IS. Calculate the missing items in IS worksheet.

Income Statements (in USD)	2018	2019
Net sales	2850	3000
Operating costs	2497	2616.2
Earnings before interest, taxes, & depr. (EBITDA)	353	383.8
Depreciation	90	100
Earnings before interest and taxes (EBIT)
Less interest	60	88
Earnings before taxes (EBT)
Taxes (40%)	81.2	78.32
Net Income before preferred dividends
Preferred dividends	4	4
Net Income available to common stockholders

Copy the tables in the questions and paste them to EXCEL.

ANSWER WITH EXCEL PLEASE