Expand my Community achievements bar.

tinamoore84
Offline
Type
• All
• Questions
• Discussions
• Ideas
• Blogs
Filter by user contributions
• I am creating a form for a cost benefit analysis and have been able to calculate the Annual Net Present Value out for 5 years.  I now need to have this form calculate the Internal Rate of Return.I am using the FormCalc for all of my calculations. I have the formula on how to calculate the IRR; howev...

Type

Questions

Views

669

Likes

0

Replies

0
• Cost Benefit  AnalysisCompletion of Project Equipment Cost   100,000 Depreciation Term            10 Risk Based Capital Requirements (11%)      11,000 Weighted Average Cost of Capital (WACC)15.00%0.991.992.993.994.99Cash Savings or InflowsYEAR 1YEAR 2YEAR 3YEAR 4YEAR 5Increase in Revenues     10,0...

Type

Questions

Views

330

Likes

0

Replies

0
• I am creating a form for a cost benefit analysis and have been able to calculate the Annual Net Present Value out for 5 years.  I now need to have this form calculate the Internal Rate of Return. I am using the FormCalc for all of my calculations. I have the formula on how to calculate the IRR; how...

Type

Questions

Views

1.2K

Likes

0

Replies

2
• The calculations that are available within FormCalc won't calculate the Internal Rate of Return.

Type

Questions

Views

421

Likes

0

Replies

0
• I have the formula on how to calculate it.  I need to find a way in order for it to be calculated automatically through the form.Here is what my sheet looks like in ExcelCost Benefit  AnalysisCompletion of Project Equipment Cost Depreciation Term Risk Based Capital Requirements (11%)            ...

Type

Questions

Views

419

Likes

0

Replies

0
• Good Morning,I am creating a form for a cost benefit analysis and have been able to calculate the Annual Net Present Value out for 5 years.  I now need to have this form calculate the Internal Rate of Return.I am using the FormCalc for all of my calculations. Does anyone have any suggestions?Thank y...

Type

Questions

Views

1.3K

Likes

0

Replies

4
Top badges earned by tinamoore84
Customize the badges you want to showcase on your profile