Reference no: EM133068575
Using excel sheet, show all formulas and do not hardcode.
Time value of money.
You need $4,000,000 in order to fund your future retirement. Solve this problem using Excel and time value of money present value AND future value concepts. (Note that this is a very unstructured problem
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?
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?
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 a five-year loan, what is your monthly payment?
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:
- List the four major types of firms in the U.S. (You do not need to add any explanation.)
- How can a firm's acceptance of positive Net Present Value projects increase shareholder wealth?
Please provide solution on excel