Corporate Financial Analysis with Microsoft Excel

McGraw Hill Professional
3
Free sample

Corporate Financial Analysis with Microsoft® Excel® visualizes spreadsheets as an effective management tool both for financial analysis and for coordinating its results and actions with marketing, sales, production and service operations, quality control, and other business functions.

Taking an integrative view that promotes teamwork across corporate functions and responsibilities, the book contains dozens of charts, diagrams, and actual Excel® screenshots to reinforce the practical applications of every topic it covers. The first two sections— Financial Statements and Cash Budgeting— explain how to use spreadsheets for:

  • Preparing income statements, balance sheets, and cash flow statements
  • Performing vertical and horizontal analyses of financial statements
  • Determining financial ratios and analyzing their trends and significance
  • Combining quantitative and judgmental techniques to improve forecasts of sales revenues and customer demands
  • Calculating and applying the time value of money
  • Managing inventories, safety stocks, and the allocation of resources

The third and final section—Capital Budgeting— covers capital structure, the cost of capital, and leverage; the basics of capital budgeting, including taxes and depreciation; applications, such as new facilities, equipment replacement, process improvement, leasing versus buying, and nonresidential real estate; and risk analysis of capital budgets and the potential impacts of unforeseen events.

Corporate Financial Analysis with Microsoft® Excel® takes a broad view of financial functions and responsibilities in relation to those of other functional parts of modern corporations, and it demonstrates how to use spreadsheets to integrate and coordinate them. It provides many insightful examples and case studies 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 your firm’s short-term operations and long-term capital investments.

Read more

About the author

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.
Read more
4.7
3 total
Loading...

Additional Information

Publisher
McGraw Hill Professional
Read more
Published on
Aug 23, 2009
Read more
Pages
512
Read more
ISBN
9780071628846
Read more
Language
English
Read more
Genres
Business & Economics / Personal Finance / General
Business & Economics / Personal Finance / Investing
Read more
Content Protection
This content is DRM protected.
Read more

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
#1 New York Times Bestseller

“Significant...The book is both instructive and surprisingly moving.” —The New York Times

Ray Dalio, one of the world’s most successful investors and entrepreneurs, shares the unconventional principles that he’s developed, refined, and used over the past forty years to create unique results in both life and business—and which any person or organization can adopt to help achieve their goals.

In 1975, Ray Dalio founded an investment firm, Bridgewater Associates, out of his two-bedroom apartment in New York City. Forty years later, Bridgewater has made more money for its clients than any other hedge fund in history and grown into the fifth most important private company in the United States, according to Fortune magazine. Dalio himself has been named to Time magazine’s list of the 100 most influential people in the world. Along the way, Dalio discovered a set of unique principles that have led to Bridgewater’s exceptionally effective culture, which he describes as “an idea meritocracy that strives to achieve meaningful work and meaningful relationships through radical transparency.” It is these principles, and not anything special about Dalio—who grew up an ordinary kid in a middle-class Long Island neighborhood—that he believes are the reason behind his success.

In Principles, Dalio shares what he’s learned over the course of his remarkable career. He argues that life, management, economics, and investing can all be systemized into rules and understood like machines. The book’s hundreds of practical lessons, which are built around his cornerstones of “radical truth” and “radical transparency,” include Dalio laying out the most effective ways for individuals and organizations to make decisions, approach challenges, and build strong teams. He also describes the innovative tools the firm uses to bring an idea meritocracy to life, such as creating “baseball cards” for all employees that distill their strengths and weaknesses, and employing computerized decision-making systems to make believability-weighted decisions. While the book brims with novel ideas for organizations and institutions, Principles also offers a clear, straightforward approach to decision-making that Dalio believes anyone can apply, no matter what they’re seeking to achieve.

Here, from a man who has been called both “the Steve Jobs of investing” and “the philosopher king of the financial universe” (CIO magazine), is a rare opportunity to gain proven advice unlike anything you’ll find in the conventional business press.
Would you like the freedom to make money from anywhere in the world? Trade in an office, or from a beach hotel, you choose when and where you work when you’re a successful day trader.

Complete Day Trading Course


How To Day Trade Stocks For Profit is a complete course designed to get you quickly making money from the stock market. No previous trading experience is necessary. Easy to read and jargon-free, it starts right from the very basics, and builds to a remarkably simple but very powerful profit generating strategy.


What Others Are Saying


Readers of this book make real money, as this short selection of comments shows:


• "Have been using the info in the book for three days... $1,490.00 in the bank."


• "It was a great day! I made a $1175.50 profit."


• “Per 1 January I started day trading full time."


• “I am already making my job salary in trading."


• “I ended my first day of live trading with a net profit of $279.53.”


What's Inside


Just some of what you will discover inside:


• What really makes the stock market tick (and how you can make lots of money from it).


• The single biggest difference between people who make money and those who lose it.


• How to trade with other people's money, and still keep the profit for yourself.


• Specific trading instructions, exactly when to buy and sell for maximum profit.


• How to make money even when the stock market is falling.


• The five reasons most traders lose their shirt, and how you can easily overcome them.


• Three powerful methods to banish fear and emotion from you trading - forever.


• How you can get started trading with absolutely no risk at all.


• 14 Golden Rules of trading that virtually guarantee you will be making money in no time.


Fully Illustrated


The book is packed with real life examples and plenty of exercises that mean you’ll be ready to go from reading about trading, to actually making your own trades that put cash in the bank.

Praise for Financial Analysis Tools and Techniques:

"Bona fide treasury for executives, managers, entrepreneurs. Have long used this great work in corporate & university programs. Uniquely makes the arcane clear."Allen B. Barnes, Provost, IBM Advanced Business Institute

"A candidate for every consultant-to-management's bookshelf. Its beauty lies in the dynamic model of the business system and its management decision framework."Stanley Press CMC, Book review in C2M Consulting to Management Journal

"Goes a long way to remove the mystery from business finance. Approach allows managers from all areas to understand how their decisions impact shareholder value."Stephen E. Frank, Chairman and Chief Executive Officer, Southern California Edison

"Helfert has rare ability to make financial concepts understandable to those lacking financial background. His finance seminars exceeded our high expectations."L. Pendleton Siegel, Chairman and Chief Executive Officer, Potlatch Corporation

"Commend the clarity, organization and currency of contents. There is no other book available that does the task in such an understandable and accessible way."Dr. Thomas F. Hawk, Frostburg State University

"Helfert's excellent overviews and simplified models effectively broadened our managers' understanding of their fiscal responsibility to HP and our shareholders."Robert P. Wayman, Executive Vice President, Chief Financial Officer, Hewlett-Packard Company

"The book has become a classic, and Helfert has been of substantial help to my company in teaching our people how to think about the numbers which drive it."Robert J. Saldich, President and Chief Executive Officer, Raychem Corporation

"Helfert has contributed to the development of financial skills of TRW managers through his book, case studies and presentations, and highly rated instruction."Peter S. Hellman, President and Chief Operating Officer, TRW Inc.

"Helfert has the ability to make financial concepts understandable, and his credibility and content added significantly to the success of our educational effort."Giulio Agostini, Senior Vice President Finance, and Office Administration, 3M Corporation

"Helfert's writing and teaching have become a mainstay for us, and his business and strategic sense have been recognized as valuable guides to our process."William H. Clover, Ph.D., Manager of Training, and AMOCO Learning Center

Concepts and tools for making sound business decisions

Financial Analysis Tools and Techniques, a business-focused revision of Erich Helfert's perennial college bestseller Techniques of Financial Analysis, is a quick, easy read for nonfinancial managers and an excellent refresher and reference for finance professionals. This practical, hands-on guide provides a new introductory chapter that gives context to today's valuation turmoil and helps professionals understand the economic drivers of a business and the importance of cash flow.

The book's overriding theme is that any business should be viewed as a dynamic, integrated system of cash flowsone that can be activated and managed by investment decisions. Topics, discussed in clear, comprehensive, and easy-to-understand detail, include:

Increasing shareholder value through value-based management (VBM) Interpreting pro forma financial statements
The ability to effectively create and interpret financial models is one of the most valued skills in corporate finance--from Wall Street to Main Street. Now, the acclaimed guide to designing, building, and implementing valuation projection models is fully revised and expanded to keep finance and accounting professionals competitive in today's marketplace.

This second edition of Building Financial Models continues the tradition of its predecessor by providing a hands-on approach to creating a core model that is supported by broad coverage of cornerstone accounting and finance principles. Additionally, this updated volume features:

Entirely new coverage of discounted cash flow (DCF) modeling Excel formulas for making powerful calculations within the spreadsheet In-depth explanations of both the principles and mechanics of projection models

Building Financial Models helps readers practice good thinking and apply sound knowledge of their tools--two key attributes to producing robust and easy-to-use models. This practical guide takes you step by step through the entire process of developing a projection model, with a full chapter dedicated to each phase. By the end, you will have a working, dynamic spreadsheet financial model for making projections for industrial and manufacturing companies.

Furthermore, this Second Edition provides the vocabulary and syntax of model building so you can tailor core models to fit any size company and allow for quick input changes to test sensitivity. The companion website www.buildingfinancialmodel.com offering example spreadsheets will give you a head start on developing your own models.

A flexible and successful financial projection model does more than just add numbers--it explains the complex relationships between those numbers and illuminates ways to use those associations to add value to an enterprise. Building Financial Models is the only book you need to create and implement a fluid financial projection model that is both state of the art and user friendly.

The Possibilities Are Staggering:

Had you invested $10,000 in Cisco Systems back in early 1990, your investment would now be worth $3,650,000

Similarly, a $10,000 investment made in Microsoft in 1986 would be valued at more than $4,721,000 today

$10,000 invested in Yahoo! in 1996 would today be worth $317,000

How do you get in on those deals—especially if you're not a Silicon Valley insider? How do you buy the high-tech win-ners and avoid the losers? How do you find the Yahoo!s, Microsofts, and Ciscos of tomorrow?

The answers are here, in this newly revised edition of the national bestseller The Gorilla Game. The book reveals the dynamics driving the market for high-tech stocks and out-lines the forces that catapult a select number of compa-nies to "gorilla" status—dominating the markets they serve in the way that Yahoo! dominates internet portals, Microsoft dominates software operating systems, and Cisco dominates hardware for data networks.

Follow the rules of The Gorilla Game and you will learn how to identify and invest in the "gorilla candidates" early on—while they are still fighting for dominance, and while their stocks are still cheap. When the dust clears and one company clearly attains leadership in its market, you'll reap the enormous returns that foresighted investors in high-tech companies deserve.

This new edition of The Gorilla Game has been updated and revised throughout, with new focus and new insights into choosing the internet gorillas—the companies that are destined to dominate internet commerce.

Bestselling author Geoffrey A. Moore is one of the world's leading consultants in high-tech marketing strategy. Here you'll find his groundbreaking ideas about tech-nology markets that made his previous books bestsellers, combined with the work of Paul Johnson, a top Wall Street technology analyst, and Tom Kippola, a high-tech consul-tant and highly successful private investor. Together they have discovered and played the gorilla game and now give readers the real rules for winning in the world of high-tech investing.

Step by step you'll learn how to spot a high-tech market that is about to undergo rapid growth and development, how to identify and spread investments across the potential gorillas within the market, and how to narrow your investments to the single, emerging leader—the gorilla—as the market matures.

High-tech investing can be extremely risky, but investors who learn to play the gorilla game can avoid many of the traps and pitfalls and instead start capitalizing on untold profits. Personal wealth is only a gorilla game away.

©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.