Question: how to do this on excel. i keep getting $7500 10. Mr. Spend has accumulated credit card loans of $15,000 and is finding it difficult

how to do this on excel. i keep getting $7500

10. Mr. Spend has accumulated credit card loans of $15,000 and is finding it difficult to make payments. His local bank has offered him a consolidation loan to payoff all the credit card loans. The loan calls for monthly payments for 10 years and has a nominal interest rate of 5.99% (APR). What will Mr. Spend's monthly payments be if he takes the loan? Credit Card Loan Monthly Payment Amount Visa 1 $3,000 $90 Visa 2 $5,000 $120 Visa 3 $6,000 $150 Master Card 1 $1,000 $20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

how to do this on excel? the orignial person did not really explain it for excel. how to do this on excel. i keep getting $7500 10. Mr. Spend has accumulated credit card loans of $15,000 and is...

Really need help on theses problems. This is a study guide that will help me tremendously. It would be appreciated if each question is solved out and explained. Please Help!!!! Business Finance (Fin...

Need help on these questions with steps shown. Business Finance (Fin 3200) Assignment 3: 30 Points; Due on June 1st. Solar-light Inc. is considering a project with the following cash flows: 1. YEAR 1...

Really need help with questions 4-15. It would be really appreciated if you could walk through the steps of each problem, so I can look back at it and understand/study. 4. Given the following data,...

Please answer the following questions 6. Big Bank Corp. wants to earn an effective interest rate of 9% (EAR) on its consumer loans. It uses monthly compounding on consumer loans. What should be the...

*Show work please 10. Mr. Spend has accumulated credit card loans of $15,000 and is finding it difficult to make payments. His local bank has offered him a consolidation loan to payoff all the credit...

***PLEASE ANSWER ALL QUESTIONS*** Calculate the future value of $1,000 in 10 years assuming an interest rate of 12% (APR) compounded quarterly. Also calculate the effective annual rate (EAR) on the...

10. Mr. Spend has cumulated credit card loans of $15,000 and is finding it difficult to make payments. His local bank has offered him a consolidation loan to payoff all the credit card one. The loan...

Could you answrs question 13 and 15? Mr. Spend has accumulated credit card loans of $15,000 and is finding it difficult to make payments. His local bank has offered him a consolidation loan to payoff...

1. What precautions are taken at the harvesting step of food production to prevent food-borne diseases? 2. What professes do liquid foods go through to remove or destroy microbes? 3. How fan the...

Suppose that a cattle feeder placed 200 head of feeder cattle in April 2020 and planned to sell the fed cattle in August. Expected fed cattle weight is 1200 lbs. per animal. On 25 Apr 2020, the cash...

The Pet Clinic Management System ( PCMS ) is a software solution designed to efficiently manage customer information, pet records, staff details, and visit records within a pet clinic setting....

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

If you were reading another persons profile as a prospective partner, how carefully would you critique it?

Consider someone with whom you share a very close relationship. In what ways are you similar to this person? Are those similarities what attracted you in the first place?

A The Quran forbids the consumption of alcohol. Does the absence affect communication between non-Muslim drinkers and Muslim nondrinkers?