• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Projected values

R

Raluca

New Member
Hello everyone! I've tried most formulas, I just can't get a hold of the right one. I am definitely doing something wrong. I need to find out the projected values at 10% per growth. I've attached the doc. Your help would be much appreciated!! Thank you in advance!
 

Attachments

  • Regular Projection Calculator.xls
    10.5 KB · Views: 5
Hi Raluca, and welcome to the forum! :awesome:

My assumptions:
Row 4 is the monthly amount being put into investment
Col A is how long the investment has been built
10% is the average annual return
Payments are made every month

If all the above is correct, formula in C5 is:
=FV(10%/12,$A5*12,-C$4)

Copy down and to the right as needed.

If assumption are incorrect, please advise and/or change example file to include what correct answer should be.
 
Hi Luke! Thanks a lot for your answer,much appreciated!

It worked for the first column, however, when I am trying to drag and fill in, it just comes up with 0 as the amount for the other premiums. That also if I introduce the formula myself. Any advice on that? Thank you!
 
Managed to get it sorted! Thank you so much, Luke, I really appreciate the help!

Have a good day!

Kind regards,

R.
 
You must log in or register to reply here.
Back
Top