and if you could explain the formulas that would be great

2. The upper left area of the worksheet is a Payment Calculator. Use a function to calculate the monthly payment (D7) using the data provided. 3. In the Payment Calculator, use Goal Seek to keep the payment per month at $3,000 by increasing the down payment. 4. Copy the info from B4:B8 and paste to cells B10:B14. Copy D4:07 and paste to D10:013. Note: Remember to use Paste Special and use Values and Number Formats. 5. Reset the value in B6 back to $75,000. 6. Perform a second Goal Seek in the Payment Calculator again keeping the payment per month at $3,000 this time by lowering the property cost. 7. Copy the info from B4:38 and paste to cells B16:B20. Copy D4:07 and paste to D16:019. See note in step 4. 8. Reset the value in B5 back to $750,000. 9. The upper right area of the worksheet will display the Payment Options. Create a two-variable Data Table to show the monthly payment for each of the interest rates by the number of monthly payments. (Note: all values in each cell will be different. If they aren't, you can erase the table by highlighting cells H6: L20 and deleting them). 10. Format the numbers in your Data Table so the that top row is Accounting Style with O decimal places and the remaining numbers are Comma Style with 0 decimal places. Titan Off-Campus Shops Property Loan Analysis 12 360 4.00% Payment Options Monthly Payments 180 240 120 300 360 3.50% 3.75% 4.00% 4.25% Payment Calculator Property Location Fullerton Payments per year Property Cost $750,000 Total Payments Down Payment $75,000 Interest (APR) Loan Amount $675,000 Payment (per month) Period (Years) 30 Goal #1: Increase Down Payment Property Location Payments per year Property Cost Total Payments Down Payment Interest (APR) Loan Amount Payment (per month) Period (Years) Goal #2: Lower Property Cost Property Location Payments per year Property Cost Total Payments Down Payment Interest (APR) Loan Amount Payment (per month) Period (Years) 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00% 2. The upper left area of the worksheet is a Payment Calculator. Use a function to calculate the monthly payment (D7) using the data provided. 3. In the Payment Calculator, use Goal Seek to keep the payment per month at $3,000 by increasing the down payment. 4. Copy the info from B4:B8 and paste to cells B10:B14. Copy D4:07 and paste to D10:013. Note: Remember to use Paste Special and use Values and Number Formats. 5. Reset the value in B6 back to $75,000. 6. Perform a second Goal Seek in the Payment Calculator again keeping the payment per month at $3,000 this time by lowering the property cost. 7. Copy the info from B4:38 and paste to cells B16:B20. Copy D4:07 and paste to D16:019. See note in step 4. 8. Reset the value in B5 back to $750,000. 9. The upper right area of the worksheet will display the Payment Options. Create a two-variable Data Table to show the monthly payment for each of the interest rates by the number of monthly payments. (Note: all values in each cell will be different. If they aren't, you can erase the table by highlighting cells H6: L20 and deleting them). 10. Format the numbers in your Data Table so the that top row is Accounting Style with O decimal places and the remaining numbers are Comma Style with 0 decimal places. Titan Off-Campus Shops Property Loan Analysis 12 360 4.00% Payment Options Monthly Payments 180 240 120 300 360 3.50% 3.75% 4.00% 4.25% Payment Calculator Property Location Fullerton Payments per year Property Cost $750,000 Total Payments Down Payment $75,000 Interest (APR) Loan Amount $675,000 Payment (per month) Period (Years) 30 Goal #1: Increase Down Payment Property Location Payments per year Property Cost Total Payments Down Payment Interest (APR) Loan Amount Payment (per month) Period (Years) Goal #2: Lower Property Cost Property Location Payments per year Property Cost Total Payments Down Payment Interest (APR) Loan Amount Payment (per month) Period (Years) 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00%