2. IErrorCorrect FIN Sheet: (30 Points, 4 for a, 5 for b, d, and e, 6 for c). (Covers Learning Objectives: 8 and 9.) a. Track down and correct all errors that you can find. Note: In general, not all errors generate error messages, but in this problem all of the errors, except for the taxes on the salvage value, have error messages. b. Calculate the Net Present Value (NPV goes in C42) for this project using IRate (cell C12), and the Free Cash Flow row for your data. c. Beginning in cell B46 create a One Way data table that shows NPV for all IRates going from 10% to 20% in half percent increments. d. Calculate the Internal Rate of Return (TRR goes in C43). In cell D43, briefly describe how you know this project has only one IRR. e. Be sure your tables are appropriately labeled. & Return on investments Demo: Workbook Auditing & Return on Investments Cond Format forming as Tables Assumptions Proposed Equipment Cost Equipment fetime (years) Salvage Value Elective Tax Rate Incremental Price In Units Sold Name 5 ZURRIOR 760.000 15% 2.00 3000000 U $ To Requiremon Cinvestment Price 2.05 Capital Expenditure Decision Support Worksheet of the Year Capital Expenditure Assumptions: Capital Expenditure Units Sold 1 2 Year 3 5 4.000.000 4 3,000,000 3.000.000 1121200 1534 (This Year 1 NAME? 2 6.130,000 5 3 $ capital Budgeting Calculations (Make): Incremental income from Project Incremental Expenses for Project Materials Labor Depreciation Total Incremental Expenses 4 CSS . WA 10,000 750.000 750,000 600.000 600,000 731744 2.316,000 52.083.7445 750.000 600.000 556,114 1.0015 500.000 600.000 01:53 171.5839 125.000 0.000 2011 $ 10,000 $ 319,50 110S 5 (10.000 LUM.2225 Operating Income Before Taxes Taxes Operating Income After Taxes 2013 (2.50 16 SOOJ NAME? NAME? NAME? $ 4016,256 5 1.412.690 $ 2.623,5665 MUS LAS 3.125 NALUCI VALLEI VALLEI $ 216.55 1412 5 NAME? 150,000 $ 2,057,310 150.000 3.710331 46.500 150,000 150,000 VALUE Operating Income Alter Taxes Depreciation Net Working Capital Change in Not Working Capital Salvage Value Taxes on Salvage Value 3,374.722 100.000 S. 157.2555 0.000 100 2.000 125.000 H. 5 5 13 VALUE Free Cash Flow Cumulative Free Cash Flow $ 3 14.156.500 14.156.500 ENAME? NAME? 257,310 NAME 2,424 225 2015 ENAME! NAMET NPV Methodent va