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:
5.71%
Explanation:
The after tax cost of debt=pretax cost of debt*(1-t)
where t is the tax rate of 35% or 0.35
pretax cost of debt=yield to maturity
The yield to maturity can be determined using rate formula in excel as below:
=rate(nper,pmt,-pv,fv)
nper is the number of coupon interest payable by the bonds i.e 12 coupons in 12 years
pmt is the annual coupon=$1000*9.5%=$95
pv is the current market price-flotation cost=$1,100-$48=$1052
fv is the face value of $1000
=rate(12,95,-1052,1000)=8.78%
After tax cost of debt=8.78%
*(1-0.35)=5.71%
<span>Goodwill messages should always be without a direct business purpose. If you are on a goodwill mission it should never be done to increase your business but in an effort to support a cause and show compassion.</span>
The thing which usually happens during tight money periods, generally is:
- short-term rates are higher than long-term rates.
<h3>What is a Tight Money Period?</h3>
This refers to an economic policy in which there is the need for control of inflation in the economy by the financial institution in a country.
With this in mind, we can see that when this happens in the tight money periods, there is usually short term rates which are higher than long term rates because there is a need to control the economy which is rising too quickly.
Read more about inflation here:
brainly.com/question/1082634
Goods and services are scare because the resources required to produce these goods and services are limited in supply and that is why we can't fulfill all the wants of the people, which results in Scarcity to arise. In economics the basic economic problem arises because resources are limited and wants are unlimited and therefore everyone cannot have what they need and that is why we have a connection with opportunity cost. We need to sacrifice or forego the items we can't have and therefore with the economic problem of scarcity, opportunity cost arises. If we can satisfy everyone's wants, then there is no question about having scarce resources.
