Compound interest since specific date

[Trotzali]

I would like to figure out the total payout figure for a loan.
I have the initial amount in column b
Date of loan in column c
Interest rate in column d

I need the total amount of the loan today with compounding interest without having made any payments.

For instance:

$10k loan from 6th July 2013
No payments made
10% interest - compounding.
What do I owe today?

I would also like to be able to change whether the interest was calculated daily, weekly, monthly etc

Thank you!

 

[MickG]

Perhaps something like this:-

Loan	Int Rate	Starting Date	Today Date
10000	10%	06/07/2013	01/01/2018
No of days	No of weeks	No of Mths	No of years
=D2-C2	=(D2-C2)/7	=(D2-C2)/365*12	=(D2-C2)/365
1640	234.2857143	53.91780822	4.493150685
Daily rate	week rate	Mth Rate	Yearly Rate
=B2/365	=B2/52	=B2/12	10%
0.000273973	0.001923077	0.008333333	0.1
Amount Owing DayRate	Amount Owing WkRate	Amount Owing MthRate	Amount Owing YrRate
=A2*(1+A11)^A6	=A2*(1+B11)^B6	=A2*(1+C11)^C6	=A2*(1.1)^D6
15671.41924	15684.95351	15643.23182	15345.58933

<colgroup><col width="170" style="width: 128pt; mso-width-source: userset; mso-width-alt: 6058;"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;"> <col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5717;"> <col width="177" style="width: 133pt; mso-width-source: userset; mso-width-alt: 6286;"> <tbody> </tbody>

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F	G	H	I
1	Description	Account	Start	Calc Date	Amount	Rate	Type	Future Value	Interest
2			6-Jul-13	1-Jan-18	$10,000.00	10%	Monthly	15,642.71	5,642.71
3			1-Jan-17	31-Dec-17	$200,000.00	12%	Yearly	224,000.00	24,000.00
4
5
6		Daily
7		Monthly
8		Weekly
9		Yearly
1bb

Cell Formulas
Range	Formula
E2	='1a'!A2
H2	=CHOOSE(MATCH(G2,$B$6:$B$9,0),FV(F2/365,(D2-C2+1),0,-E2),FV(F2/12,(D2-C2+1)/30.4375,0,-E2),FV(F2/52.1429,(D2-C2+1)/7,0,-E2),FV(F2,(D2-C2+1)/365,0,-E2))
I2	=H2-E2

You wanted to " to be able to change whether the interest was calculated daily, weekly, monthly etc "

Cell G2 has a drop down re list B6:B9