User Account

All Pages

Function keys to solve this problem in spreadsheet

Assignment Help Finance Basics
Reference no: EM131697168

Please explain the formula that is used to solve the following:

  • What will $200,000 grow to be in 15 years if it is invested today in an account with an annual interest rate of 8%?
  • How many years will it take for $192,000 to grow to be $500,000 if it is invested in an account with an annual interest rate of 8%?
  • At what annual interest rate must $272,000 be invested so that it will grow to be $477,000 in 5 years?

I used the following function keys to solve this problem in spreadsheet:

  • If you wish to accumulate $325,000 in 15 years, how much must you deposit today in an account that pays an annual interest rate of 8%:

Functions Answer

  • Future Value FV $102,453.55
  • Present Value PV  
  • Rate   I  
  • Period  n    

Reference no: EM131697168

Questions Cloud

Remoteness can affect uptake of health services : Remoteness can affect uptake of health services. Design a study to investigate the effect of an online health service or mobile application for sexual healthin
How much consumer surplus does bert get : If the price of a bottle of water is $4, how many bottles does Bert buy? How much consumer surplus does Bert get from his purchases?
Develop a location decomposition diagram for the system : Develop a location decomposition diagram for the system. Develop a location connectivity diagram for the system. Why was the particular configuration selected?
What length of common rafters needs to be ordered for roof : A roof framed with 2 × 6 rafters has a span of 18 feet, an overhang of 12 inches, and a slope of 4:12. What length of common rafters needs to be ordered.
Function keys to solve this problem in spreadsheet : What will $200,000 grow to be in 15 years if it is invested today in an account with an annual interest rate of 8%?
Specific format of a viable statement for a company : Is there a specific format of a viable statement for a company? If so, what are the elements that should be included in the viable statement?
Design a study to investigate the impact of new environment : Migrating to a new environment can affect our access to food, health care services and other resources. Design a study to investigate the impact of environment
Price of the company stock today : The company's cost of equity (rs) is 9%. Using the dividend growth model (allowing for nonconstant growth), what should be the price of the company's stock.
Compute the number of bars needed for the wall : Determine the number of 20-foot-long #4 bars needed for the wall in Problem if the wall is horizontally reinforced by bond beams at 4 feet on center.

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the probability that the student is from ucla

What is the probability that the student is from UCLA or chooses football? What is the probability that the student is from Duke, given that the student chooses basketball? What is the probability that the student is from Maryland and choosessoccer?

  Compound and simple interest-pv-annuities

Illustrate compound interest formulas, using them to find future values and present values of the dollar; describe annuities and find out the future value or present value of annuity

  How would the speculation be arranged using forward markets

The spot rate for the Danish krone is USD0.1500 and the three-month forward rate is USD0.1505. Your company is prepared to speculate that the Danish krone will move to USD0.1650 by the end of three months.

  Calculate vintage return on equity

Vintage, Inc. has a total asset turnover of 1.56 and a net profit margin of 3.26 percent. The total assets to equity ratio for the firm is 2.3. Calculate Vintage's return on equity.

  Mathematics of portfolio risk by looking at return

Discuss the mathematics of portfolio risk by looking at return, variance, coefficient, and standard deviation. (1 - 2 paragraphs)

  Light bulbs have malfunctioned

What is the probability that three or less light bulbs have malfunctioned?

  What is the expected capital gains yield

The next dividend payment by Blue Cheese, Inc., will be $1.89 per share. The dividends are anticipated to maintain a growth rate of 5 percent forever. The stock currently sells for $38 per share. 1. What is the dividend yield? 2. what is the expec..

  Research question and hypothesis statements

What is the research question and/or the hypothesis statements? What are the results of the study?

  What is evanecs cost of retained earnings

The Evanec Company's next expected dividend is $2.93; its growth rate is 6.42%; its common stock now sells for $36.34. What is Evanec's cost of retained earnings (existing equity), rs?

  Calculation of operating cash flows

Calculation of operating cash flows and what were the firm's earnings before taxes

  What are the equal annual payments

Haystack, Inc. manufactures machinery used in the mining industry. On January 2, 2018 it leased equipment with a cost of $480,000 to Silver Point Co. The 5-year lease calls for a 10% down payment and equal annual payments at the end of each year.

  Define the cost analysis

Cost Analysis: The Purchase of Health Care Equipment Team Project An equipment acquisition proposal was being considered by a large health care organization.

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