Using excel sheet, show all formulas and do not hardcode.: Time value of money.

1. You need $4,000,000 in order to fund your future retirement. Solve this problem usingExcel and time value of money present value AND future value concepts. (Note that this is a very unstructured problem
2. You want to buy a house in 15 years that costs $300,000 now. Inflation is 3%. How much do you need to save each year to be able to buy the house if you can earn 6% (compounded annually) on your savings?
3. The Ravens have 61,000 spectators per game and anticipate annual growth in attendance of 5%. If their stadium holds 71,000 people, how long will it take to fill up the stadium?
4. Suppose you want to borrow $20,000 for a new car. You can borrow at 8% per year, compounded monthly (8/12 = .66667% per month). If you take afive-year loan, what is your monthly payment?
5. On the Excel worksheet, answer the following two questions. For question a, just list the four types of firms; for question b, one to three sentences is sufficient: (a) List the four major types of firms in the U.S. (You do not need to add any explanation.) (b)How can a firm's acceptance of positive Net Present Value projects increase shareholder wealth?

Please provide solution on excel