Qno5 need only fast PART IIShow your excel workings for the following problems. Round up to two decimal places if necessary.1. Sarah would like to make a single investment and have 125 million at the time of her retirement in 11years. She has found a mutual fund that will earn 10 percent semi-annually. How much will Sarah have toinvest today? What if Sarah is a finance major and learns how to earn a 15 percent annual return - howsoon could she then retire?2. Freilyn Angob, a Filipina working in the UAE, has won in an Emirates Lotto Draw where she will receivePhp 387,000 a month for 25 years. If she decides to save 50% of those earnings every year and put intoan account that pays 8% interest, how much will her savings be after 25 years?3. How risky is your portfolio if you have invested 50% to security 1 and 50% to security 2?What if based on your research, the risk will be minimized if you changed the composition of your portfolioto be 20% of security 1 and the rest to security 2. Is your analysis correct?State of Nature12345Probability0.350.150.100.100.30Return, Security 1-20%15254560Return, Security 210%-13-520254. Consider a $1,000 par value bond issued by ACEN with a maturity date of 2045 and a stated coupon rateof 8.5 percent that pays interest on an annual basis. On January 1, 2023, the bond had 23 years left tomaturity, and the market's required yield to maturity for similarly rated debt was 7.5 percent. What is thevalue of the bond?5. Consider the valuation of a share of common stock that paid a $2 dividend at the end of last year and isexpected to pay a cash dividend every year from now to infinity. Each year the dividends are expected togrow at a rate of 10 percent. Based on an assessment of the riskiness of the common stock, the investor'srequired rate of return is 15 percent. What is the value of this common stock?

Value of stock can be determined based on the dividend and growth of dividend and based on required…

Show your excel workings for the following problems. Round up to two decimal places if necessary. 1. Sarah would like to make a single investment and have 125 million at the time of her retirement in 11 years. She has found a mutual fund that will earn 10 percent semi-annually. How much will Sarah have to invest today? What if Sarah is a finance major and learns how to earn a 15 percent annual return - how