homework help

The Detailed Projection Phase

Personalized homework help for all major subjects.

Order confidently with our risk free, 14-day money-back guarantee.

  • ✔️ No sign-up required
  • | 🔒 100% Confidential

Our Expert Writers

We proudly boast a team of expert professionals with verified academic credentials, selected for their proven skills and flexibility through a strict process.

Engage with experts from the top universities across the globe.

Get Homework Help Instantly

Say goodbye to homework stress! 📚 Just share your details and we’ll whip up an affordable quote in no time – often within 15 minutes.

Get started now for FREE!

Submit Your Homework

Let our experts help you with your college homework

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:-

Your Price: $11.00 $10.00

Pricing may change based on requirements

Descriptive text for the image

Get Homework Help In

Maths and Statistics

Science

Humanities & Arts

l

Essay Writing

How Our Homework Service Works

FAQ number 1

Share your requirements

FAQ number 2

Make secure payment

FAQ number 3

Get homework answers

FAQ - Frequently Asked Questions

Discover quick answers in our FAQ, covering the most common customer questions about our homework help service.

Is your homework service confidential?

M
L

Absolutely! Confidentiality is one of the basic guarantees of our service at MyHomeworkHelp.com.

When our customers make their homework orders, they know their information remains 100% confidential.

Even your homework writer will not be provided with your personal details. So, when you hire a professional homework helper on our website, rest assured that your information will remain private and safe.

For a comprehensive understanding of how we protect your privacy, please refer to our Privacy Policy.

Who will help me with my homework?

M
L

We work with subject experts from all over the world. We hire them with the help of complex tests in the disciplines of their expertise. We also verify the IDs and academic transcripts of our homework writers to be sure that our experts have a bachelor's or master’s or a PhD degree. This is how we can be sure of the proficiency of our panel of experts who will help you with your homework.

Is it legal to ask for help with homework?

M
L

Seeking homework help is perfectly fine and shows your proactive approach to overcoming challenges. But it's important to use our homework service to enhance your understanding, not to replace your own efforts.

Our homework service offers original solutions for personal use, including:

  • Generating ideas or arguments for your research.
  • Deepening your subject comprehension.
  • Direct citation, with proper referencing.

However, it's crucial to avoid plagiarism by not submitting our work as your own. Make sure to check your institution's academic integrity policies before using our services. Our goal is to support your educational journey in a responsible and beneficial way. Refer our honor code for more details.

Is myhomeworkhelp.com legit?

M
L

Yes, myhomeworkhelp.com is completely legitimate. We've been successfully connecting students with top experts worldwide since 2012, offering direct, secure communication for a seamless learning experience. With over thousands of students helped and a commitment to innovative, effective education tools, we're dedicated to making learning easier and more accessible for everyone.

You can read our reviews here on Trustpilot and Sitejabber (Independent, verified reviews from buying customers) like you!

Is there a possibility of plagiarism in my completed order?

M
L

Unlike our competitors who use cheap and ineffective in -house plagiarism software, MyHomeworkHelp.com uses credible software to check your homework solution originality. We guarantee that your paper will pass TurnItIn checks with a low percentage of similarity. In addition, we also check submitted papers for ai-content using Originality.ai.

You will receive a complemantary plagiarism free report with your completed order.

What makes you one of the best homework help website?

M
L

We are not number 1 (yet!). We're an independent, bootstrapped business standing up to Big EdTech for last 12 years. So it means a lot that folks like you are willing to consider our services for your educational needs.

Myhomework Help is recognized as one of the premier websites for homework answers for three key reasons.

  1. Firstly, we pride ourselves on the expertise and qualifications of our tutors/experts, who are selected through a rigorous vetting process to ensure they can provide best academic assistance across a wide range of subjects.
  2. Secondly, our response time to student inquiries is fast (as early as few minutes), reflecting our understanding of the importance of timely support in an academic setting.
  3. Lastly, we keep our pricing very student friendly. Our aim is to provide the best learning experience to students like yourself without burning a hole in your pockets.