Question

In: Computer Science

You want to calculate a bonus if the sold price was at least equal to the listing price, and if the house sold within 30 days after being listed.

BA Average Total Sold Highest 1 Location Sold Price Number Sold Dual Agent Total Sol Prices Sold Price Agent Codes and Commis

You want to calculate a bonus if the sold price was at least equal to the listing price, and if the house sold within 30 days after being listed.

In cell L12, insert an IF function with a nested AND function to calculate a bonus. The AND function should ensure both conditions are met: Sold Price divided by the Listing Price is greater than or equal to 100% (cell L7) and the Days on Market are less than or equal to 30 (cell L8). If both conditions are met, the bonus is $1,000 (cell L9). Otherwise, the bonus is $0. Use mixed cell references to the input values in the range L7:L9. Copy the function to the range L12:L39.

Solutions

Expert Solution

In order to calculate the bonus as per the requirement, please use the below Excel formula. Please make sure to copy the formula as such including the "=" symbol. This formula can be pasted in the cell L12. Then copy the cell and paste it into other cells L12:L39.

=IF(AND(G12/F12 >=$L$7,J12<=$L$8)=TRUE,$L$9,0)

Here mixed cell references are used for cell L7, L8 and L9 such that when the formula is copied to L12:L39, these cell references are not shifted.

Please cross check that the cell formula looks like below in each cell when copy pasted.

In L12 it should be as below.

=IF(AND(G12/F12 >=$L$7,J12<=$L$8)=TRUE,$L$9,0)

In L13 it should be as below.

=IF(AND(G13/F13 >=$L$7,J13<=$L$8)=TRUE,$L$9,0)

and so on.


Related Solutions

An insurance company states that at least 85% of its claims are settled within 30 days.
4) (1 point) An insurance company states that at least 85% of its claims are settled within 30 days. A consumer group selected a random sample of 66 of the company's claims to test this statement. They found that 55 of the claims were settled within 30 days. Does the consumer group have evidence to disbelieve the insurance company's claim? 1. Write the hypotheses to test if the rate of claims settled within 30 days is less than 85%. H0H0:...
You want to buy a house that is sold for $250,000. Given your income, you are...
You want to buy a house that is sold for $250,000. Given your income, you are able tonpay $1,050 monthly mortgage payment per month. You want to borrow a 30-year fixed rate mortgage. The rate is 4.125. How much down payment do you have to make so as to close the transaction? (ignore the closing cost)
I want you to choose a product that is currently being sold and think of a...
I want you to choose a product that is currently being sold and think of a way that you can make it better. You need to provide the following: Name of the product Description of the product Visual of the product List your enhancement (s) Explanation as to why your "enhancement (s)" will make the current product more attractive.
You will receive written feedback on the questions you choose to answer within 1-2 days after...
You will receive written feedback on the questions you choose to answer within 1-2 days after the due date of the assignment. Please use information from the Power Points slides, as well as the textbook, to answer these questions. Responses should be anywhere from 1-2 paragraphs for each question. Please provide a response to 2 of the critical thinking questions for this chapter. Label your answers clearly (i.e., which question you are responding to). 1. Assume for a moment you...
Ben buys a 180-day $100 000 bank bill, 30 days after issue, for a price of...
Ben buys a 180-day $100 000 bank bill, 30 days after issue, for a price of $98 140.70 (the purchase yield is 4.61% p.a.). After holding the bill for 30 days Ben sells it at a yield of 4.56% p.a. (simple interest). a. Construct a Cash flow diagram from Ben's perspective b. Find the sale price. c. Find Ben's simple interest yield p.a. (as a percentage, rounded to 2 decimal places) over the 30-day holding period. d. Explain how Ben's...
You want to know the price of a 8% coupon bond that is currently being traded...
You want to know the price of a 8% coupon bond that is currently being traded in the bond markets. The maturity of the bond is 3 years, its par value is $1000, and it pays its coupons annually. You do not know the corresponding market interest rates, but you know the YTM of 8 % for the bond. (1) What is the price of this bond? (2) Does this mean that YTM is equivalent to the market interest rate...
Suppose you want to test whether you can solely rely on assessment to predict house price,...
Suppose you want to test whether you can solely rely on assessment to predict house price, that is, knowing housing characteristics will not help you predict housing price, once assessment is included in the model. Using a sample of 125 houses, you have estimated Price= α+ β1 assess+ β2 lotsize+ β3 sqrft+ β4 bdrms+ u and you decide to do a test at the 5% significance level. Then your best approach to answering the question is to a) check each...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and had an initial balance of $800,000. The mortgage is currently exactly 18.5 years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% p.a. (with monthly compounding), how much cash will you have from the sale once you pay off the mortgage? (Round to the nearest dollar). a. $540.661 b. $459,340 c....
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a​ 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a​ 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly​ 18½ years​ old, and you have just made a payment. If the interest rate on the mortgage is 6.25% ​(APR), how much cash will you have from the sale once you pay off the​ mortgage? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.)
You have just sold your house for $900,000 in cash. Your mortgage was originally a​ 30-year...
You have just sold your house for $900,000 in cash. Your mortgage was originally a​ 30-year mortgage with monthly payments and an initial balance of $700,000. The mortgage is currently exactly​ 18½ years​ old, and you have just made a payment. If the interest rate on the mortgage is 7.75% ​(APR), how much cash will you have from the sale once you pay off the​ mortgage? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT