Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Show what formulas you used in the cells PLEASE! ALL YOU NEED TO DO IS CREATE THE EXACT SPREAD SHEET LIKE THE PICTURE BUT SHOW
Show what formulas you used in the cells PLEASE! ALL YOU NEED TO DO IS CREATE THE EXACT SPREAD SHEET LIKE THE PICTURE BUT SHOW ME WHAT FORMULAS YOU USED FOR THE CELLS WHERE I CANNOT USE 0.13 OR 0.02.
2 - Using the problem on page 15-17, PsychoCeramic Sciences, Inc. Create the spreadsheet to do the Discounted Cash Flow using the NPV formula. Use separate columns to show: Year, Inflow, OutFlow, Net Flow, Discount Factor and NPV. DO NOT TYPE IN 13 and 0.02 in the equations: instead have the hurdle rate and the inflation rate as variable cells using referencing to the specific cell Give the calculated value of the Net Present Value (NPV) Table A A B D G F Net Present Value 2 Net Flow Inflow B E Discount Factor 1/(1 + k + p) 1.00 0.87 4 5 6 0.76 0.66 7 8 Year A 2013* 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2022 Outflow $125,000.00 100,000.00 90,000.00 0.00 15,000.00 0.00 15,000.00 0.00 15,000.00 0.00 0.00 $0.00 0.00 0.00 50,000.00 120,000.00 115,000.00 105,000.00 97,000.00 90,000.00 82,000.00 65,000.00 35,000.00 9 10 11 12 13 (B-C) -$125,000.00 -100,000.00 -90,000.00 50,000.00 105,000.00 115,000.00 90,000.00 97,000.00 75,000.00 82,000.00 65,000.00 35,000.00 0.57 0.50 0.43 0.38 0.33 0.28 0.25 0.25 DXE -$125,000.00 -86,957.00 -68,053.00 32,876.00 60,034.00 57,175.00 38,909.00 36,466.00 24,518.00 23,310.00 16,067.00 8,651.00 14 15 16 Total $750,000.00 $360,000.00 $399,000.00 $17,997.00 17 18 19 *1 = 0 at the beginning of 2013 20 21 22 23 24 25 26 27 28 Formulae Cell D4 Cell E4 Cell E5 Cell E6 Cell F4 Cell B17 = (B4-C4) copy to D5:D15 1/(1 + 0.13 + 0.02)^0 1/(1 + 0.13 + 0.0241 1/(1 + 0.13 + 0.02)^(A6-2012) copy to E7:E15 D4*E4 copy to F5:F15 Sum(B4:B15) copy to C17, D17, F17Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started