Q. Search Sheet E Chapter 11 PB 11-4 Kinda, page 506 + Share + Home Insert Page Layout Formulas Data Review View n X. Cut > AutoSum Calibri (Body) - 12 Eta wrap Text General Copy Fill Merge & Center 00 Conditional Format Formattirg as Table Paste Cell Stvies Insert Delete Format Sort & Filter .n V Format Clear Check for Updates Office Update To kesp up to date with security updates, fixes, and improvements, choose Check for Updates. A2 5 Given Data: 7 PB 11-4 part for ARR, Payback and IRR A. ARR, Accounting Rate of Return $860,000 6 Years 9 Initial Investment ARR - 10 Useful Life $66,000 11 al Net Ircome 12 Cost of Capital 13 (Use as Hurtle rate 14 Salvage Value 11% Calculation of cash flow needed for B thru D, you do need the salvage value SED.O00 Net Incoma Depreciation Add back non cash expenditures (straisht lirel 15 16 Add'I data for NPV CalcLletion only Cash Inflow 17 $20,000 18 Working capital B. Payback Perlod Years 19 20 21 22 C. Net Present Value (Calculate below 23 24 25 Discount Present Value 26 Item Years Cash flow Factor Totals actualy always helang at the tap 27 NET PRESENT VALUE Initial Investment 28 since it's realy what you want to see first 29 Annual Inflow Workng Capltal Working Capital Salvage Valun 3D 31 32 33 34 35 D. Internal Rate of Return 36 Cash flows by vear Year 1 Year 5 37 Use excel IRR formula Year 0 Year 2 Year 3 Year 4 Vear & IRR - 38 DK, you can tyne this data in OK, you can type this data in OK, you can type this data in Not this data 39 40 Year Total 41 42 43 Sheet1 Ready 100% Q. Search Sheet E Chapter 11 PB 11-4 Kinda, page 506 + Share + Home Insert Page Layout Formulas Data Review View n X. Cut > AutoSum Calibri (Body) - 12 Eta wrap Text General Copy Fill Merge & Center 00 Conditional Format Formattirg as Table Paste Cell Stvies Insert Delete Format Sort & Filter .n V Format Clear Check for Updates Office Update To kesp up to date with security updates, fixes, and improvements, choose Check for Updates. A2 5 Given Data: 7 PB 11-4 part for ARR, Payback and IRR A. ARR, Accounting Rate of Return $860,000 6 Years 9 Initial Investment ARR - 10 Useful Life $66,000 11 al Net Ircome 12 Cost of Capital 13 (Use as Hurtle rate 14 Salvage Value 11% Calculation of cash flow needed for B thru D, you do need the salvage value SED.O00 Net Incoma Depreciation Add back non cash expenditures (straisht lirel 15 16 Add'I data for NPV CalcLletion only Cash Inflow 17 $20,000 18 Working capital B. Payback Perlod Years 19 20 21 22 C. Net Present Value (Calculate below 23 24 25 Discount Present Value 26 Item Years Cash flow Factor Totals actualy always helang at the tap 27 NET PRESENT VALUE Initial Investment 28 since it's realy what you want to see first 29 Annual Inflow Workng Capltal Working Capital Salvage Valun 3D 31 32 33 34 35 D. Internal Rate of Return 36 Cash flows by vear Year 1 Year 5 37 Use excel IRR formula Year 0 Year 2 Year 3 Year 4 Vear & IRR - 38 DK, you can tyne this data in OK, you can type this data in OK, you can type this data in Not this data 39 40 Year Total 41 42 43 Sheet1 Ready 100%
