Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. hi! this is for my capital budgeting project. plea

Hi! This is for my Capital Budgeting Project. Please help me find the Discounted Payback...

90.2K

Verified Solution

Question

Finance

Hi! This is for my Capital Budgeting Project. Please help me find the Discounted Payback Period. Thank you! Also please use Excel. And will also appreciate an explanation of the answer.
image
image
Tables Add-ins Charts R15 v X for G H 3 A B D E 2 Calculations of Investment in Property, Plant and Equipment 3 Sin 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 24 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 40 41 IRR = 13% 42 7.26654 0.36708 -3677 4513.76 0 836.76

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Geometry
1.2K views

1 1 point Why are the triangles similar triangles are not similar SSS SAS AA...

Medical Sciences
1.2K views

Question on visual neglect.    In visual neglet, a person is unable to process and perceive stimuli...

Biology
1.2K views

Hemoglobin is the protein found in red blood cells that transports oxygen from your lungs to...

Basic Math
1.2K views

(I need your Reference URL LINK, please) ( i need Unique answer, don't copy and paste, please)...

Statistics
1.2K views

Question 12 The highway mileage mpg for a sample of 5 different models of a...

Statistics
1.2K views

b What is the probability that a sample of 90 female graduates will provide a...

Calculus
1.2K views

A spinner marked off in 5 equal-size regions, numbered 1 through 5, is spun twice....

Algebra
1.2K views

The distance d of a point P to the line through points A and B...

Accounting
1.2K views

Q7 Q8 Unayzah Company purchased a machine for 50,000SR. The company paid 4,000SR...

Accounting
1.2K views

Josie is a material participant in a business that specializes in monetizing intellectual property. This...

Accounting
1.2K views

Required information [The following information applies to the questions displayed below.] University Car Wash purchased...

Finance
1.2K views

What is the .5 year zero rate (also known as "spot rate") give that the...