## Corporate Finance, Module 17 (Depreciation Problems)

 Author Message NEAS Supreme Being Group: Administrators Posts: 4.2K, Visits: 1.3K Corporate Finance, Module 17 (Depreciation Problems)Practice Problems on Depreciation(The attached PDF file has better formatting.){Note: The following two part problem shows the effect of depreciation schedules on the net present value of a project. You need not know the rules of different depreciation schedules for the final exam; the exam specifies the depreciation schedule to use. Given the depreciation schedule and the cash flows, you should derive the net present value.}Exercise 17.1: Part 1 – Depreciation SchedulesAn all equity financed project requires an initial investment of \$16.5 million and generates pre-tax net cash flows of \$3.5 million each year for ten years.The initial investment at time 0 is \$1.5 million for expenses and \$15 million for equipment. The expenses are written off immediately for tax purposes. The equipment is capitalized and depreciated evenly (straight-line) over ten years and has no salvage value.Shareholders require a 12% after-tax return, and the corporate tax rate is 35%.A.    What is the pre-tax cash outflow at time 0? (Expenses plus the cost of machinery.)B.    What is the after-tax cash outflow at time 0? The expenses are written off when they are incurred, so they provide a tax refund; they are not amortized over the life of the project.C.    What is the depreciation each year? (\$15 million equipment over 10 years.)D.    What is the taxable income each year? (Cash of \$3.5 million minus the depreciation.)E.    What is the tax liability each year? (Taxable income times the tax rate.)F.    What is the after-tax income each year? (Taxable income minus the tax liability.)G.    What is the after-tax cash flow each year? (After-tax income plus depreciation.)H.    What is the present value of the annual after-tax cash flow, using the 12% after-tax return.)I.    What is the net present value of the project? (The present value of the after-tax cash inflows minus the after-tax cash outflow in year 0.)Solution 17.1: Part A: The pre-tax cash outflow at time 0 is \$15 million for the machinery and \$1.5 million for expenses, or \$16.5 million.Part B: The equipment is depreciated over 10 years, so it provides no tax relief in year 0. The \$1.5 million of expenses cause taxable income for year 0 of –\$1.5 million, so the tax liability is a refund of \$1.5 million × 35% = \$0.525 million. The after-tax cash outflow is \$16.5 million – \$0.525 million = \$15.975 million.Part C: The depreciation each year is \$15 million / 10 years = \$1.5 million a year. Part D: The taxable income each year is the pre-tax cash flow of \$3.5 million minus the depreciation of \$1.5 million each year, or \$2 million.Part E: The tax liability is the taxable income times the tax rate of 35%, or \$2 million × 35% = \$700,000.Part F: The after-tax income is pre-tax income minus the tax liability, or \$2 million – \$700,000 = \$1.3 million.Part G: The after-tax cash inflow is the after-tax income of \$1.3 million plus the depreciation of \$1.5 million = \$2.8 million.Illustration: Suppose the net cash flow is \$2.8 million and depreciation is \$1.5 million. GAAP income is \$2.8 million – \$1.5 million = \$1.3 million. We add back depreciation to get the net cash flow. Part H: The present values of each year’s after-tax cash flow are shown in the table below.Part I: The present value of the after-tax net cash flows is \$2.80 million × (1–v10)/i = \$15.82 million. The after-tax initial investment is \$15 million + \$1.5 million × (1 – 35%) = \$15.98 million. The net present value of the project is \$15.821 million – \$15.98 million = –\$0.16 million. The project has a negative after-tax net present value and is not worthwhile.Year    Percentage    Depreciation    TaxableIncome    After-Tax Income    After-TaxCash Flow    PresentValue1    10.00%    1.500    2.000    1.300    2.800    2.5002    10.00%    1.500    2.000    1.300    2.800    2.2323    10.00%    1.500    2.000    1.300    2.800    1.9934    10.00%    1.500    2.000    1.300    2.800    1.7795    10.00%    1.500    2.000    1.300    2.800    1.5896    10.00%    1.500    2.000    1.300    2.800    1.4197    10.00%    1.500    2.000    1.300    2.800    1.2678    10.00%    1.500    2.000    1.300    2.800    1.1319    10.00%    1.500    2.000    1.300    2.800    1.01010    10.00%    1.500    2.000    1.300    2.800    0.902Tot    100.00%    15.000    20.000    13.000    28.000    15.821 Exercise 17.2: Part 2 – Depreciation Schedules (continued)An all equity financed project requires an initial investment of \$16.5 million and generates pre-tax net cash flows of \$3.5 million each year for ten years.The initial investment at time 0 is \$1.5 million for expenses and \$15 million for equipment. The expenses are written off immediately for tax purposes. The equipment is capitalized at purchase, and the firm uses sum of the year digits depreciation over ten years, after which it has no salvage value.Shareholders require a 12% after-tax return, and the corporate tax rate is 35%.A.    What is the pre-tax cash outflow at time 0? (Expenses plus the cost of machinery.)B.    What is the after-tax cash outflow at time 0? The expenses are written off when they are incurred, so they provide a tax refund; they are not amortized over the life of the project.C.    What is the depreciation each year? (\$15 million equipment over 10 years.)D.    What is the taxable income each year? (Cash of \$3.5 million minus the depreciation.)E.    What is the tax liability each year? (Taxable income times the tax rate.)F.    What is the after-tax income each year? (Taxable income minus the tax liability.)G.    What is the after-tax cash flow each year? (After-tax income plus depreciation.)H.    What is the present value of the annual after-tax cash flow, using the 12% after-tax return.)I.    What is the net present value of the project? (The present value of the after-tax cash inflows minus the after-tax cash outflow in year 0.)Question: What is sum of the years depreciation?Answer: In this exercise, the equipment has a ten year life. The sum of the digits {1 + 2 + … + 9 + 10} = 55. The depreciation is 10 / 55 = 18.18% the first year, 9 / 55 = 16.36% the second year, …, and 1 / 55 = 1.82% the tenth year. Solution 17.2: Part A: The pre-tax cash outflow at time 0 is \$15 million for the machinery and \$1.5 million for expenses, or \$16.5 million.Part B: The equipment is depreciated over 10 years, so it provides no tax relief in year 0. The \$1.5 million of expenses cause taxable income for year 0 of –\$1.5 million, so the tax liability is a refund of \$1.5 million × 35% = \$0.525 million. The after-tax cash outflow is \$16.5 million – \$0.525 million = \$15.975 million.Part C: The depreciation each year is shown in the table below, using the sum of the years method. The total depreciation is still \$15 million, but the depreciation is now accelerated: more depreciation is written off in the early years and less in the later years. The depreciation is \$2.727 million the first year and \$0.273 million the tenth year.Part D: The taxable income each year is the pre-tax cash flow of \$3.5 million minus the depreciation. The taxable income ranges from \$0.773 million the first year to \$2.337 million the tenth year.Part E: The tax liability is the taxable income times the tax rate of 35%.Part F: The after-tax income is pre-tax income minus the tax liability.Part G: The after-tax cash inflow is the after-tax income plus the depreciation, ranging from \$3.23 million the first year to \$2.37 million the tenth year.Part H: The present values of each year’s after-tax cash flow are shown in the table below.Year    Digits    Percentage    Depreciation    TaxableIncome    After-TaxCash Flow    PresentValue1    10    18.18%    2.727    0.773    3.230    2.8842    9    16.36%    2.455    1.045    3.134    2.4983    8    14.55%    2.182    1.318    3.039    2.1634    7    12.73%    1.909    1.591    2.943    1.8705    6    10.91%    1.636    1.864    2.848    1.6166    5    9.09%    1.364    2.136    2.752    1.3947    4    7.27%    1.091    2.409    2.657    1.2028    3    5.45%    0.818    2.682    2.561    1.0349    2    3.64%    0.545    2.955    2.466    0.88910    1    1.82%    0.273    3.227    2.370    0.763    55    100.00%    15.000    20.000    28.000    16.314Part I: The present value of the after-tax net cash flow is \$16.314 million, and the net present value of the project is \$16.314 million – \$15.98 million = \$0.33 million. The project has a positive after-tax net present value and it is worthwhile. Question 17.3: Tax DepreciationA firm acquires a subsidiary, creating goodwill of \$100 million, which is amortized (pro-rata) over Z years, ranging from 0 years (immediate write-off) to 20 years. The depreciation (amortization) period differs for tax purposes vs GAAP accounting statements.Which of the following values for Z is most advantageous to the firm?    Tax         GAAPA.     0 yrs        20 yrsB.    10 yrs        10 yrsC.    10 yrs        20 yrsD.    20 yrs        10 yrsE.    20 yrs        20 yrsWhy do firms desire short depreciation (amortization) periods for tax purposes and long period for GAAP (book accounting) statements?Answer 17.3: AImmediate tax depreciation gives the largest present value tax benefit and the highest net present value for the firm (and its projects). Firms generally desire long GAAP depreciation (amortization) periods, so that their balance sheets show high values for the firm. Question 17.4: DepreciationSuppose the corporate tax rate is 35%. Which of the following statements are true regarding tax depreciation?A.    The more costs that can be depreciated (vs being written off when they are incurred), the greater the NPV of a project.B.    The longer the depreciation schedule, the greater the NPV of a project.C.    If the government increases the corporate tax rate, many costs are depreciated, and the earnings before interest and taxes remain the same, the project NPV increases.D.    Accelerating the depreciation schedule increases the NPV of a project.E.    None of A, B, C, or D is true.Answer 17.4: DStatement A: If an expense is written off when it is incurred instead of being depreciated, the firm receives the tax benefit up front. This tax benefit has a greater present value than the tax benefits from depreciation. Depreciating a cost reduces the NPV.Statement B: Lengthening the depreciation schedule decelerates the tax benefits; with a longer depreciation schedule, the tax benefits have the same nominal value but a lower present value, so the present value of the project decreases.Statement C: If the earnings before interest and taxes remain the same and the corporate tax rate increases, the earnings after-tax earnings decrease. Although the tax shield slightly increases, its effect is overwhelmed by the decrease in after-tax earnings.Statement D: Accelerating (shortening) the depreciation schedule speeds up the receipt of the tax benefits, and the present value of the project increases. Exercise 17.5: Depreciation Schedule(Adapted from question 24 of the Spring 2001 Course 2 examination)An asset with a depreciation basis of \$100,000 and no salvage value is depreciated by the following schedule:             Year            Percent                1                33.33%                2                44.45%                3                14.81%                4                 7.41%The marginal tax rate is 35% and the pretax borrowing rate is 12%.A.    What is the depreciation in each year?B.    What is the depreciation tax shield in each year?C.    What discount rate should be used to compute the present value of the tax shields?D.    What is the present value of the tax shields in each year?E.    What is the total present value of the tax shields?Solution 17.5: Part A: The depreciation each year is the depreciation percentage times the \$100,000 cost of the asset. For year 1, the depreciation is 33.33% × \$100,000 = \$33,330.Part B: The tax shield is the depreciation times the corporate tax rate of 35%. For year 1, the tax shield is \$33,330 × 35% = \$11,666 .Part C: The discount rate is the after-tax interest rate (after-tax yield). In the exercise, the after-tax interest rate is 12% × (1 – 35%) = 7.80%.Part D: For year 1, the present value of the tax shield is \$11,666 / 1.0780 = \$10,822.Year    Depreciation    Tax Shield    Present Value1    \$33,330    \$11,666    \$10,8212    \$44,450    \$15,557    \$13,3883    \$14,810    \$5,184    \$4,1384    \$7,410    \$2,594    \$1,920Total    \$100,000    \$35,000    \$30,267Part E: The total present value of the four years’ depreciation is \$30,267.Question: Why do we use the after-tax capitalization rate?Answer: Suppose we invest \$30,267 at 12% per annum pre-tax at time 0, which is a 7.80% after-tax investment yield. We compare the accumulated investment with the tax shields.Year    Funds    Accumulated Funds    Depreciation    Tax Shield    Funds – Tax Shield1    \$30,267    \$32,628    \$33,330    \$11,666    \$20,9622    \$20,962    \$22,597    \$44,450    \$15,557    \$7,0403    \$7,040    \$7,589    \$14,810    \$5,184    \$2,4054    \$2,405    \$2,593    \$7,410    \$2,594    \$0Total            \$100,000    \$35,000    With a 12% pre-tax investment yield, or a 7.80% after-tax investment yield, \$30,267 at time 0 just equals the present value of the tax shields.Question: When we discount insurance losses or insurance benefits, we use pre-tax discount rates, not after-tax discount rates.Answer: We discount pre-tax cash flows at pre-tax discount rates and after-tax cash flows at after-tax discount rates. Insurance losses are a pre-tax expense, so we use pre-tax discount rates. Depreciation tax shields are an after-tax cash flow, so we use after-tax discount rates. Attachments CorpFinance.Module17.pps.depr.pdf (280 views, 60.00 KB)
##### Merge Selected
Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

## Reading This Topic

##### Login
 Existing Account Email Address: Password: Remember Me Social Logins
##### Select a Forum....
 VEE Financial Accounting (on-line course)      VEE Fin Accg textbook and course structure      FA practice exam questions      FA Mod 1: Financial Statements      FA Mod 2: Financial reporting standards      FA Mod 3: The income statement (statement of profit and loss)      FA Mod 4: The balance sheet (statement of financial position)      FA Mod 5: The Cash Flow Statement      FA Mod 6: Articulation of the income statement, balance sheet, and...      FA Mod 7: Financial analysis techniques      FA Mod 8: Inventories      FA Mod 9: Accounting for long-lived assets      FA Mod 10: Long-term (non-current) liabilities      FA Mod 11: Operating leases and finance leases      FA Mod 12: Accounting for income taxes      FA Mod 13: Deferred taxes assets and liabilities      FA Mod 14: Employee pensions and share-based compensation      FA Mod 15: Financial investments      FA Mod 16: Equity method of accounting      FA Mod 17: Business combinations      FA Mod 18: Foreign currency transactions      FA Mod 19: Foreign currency translation      FA Mod 20: Insurance contracts: GAAP      FA Module 21: IFRS 17 (insurance contracts) General measurement model      FA Module 22: IFRS 17 (insurance contracts) Revenue + expense;...      FA Module 23: IFRS 17 Premium allocation approach; reinsurance...      FA Module 24: IFRS 17 (insurance contracts) Reconciliations of the... VEE On-line Course: Mathematical Statistics      VEE Math Stat: textbook and course structure      MS statistical tables for final exam      MS practice exam questions      MS Module 1 Background and data visualization      MS Mod 2 Confidence intervals      MS Mod 3: Confidence intervals; t distributions; variances      MS Mod 4: Hypotheses and Test Procedures      MS Mod 5: Hypothesis testing of proportions      MS Mod 6: Inferences Based on Two Samples      MS Mod 7: Two-Sample t Test and Confidence Interval      MS Mod 8: Paired data and Two Population Proportions & Variances      MS Mod 9: Single-Factor ANOVA      MS Mod 10: Single-Factor ANOVA – Levene’s test      MS Mod 11: Single-Factor ANOVA – Tukey’s honestly statistical...      MS Mod 12: Expected values and β’s for ANOVA + unequal sample sizes      MS Mod 13: Two-Factor ANOVA without interaction effects      MS Mod 14: Two-factor ANOVA, interaction effects      MS Mod 15: Linear and logistic regression models      MS Mod 16: Regression estimates      MS Mod 17: Regression analysis confidence intervals and hypothesis...      MS Mod 18: Regression analysis: Fitted values and predictions      MS Mod 19: Correlation      MS Mod 20: Residuals and Standardized Residuals      MS Mod 21: Multiple regression analysis      MS Mod 22: χ2 tests      MS Mod 23: Actuarial risk classification      MS Mod 24: Actuarial risk classification – other bias functions VEE Exam Course: Corporate Finance      Updates      Registration      Benefits of online course      Course scheduling      Introduction      Materials      Homework assignments      Final exam      Questions      Module 1: Present value and the opportunity cost of capital      Module 2: Calculating present values      Module 3: Value of common stocks      Module 4: Net present value vs other valuation models      Module 5: Investment decisions and net present value      Module 6: Risk, return, and the opportunity cost of capital      Module 7: Risk and return      Module 8: Capital budgeting and risk      Module 9: Analyzing corporate projects      Module 10: Positive net present value      Module 11: Maximizing net present value      Module 12: Corporate financing and market efficiency      Module 13: Corporate financing      Module 14: The capital markets      Module 15: Common stock dividends      Module 16: Debt policy      Module 17: Optimal corporate borrowing      Module 18: Financing and valuation: weighted average cost of capital      Module 19: Financing and valuation: adjusted present value      Module 20: Introduction to options      Module 21: Option valuation      Module 22: Real options      Module 23: Advanced option valuation      Module 24: Financial analysis and planning VEE Exam Course: Microeconomics      Registration      Updates      Benefits of online course      Course scheduling      Introduction      Materials      Homework assignments      Final exam      Questions      Module 1: Consumer's Demand, Producer's Supply, and Equilibrium      Module 2: Prices, costs, and the gains from trade      Module 3: The behavior of consumers      Module 4: Consumers in the marketplace      Module 5: The behavior of firms      Module 6: Production and costs      Module 7: Competition: short run      Module 8: Competition: long run      Module 9: Welfare economics and the gains from trade      Module 10: Knowledge and information      Module 11: Monopoly      Module 12: Price discrimination      Module 13: Market power      Module 14: Collusion, cartels, and regulation      Module 15: Oligopoly, monopolistic competition, and product...      Module 16: The theory of games      Module 17: Externalities: Pigou and Coase      Module 18: Externalities: transaction costs, law and economics      Module 19: Common property and public goods      Module 20: The demand for factors of production      Module 21: The market for labor      Module 22: Wages and discrimination      Module 23: Allocating goods over time      Module 24: Risk and uncertainty VEE Exam Course: Macroeconomics      Textbook      Syllabus      Homework assignments      Course questions      Final exam         Macro practice exam questions      Macro Module 1: National Income Accounting      Macro Module 2: Economic Growth      Macro Module 3: Growth Models      Macro Module 4: Working with the Solow Growth Model      Macro Module 5: Conditional Convergence and Long-Run Economic Growth      Macro Module 6: Markets, Prices, Supply, and Demand      Macro Module 7: Market Clearing      Macro Module 8: Consumption, Savings, and Investment      Macro Module 9: An Equilibrium Business Cycle Model      Macro Module 10: Business Cycle Effects      Macro Module 11: Capital Utilization and Unemployment      Macro Module 12: Demand for Money      Macro Module 13: Price Levels and Seasonal Variations      Macro Module 14: Inflation and Interest Rates      Macro Module 15: Inflation, Interest Rates, and Money Growth      Macro Module 16: Government Expenditures      Macro Module 17: Temporary Changes in Government Expenditures and War...      Macro Module 18: Taxes      Macro Module 19: Public Debt      Macro Module 20: Debt and Social Security      Macro Module 21: Price mis-perceptions model, theory      Macro Module 22: Price mis-perceptions model, empirical evidence      Macro Module 23: Sticky prices (new Keynesian model)      Macro Module 24: New Keynesian model and sticky wages VEE Exam Course: Regression Analysis John Fox text      Registration      Course scheduling      Introduction      Materials      Homework assignments      Questions      Final exam      Fox Module 1 Statistical models      Fox Module 2 Basics of regression analysis      Fox Module 3 Univariate displays      Fox Module 4 Bivariate displays      Fox Module 5 Multivariate displays      Fox Module 6 Transforming data      Fox Module 7 Advanced transformations      Fox Module 8 Linear least squares regression      Fox Module 9 Multiple regression      Fox Module 10 Advanced multiple regression      Fox Module 11 Statistical inference for simple linear regression      Fox Module 12 Statistical inference for multiple regression      Fox Module 13 Dummy variable regression      Fox Module 14 Modeling interactions      Fox module 15 advanced interactions      Fox Module 16 Analysis of variance      Fox Module 17 Unusual and influential data      Fox Module 18 Outliers and Influence advanced      Fox Module 19 Heteroscedasticity      Fox Module 20 Collinearity      Fox Module 21 Generalized linear models concepts      Fox Module 22 Generalized linear models discrete and continuous data      Fox Module 23 Generalized linear models, probabilities      Fox Module 24 Student project requirements and templates VEE Regression Analysis Student Project      Student Projects: Read First (Basic Information)      Other Ideas: Parameter Stability and Heteroscedasticity      Project Template: Sports Won-Loss Statistics      Regression Analysis Student Project Samples      Loss Reserving      RA student project questions VEE Exam Course: Time Series Cryer Chan text      Registration      Materials      Introduction      Homework assignments      Course scheduling      Final exam      Questions      TS Module 1 Time series overview      TS Module 2 Time series concepts      TS Module 3 Trends      TS Module 4 Regression methods      TS Module 5 Stationary moving average processes      TS Module 6 Stationary autoregressive processes      TS Module 7 Stationary mixed processes      TS Module 8 Non-stationary time series basics      TS Module 9 Non-stationary ARIMA time series      TS Module 10 Autocorrelation functions      TS Module 11 Simulated and actual time series      TS Module 12 Parameter estimation method of moments      TS Module 13 Parameter estimation least squares      TS Module 14 Model diagnostics      TS Module 15 Forecasting basics      TS Module 16 ARIMA Forecasting      TS Module 17 Forecasting bounds      TS Module 18 Forecast updates and weights      TS Module 19 Seasonal models basics      TS Module 20 Seasonal models advanced      TS Module 21 Building an ARIMA process      TS Module 22 Student projects interest rates      TS Module 23 Student projects sport statistics      TS Module 24 Student projects weather and demographics VEE Time Series Student Project      Time Series Student Project Samples      Student Project Samples      Indices for TS Student Projects      Interest Rates      Student Project General: Introduction, Write-up, Grading (Read First)      Weather: Daily Temperature Data      Time Series Techniques      Time Series Project Templates      ARIMA Modeling      Web Sites and Data Questions