| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change loan periods in an amortization schedule
I would like to change the loan period in an amortization schedule from years
to months. Any sugestions on how to do this in a template that was downloaded? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change loan periods in an amortization schedule
Example...
Change the Length of Loan period from 30 years to 360 months. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Barbara" wrote: I would like to change the loan period in an amortization schedule from years to months. Any sugestions on how to do this in a template that was downloaded? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change loan periods in an amortization schedule
You also need to divide the rate (the Annual Rate) by 12 to fit the monthly payment schedule.
HTH, Bernie MS Excel MVP "Gary L Brown" wrote in message ... Example... Change the Length of Loan period from 30 years to 360 months. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Barbara" wrote: I would like to change the loan period in an amortization schedule from years to months. Any sugestions on how to do this in a template that was downloaded? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loan Schedule with Balloon Payment | Excel Worksheet Functions | |||
| How do I do an amortization schedule knowing the princ, int rate,. | Excel Worksheet Functions | |||
| Loan amortization schedule | New Users to Excel | |||
| How do change the amortization of loan template to accommodate pa. | Excel Discussion (Misc queries) | |||
| amortization schedule | Excel Discussion (Misc queries) | |||
Hybrid Mode
