The Detailed Projection Phase

Need help with your homework? Look no further! Our subject experts are ready to effortlessly handle your assignments, so you can finally say goodbye to stress and hello to top grades.

Please enable JavaScript in your browser to complete this form.
Click or drag files to this area to upload. You can upload up to 3 files.
Get a response in under 15 min

Going on to the second goal which is determination of cash flow is expected from the beginning of the business growth to the years of the forecast of terminal. And if you are the analyst of this business, the predictions for you will be pretty easy. In order to forecast the same for a company like Pepsi Co, you can take help from historical data but you need understanding about the business with underlying economics which includes information like corporate balance sheets of current and previous years, economics of the specific industry and so on.

But the process is not that simple. And even if you can get such information it will not be helpful for other businesses as they are company specific information.

Under the absence of inside information, the accuracy in the detailed forecast have a greater impact on the wealth of the project under two channels:

  1. Forecast of the initial 3 years of the company has a direct contribution to the value of the firm currently.
  2. The terminal value is directly linked to the base line of the company.

Let’s start with estimation that will help in illustrating the process further. It is explained in the following two different sections:

  1. Direct estimation or we can say, extrapolation of component of accounting which is needed: This step is generally used as a shortcut for analyst when they have limited time and information about the project
  2. Financial modeling of the statements or items mentioned in financial statements: This is a common method used in real world.

The Detailed Projection Phase 6

20.4 A: Faking It: Direct Extrapolation of Historical Cash Flows

First method mentioned before is generally cheated which is commonly practiced by everyone. This method will provide you cash flows from the historical data under the assumption of constant rate of growth. Unsung the formula, we can calculate the cash flows under the presence of debt and equity:

The Detailed Projection Phase 7

Here, we can notice that the decline of cash flow over 3 years is around -5.2%, which means that is annual decline is -2.6%. Also, there is a 1/3rd drop in the cash flow of assets in 12 months recently. After the investigation, one can notice that decline of Pepsi Co. was because of the investing activity which is increased in the years. Somewhere these statements seem unreal, isn’t it?

The Detailed Projection Phase 8

And that’s why one must know the detailed information about the business and their serious reasons behind the trends in finances. The information also involves economic information and some common sense too! Let’s consider the growth rate as 10% and the projection of the same can be noticed in Table 20.2 after adopting such a projection which is quite different in the case of Pepsi Co. and their statements in recent years.

Now the question is if the present value of the cash flow in future can be represented by net income growth of historical data or by cash flow in historical data.

Net Income: Talking about the positive side: cash flows are less smooth than earnings. Negative side is served by: the discounts are generally wrong as they are applied on the combination of cash of future and real.

Cash Flows: Positive side is that they are standardized if one can predict the same accurately. Negative side: the historical data cannot be trusted in order to realize the real picture in the future.

The Detailed Projection Phase 9

20.4 B the Real Thing: Detailed Financial Pro Forma Projections

How about projecting financial statements entirely in order to project the economic cash flows suggest? This is hence the common second method to do so. This process will involve components seeking he cash flows of the economics. Why, if you ask? Because:

  1. Reliability is not justified by cash flow and forecast of earnings.
  2. This method will help you understand the underlying stable business and inside information for the estimation of cash flow of economy.
  3. This method will help you project information like availability of working capital, ratio of debt and equity and covered rate of interest. These analyses in the ratios are helpful in judging the correct path of the firm.

The Income Statement: Sales

Sale forecast is thus the most crucial aspect in creating a professional pro forma as it is helpful in creating the base line for forecasting of other financial items. Considering the case of Pepsi Co, table no. 20.3 will help you to dictate the sales of the firm at the rate of annual: ($26,935/$25,093)1/2 − 1 ≈3.61% from the year 1999 to 2001. In 2002, you will predict the sales growth as:  $26,935

($26,935/$25,093)1/2 ≈$26,935

(1 + 3.61%) ≈ $27,906 million

The Detailed Projection Phase 10

The forecast of sale requires a footnote in order to state the explanation of the estimation and one can notice the same in the table. Please note that such a forecasting of sale is not simple as that is made of always and thus one must use economic modular structure that includes detailed intelligence of business.

The Income Statement: Other Components

Income statement will require going down and investigating product by product. The next estimate will entitled for COGS. The options are various which includes forecast of plain growth as well. One can use the following five methods to forecast the same:

  1. Plain Growth Forecast: Repeating the same exercise of sales for COGS will lead to

The Growth rate that is of historical ($10,754/ $10,326)1/2 − 1 ≈ 2.05% to be continues in the year 2002.

If we apply the same for the year 2001:   $10,754, your 2002 COGS forecast will be  $10,754 . (1 + 2.05%) ≈ $10,975

  1. A pure proportion of sales Forecast: The COGS forecast will be

The Detailed Projection Phase 11

  1. An economies-of-scale forecast: The COGS forecast will be:

E(COGS2002) = $3,500 + 25% . E(Sales2002)

= a + b .E(Sales2002)

E(COGS2002) ≈ $3,500 + 25% . $27,906 ≈ $10,477

The Detailed Projection Phase 12

  1. An industry-based forecast: Comparing the COGS of Pepsi Co, with Coca-Cola, we will notice that both the businesses are different, but Pepsi Co can realize better position by lowering their COGS to estimation from $10,762.
  1. A disaggregated forecast: one can notice that COGS include depreciation as well which means that the past capital of the company will affect the estimate value of COGS further. Formula can be generated by including statistical regression as the expenditures in the past capital.

The Detailed Projection Phase 13

The Cash Flow Statement

The Detailed Projection Phase 14

The next step here is modeling the statement of cash flow. Table 20.4 illustrates the same for the firm Pepsi Co. You can see that the initial step is served by transfer of net income projected from the income statement model of the pro forma to model of pro forma flow of cash. Since it’s an illustration, the cash flow items which are remaining are the estimated of the perfunctory.

The table does not include any information related to Pepsi Co. depletion and depreciation so we have assumed the number $ 1,100 million keeping in mind the standard of the company. Now, let’s keep 18% as the income tax paid by Pepsi Co. But one must keep a note on the changes in the capital working as they are closely related to the level of sales for the company.

As depicted, the sales of the year 2002 is just $ 1billion, this means that Pepsi Co needs more working capital. So, we can say here that Pepsi Co will experience reverse trends adding $ 200 million in the business for the growth in sales. So, we can say here after going through the entire table that $2.7 billion will be the outcome of investment in cash flow and operating of the company.

Financing Policy, the Balance Sheet, and Linkages

Most of the time analysts by pass to think about the policy of financing in the company. Please note that these policies affect the overall balance sheet as well as statement of cash flow and income too. As a matter of fact, if you ignore financing policies which are affecting the income statement, you might have to go back to the statements and change your forecast predictions.

The Detailed Projection Phase 14

20.4 C Ratio Calculations and Policity with Pro Formas

After projecting balance sheet & equity statement, up to the value of the terminal T, the question here is what to do with the same?

Economic Project Cash Flows

Projecting the value of the analysis is the first significant use of Pro Forma. One can compute the economic flow of cash for NPV analysis through cash flow statements of the year 2002. The economic flow of cash for the company Pepsi Co is that which sums up that of operating flow of cash and investing flow of cash subtracting the income of interest. So it will come up to about that value of $2,728 million from the table no. 20.2,

But in order to locate the answer of how much to invest will only be answered under the presence of detailed knowledge about the company and the associated statements.

Ratio and Soundness Analysis

Forward looking analysis of ratio is another useful projection by pro formas which helps in judging the viability and soundness of the company. If you want to check if your forecast is reasonable, this is where you will know! Taking an example, supposing if a firm is in non-working position or the ratio of debt or equity is high with very small amount of cash, such a scenario will help to set off the alarm on bad financial situations.

Corporate Policy Changes

Pro forma generally depends on the external factors like economy of the country but is closely related to the decision of managers too. Managers must aim to make a payment or to collect the bills along with investment information on how much of a sum to invest and where to invest. But if you are an external analyst who is projecting the pro forma for a company, it is important to collect the keen information like changes in policies or COGS sales, as changes in policy affects other items of financials deeply.

Such a scenario is easy to handle if the analysis is the owner or the internal analyst of the company. Under such cases, the prediction and seeking right information is easier.

The Detailed Projection Phase 15


Links of Previous Main Topic:-

Links of Next Financial Accounting Topics:-

Homework Blues?

Get expert help with homework for all subjects.

  • NPlagiarism-free work
  • NHonest Pricing
  • NMoney-back guarantee

Latest Reviews

Solved Sample Works

Accounting Homework

Corporate Accounting Sample

Biology Homework

Genetics Assignment Sample

Essay Writing Help

Business Plan Sample

Homework Help FAQs

Our Answers to Your Questions

How do I submit my homework?

Getting homework help is very simple with us. Students can either send us the homework via email or they can upload it to our online form here. For a quicker response, You can also chat with us at WhatsApp and submit homework directly. You are sure to get a response from our side within 10 minutes.

How much will my homework cost?

The cost of paying someone to do your homework varies depending on the service and the type of assignment. We have listed our standard pricing plans for popularly used writing services. For other kind of assignments, You can get a free instant quote from us using our online form.

We also accept partial payment to start working on your assignment help. You can pay the remaining amount when your task gets completed. No pressure of up-front payment. No hidden order costs.

Can I receive help with my homework anytime?

Yes, you can receive help with your homework anytime with us. Our online homework help services are available 24/7, allowing you to receive assistance with your homework anytime, anywhere.

For urgent homework requests, reach out to us through our LiveChat or WhatsApp channels and one of our friendly support agents will assist you in finding the right expert for your online homework help request immediately. With our services, you can rely on 24/7 availability and meeting deadlines.

Are online homework websites budget-friendly for students like me?

Yes, Our Online Homework Help websites are an affordable solution for you as a student. Compared to traditional tutoring services, MyHomeworkHelp prices their homework help services honestly and within the budget of college students. This makes it easier for you to receive assistance with your homework without breaking the bank.

What is your plagiarism-free policy?

At myhomeworkhelp, we take plagiarism very seriously and ensure that all solutions provided by our tutors are original and authentic. Our tutors are trained to provide custom-made solutions, tailored specifically to meet the requirements of each student. We do not provide pre-written papers. All our homeswork solutions are made from scratch, guaranteeing 100% orignal homework answers.

Additionally, we have strict plagiarism-detection tools in place to check all submissions for authenticity.

Is using an Online Homework Help Service cheating?

Using online homework help services is not equivalent to cheating. Our services are intended to support students with their homework and provide them with the resources they need to succeed academically. With the help of our online homework help services, students can receive immediate assistance with their homework from any location, at any time.

At myhomeworkhelp, we are committed to promoting academic integrity. Our tutors provide solutions that serve as guides for drafting your own work. It is not acceptable to submit someone else's work as your own, as this constitutes academic plagiarism.

Can I chat with my tutor?

Using our secure chat board, you can now chat directly with your assigned tutor. The chats are encrypted both ways to secure your privacy. This makes your contact with the tutor directly & confidentially, so you can better explain any requirements or changes if needed or just need updates.

You can't contact the experts outside of chat board platform. Sharing any personal information, including but not limited to contact information, goes against our Terms and Conditions and therefore may result in permanently blocking you from the platform. We take any personal data very seriously and we do it for the safety of our users.

Know more about chat board here.

What is your money-back guarantee policy?

It’s worth noting that our online homework help service rarely leads to disappointment among students. Our expert tutors, along with our support and quality assurance team, are dedicated to providing the best possible experience for our customers. However, if for any reason a student is unsatisfied with their homework help solution, we offer unlimited revisions until they are fully satisfied.

In the rare event that a student remains unsatisfied even after revisions, we offer a money-back guarantee. We want all of our students to feel confident and secure when they turn to us for assistance with their homework, and this guarantee is just one way that we demonstrate our commitment to providing the best possible service. If you have any concerns about our services or the quality of the work you receive, please contact us for support.

What is the expertise of the tutor assigned to do my homework?

At myhomeworkhelp, we take pride in our team of qualified and experienced tutors. All of our tutors undergo a rigorous selection process and are required to have a minimum of a master's degree in their respective fields. Additionally, they must pass a series of tests to demonstrate their proficiency and ability to deliver quality work. We believe in transparency and providing our clients with the best possible service. You can be confident in the expertise of the tutor assigned to do your homework.

What about privacy & confidentiality?

Using My Homework Help is absolutely safe. We care about your security, therefore we encrypt all personal data to make every user feel safe while using our services and we don’t share any personal information with any third parties without your permission. Your credit card information is not stored anywhere at My Homework Help, and use of PayPal relies on their secure payment networks. Your identity, payment and homework are in safe hands. You can always be certain of getting professional help and remaining anonymous, while using My Homework Help.