I need help trying to figure out how to input these numbers in an excel sheet to use the payment formula for Part 2 and Part 3.

125% our mucc Table Chart Text Collaborate Favorites AirDrop All My Files Cloud Drive 4 Applications Desktop Downloads You are in the market to buy a new car. You have shopped around and plan to purchase a car that costs $12,000. You have the money up front to make a down payment of $1500. You will be taking out a loan to pay the remaining balance. The car dealership and your bank have each presented you with loan options. Put this information in Excel, making sure to use the PMT formula to calculate the payment. Then, decide which option that you will choose for your loan. Explain why you chose this option. Option A from the Car Dealership: 5% APR for 3 years Option B from the Bank: 4% APR for 4 years Part II Final Excel ICloud Carboh ude Devices Remote Disc Tags Red Orange Yellow Nothing selected. Select an object or text to format. practic thinkind You and your friend are both graduating college with $8000 in credit card debt. Once employed, you each decide to stop charging on your card and start paying off the debt. However, you decide to take different approaches to achieve this goal. Your approach: You decide you want to have the debt paid off in 6 years. Your card has an APR of 22%. Use Excel to calculate the monthly payment you would need to make each month in order to have the balance paid off in 6 years. Find the total amount that you would pay back and how much you paid in interest. Your friend's approach: Your friend decides to pay the minimum monthly payment required by her credit card. Her credit card requires a minimum monthly payment of 5% of the balance and has an APR of 20%. Find the balance remaining on her card after 6 years. Part III You take out a loan for $75,000 for the purchase of land. The loan has an APR of 8%. You plan to make monthly payments on the loan for 5 years. Calculate the monthly payment for the loan. Calculate the total amount you will pay for the land. Fill in the amortization table up to 30 payments. How much equity do you have in the land after 30 payments? @ Help