Recent content by indigo2

  1. I

    MHB How to use the RATE function in Excel ?

    Hello :) I was given this task: A quarterly deposit is €700 in 4.5 years, and the accumulated value is €13,600. What is the value of annual interest rate? And I would apply this formula: S = [((1+i)n - 1) / i] ∙ R €13,600 = [((1+i)18 - 1) / i] ∙ €700 To find out the annual interest rate...
  2. I

    MHB Applying the annuity method - how?

    Hello, I was given following task: A food processing company has to make a decision whether or not to expand its production facilities. A feasibility study showed the following estimates: Initial cost outlay €800,000 Further outlay in 4 years €600,000 Residual value after 10 years €200,000...