I am trying to calculate how to repay interest on several loans that were provided by one person over a 25 year period.
Example: Following are 2 loans showing the dates and amounts of each loan I received over the years. There are several others received thereafter at different dates. I would like to show all transactions on1 worksheet. with repayment amount for each loan plus interest (eg 2.5 compounded quarterly), & breakdown of original amount of loan, amount of accrued interest and total repayment amount. .
1. 8-15-1983 loan amount received=$23,000.00
2. 5-25-1986 loan amount received= $30,000.00
TOTAL: $53,000.00
1.How would I go about setting up a spreadsheet to illustrate above items?
2.What would be a fair way to account for the time value of those loans for each period to the deadline date of September 30, 2007?
Many thanks, Ron
I need to run an interest accrual report on some lines of credit. This is usually easy enough =(interest/365)*(Ending date of the accrual - beginning date of the accrual) * principle balance.
The problem that I am having though is that the lines of credit normally do not run through the entire accrual period. They are either issued in the middle of the period or expire in the middle of the period, and I just need the interest accrual for when they are active.
I was wondering what the easiest way to approach this problem would be.
Hi
I want to know the function to calculate the SI and the CI in Excel. I know manually we calculate the Simple Interest = P*R*T and compound Interest = P(1+i)^n . When I calculate the SI using inbuilt function of Excel i.e. PMT as shown in the following link
http://www.ehow.com/how_4813646_calc...est-excel.html
It given right answer. But if on same data i apply P*R*T it gives something different. Also I saw following site
http://www.busysoftorder.com/npv/1.htm
it uses FV function. Kindly advice how to calculate the Si and CI using inbuilt functions. I just want to calculate it when there is no change in the rate of interest in the subsequent years and it will remain same.
Regards
Harbinder Singh
Don't Laugh. I just need to know how to force a value in a textbox to increase by a set amount when I click on a button. I know this code is not right but it will give you the idea of what I want to do.
Private Sub CommandButton10K_Click()
Me.TextBoxMileageValue.Value Plus 10000
End Sub
When I click the CommandButton10K I just want the value in the TextBoxMileageValue to increase by 10,000
How do I do that?
Thanks Jody
61.48-61.42=0.0599999999999952
Why?
This happens frequently in various formulas.
66555.54-66081.35=474.189999999988
What is going on? Surely I'm not the only one that has noticed this?
I am trying to add percentage numbers and it is rounding up/down...Is there
any way to stop the rounding.
example
CELL C36 CELL D36 CELL E36
ACTUAL # =C36*(1-20%) =C36*(1-80%)
$169.82 $135.86 $33.96
$775.81 $620.65 $155.16
$945.63 $756.50 $189.13
WHEN I USE A BASIC ADDITION DOWN EACH COLUMN, I GET NUMBERS ROUNDED DOWN IN
COLUMN D AND NUMBERS ROUNDING UP IN COLUMN E. IS THERE ANY WAY TO GET THE
ACTUAL NUMBER.
THANK YOU
I have a bunch of numbers in a table, all starting from row 6 and forward. Now I should put
Code:
Number in column X * TIMES * Number in column BH
and put that number in column Z. I could always just specify each cell in column X to be something like this:
Code:
=X6*BH6
but putting that manually into each cell, changing the row numbers and all would take forever. Therefore, could anybody supply me with some quick macro or formula or something (I really don't have a clue) to do this for me? Thanks!
G14: $1500.39 - Total Due
G16: =(G14/2) - 50% Deposit
G18: =(G16-G14) - Balance Remaining
When G14 is an even number - no prob. However, when it's an odd number as
above:
G16: = $750.20
G18: = $750.20
How can I get this to balance properly? (G16: $750.20 and G18: $750.19)
I was trying to figure out a simple percentage using Excel 2007, and I'm a little confused.
A1=35
A2=45
A3=A1/(A1+A2)
The value of A3 displays as 0.
Well, I just about solved my problem because I've done similar formulae to get the answer of .4375. And now even the exact formula in different cells to get that answer.
Maybe it seems silly to still post, but can someone tell me why A3 continues to give me "0" after entering the formula different ways multiple times? Is this cell possessed by Satan?
Code:
=SUM((Q158:Q163)+(Q166:Q171)+(Q174:Q179)+(Q182:Q187)+(Q190:Q195)+(Q198:Q203)+(Q210,Q211))
What is wrong with this formula? It returns a value of, well, #VALUE!
