80.2K

Verified Solution

Link Copied!

Hi! This is for my Capital Budgeting Project. I just need your help in how i will be discussing these (PPE, Annual Depreciation, Free Cash Flow, NPV, IRR and Discounted Payback Period) in my Powerpoint. Thank you! Especially the Discounted Payback Period, please briefly explain how that answer was achieved. Also should i recommend this project for acceptance or rejection? and why?

Illustrations Pivot Table Recommended Table Pivot Tables My Add-ins Recommended Charts Tables Add-ins Charts R15 X & fx B H 3 D 2 Calculations of Investment in Property, Plant and Equipment S in Million 4 Existing Balance as of September 26, 2020 $36,766 5 Investment in PPE @ 10% $3,677 6 Salvage Value @ 5% 1,383 7 Useful life (Years) 12 8 9 Annual Depreciation (using SLM) $191.17 10 11 12 13 Computation of Free Cash Flow from Project 14 S in Million 15 EBIT @ 18% of Project Cost 662 16 Less: Operating tax @ 35% -232 17 NOPAT 430 18. Add Depreciation 191.17 19 Gross Cash Flow 621.17 20 Investment in Working Capital 21 CAPEX 22 23 Free Cash Flow (FCF) 621.17 Sheet1 Ready Accessibility: Good to go 24 $ in Million 621.17 8.71% 3677 25 26 Net Present Value (NPV) 27 28 Free Cash Flow 29 Discount Rate 30 Cost of Project 31 NPV 32 PVAF (8.71%, 12 Years) 33 PVF (8.71%, 12 Years) 34 The Present Value of Cash Outflows 35 The Present Value of Cash Inflows 36 The Present Value of Salvage Value (net of tax) 37 38 Net Present Value (NPV) 39 7.26654 0.36708 -3677 4513.76 0 836.76 40 41. IRR = 13% 42 5 6 4 2 Computation of Discount Payback Period 3 $ in Million 4 Year Cash Flows PVF Calculations PVF @ 8.71% PV of Cash Flows Cumulative Values 0 -3677.00 1/(1.0871) 1.0000 -3677.00 -3677.00 1 $621.17 1/(1.0871) 1 0.9199 $541.41 -3105.59 7 2 $621.17 1/(1.0871) 2 0.8462 $525.63 -2579.95 8 3 $621.17 1/(1.0871) 3 0.7784 $483.52 -2096.43 9 $621.17 1/(1.0871) 4 0.7160 $444.76 -1651.68 10 5 $621.17 1/(1.0871) 5 0.6586 $409.10 -1242.57 11 6 $621.17 1/(1.0871) 6 0.6059 $376.37 -866.21 12 7 $621.17 1/(1.0871) 7 0.5573 $346.18 -520.03 13 8 $621.17 1/(1.0871) 8 0.5127 $318.47 -201.55 14 9 $621.17 1/(1.0871) 9 0.4716 $292.94 91.39 15 10 $621.17 1/(1.0871) 10 0.4338 $269.94 360.85 16 11 $621.17 1/(1,0871) 11 0.3991 $247.91 680.76 17 12 5621.17 1/(1.0871) 12 0.3671 $228.03 836.75 18 19 Net Present Value (NPV) $836.75 20 21 Discount Payback Period = 8 Years + $201.55 $292.94 = 8 Years +0.688 years 8.688 Years 22

Answer & Explanation Solved by verified expert

See Answer