We should fill in the excel table using information below:

Pfizer Inc. operates as a pharmaceutical company. The company develops and produces medicines and vaccines for a wide range of medical disciplines, including immunology, oncology, cardiology, endocrinology, and neurology. Its products include theblockbuster drugLipitor (atorvastatin), used to lowerLDLblood cholesterol; Lyrica (pregabalin) for neuropathic pain and fibromyalgia; Diflucan (fluconazole), an oral antifungal medication; Zithromax (azithromycin), an antibiotic; Viagra (sildenafil) for erectile dysfunction; and Celebrex (also Celebra,celecoxib), an anti-inflammatory drug.

The Covid-19vaccinetrial designed byPfizerInc. and its German partner BioNTech SE may allow them to find whether their shot works before their fastest-moving rivals.

The U.S. government hasagreed to pay Pfizer and BioNTechnearly $2 billion for 100 million doses. Pfizer could seek regulatory approval or an emergency-use authorizationby late November.

How much are you willing to pay if you estimate that growth in residual earnings after 2020 will be at the GDP growth rate of 2%?

The risk-free rate at the time was about 0.27%, Beta was 0.66, and you require a 6% risk premium for investing in this stock. Use the residual earnings model with attached information for the valuation.

BPS 11.58 Dividend payout ratio 58.5% Forecast Year 2019 2020 2021 t 0 1 2 EPS 2,9 3.24 Bp: ROCE RE Beta Risk Free Rate Market Premium Discount factor PV of RE Total PV of RE LTG Continuing Value PV of CV Value per share