To solve this problem, we use the formula:
F = A [(1 + i)^n – 1] / i
where,
F is the future value or the amount he will have
A is the amount he invest each year = 1200
n is number of years = 70 – 21= 49
i is the interest or return rate = 7% = 0.07
Hence the value of F is:
F = 1200 * [1.07^49 – 1] / 0.07
<span>F = $454,798.80 </span>
Answer and Explanation:
The answer is attached below
USES ( APPLICATIONS) of spreadsheet are;
1) to create budgets : Excel can be used in creation of budget s which is the estimation of revenue as well as expenses which covers specified future period of time.
2)produce graphs and charts: it's application is helpful in creating graphs in mathematics as well as statistics
3 for storing and sorting data: Data sorting can be done using spreadsheet. It involves arrangements of data into an order in order to make analysis of the data easier.
SPREADSHEET APPLICATION
1)Microsoft Excel : This is used in data
crunching , it can handle large data sets.
2)LibreOffice : it's applicable in Calc for a free as well as native spreadsheet app.
4) Smartsheet: is useful when handling
task involving non-spreadsheet and can be used for project management.
5)Quip : it's useful for integration of
spreadsheets into shared documents.
Policy analysts can estimate the value of a human life through contingent valuation methods. It is a method use to estimate the value of a good that is placed by a person. It involves asking people to report their willingness to pay or accept in order to have or give up a certain good. It is used to evaluate the economic values of all goods.
Answer:
b. When there is a lack of importance of the buyer to the supplier group
Explanation:
According to Porter there are five forces that can cause rivalry in a production industry. These are supplier power, threat of new entrants, buyer power, threat of substitutes, and degree of rivalry.
Supplier power is when suppliers are able to benefit from the producers by increasing prices of inputs and gaining some industry profit. Since suppliers supply input and labour to the producer they have a greater control of there is lack of importance of the buyer to the supplier group.
This means that the supplier group has more control on price and quality it supplies to the buyer with buyer having little choice but to buy.
If however buyer is more important to the supplier it means they can control price and quality of inputs
