Using excel to solve

"You receive a $23,000 car LEASE at 7.9% nominal annual interest for 3 years. Interest is compounded monthly and you make monthly payments. Your RESIDUAL value at the end of your lease is $5,100. Assume LEASE payments are made at the END of the month, with the first payment due at the end of the 1st month. You can also get a LOAN for the same terms (although you will pay off the entire car in 3 years). Assume your MARR (or your investment interest rate) is 6% nominal annual, compounded monthly as well. Do you prefer the LEASE or the LOAN? Enter the present value of the alternative that you should choose. Don't forget to include that you have a car worth $5,100 if you go with the LOAN alternative." 22,408.67 wers 19,394.69 (with margin: 193.95) "You receive a $23,000 car LEASE at 7.9% nominal annual interest for 3 years. Interest is compounded monthly and you make monthly payments. Your RESIDUAL value at the end of your lease is $5,100. Assume LEASE payments are made at the END of the month, with the first payment due at the end of the 1st month. You can also get a LOAN for the same terms (although you will pay off the entire car in 3 years). Assume your MARR (or your investment interest rate) is 6% nominal annual, compounded monthly as well. Do you prefer the LEASE or the LOAN? Enter the present value of the alternative that you should choose. Don't forget to include that you have a car worth $5,100 if you go with the LOAN alternative." 22,408.67 wers 19,394.69 (with margin: 193.95)