User Account

All Pages

How long will it take for her funds to triple

Assignment Help Corporate Finance
Reference no: EM13210936

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

Reference no: EM13210936

Questions Cloud

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)

Reviews

Write a Review

Corporate Finance Questions & Answers

  Goal of competition to win

It is hard to believe a competitor is a stakeholder. Is not goal of competition to win & perhaps even dominate the market?

  How much must frank save at the end of each year

Frank expects to be able to earn 5% after tax on any investments. How much must Frank save at the end of each year for the next 10 years in order to provide for Laura's education and auto?

  What is the projects apv in the cases

Calculate the weighted-average cost of capital (WACC) for Federated Junkyards of America and what is the project's APV in the cases

  What return would you expect to earn and why

If you were able to put together a portfolio that completely eliminated all risk, what return would you expect to earn and why?

  Amortization schedules of interest expense

Spencer Corporation sells 10% bonds having a maturity value of $3,000,000 for $2,783,724. The bonds are dated January 1, 2012, and mature January 1, 2017. Interest is payable yearly on January 1.

  Determine the ecr to support d3 team

Determine the ECR to support D3 Team Travel's goal to generate an additional $50,000 in sales over the next year. Considering its average monthly cash-in-hand, would you recommend that it fund the $50,000 ISG?

  Find the trends in net cash provided by operating activities

Choose and two firms in the same industry. Use the Internet to discover the current statement of cash flow for both firms and answer the questions using APA format to cite the sources.

  Write a brief description about the company

Write a brief description about the company you chose and also talk about how it meets the conditions just mentioned - Find your company go to the Toronto Stock Exchange website, and in the drop down menu below "ABOUT TMX GROUP" choose "Listed Compa..

  How many shares would have to be issued

How many shares would have to be issued? What is the dollar size of the issue and assuming that the market price of the firm's stock is $95, and flotation costs are 10 percent of the market price

  Calculation of future value on a per dollar basis

Calculation of future value, on a per dollar basis, of each of the two interest payment options and compute the future value of the $47 million bid using each option, and determine which is bigger.

  Analyze the structure of the variable rate debt

How useful are synthetic fixed-rate debt instruments in your opinion? Why would anybody want to construct such instruments? What are their advantages and disadvantages?

  Purpose a monthly income and expense plan for terrels

Preparation of monthly income and expense plan and analysis of financial position - Purpose a monthly income and expense plan for the Terrels in 2003.

Free Assignment Quote

Assured A++ Grade

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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