please note that I need the answer on excel and a short explanation... there isn't missing information, feel free to use any data or information as u want. thanks

Instructions: Prepare your own investment project if assuming that you already have a multinational company, and now you want to broaden your business to one more country. Meaning that you want to establish a new subsidiary and you need to prepare the capital structure for this project and then evaluate the feasibility of this project. Some basic requirements you need to cover in the project are as follows: - Capital structure should include both domestic sources and host country's sources. Apply the term of exchange rate to calculate the total initial investment in home country's currency. (1p) - Calculate appropriate minimum required rate of return for the project. (1p) - Estimate the future cash flows of the project and convert into appropriate currency to evaluate the project by using some techniques such as NPV, IRR, payback period, and discounted payback period. (3p) - Prepare some different scenarios of exchange rate that affect the cash flows and reevaluate the project. (1.5p) - Apply the technique of forward or future contract to hedge the project. (1.5p) - Reevaluate the project if we change the nancing structure. (1p) - Evaluate the project if all cash flows are blocked in the host country until you sell the subsidiary. (1p)