Solved step by step with explanation of mention question for excel

Question

I need formuals for the problems.

Enter "Down PMT" in cell P1. Then create a formula in cell P2 that calculates the down payment as the sold price times the down payment rate. In the formula, you should use the named reference for down payment rate. Copy/Paste or fill this formula to the remaining cells in column P for the details of property listings.

Answer

Solved step by step with explanation of mention question for excel

Here are the instructions:

e. In cell F2, enter the formula "=MID(E2,1,FIND(",",E2)-1)" to extract the city from the text in cell E2.

f. In cell G2, enter the formula "=MID(E2,FIND(",",E2)+2,2)" to extract the state abbreviation from the text in cell E2.

k. In cell Q1, enter the label "Days on MKT". In cell Q2, enter the formula "=C2-B2" to calculate the number of days the property was on the market. Copy the formula down to fill the remaining cells in column Q.

l. In cell R1, enter the label "Monthly Payment". In cell R2, enter the formula "=PMT(InterestRate/12,TermInYears*12,-(E2-DownPayment))" to calculate the monthly mortgage payment. Format the result as a currency with two decimal places. Copy the formula down to fill the remaining cells in column R.

q. Save your work.

r. Format the workbook professionally, using appropriate number formats and applying styles or formatting as desired.