Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to Calculate Monthly Interest
Hi!
I am extremely new to the world of EXCEL programming and wanted to run something by you guys to see if this is possible or not. I am working with EXCEL 2002. I have a spreadsheet that calculates our client's PREMIUM OWING. Interest Calculations on the PREMIUM OWING begin August 1st. Interest is calculated at the beginning of the month for the previous month. Here is a sample of the data as it is now. Contract Certificate # Balance Owing Sept Interest Due 416 22057-1 $ (100.00) ? 517 20579-1 $ (50.00) ? To calculate the interest owing for the month of August. The Time Period for the Interest Calculation is Start Date: 08/01/2005 and End Date: 08/31/2005 (31 days). I need to only calculate the interest for those Clients who owe money (have a value in balance owing). I want it to look thru all of the records on the worksheet that have a balance owing - calculate the interest (at 18%) based on this formula: Method used to calculate interest: = Balance Owing x (days/360) x 18% I want the interest to be calculated on Sept 1st. I want to store the result as values so that the interest owing for the month of Septmeber can be used in summations required for reporting. I am not sure if I have provided enough information or not. If you need to know more, please let me know. I would appreciate anyone's help with this matter! Thanks for your time. Nadine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to Calculate Monthly Interest
Does anyone have any ideas?????
PLEASE HELP! Even if you are just telling me that I am way out in left field....and provide me with a tidbit on direction that would be great! Thanks. Nadine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
PMT: Daily interest compounding; monthly payment | Excel Worksheet Functions | |||
Monthly Compound Interest | Excel Discussion (Misc queries) | |||
How do I show monthly compound interest in Excel? | Excel Worksheet Functions | |||
Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) |