Hi, could you please write the formulas with answers near the questions (16-29) and explain what should I do. thank you so much.

hi could tou

Hi, could you please write the formulas with answers near the questions(16-29) and explain what should I do? Thanks a lot. A B C D E F G H I J Down Payment Amount to Commissi be Financed on Bonus 1 Customer 2 Sterfield 3 Sceria 4 Subensklee 5 Sritzen 6 Sango 7 Satt 8 Sro 9 Sweitzer 10 Ster Seller Agent Allan John Allan John Allan John Allan John Allan Selling Price $ 250.000 $ 328.950 $ 198.000 $ 178.350 $ 333.000 $ 768.650 $ 358.000 $ 458.000 $ 168.900 Loan Term Interest Rate 30 15 15 30 30 20 15 20 30 Sell Quantity Loan Term (Years) 15 20 30 Interest % Required Rate Down Pmt 4,50% 15% 5,00% 20% 5,25% Sellers Total Comm. Commission Deserved John Allan 25% 16 1- It should be one formula that you can then drag down that will use the correct % to column E 17 2-Then, using the chart at the bottom left fill out column "F" 18 3-Calculate the amount to be financed (Selling price - down payment) in column G 19 4-Fill out the commission to be paid out to each agent. It should be calculated as follows. 20 They get paid only on the amount to be financed. They actually get paid: 21 2.5% if that amount is over or equal to $200,000 22 1.5% if it is lower than $200,000 23 5-Using one of the formulas, calculate the total commission for each seller in cells F13-F14 24 6-Using another one of the formulas, count how many sells each agent made in cells G13-14 25 7-The branch has an extra bonus where the bank manager will receive $10,000 26 for any loan that is over $250,000 27 with a loan term (amount to be financed) of 20 years or more 28 AND an interest rate of 5% or more. 29 Please enter a formula in 14 that you can drag that will give you the bonus amount for each loan. 30