Please solve the attached excel spreadsheet. Kindly use the formulas.

NAME Nikhil Raina (Student ID:11814) COURSE: International Corporate Finance Final Exam Instructor: Dan Sevall Sections Corporate Valuation Working Capital Management Multinational Financial Management Translation Effects Exchange Rate impact on Valuation Real Options Total 20% 20% 15% 20% 25% 100% Corporate Valuation Jeanne and Amanda Corp has never paid a dividend. Free cash flow is projected to follow the timeline below. After the third year, FCF is expected to grow at 7% annually. The WACC is 12%. $M Year 1 -20 2 50 3 80 1. What is Jeanne and Amanda's Terminal Value? 2. What is the current value of operations? 3. Suppose Jeanne and Amanda has $10M in marketable securities, $100M in liabilities, and 10M shares of stock. What is e timeline below. 10M shares of stock. What is Jeanne and Amanda's share price? Carmen and Vanessa's Corporation wants to determine the effect of its inventory and receivables management on its cash Carmen and Vanessa's sales last year (all on credit) was $200,000, and earned a net profit % of 10%. Inventory Turnover w Days Payable Outstanding were 30. Cost of Goods Sold was $120,000, and Fixed Assets were $50,000. a. Please calculate Carmen and Vanessa's cash conversion cycle (preferably using my methodology, not the text's ) b. Assume Carmen and Vanessa has no cash, no marketable securities and no other Long Term Assets. What is Carmen an c. If Carmen and Vanessa improves Inventory Turnover to 15, what is the new cash conversion cycle, Total Asset Turnover a management on its cash flow cycle. 0%. Inventory Turnover was 12, Days Sales Outstanding was 45, and gy, not the text's ) ssets. What is Carmen and Vanessa's Total Asset Turnover and ROA? cle, Total Asset Turnover and ROA? Multinational Financial Management Youna is the CFO of Cool Company, headquartered in Silicon Valley. All of the shareholders live in the United States. Recently, Cool Company received the following loan in millions of Korean Won: 1,200 M This was to finance a new factory in South Korea. At the time the loan was received, the exchange rate between the USD was 1 USD for 1200 South Korean Won. Due to the stronger US economy, the USD appreciated in value to 1 USD for 1500 SKW. How much has Cool Company made on the loan (either in a loss or as a gain) due to the rising USD? Foreign Investment Analysis Sevall Inc's Mexican Subsidiary, Cancunrocks, is expected to pay Sevall 1 Peso per share in 1 year after all foreign and US taxes h The exchange rate in 1 year is expected to be $0.10 dollars per peso. After this, the peso is expected to depreciate against the inflation differences between the US and Mexico. The peso denominated dividend is expected to grow at 7% a year indefinitely. Sevall owns 10M shares of Cancunrocks. Assuming that the cost of equity is 12%, what is the valuation of Cancunrocks in US dollars? ar after all foreign and US taxes have been accounted for. ected to depreciate against the dollar by 2% forever due to Real Options To capture the momenturm of the Stanford Cardinal, Ming Hsu and Wei's Hilarious Headgear is considering selling bright-red headgear for Stanford football games. The purchase cost for a franchise (lasting two years) is $30K. If Stanford football continues to do well, this will drive higher demand. There is a 35% probability for higher demand, and there would be net cash flows of $50K per year for two years. If Stanford chokes, then demand will be bad (65% probability) and then cash flows will be only $10K per year for two years. Ming Hsu and Wei's cost of capital is 10%. a. What is the expected NPV of the franchise? Ming Hsu and Wei has the option to renew the franchise license for an additional two years. The renewal fee would be for $30K and would be paid at the end of year 2. If he were to renew, then he would expect similar cash flows (35% probability of getting $50K in years 3 and 4); (65% probability of getting $10K in years 3 and 4). With an option, Ming Hsu and Wei doesn't actually have to execute the franchise license--he has the option to buy or to decline it. What is the maximum amount that Ming Hsu and Wei should pay for an option for the rights to a franchise at the end of year 2? Hint: Use Decision Tree analysis similar to part a. Remember that we don't have to pay for a franchise, if we think the bad scenario will occur