3.2 The PG Reconciliation: Setup and First Steps

As stated, we will use the 2010 10-K filing of Procter and Gamble (PG) to illustrate all the calculations.  This section shows you how to bring up the filing and set up the Valuation Tutor layout.

There are two things you have to bring up.  The first is the dataset used by Valuation Tutor to do the calculations.  The second are actual filings.  The filing was made by P&G on August 13, 2010, that contains information for the fiscal year ending June 30, 2010. 

Step 1: Run Valuation Tutor, and select Financial Statement Analysis and Valuation:

Step 2:  Download the Study Guide Dataset (data for the examples in the textbook are in this dataset).  If you have already loaded a different data set, you can get the Study Guide Dataset from the top-left of the screen

Now, select “Download Textbook Dataset”, select Procter & Gamble as shown below by selecting it from the dropdown.

Step 2:  Select Fundamental Growth from the Business Ratios part of the tree:

Step 3:   Click on the View menu and select “SEC Viewers at Bottom.”

In the viewers at the bottom, bring up the Income Statement and Balance Sheet for Proctor and Gamble (the easiest way to locate PG from the dropdown is to click on the little question mark, type in PG, and press Enter or click OK).

Note:  Be sure to select 13 August 2010 10-K from the set of 10K and 10Q filings provided to match the Study Guide Dataset.  This date is in the calculator as follows:

The full Valuation Tutor container now appears as follows:

The screen has three major components:

Top Left:  The tree that defines the topic we are working with.  Currently, we are studying Fundamental Growth which is part of Business Ratios.

Top Right:  This contains the text for quick reference.

Bottom:  We have used the View menu item display two statements for P&G simultaneously.  This is useful because the analysis frequently requires data from different statements. 

In the next section we start our journey through business ratios, starting with fundamental or accounting growth.