In cell B6 put this formula: =Principal.
In cell B3 put how much you are borrowing.In cell B2 put the number of months you need to pay.Given some basic information such as how much you are borrowing (your principal), what your interest rate is, and how many monthly payments you need to make, you can then come up with your amortization schedule. At its simplest, a mortgage payment consists of two parts: principle and interest. It actually is fairly easy to come up with the right calculations. Problem is, she doesn't know enough about finance to know which of the financial worksheet functions she should use to do the calculations. Mary would like to use Excel to create an amortization schedule for her home mortgage.