New+Files

You can go to the bottom of the page and then press pages and changes and also get a list of the files by date as illustrated in the diagrams below

After you go to the bottom, you can filter by files and then sort by dates to see what has been recently uploaded and what you may have missed.





The above files are related to the Credit Analysis Videos - Uploaded 15 February 2017.



The above files complete the WACC, Debt Beta and Cost of Capital Analysis - Uploaded 15 February 2017.



The above file is adjusted to include credit ratios and market debt to capital - Uploaded 30 January 2017.



The above file demonstrates how to correctly adjust WACC for the interest tax shield - Uploaded 23 January 2017.



The above files are updates with improved graphs for uploading commodity prices, interest rates and stock prices - Uploaded 23 January 2017.



The above files demonstrate how to evaluate actual generation distributions for solar, wind and hydro - Uploaded 12 January 2017.



The above files demonstrate how to size debt in the context of a wind farm with P50, P90, P99 - Uploaded 8 January 2017.



The above file is an improved Interpolate Lookup Function - Uploaded 8 January 2017.

The above file is a revised version of the file that downloads data from PVINSIGHTS and records data from specific historic dates. The file has It is re-formatted and revised to graph data. Uploaded 8 January 2017.



The above file is a revised version of the file that goes to CME and reads various futures prices for Oil, Gas and Electricity. It is re-formatted and imporved. Uploaded 30 December 2016.



The above file is a completed version of the sculpting course. It is described in detail on the project finance exercises page. Uploaded 30 December 2016.



The above file reads time series of currencies from the FRED database and evalutes purchasing power parity relative to actual exchange rates. This kind of analysis should be included in models where the local currency is different from the currency used in financing. Uploaded 3 December 2016.



The above file is a much improved file that demonstrates how to download currencies from a website. If you need current data for currencies in billing etc. I think it can be a help. Uploaded 26 November 2016.



The above file is a update of a comprehensive set of flexible graphs that include waterfall charts, flexible bubble charts and confidence interval charts. The file works with dynamic range names created from the offset function - Uploaded 25 November 2016.



The above file is a detailed rooftop solar model that will be the basis for a comprehensive on-line course - Uploaded 8 November 2016.



The above file is a file that shows how to quickly make a flexible bubble chart with different colours - Uploaded 8 November 2016.



The above file is a much improved Interpolate Lookup Function - Uploaded 28 October 2016.



The above file is the Value for Money in PPP file - Uploaded 25 October 2016.



This file is the comprehensive financial ratio upload file with Dow 30 stocks - Uploaded 25 October 2016.



This file is the file for PE ratio analysis with sensitivity and scenario analysis - Uploaded 25 October 2016.



This file is the file for price to book ratio analysis with regression analysis and formulas developed - Uploaded 25 October 2016.



This file is an update to make waterfall graphs. I still have one thing to fix for excel 2010. Uploaded 25 October 2016.



This file goes to PV insight website and tabulates silicon prices and panel prices for historic periods. Uploaded 2 October 2016.



This file goes to PV insight website and tabulates silicon prices and panel prices for historic periods. Uploaded 2 October 2016.



This the file that goes to alternative websites and then downloads a whole lot of financial data that can be used to evaluate cost of capital. Uploaded 25 September 2016



This file is a corporate model that illustrates different methods of creating assumptions to establish free cash flow. Uploaded 25 September 2016



This file shows how to establish retirements for existing assets. Uploaded 25 September 2016.



Big changes in file to automatically create waterfall charts. Uploaded 11 September 2016



An important file that allows you to automatically add a scenario tab to any of your spreadsheets. Uploaded 31 August 2016



File that includes different tax equity options compared to conventional financing. Uploaded 31 August 2016



Shows how to create flexible graphs with different styles, different timing (month, year quarter), multiple selections, flexible x-scale etc. Uploaded 29 August 2016



Shows how to present evaluate existing model for asset management. Uploaded 29 August 2016



Shows how to evaluate capacity charges and risks associated with 4 part tariff capacity charges. Demonstrates how two tier capacity charges are like synthetic sculpting. Uploaded 29 August 2016



Shows how to model firm and non-firm energy for hydro plant with short fall recovery and merchant analysis. Uploaded 29 August 2016



Shows how to download data and update forecast vs actual for commodity price analysis. Uploaded August 2016



Updated automatic colouring techniques. Uploaded August 2016