Which of the following sets of Excel entries will correctly solve this problem: Jim paid $138,000 for an old house to renovate. He spent an average of $3,216 per quarter over the next two years as he readied the renovated house for sale. He wants to set the price of the house high enough so that he will earn an annual rate of return of 12% for his investment. Given that information, what price should Jim set on the house?

Question

Which of the following sets of Excel entries will correctly solve this problem: Jim paid $138,000 for an old house to renovate. He spent an average of $3,216 per quarter over the next two years as he readied the renovated house for sale. He wants to set the price of the house high enough so that he will earn an annual rate of return of 12% for his investment. Given that information, what price should Jim set on the house?

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Future value and Present value

Related Finance Q&A

Find answers to questions asked by students like you.

Q: A good current and quick ratio are a guarantee of excellent working capital management strategies. I...

A: Working capital management involves the management and control of the gross current assets. The curr...

Q: Please answer using the methods or patterns of comparison. Thank You!

A: Computation:

Q: A couple who borrow $70,000 for 15 years at 8.4%, compounded monthly, must make monthly payments of ...

A: formula for remaining balance: remaining balance=princial×1+rmn-pmt×1+rmn-1rm where, r = rate of int...

Q: The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Curr...

A: Let the no. of. TV ads be X Let the no. of radio ads be Y  and the no. of online ads be Z Total audi...

Q: Q No. 3 Ladders, Inc. has a net profit margin of 5% on sales of $50 million. It has book value of eq...

A: Given: Net profit margin = 5% Sales = $50 million Book value of equity = $40 million Total liabiliti...

Q: ABC Inc., isexpected to pay an annual dividend of $5.1 per share next year. The requiredreturn is 19...

A: Present value of the cash flows from the stock at the required return is value of the stock. Here, t...

Q: Henry takes out a $650 discounted loan with a simple interest rate of 12% for a period of 7 months. ...

A: The effective return is the real rate of return on any loan, savings. It can be found out by using e...

Q: A $1,000 bond, redeemable at par, with annual coupons at i(1)=10%/a is purchases for $1,134.20. If t...

A: Bond value = 1000 Coupon = 10%

Q: Olympic Sports has two issues of debt outstanding. One is a 4% coupon bond with a face value of $34 ...

A: Let par value of bond =100 Coupon =4%=4 YEILD to MATURITY =5% Years to MATURITY =15 Present value FA...

Q: Read carefully the following scenarios and answer the questions asked in each scenario after analysi...

A: If you wanted to buy Yahoo! (to buy the ​stock), the price you would pay per share is ​$ ask price.I...

Q: FFC is trying to establish its optimal capital structure. Its current capital structure consists of ...

A: The CAPM is a model that helps to compute the return on equity with the help of beta and risk-free r...

Q: Warning: Rounding in the calculation of monthly interest rates is discouraged. Such rounding can lea...

A: a) Estimated monthly payment = Borrowed amount / n   

Q: Which will provide the largest yield on an annuity after 30 years with 6% annual interest, compounde...

A: Given, N = 30 Years r = 6%  

Q: a. Differentiate between Minor and Excessive Gharrar with examples of each.

A: In Islamic banking, interest rate is not charged on borrowings. Charging interest rate is considered...

Q: Determine the value at the end of five years of a $7,000 investment (today) in a bank certificate of...

A: Future Value = Present Value * (1+rate)^n Where, Rate = 9%/2 = 0.045 n = no. of compounding period =...

Q: Gabriele Enterprises has bonds on the market making annual payments, with seven years to maturity, a...

A: Coupon rate = coupon amount / Face value 

Q: Ten ​$7,000 bonds redeemable at par bearing 10% coupons payable quarterly are sold seven years befor...

A: The bond is a security that is issued by the organization to investor to borrow the money at the spe...

Q: Q1.1: While buying a new car, Abigail made a down payment of $1,000 and agreed to make month-end pay...

A: Using excel PV function to calculate the purchase price of the car 

Q: Throughout the 1990s, the equity premium fell considerably especially in the USA. One conceivable re...

A: The stock price would drop and vice versa if the required return increases. That makes sense: if not...

Q: Please show working   Please answer ALL OF QUESTIONS 1 AND 2   1. A 7% semiannual coupon bond mature...

A: Since you have posted multiple questions, we will solve the first question for you. If you want any ...

Q: A 10-year loan of 2000 is to be repaid with payments at the end of each year. It can be repaid under...

A: Loan Amount, A=2000Yearly Payment, P=200Number of years=10Interest rate=5%Total amount paid in case ...

Q: Consider the following premerger information about a bidding firm (Firm B) and a target firm (Firm T...

A: Since there are two options for the firm to carry out, either in cash offer or either through share ...

Q: Quantitative Problem: Sunshine Smoothies Company (SSC) manufactures and distributes smoothies. SSC i...

A: "Since you asked multiple questions, we will answer the first question for you as per the guidelines...

Q: When financial institutions, such as banks or credit unions, advertise the rates on their loans, the...

A: APR is the annual percentage rate. EAR is the effective annual rate. Banks, financial institutions o...

Q: You are evaluating the performance of two portfolio managers, and you have gathered annual return da...

A: Year Manager X Return (%) (xi-x_) (xi-x_)2 Manager Y Return (%) (yi-y_) (yi-y_)2 1 -2.5 -7 49 -6.5...

Q: Stocks A and B have the following historical returns: Year Stock A return Stock B return ...

A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for you...

Q: You are analyzing two mutually exclusive projects with the cash flows shown below. The cash flows ar...

A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If y...

Q: In December 2015, General Electric (GE) had a book value of equity of $98 billion, 9.4 billion share...

A: Market capitalization, also known as market cap refers to the total market value of the outstanding ...

Q: Pls solve asap...

A: The possible rate of return for this project is three because cash flows are not normal i.e. multipl...

Q: 4( see picture

A: according to gordon's constant growth model: pi=Di+1r-g where, pi= price at ith year Di +1 = dividen...

Q: .. Ahmed, who was admitted in a hospital, was required to undergo a surgery. Before his operation, h...

A: Yes he can succeed  Because position of doctor was dominant  position and he was under high weak pos...

Q: An accountant needs to withhold 17% of income for taxes if the income is below $30,000, and 23% of i...

A: using excel if function to calculate the amount of withhold 

Q: (Show the cashflow diagram if needed) A project requires an investment of P400,000, lasts 15 years, ...

A: This question asks if the investment is desirable based on the ROR and AWM.  The assessment based on...

Q: 1) Newman Automobiles Manufacturing is considering two alternative investment proposals with the fol...

A: Payback Period  = Initial Investment / Annual cashflow  

Q: Assume it is now January 1, 2000, and someone offers the following deal: starting from year 2000, yo...

A: Year Cash Flows Present Value of cash flow = Cash Flow / (1+interest%)^year Working 1 2000 1818.18...

Q: for information on MACRS depreciation.) What is the required net investment, and what are the year 1...

A: Net Investment= Cost of equipment  + freight and installation cost= 900000+100000=1000000 The net in...

Q: A state lottery commission pays the winner of the “Million Dollar” lottery annual installments of $5...

A: Present value of continuously compounding annuity = Cashflow/ (e^r )-1    

Q: How long will it take my money to double at 7% p.a. compounded semi-annually? a About 10 years b. Ab...

A: Given data; 2 * Present value of money = future value of money FV / PV = 2 Interest rate = 7% compou...

Q: Sales (75,000units)                                                                      P 750,000  ...

A: Degree of combined leverage = Contribution /EBT    

Q: Brittany is co-oping this semester at Regency Aircraft, which customizes the interiors of private an...

A: I. Let first cost be x Life of machine=10 years MARR= 8% Salvage value=0.2x x=15000×PVA8%,10+0.2x×PV...

Q: Call Premiuma 6 percent corporate coupon bond is callable in five years for a call premium of one ye...

A: The provided information are: Face value = $1000 Coupon rate = 6%   

Q: Nokela Industries purchases a $40 million cyclo-converter. The cyclo-converter will be depreciated b...

A: a) Impact on earnings due to cost of the purchase