FINC560

M5 Individual Assignment (62 pointa) To complete this homework, you will enter your answers to the questions below on Tab 1 of the M5 Ind Ass Submission Template. Once you have completed Tab 1, you will copy it to Tab 2 (copy range is A1:F48). 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. Please note that you must set up your spreadsheet on your own. I have not provided any inputs. Risk free rate = 0.016 Market rate = 0.136 1.=Harley-Davidson's information is below. Use it and the Two-stage Growth Model to find its intrinsic value. Forecast its cash flows for 2024 through 2027. If it's currently selling at $36.00, is it over or under valued? 2023 2024 2025 2026 2027 Beta 1.05 Dividend 0.80 Growth rates 0.170 0.106 0.106 0.106 2.-Acuity Brands' average P/E is 13.670. Its earnings per share is expected to be $13.66 a share. Find its intrinsic value. If its current price is $1 73. s it over or under valued? 3.-The average P/E of Buckle's major competitors is 25.033. If its current EPS is $1.68 and it's selling for $33.60 a share, is it over or under valued? 4.-Acuity Brands has a beta of 1.20 and a fixed dividend. If its current P/E is 15.3, is it over or under valued? 5.-Harley-Davidson has a variable dividend, Its beta is 1.05, its dividend payout ratio is 0.17, and its growth rate is 10%. Its current P/E is 8.8. Is it over or under valued