do it in excel

You have docided to refinance your mortgnge. You plan to borow whatever is outstanding on your current mottgage. The current monthly payment is $2,356 and you have made cvery payment on time. The onginal term of the mortgage was 30 years, and the mortgage is exactly four years and eight months old. You have just made your monthly pryment. The mortgage iftereat rate is 6.375% (APR). How moch do you owe on the mortgage today? Complete the sthpt bolow using cell refarencer to given data or prevous calculations, fn some cuses, a rimple cell reference is all you need. To copylpaste a formula across a row H5 down a columin, an absolute cell refercice or a miknd cell reference may be prefernal. If a specifle Exoel function is lo be used, the direetions will specify the tuse of that fienction. Do not type in numerical data into a cell or function. Inrtad, make a reforence fo the cell in which the data is found. Mabe jour compurations amly in the blue cells highlighied below, In all cases, wnless othervise directed, we the eariert appearance of she data in jour formalar, urwally the Grven Data section. Requirements 1 In cell D12, by using cell refcrences, calcalate the discount rate (1pt). 2 In cell D13, by using cell refercnces, calculate the number of periods ramaining on the loan (1 pt.). 3 In cell D14, by using cell reficnoes, celculate the amount that you owe on the martgage (t pt)