Answers to B69:B74 & R70:74

With cell reference.

3 Net systen 4 Delivered cost 5 Installation 6 Salvage value $285, 000 NPV $20,086 $18. 000 IRR $15. 000 MIRR $76.000 Payback 14 06%; 12.90%; Annual savings PI 483773.05 9 01d systen 30 Current book value 31 Current market value 32 Removal cost $4.000 s2. 500 35 Cost of capital 36 Cost of borrowing 37 Return for typical investments 38 Tax rate 12.0% 12.0% 14. 0% 36. 0% 40 MODEL-GENERATED DATA 41Cash flovs at t-0: 42 Cost of new system 43 Installation End-of- Salvage value--> SV tax ect ca $285,000 18,000 $15,000 5.400 45 Total cost $303,000 Total $9,600 47 Proceeds from old equip 48 Tax on proceeds 49 Removal cost (AT) $4.000 1,440 1,600 Depreciation infornation Depreciable basis $303,000 51 Net cash flow, old $960 302 n4n Case 95H : NPV-PROFH I MULTIPLE H Iime | | l Ready 3 Net systen 4 Delivered cost 5 Installation 6 Salvage value $285, 000 NPV $20,086 $18. 000 IRR $15. 000 MIRR $76.000 Payback 14 06%; 12.90%; Annual savings PI 483773.05 9 01d systen 30 Current book value 31 Current market value 32 Removal cost $4.000 s2. 500 35 Cost of capital 36 Cost of borrowing 37 Return for typical investments 38 Tax rate 12.0% 12.0% 14. 0% 36. 0% 40 MODEL-GENERATED DATA 41Cash flovs at t-0: 42 Cost of new system 43 Installation End-of- Salvage value--> SV tax ect ca $285,000 18,000 $15,000 5.400 45 Total cost $303,000 Total $9,600 47 Proceeds from old equip 48 Tax on proceeds 49 Removal cost (AT) $4.000 1,440 1,600 Depreciation infornation Depreciable basis $303,000 51 Net cash flow, old $960 302 n4n Case 95H : NPV-PROFH I MULTIPLE H Iime | | l Ready