Introduction to Discounted Cash Flow Analysis and Financial Functions in Excel

The financial and economic analysis of investment projects is typically carried out using the technique of discounted cash flow (DCF) analysis. This module introduces concepts of discounting and DCF analysis for the derivation of project performance criteria such as net present value (NPV), internal rate of return (IRR) and benefit to cost (B/C) ratios. These concepts and criteria are introduced with respect to a simple example, for which calculations using MicroSoft Excel are demonstrated.

An investigation of the microstructure/electrical conductivity relationship in In2O3-substituted LSGM

The effect of controlled In3+ substitution on to the B-site in the perovskite oxygen ion conductor La0.9Sr0.1Ga0.8Mg0.2O2.85 (LSGM) has been examined with a view to exploring the influence on oxygen ion conductivity. In combination with the electrical conductivity study, detailed microstructural analysis was used to verify the location of the substituting cation and to determine the nature of secondary phase formation. The indium species clearly substituted for Ga3+ on the B-site of the lattice and the electrical conductivity showed a gradual decrease as the In+3 content increased. The interpretation of this data was complicated by the formation of the secondary phases LaInO3 and LaSrGaO4. (C) 2001 Elsevier Science Ltd. All rights reserved.

The effect of heat treatment on the toughness, hardness and microstructure of low carbon white cast irons

The effect of destabilisation and subcritical heat treatment on the impact toughness, hardness, and the amount and mechanical stability of retained austenite in a low carbon white cast iron have been investigated. The experimental results show that the impact energy constantly increases when the destabilisation temperature is raised from 950 degreesC to 1200 degreesC. Although the hardness decreases, the heat-treated hardness is still greater than the as-cast state. After destabilisation treatment at 1130 degreesC, tempering at 200 to 250 degreesC for 3 hours leads to the highest impact toughness, and secondary hardening was observed when tempering over 400 degreesC. The amount of retained austenite increased with the increase in the destabilisation temperature, and the treatment significantly improves the mechanical stability of the retained austenite compared with the as-cast state. Tempering below 400 degreesC does not affect the amount of retained austenite and its mechanical stability. But the amount of retained austenite is dramatically reduced when tempered above 400 degreesC. The relationship between the mechanical properties and the microstructure changes was discussed. (C) 2001 Kluwer Academic Publishers.