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

Basic Math
1.2K views

1. Discuss the difference in linear and non-linear data 2. explain a quadratic function. Write the...

Biology
1.2K views

A germ cell divides to give rise to two daughter cells. Each of the two daughter...

Physics
1.2K views

Calculate the reactive force and reactive muscle moment at Justin Verlander’s knee for a seated leg...

Advance Math
1.2K views

Micron Inc. can invest $5,000,000 in a new technology. Micron’s CFO is concerned about uncertainty of...

Advance Math
1.2K views

Given a natural number q ? 1, define a relation ? on the set Z by...

General Management
1.2K views

Set up an organization which is intended to sell a service or a product. Prepare a...

Calculus
1.2K views

Use the table to find f 1 X 2 1 0 1 3 5 9...

Algebra
1.2K views

4 In a clinical study of divalproex sodium DEPAKOTE in patients prone to migraine headaches...

Accounting
1.2K views

XYZ Corporation prepares its statement of cash flows using the indirect method to...

Accounting
1.2K views

What would you consider most important in analyzing the data (product or customer) and why?...

Accounting
1.2K views

Data table \table[[,,lctC,Product D],[Direct materials cost per unit,$,900$,1,500],[Direct labor cost per unit,,200,100],[Indirect manufacturing cost...

Finance
1.2K views

question 32) You will use the following information to answer 3 different questions (I will...