Browse
Category
DiscussionsUncategorized

... I need help with Excel, lawl: Calculate Reverse PayPal fees

Closed
DrDudePhD

So, this site got it right, I crosschecked with some transactions: www.gregledet.net/ppfcm.html (formula is available on source I think but I can't read it)

My fees are 5.4% + a fixed fee of $0.30. Let's use an example of $5 USD.

I'm doing this formula, it's the value I'll recieve after fees:

*=$5+(($55.4%)+$0.30)**

Somehow it doesn't give the same results as the site:

  • Excel=$5.57
  • Site=$5.60

What I'm doing wrong?

1 decade ago*

Comment has been collapsed.

6 Comments
TheAnthonyNL

Well it could be that the site use rounded up numbers ...

1 decade ago
Permalink

Comment has been collapsed.
chairmankao

Yeah, could be this. If the site is rounding up, that is such bullshit.

1 decade ago
Permalink

Comment has been collapsed.
Undac

5*1.054+0.3=5.57

1 decade ago
Permalink

Comment has been collapsed.
DrDudePhD

The correct sum is 5.60. I need to arrive to 5.60, 5.57 is wrong.

1 decade ago
Permalink

Comment has been collapsed.
bloodynosepicker

Formula used on that site looks like this:
(5+0,3)/(1-(5,4/100))&oq=(5%2B0%2C3)%2F(1-(5%2C4%2F100))&gs_l=hp.3...30609.34053.8.34634.6.6.0.0.0.0.184.679.2j4.6.0...0.0...1c.1.9.psy-ab.qi3ZahNMDTs&pbx=1&bav=on.2,or.r_qf.&bvm=bv.45175338,d.Yms&fp=2eed869a957295a1&ion=1&biw=1920&bih=989)
They're adding $0.30 before calculating percentage (IMO it should be done after) and then dividing instead of multiplying. I don't know how PayPal is doing it but result will be different, for example:
100/0.946) = 105.708245243
100*1.054 = 105.4

1 decade ago
Permalink

Comment has been collapsed.
DrDudePhD

Ohh, the first formula works exactly as it should be! Thanks a lot. No idea how you reached that one, though, makes no sense to me =P

1 decade ago
Permalink

Comment has been collapsed.

Closed 1 decade ago by DrDudePhD.