Answer:
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
Explanation:
In MS Excel, on the left hand side below the tool bar there is a small box which tells the cell name where the cursor is clicked, the name of the cell can be changed from here easily, click on the desired cell and then by clicking on the box you can enter the name of the cell. After a cell is renamed the formula can be written by simply putting the name of the cell instead of the original e.g. E13
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
The cells provided in the formula above is just an example and more than two cells can be selected.
Answer:
The answer is letter C
Explanation:
The sources and uses of funds approach.
Answer:
b. Continue operating as the firm is covering all the variable costs and some of the fixed costs
Explanation:
A firm should shutdown operations if its price is less than average variable cost.
The price the firm sells is $15
Average variable cost is $10.
Price is greater than average variable cost in excess of $5.
The $5 covers some of the average fixed cost.
I hope my answer helps you
Answer:
$1,312.50
Explanation:
Calculation for How much was the referring agent paid
First step is to find the buyer agent amount by using the buyer's agent percentage to multiply the buyer purchased amount of the home
Using this formula
Buyer agent amount =Buyer's agent percentage× Home purchased amount
Let plug in the formula
Buyer agent amount=1.5%×$350,000
Buyer agent amount=$5,250
The last step is to find How much was the referring agent paid
Using this formula
Amount referring agent paid =Buyer agent amount× Percentage of buyer side commission
Let plug in the formula
Amount referring agent paid=$5,250×25%
Amount referring agent paid=$1,312.50
Therefore the amount that the referring agent paid will be $1,312.50
Answer: $297,353.33
Explanation:
In calculating the Opportunity Cost of using that space with the available data, the following formula can be used (notice that APR is a yearly figure and the rent is monthly),
Opportunity cost = Rent per month *12* (1-tax rate) / APR
= $3,431.00 * 12 * ( 1 - 0.35) / 0.09
= 297353.333333
= $297,353.33
$297,353.33 is the opportunity cost of using this space.
Note the method used above is the faster method but if you want to use the other method, first you change the rent to a monthly figure. Then you divide it by the cost of capital to get the present value. Then you multiply by the After tax rate of (1 - tax rate). It's basically the same as the above though.
