I want to create a simple calculator .
The main function of the calculator is to split the investment amount an amount that the return of all investment will be almost same . For example.
Amount investment is $2020
Company A gives Rate of 5.00 so client invest $415 return is $2075
Company B give rate of 3.40 so client invest $615 return is $2091
Company c gives rate of 2.10 so client invest $990 return is $2079
So my investment of $2020 will be divded A =$415 B=$615 C=$990
Note: At time there may be only 2 companies but maximum of 3 companies
e.g investment $2010
Company A gives Rate of 1.80 so client invest $1144 return is $2059
Company B gives Rate of 2.37 so client invest $866 return is $2052
The main Goal of the project is that return on investment is retained by splitting the amount according to the rate. Rate will change always and also the amount on investment. This might require a formula. If you want to can do this in Excel also.
Buttons
1 . enter amount
2. company A Rate
3.company B rate
4. company C rate
5. calculate
6. reset
any suuggestions
The main function of the calculator is to split the investment amount an amount that the return of all investment will be almost same . For example.
Amount investment is $2020
Company A gives Rate of 5.00 so client invest $415 return is $2075
Company B give rate of 3.40 so client invest $615 return is $2091
Company c gives rate of 2.10 so client invest $990 return is $2079
So my investment of $2020 will be divded A =$415 B=$615 C=$990
Note: At time there may be only 2 companies but maximum of 3 companies
e.g investment $2010
Company A gives Rate of 1.80 so client invest $1144 return is $2059
Company B gives Rate of 2.37 so client invest $866 return is $2052
The main Goal of the project is that return on investment is retained by splitting the amount according to the rate. Rate will change always and also the amount on investment. This might require a formula. If you want to can do this in Excel also.
Buttons
1 . enter amount
2. company A Rate
3.company B rate
4. company C rate
5. calculate
6. reset
any suuggestions