Presenting innovative Microsoft Excel techniques for top management professionals, this reference for company leaders who do not have the time to attend courses or read bulky books on the program provides basics, special shortcuts, and tips that cover the special features of Excel. Useful facts, trivia, and insider secrets about Excel are interspersed throughout the text, and readers have the choice of jumping directly to the section of real-life case studies to learn by the innovative Do & Learn (D&L) approach. This reference is fully updated to reflect Excel 12.
Financial Modeling for Business Owners and Entrepreneurs: Developing Excel Models to Raise Capital, Increase Cash Flow, Improve Operations, Plan Projects, and Make Decisions may be one of the most important books any entrepreneur or manager in a small or medium-sized enterprise will read. It combines logical business principles and strategies with a step-by-step methodology for planning and modeling a company and solving specific business problems. You’ll learn to create operational and financial models in Excel that describe the workings of your company in quantitative terms and that make it far more likely you will avoid the traps and dead ends many businesses fall into. Serial entrepreneur and financial expert Tom Y. Sawyer shows how to break your company down into basic functional and operational components that can be modeled. The result is a financial model that, for example, you can literally take to the bank or bring to local angel investors to receive the funding you need to launch your business or a new product. Or it might be a model that shows with startling clarity that your new product development effort is a likely winner—or loser. Even better, you’ll learn to create models that will serve as guideposts for ongoing operations. You’ll always know just where you are financially, and where you need to be. The models you will learn to build in Financial Modeling for Business Owners and Entrepreneurs can be used to: Raise capital for startup or any stage of growth Plan projects and new initiatives Make astute business decisions, including go/no-go assessments Analyze ROI on your product development and marketing expenditures Streamline operations, manage budgets, improve efficiency, and reduce costs Value the business when it is time to cash out or merge In addition to many valuable exercises and tips for using Excel to model your business, this book contains a combination of practical advice born of hard-won lessons, advanced strategic thought, and the insightful use of hard skills. With a basic knowledge of Excel assumed, it will help you learn to think like an experienced business person who expects to make money on the products or services offered to the public. You’ll discover that the financial model is a key management tool that, if built correctly, provides invaluable assistance every step of the entrepreneurial journey. Tom Y. Sawyer has used the principles this book contains to create financial models of numerous startup and early-stage companies, assisting them in planning for and raising the capital that they needed to grow their businesses and ultimately exit with multiples of their initial investment. Financial Modeling for Business Owners and Entrepreneurs, a mini-MBA in entrepreneurship and finance, will show you how you can do the same. Note: This book is an updated version of Sawyer's 2009 title, Pro Excel Financial Modeling.
When does nontaxable business income become taxable? How do you calculate the cost of goods sold? What can be deducted? What is a fixed asset? This no-nonsense guide answers these common questions and more, empowering small business owners to understand how and why they are taxed and maximize their deductions. You’ll learn when depreciation begins, how to classify payments to employees, how to track inventory and sales, and strategies for successful accounting. Coverage also includes: Tax benefits for employers Business classifications S corporation tax issues Deductible expenses Retirement plans Shareholder loans Family employee payroll And more Taxes can be intimidating and confusing, especially for a small business owner who may have only handled individual taxes in the past. Understanding the tax system is essential for all small business owners, whether they are filing on their own or with the help of an accountant. When it comes to running your finances, knowledge is power, and The Pocket Small Business Owner's Guide to Taxes puts the power in your hands!
Planning is essential to creating a competitive advantage for your small business, and properly done, it can actually be fun. That is the message of this thorough guide, written in easy-to-follow, nontechnical language that you don’t need an MBA to understand. In what areas will your business specialize? What are some of the resources you will need, and challenges you will face? How much do you want your company to grow? Once you have established a vision of your business’s future, you will be on your way to making it a reality. Topics covered include: Creating a business model Identifying and beating the competition Calculating expenses Determining whether you need additional capital Avoiding common mistakes Writing your executive summary Developing a marketing strategy Evaluating your team Analyzing your progress And more! Whatever your background and whatever kind of business you dream of starting, this latest installment in our popular Pocket Small Business Owner’s Guide will help you to achieve your goals!
Winning formulas to determine which activities truly drive profit, develop and nurture people as your greatest asset, discover new approaches to be more efficient, and build a peacefully performing business so you can step into your potential.
Think big, buy small. Are you looking for an alternative to a career path at a big firm? Does founding your own start-up seem too risky? There is a radical third path open to you: You can buy a small business and run it as CEO. Purchasing a small company offers significant financial rewards—as well as personal and professional fulfillment. Leading a firm means you can be your own boss, put your executive skills to work, fashion a company environment that meets your own needs, and profit directly from your success. But finding the right business to buy and closing the deal isn't always easy. In the HBR Guide to Buying a Small Business, Harvard Business School professors Richard Ruback and Royce Yudkoff help you: Determine if this path is right for you Raise capital for your acquisition Find and evaluate the right prospects Avoid the pitfalls that could derail your search Understand why a "dull" business might be the best investment Negotiate a potential deal with the seller Avoid deals that fall through at the last minute
A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. • Provides the perfect mix of practice and theory • Helps you become a DIY Excel modelling specialist • Includes updates for Excel 2019/365 and Excel for Mac • May be used as an accompaniment to the author’s online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling.
A proven guide to building financial models from scratch The Second Edition of Building Financial Models with Microsoft Excel + CD-ROM provides beginning and intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel 2007-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow you to build your own financial models. This comprehensive resource also covers important topics such as the concepts of valuation, sensitivity analysis, and contribution margin. Offers accessible guidance on building financial models using Excel 2007 Illustrates how to integrate financial statements such as the balance sheet, income statement, and statement of cash flows Covers the basics of building and using a Capitalization Table Discusses how to best present a financial model Incorporating financial models into business decisions has become an essential element of good business practice, and this book will show you how to excel at this endeavor.
