Need help with the attached Financial management questions. Prefer answers to be done using excel and showing the formulas. Also see the instructions provided in the attachment. Thanks in advance.

Problems: CIRCLE YOUR FINAL ANSWER Use Excel or the present value tables. Show your work if you're using the tables. If you're using Excel, write down the function or formula you use including the variables you supplied to the function. For instance \"=PV(0.03,10,0,-10000)\" 1) If the Nominal interest rate is 6.2%, and the Real rate of interest is 5.1%, what must the inflation rate be. 2) A bank offers an account that pays an APR of 4.3% with weekly compounding. a) What is the effective annual rate of the account? b) What would the effective annual rate of the account be if it paid continuous compounding? 3) An amortizing loan has an initial principal balance of $125,000. It has a term of 15 years with monthly payments and an APR of 4%. What is the amount of the monthly payment? 4) You deposit $5,000 into an account for 5 years with quarterly compounding. At the end of 5 years, the account balance is $6,800. You made no additional deposits. What (APR) interest rate must you have earned? 5) You deposited $500 each month into your new IRA account at the beginning of each month. There was no previous balance. You were fortunate to have earned 5.2% (APR) the entire time, and your account balance grew to $247,014! For how many years did you make the payments? 6) You can afford a monthly payment for a new car of $725. The bank will offer you a loan for 5 years, with monthly payments, at an APR of 4.8%. Given these facts, what is the maximum amount you can afford to pay for a new car