Help me make a percentage file

[abdoadawy65]

Help me make a percentage file
Who creates the file
I want to write an amount of money
It gives me a percentage and divides the result by the number of months
I sell in installments
Example
A commodity for $ 10,000
18 months rate 70%
The rate for 12 months 46%
24months rate 93%
6months rate 25%
36 months rate 138%

[RusselB]

Welcome to the Forums.
Are the percentages given fixed?
Are they monthly, annual or term percentages?
Is there a reason your months are not in sequential order?

[abdoadawy65]

Welcome to the Forums.
Are the percentages given fixed?
yes
Are they monthly, annual or term percentages?
yes
Is there a reason your months are not in sequential order?
The reason is the profit system is fixed at this rate

you can help me
Is there a reason your months are not in sequential order?

[jrkrideau]

Hi abdoadawy65
It is not really clear what you want

Look at the attached file and see it is close to what you want.

There are better ways to do this but if it is close to what you want we may be able to help.

[RusselB]

Welcome to the Forums.
Are they monthly, annual or term percentages?
yes

OK, so which are they? The proper calculation of a percentage over a period of time depends on the time period that the given percentage is for.

[abdoadawy65]

Hi abdoadawy65
It is not really clear what you want

Look at the attached file and see it is close to what you want.

There are better ways to do this but if it is close to what you want we may be able to help.

very thanks
thank you so much
Please see the example in the attachment image and apply it
thank you so much

[jrkrideau]

I am sorry but I do not understand what you are doing.

Do you want a monthly payment for each of the repayment times?

[abdoadawy65]

what is your account facebook or whatasapp

[Hagar Delest]

Sorry but this is not a customer service.
The point of the forum is to have open discussion so that other users benefit from the advice provided here.
Can't you describe what you're trying to achieve? It's still very confusing.

[abdoadawy65]

I will explain what I want with an example
I sell in installments
The price for the product is 1000
Profit rate 18 months 70%
1000 * 70/100
= 700
+ The price for the product is 1000
/ 18 months

[Hagar Delest]

Here is what I understand:

abd.ods

(8.82 KiB) Downloaded 191 times