| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Loan Amortization Schedule Formula
Does anyone know how I can set up a loan amortization for $15,000 at 5% for
10 years with monthly payments? I have tried a couple different things and keep getting NAME? in columns for to interest and to principal. I have a template but I would really like to know how to do the formula for this. Formulas are my worst problem with excel. Thanks. -- Too old to be in college |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Loan Amortization Schedule Formula
Have you looked at the loan amortization template that's generally supplied
with Excel? -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Kimmer" wrote: Does anyone know how I can set up a loan amortization for $15,000 at 5% for 10 years with monthly payments? I have tried a couple different things and keep getting NAME? in columns for to interest and to principal. I have a template but I would really like to know how to do the formula for this. Formulas are my worst problem with excel. Thanks. -- Too old to be in college |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Loan Amortization Schedule Formula
Yes, I have the template on my computer with excel. I would rather be able
to do it by hand with the formula. I know that sounds stupid but I am just learning excel and would rather do it the hard way I guess. Thanks. -- Too old to be in college "Barb Reinhardt" wrote: Have you looked at the loan amortization template that's generally supplied with Excel? -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Kimmer" wrote: Does anyone know how I can set up a loan amortization for $15,000 at 5% for 10 years with monthly payments? I have tried a couple different things and keep getting NAME? in columns for to interest and to principal. I have a template but I would really like to know how to do the formula for this. Formulas are my worst problem with excel. Thanks. -- Too old to be in college |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Loan Amortization Schedule Formula
Why not open the Loan Amortization template and unprotect it and look at
what's used there? -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Kimmer" wrote: Yes, I have the template on my computer with excel. I would rather be able to do it by hand with the formula. I know that sounds stupid but I am just learning excel and would rather do it the hard way I guess. Thanks. -- Too old to be in college "Barb Reinhardt" wrote: Have you looked at the loan amortization template that's generally supplied with Excel? -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Kimmer" wrote: Does anyone know how I can set up a loan amortization for $15,000 at 5% for 10 years with monthly payments? I have tried a couple different things and keep getting NAME? in columns for to interest and to principal. I have a template but I would really like to know how to do the formula for this. Formulas are my worst problem with excel. Thanks. -- Too old to be in college |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loan amortization schedule | Excel Worksheet Functions | |||
| loan amortization schedule | Excel Discussion (Misc queries) | |||
| Loan Amortization Schedule | Excel Worksheet Functions | |||
| loan amortization schedule | Excel Discussion (Misc queries) | |||
| Loan amortization schedule | New Users to Excel | |||
Linear Mode
