Open Microsoft Excel. Click into the top cell (A1) and type the name of the organization for which you are preparing the income statement, such as "ABC Wood Creations." ...

Type "Income Statement" in cell A1 in an Excel spreadsheet. Type "Gross Receipts" in cell A2. Type the rest of your expenses in column A, giving each expense its own cell.

You can find the net operating income and debt service figures on a company's income statement. How to Calculate the DSCR in Excel Before calculating the ratio, in Excel, we must first create the ...