How do i complete part b without having to use the pvifa function. I do not have that on my excel.

you have completed so far. It du Quartz Corporation is a relatively new firm. Quartz has experienced enough losses during its early years to provide it with at least eight years of tax loss carryforwards, so Quartz's effective tax rate is zero. Quartz plans to lease equipment from New Leasing Company. The term of the lease is four years. The purchase cost of the equipment is $970,000. New Leasing Company is in the 25 percent tax bracket. There are no transaction costs to the lease. Each firm can borrow at 6 percent. a. What is Quartz's reservation price? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g. 32.16.) b. What is New Leasing Company's reservation price? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Answer is not complete. Reservation price Reservation price $ 279,933.75