Checkout
checkout
view
Your Cart Your Cart: item(s)
View Details $1.99 Download Add to Cart

Determining the future value of a savings bond using Excel.

How do I set this problem up in a spreadsheet? You have just made your first $20,000 contribution to your individual returment account. Assuming you earn an 11% rate of return and make no additional contributions, what will your account be worth when you retire in 45 years? What if you wait 10 years before contributing?

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2353

OTA ID:

102850

View Details $1.99 Download Add to Cart

Calculating which investment option has the higher present value.

Investment X offers to pay you $2,000 per year for 10 years, whereas Investment Y offers to pay you $4,000 per year for 4 years. Which of these cash flow streams has the higher present value if the discount rate is 5%? If the discount rate is 15%?

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2354

OTA ID:

102887

View Details $1.99 Download Add to Cart

Determining the annuity present value.

An investment offers $5000 per year for 15 years, with the first payment occurring 1 year from now. If the required return is 10%, what is the value of the investment?

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2355

OTA ID:

102850

View Details $1.99 Download Add to Cart

Determining the perpetuity values of a policy.

Blue Grass Life insurance is trying to sell you an investment policy that will pay you and your heirs $10,000 per year forever. If the required return on this investment is 12%, how much will you pay for the policy?

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2356

OTA ID:

102850

View Details $1.99 Download Add to Cart

Calculating the present value of an investment that is compounded daily.

An investment will pay you $45,000 in 6 years. If the appropriate discount rate is 8% compounded daily, what is the present value? Solve using a spreadsheet.

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2357

OTA ID:

102887

Page generated in 0.3554 seconds

About Us ·  Contact Us ·  Samples ·  Solutions ·  Legal Terms and Conditions ·  Privacy Policy

©2008 SolutionLibrary.com

Search for Solutions About Us Samples