In cells B8:H16, create a Data Table using the information in cells B2:B4 where the row input cell is the Period and the column input cell is the Rate. Apply the format in B8 to the results in the data table, and then AutoFit columns C:H. Format the payment option closest to and less than $8,000 per month with the Note cell style. Change the Orientation to Landscape.

**PLEASE INCLUDE ALL FORMULAS**

I'm looking for a different answer from the existing post.

H 360 A B D E G 1 Loan Options for Idaho Store Purchase: Rates versus Months 2 Amount of Loan $950,000 3 Period (months) 120 4 Interest rate (per year) 5.75% 5 6 Payment Options 7 Number of Monthly Payments 8 $54,691.72 60 120 180 240 300 9 8.50% 10 8.00% 11 7.50% 12 7.00% Rates 13 6.50% 14 6.00% 15 5.50% 16 5.00% 17 18