Hindustan Motors has been producing its Ambassador car in India since 1948. As the companys Web site explains, the Ambassadors dependability, spaciousness and comfort factor have made it the most preferred car of generations of Indians. Hindustan is now considering producing the car in China. This will involve an initial investment of RMB 4 billion. The plant can be depreciated straight-line over the five-year period. The plant will start production one year from today. It is expected to last for five years and be depreciated to zero. It is expected that the plant will have a market value of the end of this period of RMB 500 million. The plant will produce 100,000 cars a year. The firm anticipates that in the first year it will be able to sell each car for RMB 65,000, and thereafter the price is expected to increase by 4% a year. Raw materials for each car are forecasted to cost RMB 25,000 in the first year and these costs are predicted to increase by 3% annually. Total labor costs for the plant are expected to be 20% of sales. The land on which the plant is built could be rented for five years if the plant were not built on it and the first years lost rent is RMB 300 million (pretax). The lost rent from the land is paid at the beginning of the year (6 payments total) and is expected to increase by 3% per year. Net working capital is expected to be 10% of the following years sales. For instance, if sales in year 1 are RMB 6.5 billion, then NWC in year 0 is RMB 650 million. Hindustans discount rate for this type of project is 12 and profits will be taxed at 25%. Assume all cash flows occur at the end of each year except where otherwise stated.

1. Complete the excel spreadsheet at the bottom of this assignment. Once completed, print it and turn it in; make sure to highlight your estimates of:
   1. OP CF by year
   2. FCF by year
   3. Discount factor by year
   4. Value at year 0 of each CF
2. Estimate the projects NPV?
3. show your work in excel.