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
Collapse

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

Additional Information

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

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.
The latest critical data for making superior investing decisions--from the world's most respected financial index

The Standard & Poor's 500 Index is the most watched index in America--if not the world. Whether you're an individual investor purchasing stocks, an executive researching corporate competitors, or a job seeker looking for concise and up-to-the-minute overviews of potential employers, you'll find the critical, often hard-to-find information you need in Standard & Poor's 500 Guide, 2011 Edition. Easy to use and packed with market intelligence on all 500 companies listed in the S&P 500 Index, this authoritative reference includes:

Information on the bluest of blue chip stocks, from Abbott Labs and GE to Microsoft and Yahoo! Summaries of each company's business activity, sales history, and recent developments Earnings and dividends data, with four-year price charts Exclusive Standard & Poor’s Quality Rankings (from A+ to D) New introduction by David M. Blitzer, Ph.D., Managing Director and Chairman of the Index Committee, Standard & Poor's

In addition, you get unique at-a-glance details about:

Stocks with A+ Quality Rankings Companies with five consecutive years of earnings increases--a key indicator of strong long-term performance Per share data, income statement analyses, and balance sheet overviews of each company covered

Put the comprehensive, updated data and analysis expertise of the world's premier securities information firm at your fingertips with Standard & Poor's 500 Guide, 2011 Edition.

Too many financial advisors simply close shop when they decide to exitthe business—squandering untold goodwill and legacy business.

Why waste a great opportunity?

By applying the advice of Al Depman, a.k.a. “The Practice Doctor,” you can transform your financial services practice into a legacy-focused business that will add substantial wealth to your retirement nest egg.

How to Build Your Financial Advisory Business and Sell It at a Profit walks you through the steps of developing, managing, and growing a profitable practice you can sell for enhanced value or bequeath to family members.

Depman guides you through the process of forming a sound plan for your financial services business, including how to:

Create a team of advocates in marketing and administration Build a sophisticated referral process Develop sales and casedevelopment systems Write a best-practices operations manual Maximize new technology to streamline operations Put a succession plan in place

Building a long-term business model is not just good for your future. It will also make you happier and more profitable today. You’ll be able to spend more time with clients. You’llput more energy into finding new ones. You’ll focus more on referral sources. And someone else will do the grunt work.

Use How to Build Your Financial Advisory Business and Sell It at a Profit to build your business into more than a simple means to a paycheck—and reap the rewards of your hard work long after you choose to leave the firm.

Investing for a Lifetime is designed to make saving and investing understandable to the investor. Wharton Professor Richard C. Marston, 2014 recipient of the Investment Management Consultants Association’s  prestigious Matthew R. McArthur Award,  guides an investor through the main investment decisions throughout a lifetime. 

Investing for a Lifetime shows:

how younger investors can set savings goals how both younger and older investors can choose investment portfolios to achieve these goals how investors can sustain spending once reaching retirement. 

Younger and older investors alike should understand savings goals that will provide enough income to sustain spending in retirement.   They should devise rates of saving that allow them to reach their goals by the time of retirement.  Though retirement is often the main goal of investing, it’s not the only one.  Marston discusses how funding a child’s education or saving for a down payment for a home affects overall saving.

Sensible investing is also necessary for savings goals to be realized.  Investing need not be complicated, but Marston explains that a diversified portfolio should include a mix of different types of U.S. stocks, foreign stocks, real estate as well as bonds. He describes each of these asset classes and shows how they fit in an investor’s portfolio.  He shows how investors can monitor the performance of their portfolios by establishing benchmarks for each asset class to judge how well their investments are doing.  

He focuses particular attention on those investors nearing retirement. In today’s low interest rate environment, he discusses whether it is possible to fund retirement from interest and dividends alone. He shows how savings combined with Social Security can fund retirement spending. And he asks how the “New Normal” of lower returns might force investors to save more than in past decades, and to spend less in retirement than in the past. 

Investing for a Lifetime is for investors who want to understand more about the savings and investment process, particularly those who worry about whether their retirement savings will last a lifetime.

Whenever I tell people about my job as a financial advisor, the conversation inevitably turns to how hopeless they feel when it comes to dealing with money. More than once, they’ve begged, “Just tell me what to do.”

It’s no surprise that even my most successful friends feel confused or paralyzed. Even if they have a shelfful of personal finance books, they don’t have time to make sense of all the information available. They don’t just want good advice, they want the best advice—so rather than do the “wrong thing,” they do nothing. Their 401(k) and bank statements pile up, unexamined or maybe even unopened.

What they don’t realize is that bad calls about money aren’t failures; they’re just what happens when emotional creatures have to make decisions about the future with limited information. What I tell them is that we need to scrap striving for perfection and instead commit to a process of guessing and making adjustments when things go off track. Of course we’re going to make the best guesses we can—but we’re not going to obsess over getting them exactly right.

The fact is, in a single page you can prioritize what you really want in life and figure out how to get there. That’s because a great financial plan has nothing to do with what the markets are doing, what your real estate agent is pitching, or the hot stock your brother-in-law told you about. It has everything to do with what’s most important to you.

By now you may be wondering, “What about the details? How much do I need to invest each year, and how do I allocate it? How much life insurance do I need?” Don’t worry: I’ll cover those topics and many more, sharing strategies that will take the complexity out of them.

The most important thing is getting clarity about the big picture so you can cope with the unexpected. Maybe you’ll lose the job you thought was secure; you’ll take a financial risk that doesn’t pan out; you’ll have twins when you were only budgeting for one. In other words: Life will happen.

But no matter what happens, this book will help you bridge the gap between where you are now and where you want to go.

Help students master the latest features in Excel 2013 while establishing a strong foundation in corporate finance. With Mayes's FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2013,7E, your students develop a proficiency in using Excel 2013 to solve real financial problems without sacrificing any finance background. This edition covers all of the topics in today's corporate finance course, including financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. A reader-friendly, self-directed learning approach and numerous study tools make this book both an ideal resource for independent learning and a valuable long-term reference tool. Because today's typical students enter college with basic spreadsheet skills, this new edition covers the basics early for those with no background, before moving quickly into many of the more advanced and most powerful features of Excel 2013. This edition offers new focus on Excel tables, pivot tables and pivot charts and other areas that have become increasingly important to today's employers. The book's easy-to-understand presentation helps students build upon or transfer skills from other spreadsheet programs as they establish a strong understand of contemporary corporate finance. Give your students the valuable, highly marketable skills in Excel 2013 with the understanding of corporate finance that they need to succeed with Mayes' FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2013,7E.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
#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.
©2019 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.