using ecxel functions Bill Blum needs $40,000 6 years from today to attend V.P.R. Tech. How...

using ecxel functions

Bill Blum needs $40,000 6 years from today to attend V.P.R. Tech.

How much money must Bill put in the bank today (8% quarterly) to reach his goal?

3.

Column1	FV	Time	Rate	Table Period	Rate Used	PV Factor	PV amount
question 1	$9,000	7 years	2.5% semi annual
question 2	$20,000	20 years	4% annually

Expert Solution

jeff jeffy answered 2 years ago

Assume the appropriate discount rate is 6%. What is the value 6 years from today of...

Assume the appropriate discount rate is 6%. What is the value 6 years from today of an annuity that makes payments of $3,000 per year if the first payment is made 7 years from now and the last payment is made 12 years from now?

Assume the appropriate discount rate is 6%. What is the value 6 years from today of...

Assume the appropriate discount rate is 6%. What is the value 6 years from today of a perpetual stream of $3,000 payments that begins 7 years from today? Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit any commas and the $ sign in your response. For example, an answer of $1,000.50 should be entered as 1000.50.

Assume the appropriate discount rate is 6%. What is the value 6 years from today of...

Assume the appropriate discount rate is 6%. What is the value 6 years from today of an annuity that makes payments of $3,000 per year if the first payment is made 7 years from now and the last payment is made 12 years from now?

You can buy a 1 year UST today at 1%, or a 6 month bill today...

You can buy a 1 year UST today at 1%, or a 6 month bill today at 1% - which do you choose, and what are your implicit assumptions about the direction of short term rates over the next few months? What is the 6 month rate, 6 months forward called and why is it important?

How much needs to be invested today if your goal is to have $100,000 five years...

How much needs to be invested today if your goal is to have $100,000 five years from today? The return on the investment is expected to be 10% and will be compounded semi-annually. (Use Table 1) (Round "PV Factor" to 4 decimal places and final answer to nearest dollar amount.) $61,390 $62,090 $66,667 $50,000 2. The following is a partial list of account balances from the books of Probst Enterprise at the end of 2010: Accounts payable $ 20,500 Accounts...

You have won $10,000 today, $20,000 three years from today, and $60,000 eight years from today....

You have won $10,000 today, $20,000 three years from today, and $60,000 eight years from today. As an alternative, you can receive your winnings as a 10-year annuity with the first payment received four years from today. If you require a 6% return on your investment, how much must the annuity pay you each year for you to select that option?

Question

using ecxel functions Bill Blum needs $40,000 6 years from today to attend V.P.R. Tech. How...

Solutions

Expert Solution

Related Solutions

Assume the appropriate discount rate is 6%. What is the value 6 years from today of...

Assume the appropriate discount rate is 6%. What is the value 6 years from today of...

Assume the appropriate discount rate is 6%. What is the value 6 years from today of...

You can buy a 1 year UST today at 1%, or a 6 month bill today...

How much needs to be invested today if your goal is to have $100,000 five years...

You have won $10,000 today, $20,000 three years from today, and $60,000 eight years from today....

How much would you have to invest today to receive: a. $100,000 in 6 years at...

Martha's paycheck of $1,371 will arrive in 6 days, but she needs money today. If a...

If you save $500 today, $1,000 a year from today, and $2,000 two years from today...

If you invest $4,000 today, how much will you have in 5 years at 6% (compounded...