Loading...

Invest for Excel® video tutorial, example calculation: 375 kW Hydro-power Plant

8,591 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 18, 2015

Watch a simple investment calculation being made in Invest for Excel® Software in 5 easy steps. Overview of main program features: Investments, Income Statement, Balance Sheet, Cash-Flow Statement, Working Capital, NPV calculation, IRR, Payback time, Profitability Analysis, Sensitivity Analysis, Break-even point, Charts and Comparison table.

Example Case: Small Hydro-power Plant

Investments: € 500 000
Amortization time: 40 years
Generating power: 375 kW
Electricity price: € 40 per MWh
Calculation term: 16 years
Fixed costs: € 1 800 p.a.

Maintenance cost in 2018: € 20 000
Maintenance cost in 2024: € 20 000

Working capital effects
Accounts receivable, average delay: 30 days
Accounts payable, average delay: 28 days

Required rate of return: 6 %
Inflation rate: 1.5 %

Will it be profitable? Let's find out!


Bonus: Comparison with alternative scenario of upgraded generator that requires extra € 300 000 of investments, but promises a 20% increase of electricity production.

Invest for Excel® calculations are based on discounted cash-flow methodology.


Download a free trial version: http://www.datapartner.fi/en/download
Product page: http://www.datapartner.fi/en/products...
Book a free presentation: http://www.datapartner.fi/en/request-...

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...