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. 👍
  2. 👎
  3. 👁
  4. ℹ️
  5. 🚩

Respond to this Question

First Name

Your Response

Similar Questions

  1. 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)?

  2. ELA

    Why does Skurzynski open “Nethergrave” by describing how Jeremy accidentally scores a goal for the opposing soccer team? to show that Jeremy is not very bright to show why the coach should not have put Jeremy in the game to

  3. Business

    What bankruptcy provision has the bank chosen? Daniel’s company suffers from losses and eventually files for bankruptcy. Since Daniel’s company deals in artifacts, the bank decides to opt for the provision for bankruptcy.

  4. 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

  1. 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

  2. ap stats

    Violence in School, I An SRS of 400 American adults is asked “What do you think is the most serious problem facing our schools?” Suppose that in fact 40% of all adults would answer “violence” if asked this question. The

  3. algebra 2

    a survey of 20 colleges found that seniors graduated with an average $12000 in debt from student loans. The debt was normally distributed with a standard deviation of $3200. Find the probability that a senior graduated owing more

  4. Social Studies

    ”We took away their best lands; broke treaties, promises; tossed them the most nearly worthless scraps of a continent that had once been wholly theirs. But we did not liquidate their spirit. The vital spark which kept them

  1. Corporate Finance

    Avicorp has a $14.3 million debt issue outstanding with a 6.1% coupon rate. The debt has semi-annual coupons. The next coupon is due in six months and the debt matures in five years it is currently priced at 95% of par value a)

  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. 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

  4. Corporate Finance

    Avicorp has a $14.3 million debt issue outstanding with a 6.1% coupon rate. The debt has semi-annual coupons. The next coupon is due in six months and the debt matures in five years it is currently priced at 95% of par value a)

View more similar questions or ask a new question.