*All your answers must be on the Excel*

__Question I: Return and Risk__

*Use the data in the attached Excel file named (Question 1 Return and Risk) to answer this question*

You have the index (EGX30 Index) and five companies which are CIB, Eastern Tobacco, El SWEDY Electric, Heliopolis Housing, and SODIC.

**First Portfolio**: Select only two stocks out of the five stocks as your portfolio (i.e., your portfolio will be consisting of only two stocks of your selection). Manually determine the optimal weights scenario of your first portfolio (i.e. Show your calculations step by step)**Second Portfolio**: Construct a portfolio consisting of the five stocks. Use the matrix multiplication and Data analysis tools to determine the optimal weights scenario for your second portfolio.- Does the annual return of your second portfolio exceed the annual return of the market?
- If you invest all your money in only one company of the five above mentioned companies, which one would you select? Why?

__Question II: Mortgage Finance__

*Use the data in the attached Excel file named (Question 2 Mortgage Finance) to answer this question*

Calculate the followings:

A. The monthly installment (P&I)

B. The total amount paid for the house

C. The amortization schedule for the mortgage loan

D. There is an early prepayment penalty fee of 3%. If you decide to do early prepayment in Month 70, how much will you have to pay (loan and penalty)

E. What is the maximum loan you can take given your income?

F. What is the maximum property price given your income?

G. Are you qualified for this mortgage given your income? Why?

H. What is the effect of increasing the number of years on the mortgage monthly installment? What is the effect of increasing the loan to value on the mortgage monthly installment?

__Question III: Stock Valuation__

*Use the data in the attached Excel file named (Question 3 Stock Valuation) to answer this question*

- Calculate the fair value of SODIC stock.
- What is your recommendation for this stock?

__Question IV: Time Value of Money__

*Use the data given in the file named (Question 4 Time Value) to answer the following questions:*

A. A Steel factory is offered today April 14, 2020 for a market price of 60 million. Calculate the present value (fair value) of that factory using the given expected cash flows. Do you recommend buying this factory? Why?

B. Calculate the future value of the bank deposits. Assume a land will cost you L.E 120 Million on April 14, 2020, will you be able to buy it today?

__Question V: Theoretical__

- Explain the trading and settlement process in the Egyptian stock exchange (You may just use the diagram explained in the lecture or write it in words)

- Compare between the following:
- T-bill and T-bond
- Primary market and secondary market
- Money market and capital market
- Initial public offering and private placement
- Stocks and bonds

Egyptian stock exchange - Trading and settlement process

Validation error occured. Please enter the fields and submit it again.

Thank You ! Your email has been delivered.