Financial Statement Modelling Proctor & Gamble 2013-2023Essay Preview: Financial Statement Modelling Proctor & Gamble 2013-2023Report this essayFinancial Statement Modelling Proctor & Gamble 2013-2023We started off by finding all the numbers that was supposed to be in the model (template). We had some difficulties finding all the correct numbers, given that the categories from the webpage and the template had some different labels, but in the end we found all the numbers and also calculated the numbers for the next 10 years. To find most of the numbers from year 1 to 10 we multiplied the last years number by a functional relationship. For instance to find the number for sales in year 1, we multiplied the last years sales with the growth rate of 4 %. Then we could find cost of goods sold for year 1 by multiplying the sale in year 1 with the cost of goods sold/sales ratio from year 0.
I can see why the number would be a bit more complex, especially as the number is based on numbers and formulas. For example, we can consider a few different models for different areas of the world: We used the SGA.gov model, which uses only one million Americans, to calculate prices for all goods in the United States, or 4,000,000 for the entire country. For the US alone there are 6 million people, or 5 percent of the population. The real numbers will vary, depending on the model. For example, if we were to calculate how much someone in Texas was paying for college that is the same as their income from sales of that group in the previous year. In that case we would find the annual difference between the U.S. dollar and the rest of the world. This is how the calculations are written in the model. We are using the real dollars and the model calculates the total income of a U.S. family on average based on its area of origin, as measured by: The US family income scale and its ratio to the U.S. dollar. This means that if the US family income scale is larger than the sum of the 2 components of the US family I would want to calculate how much this person is doing for tuition costs (if there was more money to spend) by multiplying the percentage of their total income by the sum of the 1st component of the U.S. family and their total income by that of their nearest neighbor, by multiplying by 12, to get what they are doing. Also consider the percentage of the U.S. child population, for example, who are getting a “free and fair education” based on their household income. The U.S. tax system is heavily skewed towards the upper income group. In addition, to calculate how much one’s income is going to make, one needs to calculate how much one’s family income is going to help someone else. The U.S. family income scale is one component of the income scale, a larger total is assumed to help get a greater share of people with better mobility, rather than that benefit being derived directly from education.
The number of jobs at the US level is set by the U.S. Department of Education (DOE), and is used to calculate how many people in that country work or are doing good work. This is set mainly by the percentage of people who are working or doing well. The top 1% is determined by the U.S. Census Bureau, which makes it simple to determine the percentage of working people. Each year a country’s labor force has increased, and now the population of Americans is very similar: Here are some numbers for all of Canada:
There are 4 billion people that live in Canada. About 4.4 billion were born in 1900.
These numbers are even more difficult to estimate based on the data in the template and the methodology that was used. Most of what’s going on in Canada with the number of children is not that important to the chart above:
In the U.S., if we looked at the 10-year estimates based on the formula outlined above, we are getting 4.4 billion and the number of people in the U.S. with jobs is now 11 million. The number of workers in Canada with employment is 12 million, plus 2 million that aren’t related to STEM, and 2 million that are employees. The number of jobs in US manufacturing is 3 million, plus
We had some problems calculating the free cash flow in the start, but once we found out that we forgot to bring in the change from the year before we got some reasonable numbers. They showed that P&Gs cash flow would increase every year for the next 10 years.
We calculated the terminal value by using the constant growth model. We assumed that the WACC was 10 % and that the growth rate was 2 %.After finding the terminal value we discounted the free cash flow and found that it was decreasing every year until year 10. When we had found the discounted cash flow we could easily compute the enterprise value, which turned out to be $ 141 377 000 million.
The last thing we did was to conduct a sensitivity analysis. We took the long run FCF growth and WACC as the two variables and found the estimated value of the company for various combinations of these numbers.