Chapter 10

Implementing basic business formulas

In this chapter, you will:

  • Learn useful formulas for price markup and discounts, as well as the break-even point.

  • Discover powerful financial formulas for analyzing sales, costs, margins, and fixed assets.

  • Try out several formulas for analyzing and managing inventory.

  • Learn how to analyze a company’s liquidity by examining its accounts receivable, accounts payables, working capital, and more.

Is it possible to run a business without Excel? It might be, but I doubt there are many businesses—and very few successful businesses—that don’t have Excel running on a computer or three somewhere. That’s because Excel was built with business in mind, so it’s bristling with tools that enable you to analyze ...

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.