Computer Science/Excel

Here's the problem:
John believes that the average American will be in debt forever. He decides to create a table that demonstrates this. He thinks that given 60 months (5 years) to get out of debt and the annual percentage rates 1-5 and 7-15 the percentage of the balance required to be paid monthly would be far beyond the average consumer's ability to repay.
Given the following graph, create an excel formula that when the monthly payment is entered, displays the annual percentage rate.
monthly percentage of balance/apr
1.75-1.79%/1%
1.80-1.84%/2%
1.85-1.89%/3%
1.90-1.94%/4%
1.95-1.99%/5%
2.00-2.04%/7%
2.05-2.09%/8%
2.10-2.14%/9%
2.15-2.19%/10%
2.20-2.24%/11%
2.25-2.29%/12%
2.30-2.34%/13%
2.35-2.39%/14%
2.40%/15%
>2.40%/16%

  1. 👍 0
  2. 👎 0
  3. 👁 175

Respond to this Question

First Name

Your Response

Similar Questions

  1. History

    Compare the results of the French and Indian War among the groups involved. Which groups suffered similar consequences? American colonists and the Iroquois bore the effects of a massive war debt. The Spanish and Native American

  2. Advanced Algebra

    Robert borrowed $750 from his parents to make some repairs on his car. He promised to repay the loan by giving his parents at least $67 from his paycheck each week. Assuming Robert sticks to his promise, which of the following is

  3. FINANCE 200

    An aggressive working capital policy would have which of following characteristics? A. A low ratio of short-term debt to fixed assets. B. A high ratio of short-term debt to long-term sources of funds. C. A short average collection

  4. Plz Help-----History @Ms. Sue or Reed

    Compare the results of the French and Indian War among the groups involved. Which groups suffered similar consequences? American colonists and the Iroquois bore the effects of a massive war debt. The Spanish and Native American

  1. psychology

    what would the dependent and independent variable and control and experimental group be in this problem: John is intrigued by the relationship between frustration and aggression. He proposes to study whether socioeconomic status

  2. Business communications.

    John, an American, is having a meeting in China where he is attempting to obtain a Chinese company as a new customer. Which of the following is most likely to generate a positive response from the Chinese (a high-context culture)?

  3. Finance

    Which type of debt is the least attractive for a consumer? Unsecured debt Secured debt Mortgage debt Lease debt My answer is unsecured debt

  4. finance

    Which of the following statements is CORRECT? (Points: 4) Junk bonds typically provide a lower yield to maturity than investment grade bonds. A debenture is a secured bond that is backed by some or all of the firm's fixed assets.

  1. Science/Math

    John and Al are in a 15 km race. John averages 4.4 m/s during the first half of the race and then runs at a speed of 4.2 m/s until the last 200 m, which he covers at 4.5 m/s. At what average speed must Al run to beat John? The

  2. Fiancne

    Stephenson Real Estate Company was founded 25 years ago by the current CEO, Robert Stephenson. The company purchases real estate, including land and buildings, and rents the property to tenants. The company has shown a profit

  3. Science/Math

    Word Problem page 19 John and Al are in a 15 km race. John averages 4.4 m/s during the first half of the race and then runs at a speed of 4.2 m/s until the last 200 m, which he covers at 4.5 m/s. At what average speed must Al run

  4. US History

    How did the French and Indian War lead to a colonial movement to manufacture American-made products? The British boycotted American exports in response to colonial war protests. The British prosecuted smugglers who had brought in

You can view more similar questions or ask a new question.