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

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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Describe the basic structure of the coronavirus, SARS-CoV2. What is the difference between SARS-CoV2 and COVID-19? How...

Medical Sciences
Q

Here are some questions with a bit of the data. if any can be answered from...

Chemistry
Q

Structure of the Chamaeleon eye: describe in detail important anatomical structures (including cells, tissues, and organs) of this sensory...

Medical Sciences
Q

Draw a single line under subjects and a double line under verbs. Cross out prepositional phrases...

General Management
Q

O spending within the income earned O purchase through credit cards payment of minimum amount...

Biology
Q

A bond has a duration of 7.65 and has a YTM of 0.08 when interest...

Basic Math
Q

From the observation deck of a skyscraper, Meena measures a 45 angle of depression to...

Basic Math
Q

K Use the Leading Coefficien f x 4x5 7x 3x 5 Choose the correct answer

Algebra
Q

Salary Vs. Dividend Decisions - Optimum Mix Ms. Barbra Stickle is the only shareholder of...

Accounting
Q

Need to write research paper and literature review on the topic " Raise of minimum...

Accounting
Q

The higher the industry concentration, the higher the industry's globalization potential. True False Neither true...

Accounting
Q

Stocks A ond B have the following probability distributions of expected future retums: a. Caiculate...

Finance