The best way for you to create the list of those who make more than $45000 a year and are full time is by using the filter option.
The filter option would be used to highlight the people that are in full employment. After this you have to use the sort to check the compensation column in order to establish those that make more than 45000.
The filter in a spreadsheet helps to put data in a particular category then arrange them based on the criteria that you selected.
The sorting method helps to arrange data based on ascending order or descending order.
Read more on brainly.com/question/15358155?referrer=searchResults
Answer:
The present Value of the growing annuity= $1,158,092.68
Explanation:
The present value of the growing annuity is going to be computed as follows:
PV = A/(r-g) × (1- (1+g/1+r)^n)
A- annual cash flow- $87,460
g- growth rate - 6.3%
n- number of years =73
r- discount rate - 13.8%
I will break out the formula into two parts to make the workings very clear to follow. So applying this formula, we can work out the present value of the growing annuity as follows.
A/(r-g) = 87,460/(0.138-0.063) =1,166,133.33
(1- (1+g/1+r)^n) = 1- (1.063/1.138)^73 =0.9931
PV = A/(r-g) × (1- (1+g/1+r)^n)
166,133.33× 0.9931 = 1,158,092.68
The present Value of the growing annuity= $1,158,092.68
Answer: $14,426.43
Explanation:
At the end of 4 months and assuming a 12 months and 365 days in a year, the formula to be used to calculate how much Rahul owes is;
We use the formula:
Amount owed = Present Value ( 1 + rate/365 ) ^ 365 * time period
Amount owed = 14,000 * ( 1 + 0.09/365 ) ^ (365 *4/12 )
Amount owed = $14,426.43
Depending on the supply and demand of equity, a bond’s price can vary, thus the premium or discount price.
For example, when the interest rate falls, older bonds may become valuable because they were sold in a higher interest rate environment and therefore with a higher coupon rate. Consequently, investors holding those bonds can commend a "premium" to sell equity. On the other hand, if the interest rate rises, older bonds may become less valuable. In order to get rid of them, investors may have to sell for less, thus the "discount” price.
Bond prices are quoted as a percent of the bond’s face value, and an easy way to learn the price of a bond is simply by adding a zero to the price quoted. For instance, when you hear a bond is quoted at 99, it means the price for the bond is $990 for every $1,000 of face value. Because the bond price is below the face value, it’s said the bond is traded at a discount. On the other hand, if the bond is trading at 101, it means you will pay $1,010 to get that $1,000 face value bond.
The dividend discount model (DDM) is a procedure for valuing the price of a stock by using the predicted dividends and discounting them back to the present value. If the value obtained from the DDM is higher than what the shares are currently trading at, then the stock is undervalued.
Learn more about equity here
brainly.com/question/1957305
#SPJ4