A Bottom-Up Example—Long-Term Accruals (Depreciation)

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.

Click or drag files to this area to upload. You can upload up to 3 files.
Get a response in under 15 min

Before we venture into the financial statements of PepsiCo, which is a huge corporate company, it will be simpler to begin with a simple hypothetical project of our own. Say you own a firm that has only one operating machine. The machine has a durability of 6 years, it doesn’t require any maintenance cost and it costs a capital spending on both first year and second year. It is capable of producing full time outputs from the very first year. It provides an average sale of $60 per year. The income tax levied on your company is 40% and the capital cost percentage amounts to 12%. Also it is assumed that you company is in a debt of $50 with an interest rate of 10%, and your annual interest payment value is $5. With all these hypothetical parameters, we will take a look at the financials.

13.2 A Doing Accounting

In real life, it is almost impossible to match actual life with accounting parameters. This is because no one can assertively say what an asset life will be. This gulf between real life and accounting life is more predominant when it comes to taxes. The depreciation rules used for calculation of taxes are set by the Congress and they follow a strict schedule which doesn’t take into consideration asset life. These tax laws vary from state to state. In real life GAAP and IRS uses different schedules but for the sake of your understanding assume that both have stated that your machine is to be depreciated over 3 years. Hence a cost of $75 will result in $25 depreciated price over 3 years. After the third year there is no more depreciation. All these affect the financial report which is depicted in the following tables. You might find a lot of new jargons while going through the table. Some of them are- COGS (cost of goods sold), SG&A (selling, general & administrative expenses). When these two expenditures are subtracted from the value of sales we get EBITDA (earnings before interest, taxes, depreciation and amortization). Upon subtracting the depreciation from it we get EBIT (earnings before interest and taxes). From EBIT we can calculate the net income or simply the earnings by subtracting the interest rate and the income tax.  Net income is the final value that we arrive to.

A Bottom-Up Example—Long-Term Accruals (Depreciation) 6

A Bottom-Up Example—Long-Term Accruals (Depreciation) 7

A closer look into the financial statements of this hypothetical project and the one provided for PepsiCo will tell you that both of them are fundamentally similar with a few differences. From table 13.3 we can see that PepsiCo’s sales were $26,935 million. Subtracting SG&A, COGS, Amortization provided an EBIT of $4,021 million. After bottling equity and other factors, the net interest income of $8 million was calculated. From there tax of $1,367 million was paid leaving the shareholders with a net income of $2,662 million. With PepsiCo being such a huge corporation, it is quite imminent that their financial statements will contain certain extra items in their financial statement, but fundamentally our hypothetical financials and their financial statement are the same.

The income statement of the hypothetical finance contains almost all the necessary information regarding the project. The only thing left out from there is the capital expenditure and the net debt. These two are not incorporated in the income statement but rather in the cash flow statement. As we know, the capital expenditure is $75 for the first year, and also $75 for the second year with no additional expenditures in the following years. The net debt of $50 issued on the first year, is repaid on principal on the sixth year.

Why is capital expenditure not reflected in the income statement? Do they not affect the income? Yes capital expenditure reduces net income, but slowly in depreciated manner over the years.

The capital expenditure is depreciated in the following way:

Year 1: $25 from the first capital expenditure is taken into account

Year 2: the second installment of $25 for the first capital expenditure followed by the first installment of 25$ for the second capital expenditure.

Year 3: the final installment of $25 of the fist capital expenditure followed by the second installment of $25 for the second capital expenditure.

Year 4: first year expenditure’s depreciation is complete. Only the third and final installment for the second capital expenditure is taken into account.

It is depicted in the following table:

A Bottom-Up Example—Long-Term Accruals (Depreciation) 8

13.2 B Doing Finance

In order to see the firm through a financier’s perspective you need to consider three elements- the machine, the tax that has to be paid and the loan itself. The relation can be described as follows:

NPV Project = NPV Machine – NPV Taxes

NPV Levered Ownership = NPV Machine – NPV Taxes + NPV Loan

There is a difference between being a full time owner of a project and being a levered equity owner. As a full time owner, you will have both the machine as well as the debt. As a full time owner, you need to worry about paying a lender at the first year. But in the following years, there is no need to worry about repaying debts. Let’s take a look at the cash flow of a machine without calculating taxes or loan.

A Bottom-Up Example—Long-Term Accruals (Depreciation) 9

Another important component while calculating machine cash flows is corporate tax. From table 13.6 you can see the tax being collected is $14 during first year followed by $2 two times and $12 and then again twice $22. For the sake of understanding if the tax discount is taken in accord with the cost-of capital which is 12%. With this discount factor you can now calculate the current tax obligation which is

A Bottom-Up Example—Long-Term Accruals (Depreciation) 10

A Bottom-Up Example—Long-Term Accruals (Depreciation) 11

Now we arrive at our third component for calculating NPV project that is loan. If you are a levered equity owner and not a full time owner, then your loan will be associated from a capital market. If the company received its fair share of return for its investment then a loan paying $50 every year at an annual rate of 10% will have zero NPV.

Hence this means that the NVP project with the loan is same as project without loan. This simplifies the scenario

A Bottom-Up Example—Long-Term Accruals (Depreciation) 12

It is interesting to note that even though the NPV remains unchanged, cash flow and net income are way different from each other. It is clearly depicted in table 13.7 where it can be seen that where the cash flow is highest, the net income is lowest and where the net income is highest, the cash flow is negative.

13.2 C Reverse-Engineering Accounting into Finance

You might be wondering how reverse engineering could fit into finance. Well, here reverse engineering refers to the process of back calculation required to calculate the firm value of a firm. It is not possible to calculate the value only with the knowledge of financials by discounting the net income with cost of capital at 12%. Neither can it be calculated correctly with cost of capital at 10%

A Bottom-Up Example—Long-Term Accruals (Depreciation) 13

A Bottom-Up Example—Long-Term Accruals (Depreciation) 14

A Bottom-Up Example—Long-Term Accruals (Depreciation) 15

So how can you successfully calculate NPV from financials? The only process is through reverse calculation. Through reverse calculation the financials are converted back into cash flows. These cash flows are necessary for NPV analysis calculations. All the data are available, you only need to know how to extract them and put into use.  To get the machine cash flow the following formula is applied:

A Bottom-Up Example—Long-Term Accruals (Depreciation) 16

This formula logically undoes the work of the accountant of laying out the machine cost over a certain time period. That is why the depreciation is added back as it is not the actual cost and the capital expenditures are subtracted which are considered as the actual costs. Next you need to deduct the corporate taxes that had been levied. It might confuse you to note that at some point taxes are assigned negative values while at some points it is assigned positive value. After adjusting the tax, the required cash flow is obtained.

A Bottom-Up Example—Long-Term Accruals (Depreciation) 17

If you are not comfortable with the above described method of obtaining cash flow, another method of doing so is through net income. This is because net income is the sum after deducting out income tax; hence you only need to deduct the interest to get back the cash flow. It can be done in the following way:

A Bottom-Up Example—Long-Term Accruals (Depreciation) 18

The above calculations provide the same result hence any method can be utilized to obtain cash flow. The figures tell us that the investors, debt and equity put together, needs to come up with $29 in the first year and $17 in second. Now you need to calculate in terms of a financed expenditure, what part has been borrowed and what part you need o pay on your own. If the creditors provided a sum of $50 and they got back $5 in the second year, then the cash flow is a positive value of $21 in the first and negative $22 in the second. Therefore to generate the cash flow, add the principal of loan as inflow and subtract the loan outflow which consists of both principal as well as the interest. The cash flow can be viewed as follows:

A Bottom-Up Example—Long-Term Accruals (Depreciation) 19

The above calculations can be done with net income too; it will generate the same result.

A Bottom-Up Example—Long-Term Accruals (Depreciation) 20

13.2 D Depreciation Nuances

You have already learnt that depreciation is not something you read from cash flow and no income statements. To understand why, you need to know more in details about depreciation and its types.

There are basically three types of depreciation- depreciation, amortization and depletion. Their similarity lies in the fact that all of them are just allocated costs and not actual cash flows. Their difference lies in the fact that they are applied on different kind of resources or assets. While depreciation is applied to tangible assets, depletion is applied to natural resources and amortization is applied to intangible assets. If you do not know what intangible assets are, they are basically assets which are not physical in nature, but they are intellect properties such as copyright or patents, etc. while intangible assets only constituted 10% of public traded US firms, today they constitute majority of the assets.

Since all three forms are conceptually same- depreciation, depletion and amortization, they are grouped under the same term that is depreciation. But you still dint get to know why depreciation is not calculated from income statements and only read from cash flow. The reason is, while making our hypothetical finance statements, you will notice that from the income statement it is not possible to judge what depreciation we allocated for the machine. The corporations can divide the depreciation and put it under COGS or SG&A. this is more convenient than stating the depreciation in a separate statement. Plus it doesn’t affect the outcome of the income statement figures in any way. If you go through the income statement of PepsiCo, you will find that they had put the depreciation under SG&A. the only depreciation that has been stated is the amortization of non physical assets.

So, can you find out the actual depreciation figures from the net income statement? The answer is no. it is only possible by reading it from the cash flow statement.

A Bottom-Up Example—Long-Term Accruals (Depreciation) 21

 

 

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?
K
L

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?
K
L

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?
K
L

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?
K
L

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?
K
L

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?
K
L

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?
K
L

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?
K
L

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?
K
L

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?
K
L

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.