For example we have capital amount of Rs. 2,500,000/-. And we have approximate 50 flats. Now we have to distributor this amount in 50 flats in such a way that there are 3 categories of it

. Catergory A has total 8 flats. And its rent should be 25 percent less than other flats payment.

Catergory B has total 8 flats. And its rent should be 5 percent more than the average rent.

Category C has remaining 34 flats. Its rent should be same

Can you devise a good formala where we can change all values like principal amount, number of flats, rents percentage.