View Single Post
 
Old 07-27-2020, 12:33 PM
revans611 revans611 is offline Windows 10 Office 2019
Novice
 
Join Date: May 2009
Location: Houston, TX
Posts: 9
revans611 is on a distinguished road
Default

Quote:
Originally Posted by trevorc View Post
all the cells are prefilled, click on an empty one and you will see the formula in it. i didn't check to see how many lines are prefilled but expect it will be a lot.

Again, if I click in the cell for loan period in years, I see a number, not a formula. Also, it appears that no lines are prefilled. The number of prefilled lines is controlled by the loan period and payments per year.



I have attempted to upload the workbook. I hope it made it.
Attached Files
File Type: xlsx Loan amortization schedule1.xlsx (54.1 KB, 9 views)
Reply With Quote