32) Ironwood Bank is offering a 25​-year mortgage with an APR of 6.25% based on monthly compounding. If you plan to borrow $169,000​, what will be your monthly​ payment? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.) The loan payment is ​$______ ​(Round to the nearest​ cent.)

Please eolve this question on excell and show formulas please.

(Related to Checkpoint 6.3) (Determining the outstanding balance of a loan) Five years ago you took out a $250,000, 25-year mortgage with an annual interest rate of 11 percent and monthly payments of $2,450.28. What is the outstanding balance on your current loan if you just make the 60th payment? CTT If you just make the 60th payment, the outstanding balance on your current loan is $ (Round to the nearest cent.)

Use chart.

If a lender makes a simple loan of $500 for 5 years and charges 3%, then the amount that the lender receive at maturity is $ (Round your response to the nearest two decimal place) If a lender makes a simple loan of $2000 for one year and charges $90 interest, then the simple interest rate on that loan is %. (Round your response to the nearest whole number) If a borrower must repay $106.50 one year from today in order to receive a simple loan of $100 today, the simple interest on this loan is OA. 6.0% OB. 6.5% OC. 65% OD. 5.0%

A mortgage broker is offering a $279,000 30-year mortgage with a teaser rate. In the first two years of the mortgage, the borrower makes monthly payments on only a 4.5 percent APR interest rate. After the second year, the mortgage interest rate charged increases to 7.5 percent APR. What are the monthly payments in the first two years? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Monthly payment What are the monthly payments after the second year? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Monthly payment > 2 D TRENE VAR TVUNG S 2006- E - E

You plan to borrow $33,600 at a 6.5% annual interest rate. The terms require you to amortize the loan with 7 equal end-of-year payments. How much interest would you be paying in Year 2? O a. $6,126.33 O b. $5,752.43 O c. $2,184.00 O d. $1,927.75 O e. $1,952.05

Ironwood Bank is offering a 30-year mortgage with an APR of 6.10% based on monthly compounding. If you plan to borrow $161,000, what will be your monthly payment? (Note. Be careful not to round any intermediate steps less than six decimal places.) The loan payment is § (Round to the nearest cent.)

A mortgage broker is offering a $279,000 30-year mortgage with a teaser rate. In the first two years of the mortgage, the borrower makes monthly payments on only a 4.5 percent APR interest rate. After the second year, the mortgage interest rate charged increases to 7.5 percent APR. What are the monthly payments in the first two years? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Monthly payment What are the monthly payments after the second year? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Monthly payment