Time Value of Money - Leeds School of Business

The excel formula in cell A3 is = NPV(10%,B2:D2). This gives a result of 248.69. ... Construct an amortization schedule for a $1,000, 10 percent annual rate loan with 3 equal installments. ... If you buy a house, you will get a schedule constructed like ours, but longer, with 30 ( 12 = 360 monthly payments if you get a 30-year, fixed rate mortgage. ................
................