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.

Adenosine deaminase and tuberculous meningitis-A systematic review with meta-analysis

Tuberculous meningitis (TBM) is a severe infection of the central nervous system, particularly in developing countries. Prompt diagnosis and treatment are necessary to decrease the high rates of disability and death associated with TBM. The diagnosis is often time and labour intensive; thus, a simple, accurate and rapid diagnostic test is needed. The adenosine deaminase (ADA) activity test is a rapid test that has been used for the diagnosis of the pleural, peritoneal and pericardial forms of tuberculosis. However, the usefulness of ADA in TBM is uncertain. The aim of this study was to evaluate ADA as a diagnostic test for TBM in a systematic review. A systematic search was performed of the medical literature (MEDLINE, LILACS, Web of Science and EMBASE). The ADA values from TBM cases and controls (diagnosed with other types of meningitis) were necessary to calculate the sensitivity and specificity. Out of a total of 522 studies, 13 were included in the meta-analysis (380 patients with TBM). The sensitivity, specificity and diagnostic odds ratios (DOR) were calculated based on arbitrary ADA cut-off values from 1 to 10 U/l. ADA values from 1 to 4 U/l (sensitivity > 93% and specificity < 80%) helped to exclude TBM; values between 4 and 8 U/l were insufficient to confirm or exclude the diagnosis of TBM (p = 0.07), and values > 8 U/l (sensitivity < 59% and specificity > 96%) improved the diagnosis of TBM (p < 0.001). None of the cut-off values could be used to discriminate between TBM and bacterial meningitis. In conclusion, ADA cannot distinguish between bacterial meningitis and TBM, but using ranges of ADA values could be important to improve TBM diagnosis, particularly after bacterial meningitis has been ruled out. The different methods used to measure ADA and the heterogeneity of data do not allow standardization of this test as a routine.

Validation of a Cutoff Value on Echo Doppler Analysis to Replace Right Heart Catheterization During Pulmonary Hypertension Evaluation in Heart Transplant Candidates

Background. Heart transplantation (OHT) has traditionally been contraindicated in the presence of severe pulmonary hypertension (PH), as detected by right heart catheterization. Noninvasive methods are still not reliably accurate to make this evaluation. Objectives. Determine the efficacy of echo Doppler analysis for the diagnosis of severe PH. Methods. One hundred thirty patients (mean age = 42 +/- 15 years, 82 men) showed severe left ventricular dysfunction (mean ejection fraction = 29 +/- 12%; functional class III-IV). We excluded patients with atrial fibrillation, heart failure secondary to congenital disease, and valvulopathy. The pulmonary parameters defined as severe PH were: systolic pulmonary artery pressure (sPAP) >= 60 mm Hg; a mean transpulmonary gradient >= 15; or pulmonary vascular resistance >= 5 Wood units. Patients underwent a right heart catheterization using a Swan-Ganz catheter to measure hemodynamic parameters and to noninvasively estimate right-sided pressures from spectral Doppler recordings of tricuspid regurgitation velocity (right ventricular systolic pressure [RVsP]). A Pearson correlation of sPAP was obtained with RVsP by; the sensitivity of RVsP for the diagnosis of PH was determined by a receiver operating characteristic (ROC) curve. Results. A good correlation between sPAP and RVsP was obtained by Pearson correlation analysis (r = 0.64; 95% confidence interval [CI] 0.50-0.75; P < .001). The ROC curve analysis showed a sensitivity of 100%, a specificity of 37.2%, (95% CI 0.69-0.83, P < .0001) of a RVsP < 45 mm Hg (cutoff) on the exclusion of severe PH. Conclusions. The cutoff of RVsP < 45 mm Hg, on noninvasive echo Doppler evaluation of PH is an efficient method to replace invasive heart catheterization in OHT candidates.

Agreement for Detecting Glaucoma Progression with the GDx Guided Progression Analysis, Automated Perimetry, and Optic Disc Photography

Purpose: To evaluate the ability of the GDx Variable Corneal Compensation (VCC) Guided Progression Analysis (GPA) software for detecting glaucomatous progression. Design: Observational cohort study. Participants: The study included 453 eyes from 252 individuals followed for an average of 46 +/- 14 months as part of the Diagnostic Innovations in Glaucoma Study. At baseline, 29% of the eyes were classified as glaucomatous, 67% of the eyes were classified as suspects, and 5% of the eyes were classified as healthy. Methods: Images were obtained annually with the GDx VCC and analyzed for progression using the Fast Mode of the GDx GPA software. Progression using conventional methods was determined by the GPA software for standard automated achromatic perimetry (SAP) and by masked assessment of optic disc stereophotographs by expert graders. Main Outcome Measures: Sensitivity, specificity, and likelihood ratios (LRs) for detection of glaucoma progression using the GDx GPA were calculated with SAP and optic disc stereophotographs used as reference standards. Agreement among the different methods was reported using the AC(1) coefficient. Results: Thirty-four of the 431 glaucoma and glaucoma suspect eyes (8%) showed progression by SAP or optic disc stereophotographs. The GDx GPA detected 17 of these eyes for a sensitivity of 50%. Fourteen eyes showed progression only by the GDx GPA with a specificity of 96%. Positive and negative LRs were 12.5 and 0.5, respectively. None of the healthy eyes showed progression by the GDx GPA, with a specificity of 100% in this group. Inter-method agreement (AC1 coefficient and 95% confidence intervals) for non-progressing and progressing eyes was 0.96 (0.94-0.97) and 0.44 (0.28-0.61), respectively. Conclusions: The GDx GPA detected glaucoma progression in a significant number of cases showing progression by conventional methods, with high specificity and high positive LRs. Estimates of the accuracy for detecting progression suggest that the GDx GPA could be used to complement clinical evaluation in the detection of longitudinal change in glaucoma. Financial Disclosure(s): Proprietary or commercial disclosure may be found after the references. Ophthalmology 2010; 117: 462-470 (C) 2010 by the American Academy of Ophthalmology.

Differential display and suppression subtractive hybridization analysis of the pulp of ripening banana

The fruit of banana undergoes several important physico-chemical changes during ripening. Analysis of gene expression would permit identification of important genes and regulatory elements involved in this process. Therefore, transcript profiling of preclimacteric and climacteric fruit was performed using differential display and Suppression subtractive hybridization. Our analyses resulted in the isolation of 12 differentially expressed cDNAs, which were confirmed by dot-blots and northern blots. Among the sequences identified were sequences homologous to plant aquaporins, adenine nucleotide translocator, immunophilin, legumin-like proteins, deoxyguanosine kinase and omega-3 fatty acid desaturase. Some of these cDNAs correspond to newly isolated genes involved in changes related to the respiratory climacteric, or stress-defense responses. Functional characterization of ripening-associated genes could provide information useful in controlling biochemical pathways that would have an impact on banana quality and shelf life. (C) 2009 Elsevier B.V. All rights reserved.

Quantitative myocardial contrast echocardiography during pharmacological stress for diagnosis of coronary artery disease: a systematic review and meta-analysis of diagnostic accuracy studies

Aims We conducted a meta-analysis to evaluate the accuracy of quantitative stress myocardial contrast echocardiography (MCE) in coronary artery disease (CAD). Methods and results Database search was performed through January 2008. We included studies evaluating accuracy of quantitative stress MCE for detection of CAD compared with coronary angiography or single-photon emission computed tomography (SPECT) and measuring reserve parameters of A, beta, and A beta. Data from studies were verified and supplemented by the authors of each study. Using random effects meta-analysis, we estimated weighted mean difference (WMD), likelihood ratios (LRs), diagnostic odds ratios (DORs), and summary area under curve (AUC), all with 95% confidence interval (0). Of 1443 studies, 13 including 627 patients (age range, 38-75 years) and comparing MCE with angiography (n = 10), SPECT (n = 1), or both (n = 2) were eligible. WMD (95% CI) were significantly less in CAD group than no-CAD group: 0.12 (0.06-0.18) (P < 0.001), 1.38 (1.28-1.52) (P < 0.001), and 1.47 (1.18-1.76) (P < 0.001) for A, beta, and A beta reserves, respectively. Pooled LRs for positive test were 1.33 (1.13-1.57), 3.76 (2.43-5.80), and 3.64 (2.87-4.78) and LRs for negative test were 0.68 (0.55-0.83), 0.30 (0.24-0.38), and 0.27 (0.22-0.34) for A, beta, and A beta reserves, respectively. Pooled DORs were 2.09 (1.42-3.07), 15.11 (7.90-28.91), and 14.73 (9.61-22.57) and AUCs were 0.637 (0.594-0.677), 0.851 (0.828-0.872), and 0.859 (0.842-0.750) for A, beta, and A beta reserves, respectively. Conclusion Evidence supports the use of quantitative MCE as a non-invasive test for detection of CAD. Standardizing MCE quantification analysis and adherence to reporting standards for diagnostic tests could enhance the quality of evidence in this field.