Complete the one-variable data table using Amount of Loan as the column input cell, and then ensure the results for…

 

Complete the one-variable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format with zero decimal places.