Gama Ltd. has to select a capital project between Project A and Project B. The details...

 

Transcribed Image Text:

Gama Ltd. has to select a capital project between Project A and Project B. The details of both the projects are given below: Cash Flows Year Project A Project B O -2000 -2000 1 1500 150 2 700 850 3 50 1500 You are required to write the formulas/ functions to calculate internal rate of return (IRR) of both the projects. What will be the formula or function to determine NPV of the projects if the discount rate is 10%. If the same amount of Rs. 2000 is invested elsewhere at 10% p.a. what will be the future value of the invested amount? You are required to only write the formulas/functions. No need to determine the exact amount. Gama Ltd. has to select a capital project between Project A and Project B. The details of both the projects are given below: Cash Flows Year Project A Project B O -2000 -2000 1 1500 150 2 700 850 3 50 1500 You are required to write the formulas/ functions to calculate internal rate of return (IRR) of both the projects. What will be the formula or function to determine NPV of the projects if the discount rate is 10%. If the same amount of Rs. 2000 is invested elsewhere at 10% p.a. what will be the future value of the invested amount? You are required to only write the formulas/functions. No need to determine the exact amount.

Answer rating: 100% (QA)

FormulasFunctions to calculate IRR of Projects IRRcashflows0 Where IRR I... View the full answer