Please help! 
a. Create a vertical one-way data table that shows loan amounts in $10,000 increments from $76,000 to $376,000 and their monthly payment amounts, assuming the loan term and annual interest rate are 10 years and 7%, respectively. What is the monthly payment for a loan of $265,000 ? Note: Round your answer to 2 decimal places. b. Expand the spreadsheet model to include calculations for monthly interest payment and monthly principal payment. Create a vertical one-way data table that shows loan amounts in $10,000 increments from $76,000 to $376,000 and their monthly payment, interest payment, and principal payment amounts, assuming the loan term and annual interest rate are 10 years and 7%, respectively. What is the monthly payment, interest payment, and principal payment amounts for a $315,000 loan? Note: Round your answers to 2 decimal places. c. Create a two-way data table that shows loan amounts in $10,000 increments from $76,000 to $376,000 vertically and annual interest rates in 0.5% increments from 3% to 10% horizontally. Fill the table with monthly payment amounts for various loan amount and interest rate combinations. What is the monthly payment amount for a $365,000 loan with a 8% annual interest rate? Note: Round your answer to 2 decimal places. a. Create a vertical one-way data table that shows loan amounts in $10,000 increments from $76,000 to $376,000 and their monthly payment amounts, assuming the loan term and annual interest rate are 10 years and 7%, respectively. What is the monthly payment for a loan of $265,000 ? Note: Round your answer to 2 decimal places. b. Expand the spreadsheet model to include calculations for monthly interest payment and monthly principal payment. Create a vertical one-way data table that shows loan amounts in $10,000 increments from $76,000 to $376,000 and their monthly payment, interest payment, and principal payment amounts, assuming the loan term and annual interest rate are 10 years and 7%, respectively. What is the monthly payment, interest payment, and principal payment amounts for a $315,000 loan? Note: Round your answers to 2 decimal places. c. Create a two-way data table that shows loan amounts in $10,000 increments from $76,000 to $376,000 vertically and annual interest rates in 0.5% increments from 3% to 10% horizontally. Fill the table with monthly payment amounts for various loan amount and interest rate combinations. What is the monthly payment amount for a $365,000 loan with a 8% annual interest rate? Note: Round your answer to 2 decimal places
