Please show all cell formulas and explanations for the calculation answers. Thank you!

i dont think the last picture serves a significant purpose.

ENVIRONMENTAL SCIENCES, INC. Lease Analysis This case lustrales the leaseversus-purchase decision from the standpoints of both the lessee and lessor. The model calculates the NAL (WPV) and IRR of the lease for both the lessee and the lessor Note that the lessee's model is presented in two diferent formats-a tree line format which includes the cost of the equipment in leu of the financing cash fows, and a time line format which includes financing costr. Finaly, note that the model contains a graph which plots lessee's NAL and lessor's NPV at dtferent lease payment amounts. Click on the GRAPH tab to view the graph. Clok on the Student Template tab to return to the spreadsheet. To complete the model, fir in the values in the green cells. For Lessor Oniy? Maintenance contract (annual 5) Oppoctunty cost rate Estmated residual value Tax rate MACRS Depreciation Table PART A. Lessee's Analysis Own vs. Lease Net Advantage to Leasing- OR We can also find NaL from using oifterences in CF per year menod: Aternative Format Lesseets Analysit Amontzation Table Recall firm would botrow full cost of equi Lesteded Analysis Lettee's Anayta. Net Advantage to Leasing Net adv to leasing (NAL) PART B Latsors malvis Gakt th. Loungra Aeoyns ENVIRONMENTAL SCIENCES, INC. Lease Anatysis This case illustrates the lease-versus-purchase decision from the standpoints of both the lessee and lessor. The model calculates the NAL (NPV) and IRR of the lease for both the lessee and the lessor. Note that the lessee's model is presented in two different formats-a time line format which includes the cost of the equipment in lieu of the financing cash flows, and a time ine format which includes financing costs. Finally, note that the model contains a graph which plots lessee's NAL and lessors NPV at difterent lease payment amounts. Click on the GRAPH tab to view the graph. Clck on the Student Template tab to retum to the spreadsheet To complete the modet, nit in the values in the green cells. (Note. All dollar amounts are stated in thousands) Generai Data: Invoice price Lease payment For Lessee Only; Maintenance contract (annual cost) Loan interest rate Estimated residual value Residual Val discount rate (Afer-Tax) Tax rate For Lessor Onty. Maintenance contract (annual 5) Opportunity cost tate Estimated residual value Tax rate MODEL-GENERATED DATA: MACRS Degreciation Table: MACRS Depreciation Table: PART A. Lessee's Analysis: OWn vs. Lease OR We can also find NAL from using differences in CF per year method: Alternative Format Lessee's Analysis: Amortization Table: Recali firm would porrow full cost of equipment at prevaling rate and pay over 4 ) Lessee's Analysis: PART B: Lessor's Analysis (Question m8) SENSTIVITY ANALYSIS (See also the "GRAPH" worksticet): 04 ENVIRONMENTAL SCIENCES, INC. Lease Analysis This case lustrales the leaseversus-purchase decision from the standpoints of both the lessee and lessor. The model calculates the NAL (WPV) and IRR of the lease for both the lessee and the lessor Note that the lessee's model is presented in two diferent formats-a tree line format which includes the cost of the equipment in leu of the financing cash fows, and a time line format which includes financing costr. Finaly, note that the model contains a graph which plots lessee's NAL and lessor's NPV at dtferent lease payment amounts. Click on the GRAPH tab to view the graph. Clok on the Student Template tab to return to the spreadsheet. To complete the model, fir in the values in the green cells. For Lessor Oniy? Maintenance contract (annual 5) Oppoctunty cost rate Estmated residual value Tax rate MACRS Depreciation Table PART A. Lessee's Analysis Own vs. Lease Net Advantage to Leasing- OR We can also find NaL from using oifterences in CF per year menod: Aternative Format Lesseets Analysit Amontzation Table Recall firm would botrow full cost of equi Lesteded Analysis Lettee's Anayta. Net Advantage to Leasing Net adv to leasing (NAL) PART B Latsors malvis Gakt th. Loungra Aeoyns ENVIRONMENTAL SCIENCES, INC. Lease Anatysis This case illustrates the lease-versus-purchase decision from the standpoints of both the lessee and lessor. The model calculates the NAL (NPV) and IRR of the lease for both the lessee and the lessor. Note that the lessee's model is presented in two different formats-a time line format which includes the cost of the equipment in lieu of the financing cash flows, and a time ine format which includes financing costs. Finally, note that the model contains a graph which plots lessee's NAL and lessors NPV at difterent lease payment amounts. Click on the GRAPH tab to view the graph. Clck on the Student Template tab to retum to the spreadsheet To complete the modet, nit in the values in the green cells. (Note. All dollar amounts are stated in thousands) Generai Data: Invoice price Lease payment For Lessee Only; Maintenance contract (annual cost) Loan interest rate Estimated residual value Residual Val discount rate (Afer-Tax) Tax rate For Lessor Onty. Maintenance contract (annual 5) Opportunity cost tate Estimated residual value Tax rate MODEL-GENERATED DATA: MACRS Degreciation Table: MACRS Depreciation Table: PART A. Lessee's Analysis: OWn vs. Lease OR We can also find NAL from using differences in CF per year method: Alternative Format Lessee's Analysis: Amortization Table: Recali firm would porrow full cost of equipment at prevaling rate and pay over 4 ) Lessee's Analysis: PART B: Lessor's Analysis (Question m8) SENSTIVITY ANALYSIS (See also the "GRAPH" worksticet): 04