Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need an amortization table that can compute on partial years. For example,
my immediate need is to amortize $437,410 at 10% over 8.52 years. The current template only allows for years stated in whole numbers from 1 - 30. |
#2
![]() |
|||
|
|||
![]()
What are the individual periods of compounding interest?
Days/Months/Years/Decades/Biweekly/Semimonthly/??? Once you know that, you can figure out the number of periods in 8.52 years. With that information you can 1) extend your table past the 30 lines you currently have to include the number of periods, 2) use the PMT function to get periodic payments and you're done. HTH, Gary Brown "Rennie M" wrote: I need an amortization table that can compute on partial years. For example, my immediate need is to amortize $437,410 at 10% over 8.52 years. The current template only allows for years stated in whole numbers from 1 - 30. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Loan Amortization Template in Excel | Excel Worksheet Functions | |||
how do i change the expense statement template macro | Excel Worksheet Functions | |||
Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
Loan amortization schedule with bi-monthly payments | Excel Worksheet Functions |