Friday, October 5, 2012

W5_INDRA_Tanker Depreciation and Income Taxes

1.            Problem Recognition, Definition and Evaluation
Refer to Indonesian Finance Minister Regulation, there are 2 depreciation methods can be used for Oil Tanker income taxes calculation:
a.     Straight Line Method
b.    Declining Balance Method
Problem Statement
            Our new vessel already delivered. The price is 16,750,000 US $. What is the best depreciation method will be used for her?

2.            Develop of  the Feasible Alternatives

Based on the regulation, each method described as below :

a.     Straight Line Method, 5% of vessel price per year, 20 years amortization, no salvage value

b.    Declining Balance Method, 10% of vessel’s last book value per year, 20 years amortization, in year 20th the depreciation same to salvage value


3.            Develop the outcomes for each alternative

We calculate the depreciation for each method as below :
Figure 1 : Straight Line Depreciation VS Declining Balance Depreciation

Next, we calculate the income tax and cash flow for each method as below :
Figure 2 : Comparison of Cash Flow for Each Depreciation Method


4.            Selection of the acceptable criteria.
Based on figure 2, both of the methods give same tax and cash flow in total but different allocating per year. It means we may use IRR as the criteria

5.            Analysis and comparison of the alternatives

Based on the criteria, we calculate and compare the IRR as below:
Figure 3 : IRR Comparison

6.            Select the preferred alternative
Based on the IRR, Declining-Balance Method is the best way to calculate depreciation. The most important thing, it’s legal!
7.            Performance Monitoring & Post Evaluation of Result

Next action we will do :
a.     Inform to finance department to implement Declining-Balance depreciation to this new asset
b.    Compare this method use other criteria like NPV and ERR (good topic for another blog posting)
We monitor the result by Investment Post Mortem Analysis. We report it every 3 months to our BOD.

Reference
i.        Depreciation Methods for Fixed Assets, Retrieved from:

ii.       Internal Rate of Return, retrieved from:
iii.      Indonesian Finance Minister Regulation 96/PMK.03/2009, retrieved from: http://www.ortax.org/files/lampiran/09PMK03_96lamp.html

2 comments:

  1. Hmmmmm....... Pak Indra, you did a great job on the two methods you identified, but there are two that you missed......

    Google on "Sum of the Years Digits" method.......
    http://beginnersinvest.about.com/od/incomestatementanalysis/a/sum-of-the-years-digits-depreciation.htm

    Also you missed the Modified Accelerated Cost Recovery System (MACRS)...
    http://www.investopedia.com/terms/m/macrs.asp#axzz28QrPwJcL

    And while you identified Declining Balance Method, there are two common versions of this method-
    Double Declining Balance and 1.5 Declining Balance.
    http://accountinginfo.com/study/dep/depreciation-01.htm and http://pakaccountants.com/double-declining-balance-method-of-depreciation/

    While I will accept this posting, I would like to see you take the same case study but this time, apply the Sum of the Years Digits, MACR and the two Declining Balance methods then compare all 5 of them together in a table.

    FWIW, this is a question you are VERY likely to see on your CCC/E and/or CEP exam!!!! So the time spent doing this will be well worth your time and effort.

    BR,
    Dr. PDG, Singapore

    ReplyDelete
  2. PS Pak Indra, you need to get ahead before you leave on your Haj......

    Don't risk hurting your team's overall SPI or CPI by falling behind...!!!

    ReplyDelete