FINC 560

MA Individual Assignment (50 points) jo complete this homework, you will enter your answers to the questions below 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 :#43).| Once you've 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- Federated Hermes has a beta of 1.45 and a fixed dividend of $1.08 a share. Find its intrinsic value. If its current price is $32.61, is the stock over or under volued? 2.-Jeffenes has a beta of 1.20, a 2024 dividend of $1.564, and a growth rate of 15%. Find its intrinsic value. If it's currently selling at $27.96, is it over or under valued? 3.-The information for Jefferies 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 $27.96, is it over or under valued? ""Note that the info below is for 2023: you must forecast the 2024 EPS using the formula EPS, 2023 ERSI 83.90 Beto 1.20 Average DPO 0.287 Growth rate 0. 15 Average PIE 8.967