Table Of Content1: Spreadsheet Basics.2: The Basic Financial Statements.3: The Cash Budget.4: Financial Statement Analysis Tools.5: Financial Forecasting.6: Break-even and Leverage Analysis.7: The Time Value of Money.8: Stock Valuation and Rates of Return.9: Bond Valuation.10: The Cost of Capital.11: Capital Budgeting.12: Risk, Capital Budgeting, and Diversification.13: Using VBA to Create Function Macros.
Edition DescriptionRevised edition
SynopsisFAME explores the use of Excel as THE calculating tool for finance professionals. As students enter College with basic skills for using Excel and other software packages they need for their business courses, the materials they read must be ramped up. The book as it stands covers the main topics that students would see in a typical corporate finance course: financial statements, budgets, TVM, capital budgeting, the Market Security Line, some options materials, pro forma statements, cost of capital, equities, and debt. In the final chapter of this revision, we include a section on how students can build their own models (or macros) to perform everyday financial analyses., Start mastering the tool that finance professionals depend upon every day. FINANCIAL ANALYSIS WITH MICROSOFT ® EXCEL covers all the topics you'll see in a corporate finance course: financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. Plus, it's easy-to-read and full of study tools that will help you succeed in class., Start mastering the tool that finance professionals depend upon every day. FINANCIAL ANALYSIS WITH MICROSOFT EXCEL covers all the topics you'll see in a corporate finance course: financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. Plus, it's easy-to-read and full of study tools that will help you succeed in class.
LC Classification NumberHG4012.5.M29 2007