Question: Please use excel to answer the following: Alpha Inc. is contemplating on investing in a manufacturing facility in China. As a consultant, you are charged

Please use excel to answer the following:

Please use excel to answer the following: Alpha Inc. is contemplating on

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-2024 and that the cash flows will grow at a constant rate starting 2025. (12 Points) Year 2020 2021 2022 2023 2024 FCF -90,000,000 RMB 10,000,000 RMB 12,000,000 RMB 15,000,000 RMB 16,000,000 RMB Other Data Growth rate of RMB FCF starting 2025 = 3% Cost of Capital for similar U.S. Projects (WACC) = 12% Inflation in the U.S. = 2% Inflation in China = 6% Spot rate = 6.8 RMB/USD 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%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Heather, an individual, owns all of the outstanding stock in Silver Corporation. Heather purchased her stock in Silver nine years ago, and her basis is $56,000. At the beginning of this year, the...

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...

Please show work. Thanks 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...

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...

please show work. thanks a lot! (15 points) 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...

Supreme 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...

Please this is an actual testt. I need the answer within an hour. Please do not take it if you cannot do it within an hour. 2 problem question. Please type the answer in word at attach please. Also...

Supreme 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...

Planned Parenthood of Central New Jersey v. Farmer: What is the basis of the plaintiffs' equal protection challenge? Why does the New Jersey Supreme Court hold that the statute violates plaintiffs'...

What is the concept of marginal cost of capital?

You can leave the default options enabled for each model ( number of nodes, models, iterations, etc. ) . After you have run your 3 models, evaluate each model on the test set. Finally, using what you...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...