Conceptual Understanding of Rate / Volume Analysis for Balance Sheet changes











up vote
1
down vote

favorite












Not sure if this is the right place to ask this but I searched and didn't find this question already asked. I am having a lot of trouble conceptually understanding the formulas behind a rate / volume analysis for changes to a bank's balance sheet. I know this is just a specific application of a more general question (apportioning change to different factors) but this is the application within which I am working. Below is an example and then my question.




  • Time Period 1: Balances = 100, Interest Rate = 1%, Income = 100 * 1% = 1

  • Time Period 2: Balances = 200, Interest Rate = 2%, Income = 200 * 2% = 4

  • Change in Income = 4 - 1 = 3


I am trying to explain how much of the increase in income is due to the balance increase and how much is due to the interest rate increase. The way I was taught to do this, and everything I've read in the last hour or so of googling, is below:




  • Change due to volumes = (200 - 100) * 1% = 100 * 1% = 1

  • Change due to rates = (2% - 1%) * 200 = 1% * 200 = 2


The math here works, and I understand what we're doing conceptually by calculating the change due to volumes (in the absence of any rate increase this is the income that is attributable to our observed volume increase), but I don't understand what we're doing conceptually by calculating the change due to rates; it seems like we should be multiplying the change in rates times the old balances i.e. calculating increased income in the absence of any balance increase. That math doesn't work, though.



Assuming these are the correct calculations for apportioning change (and if they aren't please let me know!), what is the conceptual explanation behind what we're doing to calculate rate change? And is my understanding of change due to volumes incorrect?










share|cite|improve this question
























  • You haven´t calculated the variance. Please read the definition of the variance here:en.wikipedia.org/wiki/Variance
    – callculus
    May 21 '16 at 22:09










  • Hi, thank you for the link but I know what variance is. I'm not referring to the statistical definition of variance, I'm referring to the colloquial definition just meaning the change in income. I've taken your point, though, and I've edited my post to say "change" instead of "variance".
    – Greg Bunker
    May 21 '16 at 22:35















up vote
1
down vote

favorite












Not sure if this is the right place to ask this but I searched and didn't find this question already asked. I am having a lot of trouble conceptually understanding the formulas behind a rate / volume analysis for changes to a bank's balance sheet. I know this is just a specific application of a more general question (apportioning change to different factors) but this is the application within which I am working. Below is an example and then my question.




  • Time Period 1: Balances = 100, Interest Rate = 1%, Income = 100 * 1% = 1

  • Time Period 2: Balances = 200, Interest Rate = 2%, Income = 200 * 2% = 4

  • Change in Income = 4 - 1 = 3


I am trying to explain how much of the increase in income is due to the balance increase and how much is due to the interest rate increase. The way I was taught to do this, and everything I've read in the last hour or so of googling, is below:




  • Change due to volumes = (200 - 100) * 1% = 100 * 1% = 1

  • Change due to rates = (2% - 1%) * 200 = 1% * 200 = 2


The math here works, and I understand what we're doing conceptually by calculating the change due to volumes (in the absence of any rate increase this is the income that is attributable to our observed volume increase), but I don't understand what we're doing conceptually by calculating the change due to rates; it seems like we should be multiplying the change in rates times the old balances i.e. calculating increased income in the absence of any balance increase. That math doesn't work, though.



Assuming these are the correct calculations for apportioning change (and if they aren't please let me know!), what is the conceptual explanation behind what we're doing to calculate rate change? And is my understanding of change due to volumes incorrect?










share|cite|improve this question
























  • You haven´t calculated the variance. Please read the definition of the variance here:en.wikipedia.org/wiki/Variance
    – callculus
    May 21 '16 at 22:09










  • Hi, thank you for the link but I know what variance is. I'm not referring to the statistical definition of variance, I'm referring to the colloquial definition just meaning the change in income. I've taken your point, though, and I've edited my post to say "change" instead of "variance".
    – Greg Bunker
    May 21 '16 at 22:35













up vote
1
down vote

favorite









up vote
1
down vote

favorite











Not sure if this is the right place to ask this but I searched and didn't find this question already asked. I am having a lot of trouble conceptually understanding the formulas behind a rate / volume analysis for changes to a bank's balance sheet. I know this is just a specific application of a more general question (apportioning change to different factors) but this is the application within which I am working. Below is an example and then my question.




  • Time Period 1: Balances = 100, Interest Rate = 1%, Income = 100 * 1% = 1

  • Time Period 2: Balances = 200, Interest Rate = 2%, Income = 200 * 2% = 4

  • Change in Income = 4 - 1 = 3


I am trying to explain how much of the increase in income is due to the balance increase and how much is due to the interest rate increase. The way I was taught to do this, and everything I've read in the last hour or so of googling, is below:




  • Change due to volumes = (200 - 100) * 1% = 100 * 1% = 1

  • Change due to rates = (2% - 1%) * 200 = 1% * 200 = 2


The math here works, and I understand what we're doing conceptually by calculating the change due to volumes (in the absence of any rate increase this is the income that is attributable to our observed volume increase), but I don't understand what we're doing conceptually by calculating the change due to rates; it seems like we should be multiplying the change in rates times the old balances i.e. calculating increased income in the absence of any balance increase. That math doesn't work, though.



Assuming these are the correct calculations for apportioning change (and if they aren't please let me know!), what is the conceptual explanation behind what we're doing to calculate rate change? And is my understanding of change due to volumes incorrect?










share|cite|improve this question















Not sure if this is the right place to ask this but I searched and didn't find this question already asked. I am having a lot of trouble conceptually understanding the formulas behind a rate / volume analysis for changes to a bank's balance sheet. I know this is just a specific application of a more general question (apportioning change to different factors) but this is the application within which I am working. Below is an example and then my question.




  • Time Period 1: Balances = 100, Interest Rate = 1%, Income = 100 * 1% = 1

  • Time Period 2: Balances = 200, Interest Rate = 2%, Income = 200 * 2% = 4

  • Change in Income = 4 - 1 = 3


I am trying to explain how much of the increase in income is due to the balance increase and how much is due to the interest rate increase. The way I was taught to do this, and everything I've read in the last hour or so of googling, is below:




  • Change due to volumes = (200 - 100) * 1% = 100 * 1% = 1

  • Change due to rates = (2% - 1%) * 200 = 1% * 200 = 2


The math here works, and I understand what we're doing conceptually by calculating the change due to volumes (in the absence of any rate increase this is the income that is attributable to our observed volume increase), but I don't understand what we're doing conceptually by calculating the change due to rates; it seems like we should be multiplying the change in rates times the old balances i.e. calculating increased income in the absence of any balance increase. That math doesn't work, though.



Assuming these are the correct calculations for apportioning change (and if they aren't please let me know!), what is the conceptual explanation behind what we're doing to calculate rate change? And is my understanding of change due to volumes incorrect?







analysis volume variance






share|cite|improve this question















share|cite|improve this question













share|cite|improve this question




share|cite|improve this question








edited May 21 '16 at 22:34

























asked May 21 '16 at 21:18









Greg Bunker

613




613












  • You haven´t calculated the variance. Please read the definition of the variance here:en.wikipedia.org/wiki/Variance
    – callculus
    May 21 '16 at 22:09










  • Hi, thank you for the link but I know what variance is. I'm not referring to the statistical definition of variance, I'm referring to the colloquial definition just meaning the change in income. I've taken your point, though, and I've edited my post to say "change" instead of "variance".
    – Greg Bunker
    May 21 '16 at 22:35


















  • You haven´t calculated the variance. Please read the definition of the variance here:en.wikipedia.org/wiki/Variance
    – callculus
    May 21 '16 at 22:09










  • Hi, thank you for the link but I know what variance is. I'm not referring to the statistical definition of variance, I'm referring to the colloquial definition just meaning the change in income. I've taken your point, though, and I've edited my post to say "change" instead of "variance".
    – Greg Bunker
    May 21 '16 at 22:35
















You haven´t calculated the variance. Please read the definition of the variance here:en.wikipedia.org/wiki/Variance
– callculus
May 21 '16 at 22:09




You haven´t calculated the variance. Please read the definition of the variance here:en.wikipedia.org/wiki/Variance
– callculus
May 21 '16 at 22:09












Hi, thank you for the link but I know what variance is. I'm not referring to the statistical definition of variance, I'm referring to the colloquial definition just meaning the change in income. I've taken your point, though, and I've edited my post to say "change" instead of "variance".
– Greg Bunker
May 21 '16 at 22:35




Hi, thank you for the link but I know what variance is. I'm not referring to the statistical definition of variance, I'm referring to the colloquial definition just meaning the change in income. I've taken your point, though, and I've edited my post to say "change" instead of "variance".
– Greg Bunker
May 21 '16 at 22:35










1 Answer
1






active

oldest

votes

















up vote
1
down vote













I think it would be easier if you imagine an interim state where
Balance = 200, and interest rate = 1%.
The change can be regarded as two small changes.




  1. From Period 1 to interim state. Balance increased from 100 to 200. But rate stays the same.

  2. From interim state to Period 2. Balance stays as 200. But rate increased from 1% to 2%.






share|cite|improve this answer























  • This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
    – Leucippus
    Nov 20 at 22:20










  • @Leucippus I realize that comment is from review, but I think that this answer does explain conceptually how the formulas in the question were derived.
    – jgon
    Nov 20 at 23:45











Your Answer





StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");

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',
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
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f1794661%2fconceptual-understanding-of-rate-volume-analysis-for-balance-sheet-changes%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
1
down vote













I think it would be easier if you imagine an interim state where
Balance = 200, and interest rate = 1%.
The change can be regarded as two small changes.




  1. From Period 1 to interim state. Balance increased from 100 to 200. But rate stays the same.

  2. From interim state to Period 2. Balance stays as 200. But rate increased from 1% to 2%.






share|cite|improve this answer























  • This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
    – Leucippus
    Nov 20 at 22:20










  • @Leucippus I realize that comment is from review, but I think that this answer does explain conceptually how the formulas in the question were derived.
    – jgon
    Nov 20 at 23:45















up vote
1
down vote













I think it would be easier if you imagine an interim state where
Balance = 200, and interest rate = 1%.
The change can be regarded as two small changes.




  1. From Period 1 to interim state. Balance increased from 100 to 200. But rate stays the same.

  2. From interim state to Period 2. Balance stays as 200. But rate increased from 1% to 2%.






share|cite|improve this answer























  • This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
    – Leucippus
    Nov 20 at 22:20










  • @Leucippus I realize that comment is from review, but I think that this answer does explain conceptually how the formulas in the question were derived.
    – jgon
    Nov 20 at 23:45













up vote
1
down vote










up vote
1
down vote









I think it would be easier if you imagine an interim state where
Balance = 200, and interest rate = 1%.
The change can be regarded as two small changes.




  1. From Period 1 to interim state. Balance increased from 100 to 200. But rate stays the same.

  2. From interim state to Period 2. Balance stays as 200. But rate increased from 1% to 2%.






share|cite|improve this answer














I think it would be easier if you imagine an interim state where
Balance = 200, and interest rate = 1%.
The change can be regarded as two small changes.




  1. From Period 1 to interim state. Balance increased from 100 to 200. But rate stays the same.

  2. From interim state to Period 2. Balance stays as 200. But rate increased from 1% to 2%.







share|cite|improve this answer














share|cite|improve this answer



share|cite|improve this answer








edited Nov 20 at 23:46









jgon

11.1k11839




11.1k11839










answered Nov 20 at 21:54









Yan

111




111












  • This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
    – Leucippus
    Nov 20 at 22:20










  • @Leucippus I realize that comment is from review, but I think that this answer does explain conceptually how the formulas in the question were derived.
    – jgon
    Nov 20 at 23:45


















  • This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
    – Leucippus
    Nov 20 at 22:20










  • @Leucippus I realize that comment is from review, but I think that this answer does explain conceptually how the formulas in the question were derived.
    – jgon
    Nov 20 at 23:45
















This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
– Leucippus
Nov 20 at 22:20




This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
– Leucippus
Nov 20 at 22:20












@Leucippus I realize that comment is from review, but I think that this answer does explain conceptually how the formulas in the question were derived.
– jgon
Nov 20 at 23:45




@Leucippus I realize that comment is from review, but I think that this answer does explain conceptually how the formulas in the question were derived.
– jgon
Nov 20 at 23:45


















draft saved

draft discarded




















































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.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • 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.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f1794661%2fconceptual-understanding-of-rate-volume-analysis-for-balance-sheet-changes%23new-answer', 'question_page');
}
);

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







Popular posts from this blog

Probability when a professor distributes a quiz and homework assignment to a class of n students.

Aardman Animations

Are they similar matrix