Author Question: Your need to repay a loan with a future value of 304,071.00 in 18.5 years. If you can make annual ... (Read 29 times)

lindiwe

  • Hero Member
  • *****
  • Posts: 577
Your need to repay a loan with a future value of 304,071.00 in 18.5 years. If you can make annual year-end deposits of 11,000 into an account, what annual rate of return would you require to earn enough money to pay the loan in full at the due date?
 
  A) 7.92
  B) 8.73
  C) 4.16
  D) 4.39

Question 2

Solving for an unknown interest rate for annuity cash flows is an iterative (or trial-and-error) process.
 
  Indicate whether the statement is true or false.



olivia_paige29

  • Sr. Member
  • ****
  • Posts: 334
Answer to Question 1

Answer: D
Explanation: D) This is an iterative process (trial and error). Solve using the RATE function in Excel.
MODE = END
INPUT 18.5 ? 0 11,000 -304,071
KEY N I/Y PV PMT FV
CPT 4.39

Answer to Question 2

Answer: TRUE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

For a complete list of videos, visit our video library