In the spreadsheet shown below we computed profit earned by, Ask an Expert

Finance

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,"_ ")

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M91227133

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Why does eps decrease if a companies additional capital it

Why does EPS decrease if a companies additional capital it wants is obtained by issuing more shares? How would it affect a companies decision about issuing equity to try and raise their capital? What would be the firms d ...

2 part questionpart 1 what do you think is the item that

2 part question: Part 1: What do you think is the item that accounts for the most cost in any hospital's budget? Can you outline ways to keep this cost under control? Part 2: Do think it is more difficult for a manager t ...

Starting with her next salary payment next month kathy

Starting with her next salary payment (next month), Kathy intends to save $200 each month. If the interest rate is 1% per month, how much will Kathy have saved after 12 months (12 deposits altogether over 12 months)? Fil ...

Great start to our discussion on the cost of capital

Great start to our discussion on the Cost of Capital. Basically it is the cost of all financing for a business. As a manager would we want the cost of capital to be lower or higher? Why

What do you think is the most important factor in

What do you think is the most important factor in developing a successful agile transformation? Why? What do you think are three most critical factors in a change management initiative? Why?

1 what criteria would you use to evaluate projects in terms

1. What criteria would you use to evaluate projects in terms of selection? 2. What factors are important to included in project plans to ensure effective planning and management?

You borrow 165000 to buy a house the mortgage rate is 40

You borrow $165,000 to buy a house. The mortgage rate is 4.0 percent and the loan period is 30 years. Payments are made monthly. If you pay the mortgage according to the loan agreement, how much total interest will you p ...

A company recently had 26 million shares outstanding

A company recently had 26 million shares outstanding trading at $45/share. The company announces its intention to raise $290M by selling new shares. What price shoukd the company expect its existing shares shares to sell ...

Within the secondary market which of the following us

Within the secondary market, which of the following US Treasury securities' prices will react most violently to a change in market interest rates (assume all securities were issued on the same date): a.90-day T- Bills b. ...

Y want to save enough money to retire as a millionairea

You want to save enough money to retire as a millionaire. a. If you could earn 10% with common stocks, how much would you have to set aside per year to have $1,000,000 when you are 65? Please use your own age. b. If you ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert