Redwood Hospital must replace its energy plant including the heating and air-conditioning systems and backup electrical systems due to a series of breakdowns. The replacement cost is $ 20,000,000, and the local bank will provide a 20-year loan at 4.0 % . Calculate the annual loan payment and create the 20 - year amortization schedule. What are the to Hello, I need this problem solved using an excel grapgh Thanks!

Owe

The Atlantic Medical Clinic can purchase a new computer system that will save $7,000 annually in billingcosts. The computer system will last for eight years and have no salvage value.Required:Up to how much should the Atlantic Medical Clinic be willing to pay for the new computer system if theclinic’s required rate of return is:1. Sixteen percent?2. Twenty percent?

The Atlantic Medical Clinic can purchase a new computer system that will save $6,000 annually in billing costs. The computer system will last for seven years and have no salvage value.   Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor(s) using tables.   Required: What is the maximum price (i.e., the price that exactly equals the present value of the annual savings in billing costs) that the Atlantic Medical Clinic should be willing to pay for the new computer system if the clinic’s required rate of return is: (Round your final answer to the nearest whole dollar amount.)   Maximum Price 1. Seven percent   2. Nine percent