NPV Formula: Capital Budgeting Report

Exclusively available on IvyPanda Available only on IvyPanda

NPV is the difference between the initial cash input to a project and expected cash inflows from the project. The sign of the value of the NPV is very significant. A positive value indicates that the project is viable where as a zero indicates that the input to the project and the returns are equal. A negative value indicates that investment is not worthy of the money that is about to invest in it as the returns will be less than the expenditure.

We will write a custom essay on your topic a custom Report on NPV Formula: Capital Budgeting
808 writers online

NPV Formula

NPV Formula

Where; CF represents the amount

K represents the rate.

CFO represents the initial expenditure.

From the equation,

12 % revenue.

1 hour!
The minimum time our certified writers need to deliver a 100% original paper

Note: all the values used are in millions of dollars.

NPV= Equation -150

NPV=-117.857

Extra 10% revenue.ie 22%.

NPV= Equation -150

NPV=-120.4918

10% lower revenue.

Remember! This is just a sample
You can get your custom paper by one of our expert writers

NPV= Equation -150

NPV=-114.7058

With a growth of 2%,

Year 2

NPV= Equation -150

NPV=-118.421.

Year 3

NPV= Equation -150

NPV=-118.9655.

It is evident that the NPV becomes more negative with the increase in revenue.

We will write
a custom essay
specifically for you
Get your first paper with
15% OFF

With a 5% growth in revenue,

NPV= Equation-150

NPV=-119.2307.

NPV= Equation-150

NPV=-120.4918

If the revenues grow by a rate of 5% every year the NPV becomes more negative hence investing in the project becomes more costly than when the revenue grows with a rate of2%yearly.

RevenueNPV(millions of dollars)
5%-115.7143
10%-117.2727
15%-118.6956
20%-120.0000
25%-121.2000
30%-122.3077

NPV vs REVENUE

From the graph, it is seen that the NPV does not become positive. This is a clear indication that the project is not viable as the returns are not worth that is the expenditure is more than the income from that project.

Print
Need an custom research paper on NPV Formula: Capital Budgeting written from scratch by a professional specifically for you?
808 writers online
Cite This paper
Select a referencing style:

Reference

IvyPanda. (2021, March 24). NPV Formula: Capital Budgeting. https://ivypanda.com/essays/npv-formula-capital-budgeting/

Work Cited

"NPV Formula: Capital Budgeting." IvyPanda, 24 Mar. 2021, ivypanda.com/essays/npv-formula-capital-budgeting/.

References

IvyPanda. (2021) 'NPV Formula: Capital Budgeting'. 24 March.

References

IvyPanda. 2021. "NPV Formula: Capital Budgeting." March 24, 2021. https://ivypanda.com/essays/npv-formula-capital-budgeting/.

1. IvyPanda. "NPV Formula: Capital Budgeting." March 24, 2021. https://ivypanda.com/essays/npv-formula-capital-budgeting/.


Bibliography


IvyPanda. "NPV Formula: Capital Budgeting." March 24, 2021. https://ivypanda.com/essays/npv-formula-capital-budgeting/.

Powered by CiteTotal, best essay citation creator
If you are the copyright owner of this paper and no longer wish to have your work published on IvyPanda. Request the removal
More related papers
Cite
Print
1 / 1