Hi Guys,
I am dealing with a tremendous issue and I am walking with this idea for months and it is quite challenging also. Oke here is the deal, it is about Math and Finance.
Suppose I have three Real Estates A,B and C. See inserted picture for the table:
If I buy 1 Real Estate A I can buy it for $1,000 and get an periodic income of $100. So my ROI (Return On investment) is (monthly income/Purchase price) = 10% and if I buy a second Real Estate Type A than the purchase price becomes
$ 1,100 and the income stays fixed for Real Estate namely $100, so the ROI becomes than 9,1% and so on..the same goes for the other Real Estate B en C.
The Case is the following, let say I got an Investment budget of $10,000 I want to invest that into the Real Estate with the highest possible Income, can Excel tell me eventually you have to buy 5 Real Estate A en 1 Real Estate C (marked in table in blue) for the optimal ROI.
Here are some statistics for this given issue:
Total Cost Real Estate Investment A = 1,000 + 1,100 + 1,200 + 1,300 + 1,400 = $ 6,000
Total Cost Real Estate Investment C = 4,000 + = $ 4,000
Total Investment Cost= $ 10,000
Total Income Real Estate A = 5 * 100 = $ 500
Total Income Real Estate C = 1 * 300 = $ 300
Total Income = $ 800
So my Overall ROI becomes= Total Income/ Total Invesment Cost = $800/$10,000 = 8%
Note: The prices of the real estate is a linear function: Cost A
= Initial price + 10% *initial price * (n-1)
I am dealing with a tremendous issue and I am walking with this idea for months and it is quite challenging also. Oke here is the deal, it is about Math and Finance.
Suppose I have three Real Estates A,B and C. See inserted picture for the table:

If I buy 1 Real Estate A I can buy it for $1,000 and get an periodic income of $100. So my ROI (Return On investment) is (monthly income/Purchase price) = 10% and if I buy a second Real Estate Type A than the purchase price becomes
$ 1,100 and the income stays fixed for Real Estate namely $100, so the ROI becomes than 9,1% and so on..the same goes for the other Real Estate B en C.
The Case is the following, let say I got an Investment budget of $10,000 I want to invest that into the Real Estate with the highest possible Income, can Excel tell me eventually you have to buy 5 Real Estate A en 1 Real Estate C (marked in table in blue) for the optimal ROI.
Here are some statistics for this given issue:
Total Cost Real Estate Investment A = 1,000 + 1,100 + 1,200 + 1,300 + 1,400 = $ 6,000
Total Cost Real Estate Investment C = 4,000 + = $ 4,000
Total Investment Cost= $ 10,000
Total Income Real Estate A = 5 * 100 = $ 500
Total Income Real Estate C = 1 * 300 = $ 300
Total Income = $ 800
So my Overall ROI becomes= Total Income/ Total Invesment Cost = $800/$10,000 = 8%
Note: The prices of the real estate is a linear function: Cost A

Last edited: