Time value of money calculations template

Assignment Help Finance Basics
Reference no: EM131657436

Resources: Microsoft® Office® 2013 Accessibility Tutorials, Microsoft® Excel®, Time Value of Money Calculations Template

Calculate the following time value of money problems using Microsoft® Excel®:

  1. If we place $8,592.00 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 9.5 years?
  2. What is the present value of $992 to be received in 13.5 years from today if our discount rate is 3.5 percent?
  3. If you bought a stock for $45 dollars and could sell it fifteen years later for three times what you originally paid. What was your return on owning this stock?
  4. Suppose you bought a house for $3,250,000 to make it a nursing home in the future. But you have not committed to the project and will decide in nine years whether to go forward with it or sell off the house. If real estate values increase annually at 1.5%, how much can you expect to sell the house for in nine years if you choose not to proceed with the nursing home project?
  5. If your daughter wants to earn $215,000 within the next twenty-three years and the salaries grow at 4.45% per year. What salary should she start to reach her goal?

Reference no: EM131657436

Questions Cloud

Introducing the new pepsi stuff catalog : A voiceover then intones, "Introducing the new Pepsi Stuff catalog." The scene then shifts to three young boys sitting in front of a high school building.
Effective annual rate as a percentage : The annual nominal rate is jm = 0.13pa. What is the effective annual rate as a percentage to two decimal places?
What is planned obsolescence : What is planned obsolescence? What role does planned obsolescence play in consumerism? What are your personal beliefs and biases about consumption?
Identifies the challenges for the business : Prepare a report on Volkswagen Report should have the following section Executive summary Introduction Business challenges Governance Issues
Time value of money calculations template : Resources: Microsoft® Office® 2013 Accessibility Tutorials, Microsoft® Excel®, Time Value of Money Calculations Template
Compute the payback period of the two projects : Compute the payback period of the two projects. Suppose Fuji's cutoff payback period is two years. Which of these two projects should be chosen.
Discuss the attached purchase agreement : The church's president signed this attached purchase agreement, but defendant did not sign it. The offer by letter dated June 3, 2003, did not reference other.
Why senior citizens are targeted by telemarketers : Topic - WHY MOST (APPROXIMATELY 50%) OF THE SENIOR CITIZENS ARE MAINLY TARGETED BY TELEMARKETERS IN FRAUD IN CANADA
Does the authrors argruments support the main point : Does the authrors argruments support the main point? What evidence supports the main point? What is your opinion of this article do you agree with the finding?

Reviews

Write a Review

Finance Basics Questions & Answers

  Cmc uses the residual distribution model and pays all

components manufacturing corporation cmc has 1 million shares of stock outstanding. cmc has a target capital structure

  In a simple regression the regression equation

In a simple regression the regression equation is Y^ = 5X 7.- But the slope will only be approximately equal to 0.2 and almost never exactly equal to 0.2. Why?

  What is the tax advantage of the merger each year

What is the tax advantage of the merger each year for Reilly? What is the tax advantage of the merger each year for Webster? What is the maximum cash price each interested firm would be willing to pay for Hahn Textiles?

  Loss reserves originating in 2000 too low or too high

U.S.-based American International Group Inc. (AIG) is one of the world's largest insurance companies, offering property-casualty, life insurance, and retirement services to customers in more than 130 countries. In its 2010 10-K report to the S..

  Excel to determine the price of a bond at issue

Excel to determine the price of a bond at issue? For example, a bond issued at 9% on February 1 with a face value of $80m. Maturing on Jan 31, 2020. Mkt yield of 10% for similar bonds. Semi-Annual payments on July 31 and Jan 31.

  What is experimental contamination

Does a nonequivalent groups pretest-posttest design eliminate local history as a potential explanation of the results? Explain.

  Determine the aspen restaurant''s terminal value

Determine the Aspen Restaurant's terminal or horizon value at the end of five years, assuming the venture will be entering its maturity stage. What is the present value of the Aspen Restaurant, assuming that it is a development-stage venture?

  Web-oriented entertainment company

R.K. Maroon (RKM) is a seed-stage, Web-oriented entertainment company with important intellectual property. RKM's founders, all technology experts in the relevant area, are anticipating a quick leap to dot-com fortune and believe that their unique..

  If the current market price of security d costs $18

If the current market price of Security D costs $18, but the no-arbitrage price of Security D is $17.40,  is there an arbitrage opportunity? What are the details of my trade?

  Determining the sustainable growth rate

It is now time to prepare your final report, summarizing the findings and analysis that you conducted over the past few weeks. Your report should include the following: Las Vegas Sands Corporation

  What factor contribute to moral hazard on internatinal level

What is moral hazard? Why does deposit insurance inherently involve moral hazard? What factors contribute to moral hazard on the internatinal level?

  What is the effective interest cost of loan

Set up the amortization schedule for a five-year, $1 million, 9 percent loan that requires equal annual end-of-year principal payments plus interest on the unamortized loan balance. What is the effective interest cost of this loan?

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