View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard[_10_] Richard[_10_] is offline
external usenet poster
 
Posts: 1
Default 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!