C6 C11. If we calculate the total of the payments made 36 193290 then the inferred interest is a whopping 5255579. To calculate net debt using Microsoft Excel examine the balance sheet to find the following information.
For example enter 736 into B1.
For example a detailed total debt formula could be written as follows. Select the cell where you want to display the percentage. To calculate percent of a total ie. To calculate the percentage of a total in Excel execute the following steps.