View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EGavin
 
Posts: n/a
Default Construction Loan Interest Formula


Hello!

I'm in the process of building a new home. I have built an Excel sheet
that adds up each draw on my loan. I would like to put in a formula
that calculates a daily interest based on amounts as they are drawn
from the bank. I'm not paying any principal on the loan during the 9
month construction phase. The monthly rate is 6.9% Can someone help
me with a formula that calculates interest as draws are taken on the
loan?

Thanks,
EGavin


--
EGavin
------------------------------------------------------------------------
EGavin's Profile: http://www.excelforum.com/member.php...o&userid=30127
View this thread: http://www.excelforum.com/showthread...hreadid=498136