IRR / PVIF

1752 views 8 replies

AGENT IS GIVING ME BELOW OFFER

I HAVE TO INVEST RS 60,000 / YEAR FOR 5 YEAR THAT MEANS I HAVE TO INVEST RS 300,000 IN FIVE YEARS ONLY THEN I WILL NOT INVEST ANYTHING, BUT END OF TWELVE YEARS HE WILL GIVE ME RS. 1,200,000 - WHAT IS PVIF/ IRR - IS IT ADVICEALE

ONLINE : parajf @ yahoo.com

                 parajf @ gmail.com

 

Replies (8)
As per my calculations, it is 14.9 %........... Although ULIP's which theAgent is trying to sell you, are NEVER recommended........ A term plan is best...... They recommend Such plans coz about 25 % of your premium goes towards their commission........

how did you calculate, please forward me your calculation file, what % of discount you have taken, thanking you in advance

Well, I did it on a calc....here s it.... The PV factor will remain them same if you invest 3,00,000 at one go for 10 years..... Hope u got what m trying to say....... So, 3,00,000 at x % interest rate yields 12,00,000 at end of 10 years.... A simple sum that can be solved by formula......... :)
Hi please share the excel file manmohan.... I worked out and it comes to 14.9 %.... There is some confusion i think....

 

 

HI !

 

IT WILL COME 16.3573 IF INVESTMENT IS MADE AT THE END OF EACH YEAR (WHAT WE DO IN FINANCIAL MANAGEMENT.)

 

IT WILL COME 14.6560% ,IF INVESTMENT IS MADE AT THE BEGAINING  OFEACH YEAR(WHICH IS APPLICABLE IN PRESENT CASE)

 

HENCE ANSWER IS 14.6560 %

 

I HAVE ATTACHED EXCAL FILE.

 

 

REGARDS…………..!

Dear Manmohan

Thanks for the file, very very useful, please attached excel file with calculation of NPV at 10 percent discount, please.... thankyou in advance

 

 

juzar sending you the NPV file as required by u

 

thank you

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 10 July 2026
Article Assistant

N S Gokhale & Co

Thane

CA Inter

View Details
Company
ARTICLESHIP 18 June 2026
Article Assistance

RB KESHRI & CO.

Mumbai

CA Inter

View Details
Company
29 June 2026
Accountant (Finance & Compliance)

TRIEYEZ

Kolkata

CA

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
22 June 2026
Finance Manager- Chartered Accountant

Triveni Turbine Limited

Bengaluru

CA

View Details
Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details
Company
ARTICLESHIP 16 July 2026
CA Article

Pipara & Co. LLP.

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 14 July 2026
Article Assistants

R Shyam and Associates

New Delhi

CA Final

View Details