Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Numbers and financial data drives today's business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. Curt explains how to review formulas to ensure they have the proper inputs, and shows how to interpret formula output. He also covers how to calculate leverage ratios and amortization and depreciation schedules, as well as forecast future growth. Exercise files accompany this course.
Companies must walk a fine line between maintaining enough inventory to enable immediate sales, but without producing too many units that end up sitting in a warehouse unsold. Modern companies do their best to produce goods as needed on a just-in-time basis. So they limit their upfront investment and don't have unsold products sitting in a warehouse. The inventory turnover ratio indicates how well a company handles that problem. To calculate the inventory turnover ratio, you divide the cost of goods sold by the value of goods currently in inventory. So, I have those figures here. The cost of goods sold and the inventory, and to calculate the ratio, we divide B5, cost of goods sold, by B6, which is the inventory turnover ratio.
The inventory turnover ratio is a measure of how efficiently a company manages its production processes. One example of managing inventory is the book publishing industry. On a per unit basis, it is much less expensive to print 100,000 copies of a book than 10,000. So publishers will often order a huge run of books. So, half of them with the regular price, and offer the rest of the stores at a deep discount. This process called remaindering enables stores to purchase for $1 older books that might have been sold at a wholesale price of $10 when the book was still popular.
Selling the extra books at that deeply discounted price, removes the stock from the publisher's inventory, and improves the company's inventory turnover ratio. If you're thinking about investing in a manufacturing firm, you should compare its inventory turnover ratio to the industry average, and the ratio of other companies in the sector. A relatively high inventory turnover ratio indicates that goods are sitting in a warehouse, taking up space and depreciating.
There are currently no FAQs about Excel 2007: Financial Analysis.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.