ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change Xcel Amortization from 30 years to 40 years? (https://www.excelbanter.com/excel-discussion-misc-queries/57567-change-xcel-amortization-30-years-40-years.html)

onroad80

Change Xcel Amortization from 30 years to 40 years?
 
In using Xcel Mortgage Amortization templates, I find they are limited to a
30-year amortization. I would like to change them to 40 years or more. The
worksheets are protected, but I am unable to "fill down" the columns to get
them to calculate beyond 30 years.

Fred Smith

Change Xcel Amortization from 30 years to 40 years?
 
I don't know anything about Xcel Mortgage, but amortization tables aren't that
complicated. One thing you might try is copying the data to a new spreadsheet,
which you should then be able to extend. Either that, or build your own
amortization table.

--
Regards,
Fred


"onroad80" wrote in message
...
In using Xcel Mortgage Amortization templates, I find they are limited to a
30-year amortization. I would like to change them to 40 years or more. The
worksheets are protected, but I am unable to "fill down" the columns to get
them to calculate beyond 30 years.





All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com