I need a ROI spreedsheet?

Answer 1

ROI is return on investment. It is a percentage calculated by dividing the net income by the cost of making that income

net income is basically total income less total costs

thus ..... (total income - total costs) / total costs
or ...... net income / total cost
Times by 100 to get your percentage


Create rows of income and total them
Create rows of expenditure and total them
Calaculate the net income by taking the total income and minusing the total expenditure
Then create a formula that divides the net income cell by the total expenditure cell and times by 100 to get the percentage figure

eg

Income
IA 50
IB 100
Total Income 50 + 100 = 150

Expenditure
EA 45
EB 55
Total Exp. 45 + 55 = 100

Net Income 150 - 100 = 50

ROI (50/100)*100 = 50%



Sharewise if you bought some shares for $100 and sold them for $125 then you made $25 profit, your ROI would be ($25/$100) = 0.25 or 25%

You may want to add other costs incurred to the $100 (initial share cost) for example transaction fees etc to get a true ROI. eg Trading Fee $10

You profit would be $15 and your total cost would be $110 thus your ROI would be
(15/110) = 0.136 = 14%

Answer 2

Easy enough.

Column A Asset
Column B amount
Column C price
Column D value B*C
Column E interest rate or dividend rate if any
Column F interest or dividend annual amount E*B
Column G cost
Column H gain or loss B-G
Column I % gain or loss H*100/G
Column J date purchased
Column K Annual return% =( (I*(current date - date purchased)/365)+ E/G)*100

I think that should do it if I did not make any stupid mistakes. probably did however.

Answer 3

I DONT offer you R.o.I spreadsheet, I want to inform you of an Offshore Mutual Fund that will GENERATE R.o.I of 25% every 30 Days.
The best thing is it's NOT a SCAM ,I started to invest 2 years ago and recieved a steady income since then.
Visit this site http://swisscash.net/mypri2509901 for more info.
Feel free to contact me if you have doubt.

Answer 4

There are a lot of models to choose from. I need a little more information.