To complete this homework, you will enter your answers on Tab 1 of the M4 Ind Ass Submission Template. Once you have completed Tab 1, you will copy it to Tab 2 (copy range is A1:E43). Once youve copied your answers to Tab 2, you will click on Formulas, then on Show Formulas. Remember that you are graded on the assignment as well as your accuracy in using the Principles of Spreadsheet Design.

Risk free rate = 0.016 Market rate = 0.136 1. Healthpeak Properties has a beta of 1.05 and a fixed dividend of $1.20 a share. Find its intrinsic value. If its current price is $20.67, is the stock over or under valued?

2. AllianceBernstein has a beta of 1.30, a current dividend of $2.80, and a growth rate of 5.50%. Find its intrinsic value. If its currently selling at $31.68, is it over or under valued?

3. The information for Aramark is below. Use the Combined Dividends & Earnings Model to find its intrinsic value. Remember that you are forecasting future cash flows (2024, 2025, and 2026). If its current price is $40.58, is it over or under valued? Current EPS $1.30 Beta 1.45 Average DPO 0.423 Growth rate 0.055 Average P/E 34.067560

M4 HMWK PROBLEMS Market rate Risk free rate Answer in the following template

PROBLEM 1Healthpeak Properties

Beta

Dividend

r

IV

Over/under

PROBLEM 2

AllianceBernstein

Beta

Current dividend

g

r

Next year's dividend

IV

Over/under P

ROBLEM 3

Aramark

Beta

Current EPS Avg. DPO

g

Avg. P/E

r

2023 2024 2025 2026

EPS

Dividend

Price

Total cash flow

NPV

Over/under