Suppose you have a loan for $$400,000,30$ year fixed, fully amortizing loan, monthly payments. Rate $6\mathrm{.}5\%.$ Calculate your loan payment.

#$1$ How much will you owe using PV Method and FV Method assuming you move after $8$ years.

#$2$ Suppose you make $$3500$ payments, how much will you owe after $8$ years?

#$3$ How long will it take to payoff the loan $($in total$)$ if you make $$3500$ payments from first loan payment?

#$4$ Suppose an investment pays $10\%$ compounded WEEKLY, What is the effective Annual Yield?

I need help on how to do these on excel....