Excel Applications for Corporate Finance with Excel Tutor

Troy Alton Adair Jr. received his B.S. in computers/information science from the University of Alabama at Birmingham, his M.B.A. from the University of North Dakota, and his Ph.D. in finance from Indiana University. He is senior director of Research Computing Services at Harvard Business School. He is the author of Corporate Finance Demystified, Excel Applications in Corporate Finance, and Excel Applications in Investments. Dr. Adair has served as a consultant on financial data information systems and business intelligence to international banks and insurance companies and as the faculty representative to the board of trustees investments committee at Alma College. Dr. Adair has taught at the University of Michigan, Alma College, Hofstra University, Indiana University, and the University of North Carolina at Chapel Hill. He is a member of the Financial Management Association, the American Finance Association, and the Southern Finance Association.

PART I - EXCEL: SETTING THE STAGEChapter 1 - Making and Using SpreadsheetsChapter 2 - Bringing Data into ExcelPART II - WORKING WITH ACCOUNTING STATEMENTSChapter 3 - Making and Getting Accounting StatementsChapter 4 - Ratio AnalysisPART III - TIME VALUE OF MONEYChapter 5 - Calculating Present and Future ValuesChapter 6 - Compounding and Interest Rate ConversionChapter 7 - Loan Amortization and Payment CompositionPART IV - VALUING SIMPLE FINANCIAL ASSETSChapter 8 - Valuing BondsChapter 9 - Valuing StocksPART V - CAPITAL BUDGETING DECISION RULESChapter 10 - Net Present ValueChapter 11 - Other Capital Budgeting Decision RulesPART VI - PART V – RISK, RETURN AND THE COST OF CAPITALChapter 12 - Measuring Risk and ReturnChapter 13 - Calculating BetaChapter 14 - Analyzing the Security Market LineChapter 15 - Weighted Average Cost of CapitalPART VII - CASH FLOW ANALYSIS AND ESTIMATIONChapter 16 - Estimating Future Cash Flows: Pro Forma AnalysisChapter 17 - Scenario Analysis and Sensitivity AnalysisPART VIII - ADVANCED TOPICS IN CORPORATE FINANCEChapter 18 - Option Valuation in Corporate FinanceChapter 19 - International Corporate Finance