QUESTION NO.12
A company proposes to invest 10,00,000 by installing a plant and machinery with
expected cash inflow of Rs. 400,000 and Rs. 350,000 ₹275,000 and 225,000
respectively for 4 years of its life . Find out the Net Present Value of the project using
appropriate Spreadsheet Function. The Normal rate of return of business is 20%
Procedure and Answers
1).Open LibreOffice Calc.
ii) Enter the values as given below

iii) Apply the formula
=NPV(B1,B2,B3,B4,B5,B6) then press Enter.
Output ₹
1,29,967.21.