GoSkills
Back to lesson
Question
1
of
3
1. Which of the following is not a directly related variable in calculating interest received?
Opening debt balance
Tax rate
Non-interest cash movement for the period
Don’t know
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
Don’t know
3. Which of the following situations would cause the algebraic method of calculating interest received to “technically” fail?
Tax equals 100% (essential to deriving the formula)
Average cash being calculated solely on the opening balance
Average cash being calculated solely on the closing balance
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement