must use excel. show work/equations

must use excel. show work/equations

Assume the Mayo Clinic has developed a new drug for the treatment of a disease. The development cost $20,000,000 initially plus it will cost them $1,000,000 per year for ongoing operations and $28.50 per vial to produce. The Mayo Clinic has 12 years left on their patent and their required rate of return is 8%. How much do they need to charge per dose assuming 80,000 patients get 12 doses per year