How to Make Income Statements Using Excel. An income statement is typically prepared at the end of the year or the beginning of a new year when all financial information has been wrapped up and ...

How to Make a Statement Balance Column in Excel. ... The Income statement balance shows 1,900,000 in the cell, indicating the result of taking 100,000 from the 2,000,000 amount.