| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Loan Amortization Schedule
How do I change formula to get loan period in months, not years?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Loan Amortization Schedule
Multiply the number of periods by 12 and change the rate.
This last one depends on how it is calculated: simplest is divide by 12, but you may need the EFECT or NOMINAL function to compute the rate. Depends on your specs. See HELP for the functions. -- Kind regards, Niek Otten "Linda V" <Linda wrote in message ... How do I change formula to get loan period in months, not years? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loan Schedule with Balloon Payment | Excel Worksheet Functions | |||
| change loan periods in an amortization schedule | Excel Worksheet Functions | |||
| loan amortization schedule | Excel Discussion (Misc queries) | |||
| Loan amortization schedule | New Users to Excel | |||
| Loan amortization schedule with bi-monthly payments | Excel Worksheet Functions | |||
Linear Mode
