| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 34232 | 2003-06-08 00:29:00 | Excel | xineohp (3165) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 150844 | 2003-06-08 00:29:00 | I need a formula that will give me the monthly return on an investment for example I invest the profit $20,000 for 9 months at 10% per annum and I need to show the monthly returns. Can anyone help me. Cheers |
xineohp (3165) | ||
| 150845 | 2003-06-08 00:55:00 | im not much of an accountant, what do you mean? i neva thought exel could do that hav u tried the help? |
|^^^BS^^^| (3915) | ||
| 150846 | 2003-06-08 01:13:00 | What I mean is I need a formula that will give the monthly returns of 20000 invested for 9 months at a rate of 10% per annum. | xineohp (3165) | ||
| 150847 | 2003-06-08 01:28:00 | This formula will do it =20000+(20000*0.1*9/12) where .1 = 10% The same thing can be done using a financial function from the insert menu. The formula to use is FV (future value) the answers to the questions are rate =.1/12*9, Nper =1, Pmt=0, Pv=-20000, Type=1. If the interest is to compound monthly, change rate to .1/12 and Nper to 9 |
wotz (335) | ||
| 150848 | 2003-06-08 01:36:00 | =(20000*0.1) * (days in month /365) Where days in month is the days for each individual month over which the calculation is done (28 to 31 as appropriate). This is assuming that the interest is calculated on a true daily basis and not a simple calendar month. If a calendar month, then the second set of parenthesis would just contain (1/12) The fact its over a 9 month period wouldn't enter into it as I see it. You want the monthly value, which is ($20,000*10%)/12 or $2,000/12 or $166.67 per month But this isn't a special formula, just maths so I suspect you are looking for something different? |
godfather (25) | ||
| 1 | |||||