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.
Answer:
The correct answer is option a.
Explanation:
Apples and oranges are substitutes. An increase in the price of oranges will cause the demand for apples to increase. This is because people will prefer a cheaper substitute. This increase in the demand for apples will cause its demand curve to shift to the right.
The rightward shift in the demand curve will cause the equilibrium price to increase. But this change in price will not cause a change in demand. The change in price affects only the quantity demanded. Change in demand happens because of a change in other factors.
So, the given statement is not correct.
Answer:
$77,217
$11,289
Explanation:
Fist we will calculate the present value of $10,000 payment
A fix Payment for a specified period of time is called annuity. The discounting of these payment on a specified rate is known as present value of annuity. The value of the annuity is also determined by the present value of annuity payment.
Formula for Present value of annuity is as follow
PV of annuity = P x [ ( 1- ( 1+ r )^-n ) / r ]
Where
P = Annual payment = $10,000
r = rate of return = 10% / 2 = 5%
n = number of period = 5 years x 2 semiannual payments per year = 10 payments
PV of annuity = $10,000 x [ ( 1- ( 1+ 0.05 )^-10 ) / 0.05 ]
PV of Annuity = $77,217
Now we will use the discounting method to calculate the present value of lump sum payment of $20,000
Present value = Future value x Present value factor
PV = FV x ( 1 + r )^-n
PV = $20,000 x ( 1 + 0.1 )^-6
PV = $11,289
When survivors or beneficiaries receive a set sum of money from insurance, it is from a life insurance policy. Many people pay into a life insurance policy for numerous years to leave money for their families future. There are several types of life insurance that can be purchased such as term life and permanent life insurance.
Answer:
B tutor how are u???????????
