Time value of money problems

Assignment Help Financial Management
Reference no: EM131859843

In Excel, calculate the following time value of money problems: a.) if I am to receive $10,000 in 5 years and given a 5% rate of return, what would be present value of this amount. b.) if I put $7,000 in the bank at 3% interest for 10 years, what is the future value of that amount. c.) if I deposit $1,000 a year into an account for 10 years at 2%, what is the future value of that account. d.) what is the present value of $1,000 a year deposited for 10 years at 4% interest. Can this be shown in Excel?

Reference no: EM131859843

Questions Cloud

Explain what is callable bond : Explain what is a callable bond. Why would a firm call a bond? Explain why it would be a premium or discount bond.
Expected value of the short-term interest rate next year : If you believe in the expectations hypothesis, what is your best guess as to the expected value of the short-term interest rate next year?
Explanation of the constant risk portfolio strategy : Explanation of the constant risk portfolio strategy
How much will he have available for retirement : How much will he have available for retirement if he can earn 8% on his investment and begins investing one year from now?
Time value of money problems : calculate the following time value of money problems. if I am to receive $10,000 in 5 years and given a 5% rate of return, what would be present value of amount
Dividends are expected to grow at a rate : Synovec Co. is growing quickly. Dividends are expected to grow at a rate of 24 percent for the next three years, what is the current share price?
What is firm dividend growth rate assuming constant growth : The expected dividend in one period is $2 and the required return is 12%. What is this firm’s dividend growth rate assuming constant growth?
What is the value of stock at the beginning : Waller Co. (WAG) paid a $0.147 dividend per share in 2006, What is the value of this stock at the beginning of 2013 when the required return is 14.7 percent?
Discuss the price sensitivity of both bonds : Make a table comparing the bond prices when market interest rates vary from 5%, 6%, …..17%, and discuss the price sensitivity of both bonds.

Reviews

Write a Review

Financial Management Questions & Answers

  How do you think sweeps have affected m2

Given Figure shows that sweep programs have reduced the level of M1. - How do you think sweeps have affected M2?

  Annual yield assuming the investment was held to maturity

An investor is looking to buy a $1,000,000 T-bill issue at an Ask Discount of 1.13 on January 22 for a maturity date of February 27 (36 days to maturity), what is the discount rate, dollar discount, purchase price, and the holding period yield and an..

  What was internal rate of return on this investment

She sold the stock the same day she received that last dividend payment. What was Alice's internal rate of return (IRR) on this investment?

  Standard deviation of returns for this investors portfolio

An investor plans to invest 75 percent of her funds in the common stock of GAmma Industries and 25 percent in Epsilon Company. The expected return on GAmma is 12 percent and the expected return on Epsilonis 16 percent. Determine the standard deviatio..

  Maximum cost-cost of capital for such risky projects

Scanlin, Inc., is considering a project that will result in initial aftertax cash savings of $1.78 million at the end of the first year, and these savings will grow at a rate of 2 percent per year indefinitely. The firm has a target debt−equity ratio..

  Proportional change method

Using the following data, calculate the estimated total revenues for fiscal year 6 (FY6), using 1) proportional change method,

  Forecasts of revenues over the lifetime of project

These are the forecasts of revenues over the lifetime of a project. Assume all cash flows occur at the end of the year. This hint is optional; you don't have to read this. This is only to help you, if you are confused by this hint just ignore it and ..

  What is the duration of a four-year treasury bond

What is the duration of a four-year Treasury bond with a 5 percent semiannual coupon selling at par?

  Will the new level of operating leverage

At an output level of 83,000 units, you calculate that the degree of operating leverage is 3. The output rises to 90,000 units. What will the percentage change in operating cash flow be? Will the new level of operating leverage be higher or lower?

  Company is offering a new policy to its customer

An insurance company is offering a new policy to its customers. Typically the policy is bought by a parent or grandparent for a child at the child’s birth. The details of the policy are as follows: The purchaser (say, the parent) makes the following ..

  What was your total return for the past year

You purchased a zero-coupon bond one year ago for $283.33. The market interest rate is now 9 percent. Assume semiannual coumpounding periods. If the bond had 15 years to maturity when you originally purchased it, what was your total return for the pa..

  What is the smallest expected loss for portfolio

What is the smallest expected loss for your portfolio in the coming month with a probability of 5.0 percent?

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!

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