3. In the Budget worksheet, in the range B3:B8, enter the parameters for a $285,000 mortgage at 4.3% annual interest paid back over 25 years. Calculate the interest rate per month and the total number of payments.

ortage nnual Interest Rate nterest Rate per Month ears Total Payments onthly Payment ncome & Expenses Feb Mar May Jul Jan 4.750 1,500 Apr 4,750 1,400 Aug 4,750 2,400 Sep 4.750 1,500 4.750 2,200 Oct 4.750 1,300 Nov 4.750 1,300 Dec 4.750 Income 1,200 1,500 1,100 2,300 1.500 Edmund Lydia Total Income Food Utilities Phone Insurance Car Travel Mortgage Misc Total Expenses Net Income -480 -1351 -85 -410 -325 -105 -430 - 1151 -85 -410 325 -55 -575 1451 -105 -410 325 -135 -615 125 -1251 -475 325 -275 -5451 130 -110 -475 -325 -1,100 -6751 135 -120 -525 325 -225 -725 - 155 -1151 -525 325 -235 -815 - 160 - 135 -525 -325|| -1,750| -575 -125 -85 -525 325 -75 -6051 -135 -85 -575 325 -125 -625| -105 -125 -575 325 -715 -715 -125 -135 -575 325 -725 Expenses -400 -350 -300 -375 -5.750 -275 -180 2,420 -210 -375 -415 -895 NET