banner_ad

IRR / PVIF

AS 1718 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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
22 May 2026
Sr. Financial Analyst - Consolidation

Search Synergy

Mumbai

CA

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details