MATH PROBLEM CHOOSE $10($TEN$)$ ONLY! $5$ points each. SHOW ALL WORK!

Latisha invested $$1,000$ in $xYZ$ stock. Two years later she sold the stock for $$1,400.$ During the time she owned the stock, she received a total of $$100$ in dividends. What was her total percent return on this investment?

You purchase shares of $xYZ$ company at the beginning of the year for $$22$ per share. After receiving dividends of $$2$ per share, you sell the stock for $$26$ per share at the end of the year. What is your percent rate of return of the stock for the year?

Suppose that you are beginning an investment plan. You have decided that you want to retire in $30$ years with $$1,000,000$ in your bank account at that time. How much would you need to invest at the end each of the next $30$ years if you could earn $6\%?($Show the excel function and variables needed to do this calculation.$)$

Lexi earns a nominal rate of return of $12\mathrm{.}2\%$ this year on her investment. If inflation is calculated at $2\mathrm{.}3\%$ for the year, what is her approximate real rate of return for the year?

You believe that the stock of MoabBikes will soon fall from its current price of $$25$ per share. You short $1,000$ shares with your broker who has a $50\%$ margin requirement. The price falls to $$15$ per share, but not before it pays a $$5$ dividend per share. Your commissions and other charges totaled $$70.$ What was your total profit?