How can I find the pic cost of owning to determine if company should own or lease?

WK 8 Seattle Cancer Ctr lable format (!) Formulas Data Review Help Acrobat Home Insert Draw Page Layout View General Arial - 12 - A A 29 Wrap Text $ ~ % 9 100 Conditional Form B I U F V A v EEEE Merge & Center ~ 00 Formatting ~ Tab Font Alignment Number Style X B C D E F G estuual Value Discount Rate. 9.070 Cost of Owning: Year 0 Year 1 Year 2 Year 3 Year 4 uipment cost -3000000 intenance -100000 -100000 -100000 -100000 int tax savings preciation shield 120000 sidual value sidual value tax t owning CF 3100000 -100000 -100000 -100000 120000 cost owning: Cost of Leasing: Year 0 Year 1 Year 2 Year 3 Year 4 ase payment 675000 675000 675000 -675000 ayment tax savings et leasing CF $0 Model + UX Accessibility: Investigate LO X P S zoom w X O.+ 9- F1 F3 F4 F5 F6 F7 F8 Fg F10 @ S % K 2 3 4 5 6 8 9X V for 3000000 26 C D E F A B KEY OUTPUT: INPUT DATA: Lessee: General Data: $3,000,000 NAL Invoice price 27 Annual lease payment $675,000 IRR 28 Net revenue per procedure $10,000 29 Per procedure lease payment $7,000 Lessor: BO 31 For Lessee Only: Unleveraged lease: 32 NPV 33 Maintenance contract cost $100,000 IRR 34 Loan interest (discount) rate 9.0% 35 Estimated residual value $1,200,000 Leveraged lease: 36 Residual value discount rate 9.0% NPV 37 Tax rate 0.0% IRR 38 39 For Lessor Only: Per Procedure Versus Ann 40 (Volume = procedures ar 41 Maintenance contract cost $100,000 42 Opportunity cost rate 8.0% 43 Estimated residual value $1,600,000 Per procedure lease 44 Residual value discount rate 8.0% 45 Tax rate Annual lease 40.0% 46 Leveraged lease inputs: Difference 47 Amount borrowed $1,500,000 Model + Ready MX Accessibility: Investigate 9 O S Esc FnLock 4+ F1 X F2 F3 F4