| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interest payment
For loan amount 12,000, interest rate 2%, loan term 3 years (36 payments),
how would you set up the columns and what would be the result in each cell interest payment, principal payment, and loan balance each month and total cost of the loan? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Interest payment
go look at the answer to your same question below.
"da" wrote: For loan amount 12,000, interest rate 2%, loan term 3 years (36 payments), how would you set up the columns and what would be the result in each cell interest payment, principal payment, and loan balance each month and total cost of the loan? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Interest payment
this will walk you through it step-by-step
http://www.dailydoseofexcel.com/arch...ization-table/ "da" wrote: For loan amount 12,000, interest rate 2%, loan term 3 years (36 payments), how would you set up the columns and what would be the result in each cell interest payment, principal payment, and loan balance each month and total cost of the loan? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interest payment | Excel Discussion (Misc queries) | |||
| How do I calculate the interest payment manually (without using IP | Excel Worksheet Functions | |||
| Calculate Interest Rate when payment changes! | Excel Worksheet Functions | |||
| Why are cumulative interest payment calculations different? | Excel Worksheet Functions | |||
| Interest only payment | Excel Worksheet Functions | |||
Linear Mode
