# lost??????????????

#### karolinagul

##### New Member
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

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Hi:

Do you mean this?

plettieri
Book1
EFGH
13
14107902857537.76%
15
16
Sheet1

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

Welcome to the Board!

If you're just looking for the variance, you can use: =InterestEarned/InvestmentAmount.
Book1
ABCD
1Purchase PriceInterestTotal% Variance
2\$17,785\$10,790\$28,57561%
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

Replies
13
Views
718
Replies
7
Views
238
Replies
7
Views
165
Replies
19
Views
2K
Replies
3
Views
415

1,202,920
Messages
6,052,567
Members
444,593
Latest member
Smaxls

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back