Please attach your spreadsheet for Question 5 here.

5. Alpha Inc. is contemplating on investing in a manufacturing facility in China. As a consultant, you are charged with doing the financial analysis for this project. You expect the cash flows (in Chinese RMB) for this project to last indefinitely. You estimated the following cash flows for 2020-2025 and that the cash flows will grow at a constant rate starting 2026. (12 Points) Year202020212022202320242025FCF85,000,000RMB10,000,000RMB12,000,000RMB15,000,000RMB16,000,000RMB18,000,000RMBOtherDataGrowthrateofRMBFCFstarting2026=3%CostofCapitalforsimilarU.S.Projects(WACC)=14%InflationintheU.S.=2%InflationinChina=6%Spotrate=7.1RMBUSD a) What is the appropriate discount rate you should use to discount the RMB cash flows? b) What is the RMB NPV and IRR for this project? (If Excel is used, please cut and paste it here, showing all the cash flows and answers to this question.) c) What is the USD NPV for this project? (Please show your calculation converting RMB NPV to USD NPV.) d) What are the i) RMB cost of capital and ii) RMB NPV if inflation in China rises to 7% and the U.S. inflation drops to 1% ? 5. Alpha Inc. is contemplating on investing in a manufacturing facility in China. As a consultant, you are charged with doing the financial analysis for this project. You expect the cash flows (in Chinese RMB) for this project to last indefinitely. You estimated the following cash flows for 2020-2025 and that the cash flows will grow at a constant rate starting 2026. (12 Points) Year202020212022202320242025FCF85,000,000RMB10,000,000RMB12,000,000RMB15,000,000RMB16,000,000RMB18,000,000RMBOtherDataGrowthrateofRMBFCFstarting2026=3%CostofCapitalforsimilarU.S.Projects(WACC)=14%InflationintheU.S.=2%InflationinChina=6%Spotrate=7.1RMBUSD a) What is the appropriate discount rate you should use to discount the RMB cash flows? b) What is the RMB NPV and IRR for this project? (If Excel is used, please cut and paste it here, showing all the cash flows and answers to this question.) c) What is the USD NPV for this project? (Please show your calculation converting RMB NPV to USD NPV.) d) What are the i) RMB cost of capital and ii) RMB NPV if inflation in China rises to 7% and the U.S. inflation drops to 1%