Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
Formula which splits principal & interest pmts on P&I Loan | Excel Worksheet Functions | |||
Need formula to figure compound interest of a deposit for a year | Excel Worksheet Functions | |||
Interest formula on Personal Line | Excel Discussion (Misc queries) | |||
How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions |