investment formula with fixed periodical deposit and variable interest in excel
$begingroup$
Beeing far from a math guy, I've come here to ask the gurus for help :)
I have an index data imported to spreadsheet and I would like to calculate the investment return after n months with fixed periodical deposits starting from principal of 0. The data involves changing interest (or change of the index value) monthly.
Lets say, I would like to deposit 100$ every month for 36 months in total, starting at any moment during the history (lets say 1st of May 1901 in this case). So what will be my final yield after 36 months feeding the interest rates monthly? (1st of May 1904 in this case). Is there any useful formula that can be used in excel?
The data in spreadsheet looks like this:
data
Thanks a lot
PS. Sorry, I dont even know what is the proper tag for this question
functions
asked Dec 22 '18 at 21:26
salamunsalamun
1
$endgroup$
add a comment |
$begingroup$
Beeing far from a math guy, I've come here to ask the gurus for help :)
I have an index data imported to spreadsheet and I would like to calculate the investment return after n months with fixed periodical deposits starting from principal of 0. The data involves changing interest (or change of the index value) monthly.
Lets say, I would like to deposit 100$ every month for 36 months in total, starting at any moment during the history (lets say 1st of May 1901 in this case). So what will be my final yield after 36 months feeding the interest rates monthly? (1st of May 1904 in this case). Is there any useful formula that can be used in excel?
The data in spreadsheet looks like this:
data
Thanks a lot
PS. Sorry, I dont even know what is the proper tag for this question
functions
asked Dec 22 '18 at 21:26
salamunsalamun
1
$endgroup$
$begingroup$
So you invest $$100$ in May and also in June. During June, does the money invested in May earn at the May rate or the June rate?
$endgroup$
– saulspatz
Dec 22 '18 at 21:30
$begingroup$
I guess the may investment would earn at june rate.
$endgroup$
– salamun
Dec 22 '18 at 23:17
$begingroup$
Then it's simple. Each month you increase the principal by interest on the prior balance plus $100,
$endgroup$
– saulspatz
Dec 22 '18 at 23:44
$begingroup$
Yeah, I manage to calculate it like this. I was wondering if there is a formula in excel, that would allow me to insert the data in one row and get the result for certain period of time in other cell.
$endgroup$
– salamun
Dec 24 '18 at 11:40
$begingroup$
I rather doubt it.
$endgroup$
– saulspatz
Dec 24 '18 at 15:38
add a comment |
$begingroup$
Beeing far from a math guy, I've come here to ask the gurus for help :)
I have an index data imported to spreadsheet and I would like to calculate the investment return after n months with fixed periodical deposits starting from principal of 0. The data involves changing interest (or change of the index value) monthly.
Lets say, I would like to deposit 100$ every month for 36 months in total, starting at any moment during the history (lets say 1st of May 1901 in this case). So what will be my final yield after 36 months feeding the interest rates monthly? (1st of May 1904 in this case). Is there any useful formula that can be used in excel?
The data in spreadsheet looks like this:
data
Thanks a lot
PS. Sorry, I dont even know what is the proper tag for this question
functions
asked Dec 22 '18 at 21:26
salamunsalamun
1
$endgroup$
Beeing far from a math guy, I've come here to ask the gurus for help :)
I have an index data imported to spreadsheet and I would like to calculate the investment return after n months with fixed periodical deposits starting from principal of 0. The data involves changing interest (or change of the index value) monthly.
Lets say, I would like to deposit 100$ every month for 36 months in total, starting at any moment during the history (lets say 1st of May 1901 in this case). So what will be my final yield after 36 months feeding the interest rates monthly? (1st of May 1904 in this case). Is there any useful formula that can be used in excel?
The data in spreadsheet looks like this:
data
Thanks a lot
PS. Sorry, I dont even know what is the proper tag for this question
functions
functions
asked Dec 22 '18 at 21:26
salamunsalamun
1
asked Dec 22 '18 at 21:26
salamunsalamun
1
asked Dec 22 '18 at 21:26
salamunsalamun
1
asked Dec 22 '18 at 21:26
salamunsalamun
1
asked Dec 22 '18 at 21:26
salamunsalamun
1
1
$begingroup$
So you invest $$100$ in May and also in June. During June, does the money invested in May earn at the May rate or the June rate?
$endgroup$
– saulspatz
Dec 22 '18 at 21:30
$begingroup$
I guess the may investment would earn at june rate.
$endgroup$
– salamun
Dec 22 '18 at 23:17
$begingroup$
Then it's simple. Each month you increase the principal by interest on the prior balance plus $100,
$endgroup$
– saulspatz
Dec 22 '18 at 23:44
$begingroup$
Yeah, I manage to calculate it like this. I was wondering if there is a formula in excel, that would allow me to insert the data in one row and get the result for certain period of time in other cell.
$endgroup$
– salamun
Dec 24 '18 at 11:40
$begingroup$
I rather doubt it.
$endgroup$
– saulspatz
Dec 24 '18 at 15:38
add a comment |
$begingroup$
So you invest $$100$ in May and also in June. During June, does the money invested in May earn at the May rate or the June rate?
$endgroup$
– saulspatz
Dec 22 '18 at 21:30
$begingroup$
I guess the may investment would earn at june rate.
$endgroup$
– salamun
Dec 22 '18 at 23:17
$begingroup$
Then it's simple. Each month you increase the principal by interest on the prior balance plus $100,
$endgroup$
– saulspatz
Dec 22 '18 at 23:44
$begingroup$
Yeah, I manage to calculate it like this. I was wondering if there is a formula in excel, that would allow me to insert the data in one row and get the result for certain period of time in other cell.
$endgroup$
– salamun
Dec 24 '18 at 11:40
$begingroup$
I rather doubt it.
$endgroup$
– saulspatz
Dec 24 '18 at 15:38
$begingroup$
So you invest $$100$ in May and also in June. During June, does the money invested in May earn at the May rate or the June rate?
$endgroup$
– saulspatz
Dec 22 '18 at 21:30
$begingroup$
So you invest $$100$ in May and also in June. During June, does the money invested in May earn at the May rate or the June rate?
$endgroup$
– saulspatz
Dec 22 '18 at 21:30
$begingroup$
I guess the may investment would earn at june rate.
$endgroup$
– salamun
Dec 22 '18 at 23:17
$begingroup$
I guess the may investment would earn at june rate.
$endgroup$
– salamun
Dec 22 '18 at 23:17
$begingroup$
Then it's simple. Each month you increase the principal by interest on the prior balance plus $100,
$endgroup$
– saulspatz
Dec 22 '18 at 23:44
$begingroup$
Then it's simple. Each month you increase the principal by interest on the prior balance plus $100,
$endgroup$
– saulspatz
Dec 22 '18 at 23:44
$begingroup$
Yeah, I manage to calculate it like this. I was wondering if there is a formula in excel, that would allow me to insert the data in one row and get the result for certain period of time in other cell.
$endgroup$
– salamun
Dec 24 '18 at 11:40
$begingroup$
Yeah, I manage to calculate it like this. I was wondering if there is a formula in excel, that would allow me to insert the data in one row and get the result for certain period of time in other cell.
$endgroup$
– salamun
Dec 24 '18 at 11:40
$begingroup$
I rather doubt it.
$endgroup$
– saulspatz
Dec 24 '18 at 15:38
$begingroup$
I rather doubt it.
$endgroup$
– saulspatz
Dec 24 '18 at 15:38
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "69"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3049856%2finvestment-formula-with-fixed-periodical-deposit-and-variable-interest-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Mathematics Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3049856%2finvestment-formula-with-fixed-periodical-deposit-and-variable-interest-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
$begingroup$
So you invest $$100$ in May and also in June. During June, does the money invested in May earn at the May rate or the June rate?
$endgroup$
– saulspatz
Dec 22 '18 at 21:30
$begingroup$
I guess the may investment would earn at june rate.
$endgroup$
– salamun
Dec 22 '18 at 23:17
$begingroup$
Then it's simple. Each month you increase the principal by interest on the prior balance plus $100,
$endgroup$
– saulspatz
Dec 22 '18 at 23:44
$begingroup$
Yeah, I manage to calculate it like this. I was wondering if there is a formula in excel, that would allow me to insert the data in one row and get the result for certain period of time in other cell.
$endgroup$
– salamun
Dec 24 '18 at 11:40
$begingroup$
I rather doubt it.
$endgroup$
– saulspatz
Dec 24 '18 at 15:38