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

  Evaluate the optimal level of investment for a household

Evaluate total savings in each period.  Is the Investment/Saving market at equilibrium in each period?

  Calculate jaedans free cash flow

Calculate Jaedan's free cash flow and calculate Jaedan's liquidity - calculate Jaedan's debt and profitability ratios.

  What obstacles to lucents earnings recovery present

Conduct a DuPont decomposition of Lucent's ROE for the 1998, 1999 and 2000 first (December) quarters.  What factors contributed to the differences in Lucent's performance between those quarters?

  How would you hedge this exposure

How would you hedge this exposure? If you hedge, what is the variance of the pound value of the hedged position?

  Prepare the schedule of cost of goods manufactured

All raw materials are considered direct to the manufacturing process. During April, the company purchased $260,000 of raw materials. Direct labor cost for the month was $342,000; workers are paid $9.50 per hour. Overhead is applied at the rate of ..

  Find the break even quantity

Two different production procedure is being considered for making a new product. The 1st procedure is less capital intensive, with fixed costs of only $50,000 per year and variable costs of dollar 7,000 per unit. Find the break even quantity

  Calculate the current earnings per share

Calculate the current earnings per share (EPS) and calculate the current gearing (non-current debt/equity, using book value).

  What is the annual payment amount on loan

What is the annual payment amount on this loan? Show your calculations. Do you agree with this decision when compared to the options listed under Question 1 of this task

  Explain how inflation affects the rate of return

Explain how inflation affects the rate of return required on an investment project, and also explain the distinction between a real and a nominal (or ‘money terms') approach to the evaluation of an investment project under inflation

  Define transaction-translation and economic exposure

Which is the best strategy for ABC to avoid paying the least amount of Australian dollars by hedging its exchange rate risk, forward or option?

  Identifing the likely stage for every venture

The given ventures are at different stages in their life cycles. Identify the likely stage for every venture & explain type of financing every venture is likely to be seeking and identify potential sources for that financing.

  Make a report for nyse-euronext and the nasdaq

You have been asked to make a report for a group of stock brokers about NYSE-Euronext and the NASDAQ.

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