Once you have entered these details the summary table at the top-right of the spreadsheet will automatically display a summary of the mortgage payment details and the mortgage. If you dont have Excel installed on your computer you can use Outlooks online Excel extension in its place. This will go in the A column.
Once you have entered these details the summary table at the top-right of the spreadsheet will automatically display a summary of the mortgage payment details and the mortgage.
Once you have entered these details the summary table at the top-right of the spreadsheet will automatically display a summary of the mortgage payment details and the mortgage. Step 1 Open Microsoft Excel. In the example shown the formula in C10 is. The details required are the loan amount the interest rate the number of years over which the loan is taken out and the number of payments per year.