lost??????????????

[karolinagul]

if i bought something for $17, 785 and the interest was $10,790 (which equaled 28, 575).. that 10, 790- how would i calculate what percentage that is??? i really need to find this out but i dont know how. thanks

 

[plettieri]

Hi:

Do you mean this?

plettieri

Book1
	E	F	G	H
13
14	10790	28575	37.76%
15
16
Sheet1

 

[Ron Morris]

Hi,

Are you looking to find out what your interest rate was based on the how much interest you paid?

If so, I am not sure if this is totally correct, but you can give it a shot.

=RATE(number of years of loan*12,-amount of monthly payment,amount of loan)*12

So, if I replaced the data above with some numbers,

=RATE(5*12,-200,17785)*12 the result would be 14.52%

I believe it will provide you with the interest rate.
make sure to enter the monthly payment as a negative number.

Hope this helps.

Ron

 

[Smitty]

Welcome to the Board!

If you're just looking for the variance, you can use: =InterestEarned/InvestmentAmount.

Book1
	A	B	C	D
1	Purchase Price	Interest	Total	% Variance
2	$17,785	$10,790	$28,575	61%
3
4		$10,790	$28,575
Sheet1

Hope that helps,

Although, I really want to know what that investment was! More specific details would help.

Smitty