Change set

Pick exam & year, then Go.

Question map
Not attempted Correct Incorrect ★ Bookmarked
Loading…
Q144 (CISF/2019) Science & Technology › ICT, AI, Cybersecurity & Emerging Tech

In MS-Excel 2007, NPV(rate, value1, [value 2], ... ) is a financial function that returns

Explanation

In MS-Excel, the NPV (Net Present Value) function calculates the net value of an investment by using a discount rate and a series of future cash flows. The rate represents the discount rate for one period, while value1, value2, ... represent payments (negative values) and income (positive values) occurring at the end of each period.

  • Option B describes the NPER function, which calculates the number of periods for an investment.
  • Option C describes the FV function, which calculates the future value of an investment with constant payments.
  • Option D describes the FVSCHEDULE function, which calculates the future value of an initial principal after applying a series of compound interest rates.
✓ Thank you! We'll review this.

SIMILAR QUESTIONS

CAPF · 2017 · Q68 Relevance score: -8.00

The difference between the compound interest and the simple interest for 2 years on a sum of money is Rs. 60. If the simple interest for 2 years is Rs. 1440, what is the rate of interest ?

CDS-II · 2013 · Q63 Relevance score: -8.15

The value of money varies :

CDS-I · 2021 · Q88 Relevance score: -8.22

The percentage by which the money the borrower pays back exceeds the money that was borrowed is called as

IAS · 2016 · Q43 Relevance score: -8.23

What is/are the purpose/purposes of the 'Marginal Cost of Funds based Lending Rate (MCLR)' announced by RBI? 1. These guidelines help improve the transparency in the methodology followed by banks for determining the interest rates on advances. 2. These guidelines help ensure availability of bank credit at interest rates which are fair to the borrowers as well as the banks. Select the correct answer using the code given below.