Back to lesson
1. Which of the following is not a directly related variable in calculating interest received?
Opening debt balance
Non-interest cash movement for the period
2. Of the three interest received modelling methods used in practice, which one is our preferred option and why?
A macro-based copy and paste solution using Visual Basic for Applications (VBA)
An iterative technique using Goal Seek as this allows for up to 32,767 iterations balancing accuracy with transparency
The formulaic solution (based on solving simultaneous equations) as it provides the exact answer
3. Which of the following situations would cause the algebraic method of calculating interest received to “technically” fail?
Average cash being calculated solely on the closing balance
Tax equals 100% (essential to deriving the formula)
Average cash being calculated solely on the opening balance
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement