Ask Question
BusinessBusiness
18 October, 15:35

Your brother would like to have $27,000 in 3 years for the purchase of a new car. What monthly payment should he make into an account paying 7% per year compounded monthly to attain his goal?

+5
Answers (1)
  1. 18 October, 18:53
    0
    The monthly payment which is required to achieve the goal is $676.18

    Explanation:

    The monthly payment which is required to achieve the goal is computed as:

    Using the excel formula of PMT:

    =PMT (rate, nper, pv, fv, type)

    where

    PMT is payment monthly

    rate is 7%

    but rate is compounded monthly, so

    r = 7% / 12

    nper is number of years which is 3 years

    but the number of years also compounded monthly, so

    nper = 3 * 12

    fv is future value, which is $27,000

    Putting the values above:

    =PMT (7%/12,3 * 12,0,-27000,0)

    = $676.18
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Your brother would like to have $27,000 in 3 years for the purchase of a new car. What monthly payment should he make into an account ...” in 📘 Business if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers
You Might be Interested in
An organization in which the management builds a commitment to learning, works to generate ideas with impact, and works to generalize ideas with impact is creating a (n) question 9 options: focused organization. learning organization.
Answers (1)
Mr. E, a petroleum engineer, earns an $72,500 annual salary, while Mrs. E, a homemaker, has no earned income. Under current law, the couple pays 20 percent in state and federal income tax.
Answers (1)
Jobs that are grouped into the same pay grade should a. be paid at different wage rates because the worth of these jobs to the organization may differ. b.
Answers (1)
Last week, the Card Shop had 600 shoppers enter the store. Of those 600 shoppers, 120 actually made purchases. What would be the conversion rate for the store's sales staff?
Answers (1)
Which is true of overdraft protection (ODP) ? It ensures that your checks will not bounce. It is required by law for most accounts. It is usually available free for most accounts. It requires funds to be available from a linked account.
Answers (1)
New Questions in Business
Assume that we use a perpetual inventory system and that five identical units are purchased separately at the following four dates and costs: April 5 at $10, April 10 at $12, April 15 at $14, and April 20 at $16 April 20 $17.
Answers (1)
In Section 7, the word warranty is best defined as A) a contract between USATestPrep and its Customers. B) a guarantee of any part of the site and its contents. C) a pledge of Customer service if anything goes wrong with the site.
Answers (2)
A (n) is the issuer's written promise to pay an amount equaling the par value. The par value is paid at a specified future date. Most often, the issuer is required to make semiannual interest payments.
Answers (1)
The primary goal of the Consumer Financial Protection Bureau is: A To monitor your credit report and ensure your identity and other sensitive data has not been compromised. B To protect against abusive or deceptive debt collection purposes.
Answers (1)
Jake Skinner purchases a big screen TV on credit and will repay the loan with one payment at the end of 90 days. What type of credit did Jake use?
Answers (1)
Home » Business » Your brother would like to have $27,000 in 3 years for the purchase of a new car. What monthly payment should he make into an account paying 7% per year compounded monthly to attain his goal?
Sign Up Forgot Password?