|
![]() |
|||
|
||||
OverviewNow readers can master their Excel® 2010 skills while establishing a strong understanding of contemporary corporate finance. Mayes/Shank’s FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2010, 6E shows today's reader how to tap into some of Excel® 2010's most powerful tools to solve real financial problems. The book's solid content addresses today’s most important corporate finance topics, including financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. This edition now covers Excel® tables, pivot tables and pivot charts and other areas that have become increasingly important to today’s employers. The book’s reader-friendly, self-directed learning approach and numerous study tools help readers build upon basic skills for the Excel® 2010 proficiency and the solid finance knowledge business professionals need for success. Full Product DetailsAuthor: Timothy Mayes (Metropolitan State College of Denver) , Todd Shank (University of Portland)Publisher: Cengage Learning, Inc Imprint: South-Western College Publishing Edition: 6th edition Dimensions: Width: 20.40cm , Height: 2.00cm , Length: 25.40cm Weight: 1.002kg ISBN: 9781111826246ISBN 10: 1111826242 Pages: 528 Publication Date: 10 October 2011 Audience: College/higher education , Tertiary & Higher Education Replaced By: 9781285432274 Format: Paperback Publisher's Status: Out of Print Availability: In Print ![]() Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock. Table of Contents1. Introduction to EXCEL (R) 2010. 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. Common Stock Valuation. 9. Bond Valuation. 10. The Cost of Capital. 11. Capital Budgeting. 12. Risk and Capital Budgeting. 13. Portfolio Statistics and Diversification. 14. Writing User-Defined Functions with VBA. 15. Analyzing Datasets with Tables and Pivot Tables.ReviewsAuthor InformationTimothy R. Mayes serves as finance professor at Metropolitan State College of Denver. He holds a B.S. and B.A. in Finance and a Ph.D. in Finance from the University of Central Florida. Dr. Mayes' research interests include portfolio performance analysis and reporting, portfolio theory, derivatives and, of course, the use of spreadsheets in financial education. Todd M. Shank is Associate Dean and M.B.A. Director of the Robert B. Pamplin, Jr. School of Business Administration at the University of Portland in Oregon. In the spring of 2003, he served as a Fulbright Lecturer in China, where he taught corporate financial management in the graduate school at Sun Yat-sen University in Guangzhou. Dr. Shank received his Ph.D. from Central Florida. He has worked for the U.S. Treasury Department's Office of Comptroller of the Currency as a banking regulator and has been teaching, consulting, and writing for more than 25 years. During that time, he has served on the faculties of three universities, published two textbooks and academic articles in numerous journals, including American Business Review, Global Business and Finance Review, Journal of Foreign Exchange and International Finance, and the Journal of Financial Education. He has received numerous teaching awards, including the University's Teacher of the Year and the Pamplin School's Best Graduate Professor. He also serves on several national panels that promote technological applications in business education. Tab Content 6Author Website:Countries AvailableAll regions |