Forum Discussion
Help Please :)
Help, I do not know what I am missing. Obviously I am a complete newbie in every aspect of excel. I have been watching video tutorials for the last 2 hrs, to no avail. I am trying to get the Princip...
This certainly appears to be a spreadsheet you've gotten from another source--it's not one created by a "complete newbie in every aspect of excel." Is that correct?
I think you're trying to do something it wasn't intended for. Those white-background cells are not meant to calculate; you're supposed to be entering data concerning your current mortgage, what you are paying currently in principal and interest, escrow, etc. It then will show you some comparisons were you to re-finance.
What you need (if you are wanting to have a spreadsheet calculate principal and interest) is a different template altogether. This one, for example: https://templates.office.com/en-us/Loan-amortization-schedule-TM03986974