Please resolve Problem $7$ Use Excel Spreadsheet. Problem $1.$ Invest $$1500$ into an account earning $4\%$ simple interest. What amount is in the account after $5$ years? Make a separate column showing the interest.

Problem $2.$ Repeat Problem $1$ with compound interest $($compounded annually$).$

Problem $3.$ Gracie deposits $$425$ into an account earning $3\mathrm{.}2\%$ interest compounded quarterly.

Show the quarterly balance for the first two years

Problem $4.$ Make an initial deposit $($any amount you wish$)$ into an account earning $7\%$ APR compounded annually. How long before your initial deposit grows by $50\%?$ Drag as far down so you can see when this happens.

Problem $5.$ Your lovely grandmother leaves you $$20,000$ in her will. Experts tell you if you deposit this money into an account paying $9\%$ interest compounded annually, and leave it there untouched for $45$ years, you will retire nearly a millionaire. Is this true?

Problem $6.$ Suppose you make $$125$ monthly payments into an account earning $5\%$ APR compounded monthlv. What is the balance after $24$ months?

Problem $7,$ Plav around with this one: What monthly deposit would you need to make in order to have $$170\mathrm{.}000$ ready for vour child in $15$ years? Suppose the fund offers an APR of $5\%.$

Note $1$: Make up any monthly deposit at first $($it will be incorrect$)$ but program all of your formulas. Then just change the monthly deposit and see what happens. Note $2$: If you are showing the monthly balance across $15$ years, you'll need $180$ rows in your spreadsheet.

Problem $8.$ You pay $$8,000$ for a municipal bond. When it matures after $20$ years, you receive $$12,500.$ This shows about a $56\mathrm{.}3\%$ total return on investment. First, figure out the annual return and then use Excel$/$Sheets to show that this agrees with the total return $($to within a few cents$).$

Problem $9.$ Show an amortization table for the following loan:

A student loan of $$24,000$ with a fixed APR of $8\%$ for $15$ years.

Your table should show the fixed monthly payment $($$$229\mathrm{.}36)$ as well as how much of it goes to principal and interest each month. After $15$ years $(180$ payments$)$ the balance should be $$0($paid off$).$