Solved

An Investor Wants to Determine How Much Interest He Must

Question 17

Essay

An investor wants to determine how much interest he must earn to be able to make the payments on a 10-year mortgage which has increasing annual payments. The problem is summarized in the accompanying spreadsheet. The investor has enough money to make an initial investment of $12,000 and hopes he can earn 18% on his investments. He would like to know how low his annual return can be and still allow him to make his payments from interest income.
If the Risk Solver Platform (RSP) is used, which are the Objective, Variables and Constraint cells in the spreadsheet for this problem?
An investor wants to determine how much interest he must earn to be able to make the payments on a 10-year mortgage which has increasing annual payments. The problem is summarized in the accompanying spreadsheet. The investor has enough money to make an initial investment of $12,000 and hopes he can earn 18% on his investments. He would like to know how low his annual return can be and still allow him to make his payments from interest income. If the Risk Solver Platform (RSP) is used, which are the Objective, Variables and Constraint cells in the spreadsheet for this problem?

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q13: How much are additional units of

Q14: A company wants to locate a new

Q16: A company wants to locate a new

Q20: A company wants to locate a

Q21: A company makes products A and

Q22: An office supply company is attempting

Q30: A construction company just purchased a 300

Q37: The Sweet Water beverage company is designing

Q41: When using the GRG algorithm to solve

Q87: The main difference between LP and NLP