LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate total interest earned on a loan and monthly payment Matt Stanley Excel Worksheet Functions 4 May 4th 23 03:42 AM
Formula which splits principal & interest pmts on P&I Loan Dealmakerjc Excel Worksheet Functions 1 November 7th 05 03:37 PM
Need formula to figure compound interest of a deposit for a year Usedtobesmart Excel Worksheet Functions 3 July 27th 05 06:34 PM
Interest formula on Personal Line Elissa Excel Discussion (Misc queries) 6 January 17th 05 08:43 PM
How to calculate total interest on 12 month loan with early payments Fred Smith Excel Worksheet Functions 0 January 6th 05 02:33 AM


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"