spreadsheet to track mortgage interest paid and interest paid to borrow the funds to establish the m

Richie970 

First suggestion: Please post a copy of whatever spreadsheet you've developed so far. 

This would include the various numbers to incorporate:

• interest rate on the loan
• interest rate on the mortgage
• term of the loan
• term of the mortgage (30 year? 15 year?)
• payment schedules (monthly? quarterly)
• amount of loan
• amount of mortgage

Are you expecting both loan and mortgage payments to include principle AND interest, or will one or both be interest only? Do you want to allow for payments over and above the principle?

I gather you're the one who will be paying off the loan, and you are the one granting the mortgage... it's not necessary for you to reveal private or confidential data here, but it would help if your role is clear AND if some realm of reality is reflected in the numbers referenced above (i.e., you don't need to tell us the actual amounts of the loan/mortagage, but something that gives an idea of the ratio....and is somewhat "real world" like)