this is a report I am adding Table 9-4 that was requested

what additional clarification is needed?

Use Table 9-4 to calculate the monthly mortgage payment for the mortgage loan that Alex would need. Round Estimating Mortgage Loan Payments for Principal and Interest in your intermediate calculations to four decimal places. Round your answer to the nearest cent S b. How much interest would Alex pay during the first year of the loan? Round your answer to the nearest cent S c. Use the Run the Numbers worksheet, Should You Buy or Rent?" to determine whether Alex would be better off buying or renting. On the basis of net cost, Alex would be better off (Buying or renting) she Math 9.4 inancing a Mortgage payment (including taxes and insurance) could they afford? Round your answer to the illiy littgage nearest dollar 15090 S Do the Math 9-3 Rent Versus Buy Alex Guadet of Nashville, Tennessee, has been renting a two-bedroom house for several years. He pays $900 per month in rent for the home and $300 per year in property and liability insurance. The owner of the house wants to sell it, and Alex is considering making an offer. The owner wants $150,000 for the property, but Alex thinks he could get the house for $140,000 and use his $30,000 in 3 percent certificates of deposit that are ready to mature for the down payment. Alex has talked to his banker and could get a 5.5 percent mortgage loan for 25 years to finance the remainder of the purchase price. The banker advised Alex that he would reduce his debt principal by $1,600 during the first year of the loan. Property taxes on the house are $1,400 per year. Alex estimates that he would need to upgrade his property and liability insurance to $1,200 per year and would incur about $3,000 in costs the first year for maintenance and improvements. Property values are increasing at about 3 percent per year in the neighborhood. Alex will have to pay $50 a month for private mortgage insurance. He is in the 25 percent marginal tax bracket. CHAPTER 9 Obtaining Table 9.4 Estimating Mortgage Loan Payments for Principal and Interest (Monthly Payment per $1,000 Borrowed) un Interest Rate (%) Payment Period (Years) 15 20 25 30 3.0 $6.9058 $5.5460 $4.7421 $4.2160 3.5 7.1488 5.7996 5.0062 4.4904 4.0 7.3969 6.0598 5.2783 4.7742 4.5 7.6499 6.3265 5.5583 5.0669 5.0 7.9079 6.5996 5.8459 5.3682 5.5 8.1708 6.8789 6.1409 5.6779 6.0 8.4386 7.1643 6.4430 5.9955 6.5 8.7111 7.4557 6.7521 6.3207 7.0 8.9883 7.7530 7.0678 6.6530 7.5 9.2701 8.0559 7.3899 6.9921 8.0 9.5565 8.3644 7.7182 7.3376 Note: To use this table to figure a monthly mortgage payment divide the amount borrowed by 1,000 and multinly by the appropriate figure in the table for the intersecate and time period of the loanBoreamole a 160 000 kan for 30 years at 6.0 percent would require a payment of $959.280 ($160,000+ 1.0001 5.99551, over 20 years, it would requirea payment of 51 146.29 $160,000 + 1,000*71643) For cakulations for different interest rates, visit the Gamantage qualify for an interest rate that is perhaps 0.5 percentage points lower. In that companion website Use Table 9-4 to calculate the monthly mortgage payment for the mortgage loan that Alex would need. Round Estimating Mortgage Loan Payments for Principal and Interest in your intermediate calculations to four decimal places. Round your answer to the nearest cent S b. How much interest would Alex pay during the first year of the loan? Round your answer to the nearest cent S c. Use the Run the Numbers worksheet, Should You Buy or Rent?" to determine whether Alex would be better off buying or renting. On the basis of net cost, Alex would be better off (Buying or renting) she Math 9.4 inancing a Mortgage payment (including taxes and insurance) could they afford? Round your answer to the illiy littgage nearest dollar 15090 S Do the Math 9-3 Rent Versus Buy Alex Guadet of Nashville, Tennessee, has been renting a two-bedroom house for several years. He pays $900 per month in rent for the home and $300 per year in property and liability insurance. The owner of the house wants to sell it, and Alex is considering making an offer. The owner wants $150,000 for the property, but Alex thinks he could get the house for $140,000 and use his $30,000 in 3 percent certificates of deposit that are ready to mature for the down payment. Alex has talked to his banker and could get a 5.5 percent mortgage loan for 25 years to finance the remainder of the purchase price. The banker advised Alex that he would reduce his debt principal by $1,600 during the first year of the loan. Property taxes on the house are $1,400 per year. Alex estimates that he would need to upgrade his property and liability insurance to $1,200 per year and would incur about $3,000 in costs the first year for maintenance and improvements. Property values are increasing at about 3 percent per year in the neighborhood. Alex will have to pay $50 a month for private mortgage insurance. He is in the 25 percent marginal tax bracket. CHAPTER 9 Obtaining Table 9.4 Estimating Mortgage Loan Payments for Principal and Interest (Monthly Payment per $1,000 Borrowed) un Interest Rate (%) Payment Period (Years) 15 20 25 30 3.0 $6.9058 $5.5460 $4.7421 $4.2160 3.5 7.1488 5.7996 5.0062 4.4904 4.0 7.3969 6.0598 5.2783 4.7742 4.5 7.6499 6.3265 5.5583 5.0669 5.0 7.9079 6.5996 5.8459 5.3682 5.5 8.1708 6.8789 6.1409 5.6779 6.0 8.4386 7.1643 6.4430 5.9955 6.5 8.7111 7.4557 6.7521 6.3207 7.0 8.9883 7.7530 7.0678 6.6530 7.5 9.2701 8.0559 7.3899 6.9921 8.0 9.5565 8.3644 7.7182 7.3376 Note: To use this table to figure a monthly mortgage payment divide the amount borrowed by 1,000 and multinly by the appropriate figure in the table for the intersecate and time period of the loanBoreamole a 160 000 kan for 30 years at 6.0 percent would require a payment of $959.280 ($160,000+ 1.0001 5.99551, over 20 years, it would requirea payment of 51 146.29 $160,000 + 1,000*71643) For cakulations for different interest rates, visit the Gamantage qualify for an interest rate that is perhaps 0.5 percentage points lower. In that companion website