A firm would like to finance an investment by taking out a loan that requires $10$ fixed annual payments,

with the first payment due in one year. The bank will require a return of $6\mathrm{.}5\%$ on this loan. The firm

plans to borrow $$450,000$ using this loan. Use annuity formulas to answer questions $2.$a$,2.$b$,$ and $2.$c$.$

a$.$ What will the firm's annual payments be$?$

b$.$ Check your calculation by computing the present value of those annual payments, using the rate of

return given above. Is it equal to the loan amount?

c$.$ What would the first annual payment be$,$ if the firm wanted the annual payments to grow at a rate of

$4\%$ each year?

d$.$ What would the last payment be$?$

solve this for me with

complete explaintion and tell me how should I make an

spreadsheet in excel because I should give it to my professor as a spreadsheet excel not Ai$.$