percentage For our mortgage example, suppose you lortgage example, suppose you know the annual interest rate will be 5.5 percent. le a table that shows for amounts borrowed from $300,000 through $600,000 (in $50,000 increments) the difference in payments between a 15-vear. 20-year, and 30-year mortgage. 5. Currently, you sell 40,000 units of a need on AutoSave B-D a be Mortgagedt - Excel O Search Page Layout Formulas Data Review View Help 10 A File Home Insert Draw 1 X cut Arial LB Copy Paste Format Painter BIU Clipboard A A === ESE Wrap Text E Merge & Center $ Font Alignment DS fr {=TABLE(D4,D2)} HT $400,000.00 180 2 Amt Borrowed 3 Number of Months 4 Annual int rate 5 Monthly Payment 6% $3,375.43 E-PMT(Annual_int_rate/12, Number_of_Months Amt_Borrowed) Annual Interest Rate 5.0% 5.5% 6.0% 6.5% 7.0% 17.5% 8.0% $2,32.38 $2,451.25 $2,531.57 $2,613.32 $2,696.48 $2,781.04 $2,866.96 $2,767.78 $2,859.79 $2,953.50 $3,048.88 $3,145.90 $3,244.54 $3,344.78 $3,163.17 $3,268.33 $3,375.43 $3,484.43 $3,595.31 $3,708.05 $3,822.61 $3,558.57 $3,676.88 $3,797.36 $3,919.98 $4,044.73 $4,171.56 $4,300.43 $3,953.97 $4,085.42 $4,219.28 $4,355.54 $4,494.14 $4,635.06 $4,778.26 $4,349.36 $4,493.96 $4,641.21 $4,791.09 $4,943.56 $5,098.57 $5,256.09 $4,744.76 $4,902.50 $5,063.14 $5,226.64 $5,392.97 $5,562.07 $5,733.91 $5,140.16 $5,311.04 $5,485.07 $5,662.20 $5,842.38 $6,025.58 $6,211.74 $3,375.43 300,000.00 350,000.00 400,000.00 450,000.00 500,000.00 550,000.00 600,000.00 650,000.00 A A A