Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. which of the following sets of excel entries will

Which of the following sets of Excel entries will correctly solve this problem: Jim paid $167,000...

60.2K

Verified Solution

Question

Finance

Which of the following sets of Excel entries will correctlysolve this problem: Jim paid $167,000 for an old house to renovate.He spent an average of $1,998 per quarter over the next two yearsas he readied the renovated house for sale. He wants to set theprice of the house high enough so that he will earn an annual rateof return of 10% for his investment. Given that information, whatprice should Jim set on the house?

A. NPER=8 RATE=2.5000% PV=(167,000) PMT=1998 solve for FV

B. NPER=8 RATE=2.5000% PV=($167,000) PMT=($1,998) solve forFV

C. NPER=2 RATE=10.0000% PV=($167,000) PMT=($7,992) solve forFV

D.  NPER=24 RATE=0.8333% PV=($167,000) PMT=($1,998)solve for FV

Answer & Explanation Solved by verified expert
4.5 Ratings (660 Votes)
SEE THE    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Use the Internet to research an annual report of a retail company. Then, imagine you are...

Accounting
Q

Find the arc length of the curve on the given interval. x= lnt , y =...

Basic Math
Q

Question 1 a. Discuss the factors that are likely to influence the desired level of cash of...

Accounting
Q

Four charges are placed on corners of a square as shown in figure having side...

Physics
Q

2 Find the lengths of both circular arcs of the unit circle connecting the point...

Basic Math
Q

The number of songs enjoyed from Aesop Rock for all Learn4Life students is normally distributed...

Basic Math
Q

41 cos 3 To 2

Calculus
Q

A very special base e Euler s number P 22

Algebra
Q

5 Jed is working on a stained glass project and needs to form a triangle...

Algebra
Q

Required information [The following information applies to the...

Accounting
Q

Describe one of the corporate accounting scandals (except Enron) that rocked the U.S financial community...

Accounting
Q

Consider the following average annual returns: Investment Small Stocks S&P 500 Corporate Bonds Treasure Bonds...

Finance