Please show calculations in excel

la. Cost of owning Year 0 Year 1 Year 2 Year 3 Year 4 Bolden Health System Inc. has decided to acquire a new electronic health record system for its Rio hospital. The system receives clinical data and other patient information from nursing units and other patient care areas, then either displays the information on a screen or stores it for later retrieval by physicians. The system also permits patients to call up their health record on Bolden's website. The equipment costs $1,000,000, and, if it were Burchased, Bolden could obtain a term loan for the full purchase price at a 10 percent interest rate. Although the equipment has a six-year useful life, it is classified as a special-purpose computer, so it falls into the MACRS three-year class. If the system were Burchased a four-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after four years, and the best estimate of its residual value at that time is $200,000. However, since real-time display system technology is changing rapidly, the actual residual value is uncertain. Net purchase price Maintenance cost Maintenance tax savings Depreciation tax savings Residual value Tax on residual value Net cash flow PV cost of owning b. Cost of Leasing Year Year 1 Year2 Year 3 Lease payment Lease tax savings Net cash flow PV cost of leasing As an alternative to the borrow-and-buy plan, the equipment manufacturer informed Bolden that Consolidated Leasing Center would be willing to write a four-year guideline lease on the equipment, including maintenance, for payments of $260,000 at the beginning of each year. Bolden's marginal federal-plus-state tax rate is 40 percent. You have been asked to analyze the lease-versus-purchase decision, and in the process to answer the following questions: c. Net advantage to leasing PV cost of leasing PV cost of owning NAL =D62 =D55 d. Net advantage to Leasing: a. What is the present value cost of owning the equipment? b. What is the present value cost of leasing the equipment? c. What is the net advantage to leasing (NAL)? d. Answer again the above questions one at a time to see the effect of the change on NAL. That is, starting with the original numbers you used for questions a. and b., what is the NAL if: - pre-tax interest rate increases to 12 percent - the tax rate falls to 34 percent - maintenance cost increases to $25,000 per year - residual value falls to $150,000 - the system price increases to $1,050,000? e. Do the changes in d. make leasing more or less attractive? Explain. Pre-tax interest rate 12% Tax rate 34% Maintenance Residual cost value $25,000 $150,000 System price $1,050,000 PV cost of leasing PV cost of owning NAL 10% 40% MACRS Year 1 Year 2 Year 3 15% Year 4 7% 33% 45% ANSWER Pre-tax interest rate Tax rate After-tax interest rate Lease payment System purchase price Maintenance Residual value 6% $260,000 $1,000,000 $20,000 $200,000 la. Cost of owning Year 0 Year 1 Year 2 Year 3 Year 4 Bolden Health System Inc. has decided to acquire a new electronic health record system for its Rio hospital. The system receives clinical data and other patient information from nursing units and other patient care areas, then either displays the information on a screen or stores it for later retrieval by physicians. The system also permits patients to call up their health record on Bolden's website. The equipment costs $1,000,000, and, if it were Burchased, Bolden could obtain a term loan for the full purchase price at a 10 percent interest rate. Although the equipment has a six-year useful life, it is classified as a special-purpose computer, so it falls into the MACRS three-year class. If the system were Burchased a four-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after four years, and the best estimate of its residual value at that time is $200,000. However, since real-time display system technology is changing rapidly, the actual residual value is uncertain. Net purchase price Maintenance cost Maintenance tax savings Depreciation tax savings Residual value Tax on residual value Net cash flow PV cost of owning b. Cost of Leasing Year Year 1 Year2 Year 3 Lease payment Lease tax savings Net cash flow PV cost of leasing As an alternative to the borrow-and-buy plan, the equipment manufacturer informed Bolden that Consolidated Leasing Center would be willing to write a four-year guideline lease on the equipment, including maintenance, for payments of $260,000 at the beginning of each year. Bolden's marginal federal-plus-state tax rate is 40 percent. You have been asked to analyze the lease-versus-purchase decision, and in the process to answer the following questions: c. Net advantage to leasing PV cost of leasing PV cost of owning NAL =D62 =D55 d. Net advantage to Leasing: a. What is the present value cost of owning the equipment? b. What is the present value cost of leasing the equipment? c. What is the net advantage to leasing (NAL)? d. Answer again the above questions one at a time to see the effect of the change on NAL. That is, starting with the original numbers you used for questions a. and b., what is the NAL if: - pre-tax interest rate increases to 12 percent - the tax rate falls to 34 percent - maintenance cost increases to $25,000 per year - residual value falls to $150,000 - the system price increases to $1,050,000? e. Do the changes in d. make leasing more or less attractive? Explain. Pre-tax interest rate 12% Tax rate 34% Maintenance Residual cost value $25,000 $150,000 System price $1,050,000 PV cost of leasing PV cost of owning NAL 10% 40% MACRS Year 1 Year 2 Year 3 15% Year 4 7% 33% 45% ANSWER Pre-tax interest rate Tax rate After-tax interest rate Lease payment System purchase price Maintenance Residual value 6% $260,000 $1,000,000 $20,000 $200,000