Find the future value =fv(rate,nper,pmt,[pv],type)

Find the present value =pv(rate,nper,pmt,[fv],type)

Payment =pmt(rate,nper,pv,[fv],type)

Number of periods =nper(rate,pmt,pv,[fv],type)

Yield (Interest rate) =rate(nper,pmt,pv,[fv],type)

There are five arguments in each function. Rate is the interest rate per period. For example, if the interest rate per period is 5%, you will type .05 for this argument. Nper is the total number of periods. Pv is the present value, and fv is the future value. Pmt is the dollar amount of the periodic payment. The "type" argument tells Excel whether the cash flows occur at the end (0) or beginning (1) of the period. The bracket ,"[ ]", means that you will input a negative value in order to return a positive value for the answer.

1. Suppose you have $1,500 and plan to purchase a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures?

a. $1,781.53

b. $1,870.61

c. $1,964.14

d. $2,062.34

e. $2,165.46

2. How much would $20,000 due in 50 years be worth today if the discount rate were 7.5%?

a. $438.03

b. $461.08

c. $485.35

d. $510.89

e. $537.78

3. Suppose the U.S. Treasury offers to sell you a bond for $747.25. No payments will be made until the bond matures 5 years from now, at which time it will be redeemed for $1,000. What interest rate would you earn if you bought this bond at the offer price?

a. 4.37%

b. 4.86%

c. 5.40%

d. 6.00%

e. 6.60%

4. Janice has $5,000 invested in a bank that pays 3.8% annually. How long will it take for her funds to triple?

a. 23.99

b. 25.26

c. 26.58

d. 27.98

e. 29.46

5. You want to buy a new ski boat 2 years from now, and you plan to save $8,200 per year, beginning one year from today. You will deposit your savings in an account that pays 6.2% interest. How much will you have just after you make the 2nd deposit, 2 years from now?

a. $15,260

b. $16,063

c. $16,908

d. $17,754

e. $18,642

6. You just inherited some money, and a broker offers to sell you an annuity that pays $5,000 at the end of each year for 20 years. You could earn 5% on your money in other investments with equal risk. What is the most you should pay for the annuity?

a. $50,753

b. $53,424

c. $56,236

d. $59,195

e. $62,311

7. Suppose you inherited $275,000 and invested it at 8.25% per year. How much could you withdraw at the end of each of the next 20 years?

a. $28,532

b. $29,959

c. $31,457

d. $33,030

e. $34,681

8. What's the future value of $1,500 after 5 years if the appropriate interest rate is 6%, compounded semiannually?

a. $1,819

b. $1,915

c. $2,016

d. $2,117

e. $2,223

Determine the tangential component of the acceleration : determine the tangential component of the acceleration of the sled a) just before it reaches B, b) just after it passes C. |

In an experiment-hypnotized subjects : In an experiment, hypnotized subjects are told to scratch their ear if they hear the word "psychology" mentioned later. The fact that they do so only if they think the experiment is still underway most clearly supports the theory that hypnosis involv.. |

Describe electron and hole motions in a p-n junction : Briefly describe electron and hole motions in a p-n junction for forward and reverse biases; |

Briefly describe the measures : Briefly describe the measures that should be considered for the control of corrosion of embedded steel in concrete. |

How long will it take for her funds to triple : How much would $20,000 due in 50 years be worth today if the discount rate were 7.5% and what interest rate would you earn if you bought this bond at the offer price? |

Determine the maximum and minimum stress intensities : Determine the maximum and minimum stress intensities in the section. |

Spectroscopic studies have shown that the fusion reaction : Spectroscopic studies have shown that the fusion reaction in the sun's core proceeds by a complicated mechanism. One proposed overall equation for the solar fusion reaction is |

In 1888-92 the major issue of the presidential election : In 1888 and 1892 the major issue of the presidential election |

Design an algorithm that lists all possible rearrangements : Design an algorithm that lists all possible rearrangements of the symbols in a string of five distinct characters. (in pseudocode) |

## Impact of the global economic crisis on business environmentThis paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011). |

## Explain the short and the long-run effects on real outputExplain the short and the long-run effects on real output, price, and unemployment |

## Examine the requirements for measuring assetsExamine the needs for measuring assets at fair value in accounting standards |

## Financial analysis report driven by rigorous ratio analysisFinancial analysis report driven by rigorous ratio analysis |

## Calculate the value of the merged companyCalculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method. |

## Stock market projectSelect five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports. |

## Write paper on financial analysis and business analysisWrite paper on financial analysis and business analysis |

## Determine the financial consequencesShow by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose |

## Prepare a spread sheet modelPrepare a spread sheet model for the client that determines NPV/IRR with and without tax. |

## Principles and tools for financial decision-makingPrinciples and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital. |

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd