| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you calculate an interest only loan
I want to set up a loan, lets say for 100,000. The payments are interest
only, payable and compounded monthly. the principal of the loan is due on 60 months. what if i wanted to then amortorize the principal at the end of the 5 year period for another 3 years after the interest only term. The interest is compounded daily and payable over 36 months -- thank you so much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
| how calculate a loan amount with quarterly compounded interest | Excel Discussion (Misc queries) | |||
| how to calculate average loan period of a 5 year loan | Excel Worksheet Functions | |||
| Calculate correct interest on loan when debtor pays late | Excel Discussion (Misc queries) | |||
| How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions | |||
![Richard[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
