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.067