I NEED A MANUAL STEP BY STEP SOLUTION!!!!!!!!!!! SO THAT I COULD BE ABLE TO FOLLOW THE STEPS ONE BY ONE AND SOLVE ON MY OWN.

A. Merlin Mermer is a car salesman earning commission at a rate of 23%. He closed a deal for a car whose balance of P650,000 will paid monthly in 3 years at an interest rate of 6%. Compute the total commission Merlin Mermer will earn once total payment is completed. B. Annie Mae Karton works as a sales agent for a certain company. She was able to sell a product worth P42,000 at an interest of 4% to be paid in 4 equal monthly payments. For the 1st term, she will earn 5.5% in commission which will decrease by 0.5% next term and for each of the succeeding outstanding balances. Compute Annie Mae' commission for each of the term and in total. B 650000 3 6% A 1 Balance 2 Time in year 3 Rate 4 Yearly payment 5 Total payment 6 Commission rate 7 Commission 8 9 Selling price 10 Interest rate 11 Monthly rate 12 Total monthly payments 13 Monthly payment 14 Total commission $243,171.38 $729,514.13 23% $167,788.25 A. 42000 4% 0.003333333 4 $10,587.65 $2,011.65 B. A B 1 Balance 650000 2 Time in year 3 3 Rate 0.06 4 Yearly payment =PMT(B3,B2,-B1,0,0) 5 Total payment =B4*B2 6 Commission rate 0.23 7 Commission =B6%B5 8 9 Selling price 42000 10 Interest rate 0.04 11 Monthly rate =B10/12 12 Total monthly payments 4 13 Monthly payment =PMT(B11, B12,-B9,0,0) 14 Total commission =B13*5.5%+B13*5%+B13*4.5%+B13*4% B. A