Im not asking for the answer to any of these specifically but im asking for some guidance on how you would go about building an excel clac that can answer these! thanks!

1) Given the following information on a fixed-rate fully amortizing loan, determine the maximum amount that the lender will be willing to provide to the borrower: loan term: 30 years; monthly payment: $800; interest rate: 6%. A) $6,707 B) $9,295.15 C) $13,333 D) $133,433 2) Given the following information on a 30-year fixed-payment fully amortizing loan, determine the remaining balance that the borrower has at the end of seven years: interest rate: 7%; monthly payment: $1,200. A) $17,143 B) $79,509 C) $164,402 D) $180,369 3) Given the following information on an interest-only mortgage, calculate the monthly mortgage payment: loan amount: $56,000; term: 15 years; interest rate: 7.5%. A) $169.13 B) $350 C) $519.13 D) $4,200 4) Given the following information, calculate the balloon payment for a partially amortized mortgage: loan amount: $84,000; term to maturity: 7 years; amortization term: 30 years; interest rate: 4.5%; monthly payment: $425.62. A) $9,458 B) $30,620 C) $73,103 D) $84,000 5) Suppose a potential home buyer is interested in taking a $500,000 mortgage loan that has a term of 30 years and a fixed mortgage rate of 5.25%. What is the monthly mortgage payment that the homeowner would need to make if this loan is fully amortizing? A) $552.50 B) $2,761.02 C) $17,820.72 D) $33,458.47