Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
373 views
in Spread Sheet by (27.3k points)
closed by

Calculate the present value of an annuity that pays Rs. 3000 per month for a period of 5 years. The interest is 11.5% per annum and each payment is made at the end of the month. Assume the payments are made.

  • At the beginning of each month 
  • At the end of each month

1 Answer

+1 vote
by (25.6k points)
selected by
 
Best answer

Procedure: 

Step 1 – Open a new blank worksheet in LibreOffice Calc 

Step 2 – Enter the following data/ Formula in respective cells.

Step 3 – Enter the formula as follows

B6 = PV (B2/12, B3*12, B4, B5) 

C6 = PV(C2/12, C3*12, C4, C5)

Output:

Present value - at the beginning 136409.4
Present value - at the end 136410.04

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...