How many of the following formulas could be entered in cell

Assignment Help Finance Basics
Reference no: EM13687411

In the spreadsheet shown below, we computed profit earned by selling houses by entering the formula =F9-E9 in cell G9 and copying it down to G10:G1b. We used the word open to denote a house that is not yet sold. Unfortunately, when a house has not yet been sold our spreadsheet shows the #VALUE error, because you cannot subtract the buy price from the word open. We would like to "error trap" column G so that when a house has been sold the correct profit has been computed and if the house has not yet been sold a _ will be entered in Column G. How many of the following formulas could be entered in cell G9 and copied down to G10:G12 to achieve this goal?

  • I. IFERROR(F9-E9,"_ ")
  • II. ISERROR(F9-E9," _")
  • III. IF(COUNT(G9)>0,F9-E9,"_")
  • IV. IFERROR(F9-E9,_)

• V. IFERROR(E9-F9,"_ ")

 

Reference no: EM13687411

Questions Cloud

Parties to a contract should have and understanding : Parties to a contract should have and understanding of what they are undertaking—a meeting of the minds. Provide an example of two parties who have reached such a clear understanding.
A real estate investment is available at an initial cash out : A real estate investment is available at an initial cash outlay
Why may the corporate bond be preferred : Why may the corporate bond be preferred?
Griswold travel company has issued six-years bonds : Griswold travel company has issued six-years bonds that pay €30 in interest twice each year. The par value of these bonds is €1000 and they offer a yield to maturity of 5.5 per cent. How much are the bonds worth?
How many of the following formulas could be entered in cell : How many of the following formulas could be entered in cell G9 and copied down to G10:G12 to achieve
The pear torte sales are always listed in cell f7 : Suppose you have listed Le Napoleon's monthly sales of pear tortes in a twelve-sheet workbook. The first worksheet contains January sales, the second worksheet February sales, etc. The pear torte sales are always listed in cell F7.
Draw the circular flow model of a simple economy : Draw the Circular Flow Model of a simple economy with the roles of firms, Households, Government and a foreign sector. In addition, identify the factor and product markets in this economy. Identify in the diagram the flows for all injections and leak..
Purchased a zero coupon bond one year ago : Purchased a zero coupon bond one year ago for 109.83. The market interest rate is now 9 percent. If the bond had 25 years to maturity when you originally purchased it, what was your total return for the past year?
Product market-provable supply and demand curve : Consider the product market for 'New York' steaks. Draw the provable supply and demand curve for this product and identify the equilibrium price and quantity. Consider the effect of a 'snafu' in the withholding tax on all consumers in this market whi..

Reviews

Write a Review

 

Finance Basics Questions & Answers

  The larger check takes four days to clear after it is

your neighbor goes to the post office once a month and picks up checks one for 17000 and one for 6000. the larger

  Calculate how much has to be in your account

Calculate how much you would have to save annually between now and age 63 in order to finance your retirement income and to fill that account.

  On ltd has the following capital structure componentsfive

on ltd has the following capital structure componentsfive million shares issued with a current market price of 6.

  Should firm increase growth by attaining other companies

should the firm increase growth by acquiring other companies for synergies or grow internally? do they have

  Determine the net benefit to acme

Acme Corporation is planning shortening its credit terms from the current net 45 days to net 30 days. If this policy is adopted it is believed that average collection period will move from the current 52 days to 36 days

  Determining financial management

What new problems and factors are encountered in international as opposed to domestic financial management? What does the term arbitrage profits mean?

  What is the effective cost of borrowing in this case

Your firm has an average collection period of 27 days. Current practice is to factor all receivables immediately at a 1.70 percent discount.

  Genaro needs to capture a return of 40 percent for his

1.genaro needs to capture a return of 40 percent for his one-year investment in a property. he believes that he can

  If the required return is 16 percent and the company just

wasserman corp. is growing quickly. dividends are expected to grow at a 28 percent rate for the next three years with

  What is its total corporate value

The company owns marketable securities of $100 million. It is financed with $200 million of debt, $50 million of preferred stock, and $210 million of book equity.

  Evaluate the option''s exercise value

The exercise price on one of ORNE Corporation's call options is $35 and the price of the underlying stock is $34 - evaluate the option's exercise value

  What would be the tax effect on the sale

Your company is in the 40% tax bracket. Assuming you could sell the machine today, what would be the tax effect on the sale?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd