Corporate Financial Analysis with Microsoft Excel
Seiten
2009
McGraw-Hill Professional (Verlag)
978-0-07-162885-3 (ISBN)
McGraw-Hill Professional (Verlag)
978-0-07-162885-3 (ISBN)
A highly practical guidebook for working professionals in both corporate finance and security analysis that integrates both spreadsheet skills with management skills including multiple examples from real corporations
Corporate Financial Analysis with Microsoft®Excel® visualizes spreadsheets as an effectivemanagement tool both for financial analysisand for coordinating its results and actionswith marketing, sales, production and serviceoperations, quality control, and other businessfunctions.
Taking an integrative view that promotesteamwork across corporate functions andresponsibilities, the book contains dozens ofcharts, diagrams, and actual Excel® screenshotsto reinforce the practical applications ofevery topic it covers. The first two sections—Financial Statements and Cash Budgeting—explain how to use spreadsheets for:
Preparing income statements,balance sheets, and cashflow statementsPerforming vertical andhorizontal analyses offinancial statementsDetermining financial ratiosand analyzing their trendsand significanceCombining quantitative andjudgmental techniques to improveforecasts of sales revenues andcustomer demandsCalculating and applying thetime value of moneyManaging inventories,safety stocks, and theallocation of resources
The third and final section—Capital Budgeting—covers capital structure, the cost ofcapital, and leverage; the basics of capitalbudgeting, including taxes and depreciation;applications, such as new facilities, equipmentreplacement, process improvement, leasingversus buying, and nonresidential real estate;and risk analysis of capital budgets and thepotential impacts of unforeseen events.
Corporate Financial Analysis with Microsoft®Excel® takes a broad view of financial functionsand responsibilities in relation to thoseof other functional parts of modern corporations,and it demonstrates how to use spreadsheetsto integrate and coordinate them. Itprovides many insightful examples and casestudies of real corporations, including Wal-Mart, Sun Microsystems, Nike, H. J. Heinz,Dell, Microsoft, Apple Computer, and IBM.
Corporate Financial Analysis with Microsoft®Excel® is the ideal tool for managing yourfirm’s short-term operations and long-termcapital investments.
Corporate Financial Analysis with Microsoft®Excel® visualizes spreadsheets as an effectivemanagement tool both for financial analysisand for coordinating its results and actionswith marketing, sales, production and serviceoperations, quality control, and other businessfunctions.
Taking an integrative view that promotesteamwork across corporate functions andresponsibilities, the book contains dozens ofcharts, diagrams, and actual Excel® screenshotsto reinforce the practical applications ofevery topic it covers. The first two sections—Financial Statements and Cash Budgeting—explain how to use spreadsheets for:
Preparing income statements,balance sheets, and cashflow statementsPerforming vertical andhorizontal analyses offinancial statementsDetermining financial ratiosand analyzing their trendsand significanceCombining quantitative andjudgmental techniques to improveforecasts of sales revenues andcustomer demandsCalculating and applying thetime value of moneyManaging inventories,safety stocks, and theallocation of resources
The third and final section—Capital Budgeting—covers capital structure, the cost ofcapital, and leverage; the basics of capitalbudgeting, including taxes and depreciation;applications, such as new facilities, equipmentreplacement, process improvement, leasingversus buying, and nonresidential real estate;and risk analysis of capital budgets and thepotential impacts of unforeseen events.
Corporate Financial Analysis with Microsoft®Excel® takes a broad view of financial functionsand responsibilities in relation to thoseof other functional parts of modern corporations,and it demonstrates how to use spreadsheetsto integrate and coordinate them. Itprovides many insightful examples and casestudies of real corporations, including Wal-Mart, Sun Microsystems, Nike, H. J. Heinz,Dell, Microsoft, Apple Computer, and IBM.
Corporate Financial Analysis with Microsoft®Excel® is the ideal tool for managing yourfirm’s short-term operations and long-termcapital investments.
Francis J. Clauss, Ph.D., teaches in the MBA program at Golden Gate University’s School of Business. He earned his Ph.D. from the University of Michigan and has both technical and management experience in the steel, chemical, and aerospace industries. He lives in Palo Alto, California.
1: Corporate Financial Statements 2: Analysis of Financial Statements 3: Forecasting Annual Revenues 4: Forecasting Financial Statements 5: Forecasting Seasonal Revenues 6: Time Value of Money 7: Cash Budgeting 8: Cost of Capital 9: Profits, Leverage 10: Depreciation, Taxes 11: Capital Budgeting 12: Applications of Capital Budgeting 13: Capital Budgeting: Risk Analysis 14: Capital Budgeting: Monte Carlo
| Erscheint lt. Verlag | 16.10.2009 |
|---|---|
| Zusatzinfo | 0 Illustrations |
| Sprache | englisch |
| Maße | 213 x 262 mm |
| Gewicht | 1193 g |
| Themenwelt | Informatik ► Office Programme ► Excel |
| Wirtschaft ► Betriebswirtschaft / Management ► Finanzierung | |
| ISBN-10 | 0-07-162885-1 / 0071628851 |
| ISBN-13 | 978-0-07-162885-3 / 9780071628853 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
raffinierte Zaubereien für Excel-Kenner
Buch | Softcover (2024)
Markt + Technik (Verlag)
CHF 34,90
Komplett in Farbe. Ideal für alle Einsteiger, Umsteiger und auch …
Buch | Softcover (2022)
Markt + Technik Verlag
CHF 18,10
Datenanalyse und Reporting mit Power Query, Power Pivot und Power BI …
Buch (2023)
Carl Hanser (Verlag)
CHF 62,95
