Business

Business, 11.07.2019 23:40, 1129682

In cell g3 on the investments worksheet, use the fv function to calculate the future value of the investment in 2 years. use the target growth rate yo define the rate argument. this is not an annuity so there is no periodic investment. use the current balance to define the pv argument. assume that the investment is made at the beginning of the period.
how do i set up the formula?

In cell g3 on the investments worksheet, use the fv function to calculate the future value of the in

answer

Answers: 1

Show answers

Similar questions

Предмет

Business, 24.06.2019 09:10, hmj192905

Rate of return and investment choice clare jaccard has $5 comma 000 to invest. because she is only 25 years old, she is not concerned about the length of the investment's life. what she is sensitive to is the rate of return she will earn on the investment. with the of her financial advisor, clare has isolated four equally risky investments, each providing a single amount at the end of its life, as shown in the following table, all of the investments require an initial $5 comma 000 payment. a. calculate, to the nearest 0.01%, the rate of return on each of the four investments available to clare. b. which investment would you recommend to clare, given her goal of maximizing the rate of return?

Answers: 2

Предмет

Computers and Technology, 01.07.2019 23:20, milkshakegrande101

(financial application: calculate future investment value) write a program that reads in investment amount, annual interest rate, and number of years, and displays the future investment value using the following formula: futureinvestmentvalue = investmentamount * (1 + monthlyinterestrate)^numberofyears*12 for example, if you enter amount 1000, annual interest rate 3.25%, and number of years 1, the future investment value is 1032.98.

Answers: 3

Предмет

Business, 29.07.2019 19:20, Manuel2019

Douglas keel, a financial analyst for orange industries, wishes to estimate the rate of return for two similar-risk investments, x and y. douglas�s research indicates that the immediate past returns will serve as reasonable estimates of future returns. a year earlier, investment x had a market value of $20,000; investment y had a market value of $55,000. during the year, investment x generated cash flow of $1,500 and investment y generated cash flow of $6,800. the current market values of investments x and y are $21,000 and $55,000, respectively. a. calculate the expected rate of return on investments x and y using the most recent year�s data. b. assuming that the two investments are equally risky, which one should douglas recommend? why?

Answers: 3

Предмет

Business, 31.07.2019 00:30, Maddenmobile7625

P8-1: rate of return douglas keel, a financial analyst for orange industries, wishes to estimate the rate of return for two similar risk investments, x and y. douglas’s research indicates that the immediate past returns will serve as reasonable estimates of future returns. a year earlier, investment x had a market value of $20,000, and investment y had a market value of $55,000. during the year, investment x generated cash flow of $1,500, and investment y generated cash flow of $6,800. the current market values of investments x and y are $21,000 and $55,000, respectively. a. calculate the expected rate of return on investments x and y using the most recent year’s data. b. assuming the two investments are equally risky, which one should douglas recommend? why?

Answers: 3

Do you know the correct answer?

In cell g3 on the investments worksheet, use the fv function to calculate the future value of the in...

Questions in other subjects:

Konu

Chemistry, 04.08.2019 18:40

Last question i think. . what would newtons third law be. . me!...

Konu

Health, 04.08.2019 18:40

Research indicates that using electronic devices before bed may make it difficult for people to fall asleep. the light appears to interfere with the body’s ability to create this h...

Konu

History, 04.08.2019 18:40

In revelation, jesus christ is referred to as the lion of the tribe of judah. true or false the black horse in revelation refers to war. true or false there is a half hour of silen...

Konu

Spanish, 04.08.2019 18:40

¡el gimnasio es divertido! voy a temprano para ir mañana. a. despertarse b. despertarme c. me despierto...

Konu

Mathematics, 04.08.2019 18:40

There is a negative correlation between the number of year in college and earnings....

Konu

History, 04.08.2019 18:40

1.how can the united states government best be described? a. democratic and unitary b. autocratic and confederate c. democratic and federal...

Konu

Spanish, 04.08.2019 18:40

When expressing a deadline or due date in spanish how do you say for monday. a. por la mañana b. por la tardec. para mañanad. para el lunes...

Konu

Mathematics, 04.08.2019 18:40

Evan’s mother used 1/3 pound of beef 1/2 pound of shrimp and 3 pounds of pasta to make dinner for 4 people each person will receive an equal share of beef with none leftover. what...

Konu

History, 04.08.2019 18:40

The fugitive slave law was meant to slaves escape t or f...

Konu

Computers and Technology, 04.08.2019 18:40

Is an example of a locally installed email client. a. aol b. thunderbird c. yahoo mail d. gmail...

Other tasks in the category: Business More task