Calculate present worth of the weekly payment

Assignment Help Business Management

Reference no: EM133650050

Question

Your friend asks you if you would rather have 1 million dollars now or 5000 dollars for the rest of your life.

As a good friend, you immediately open Excel analysis and back your claim with evidence.

Assume that TVOM is fixed at 4.74 percent APY with weekly compounding over the analysis period.

Inflation is assumed to be relevant over the analysis period but the value is unknown.

1. Using a 2D data table, calculate the present worth of the weekly payment for a given weekly period and inflation values.

Use a range of 0 to 300 weeks with 6 week spacing.

Use inflation values of 2 percent, 5 percent, and 10 percent.

2. Create proper line plot of your data table.

Reference no: EM133650050

Questions Cloud

Calculate the corresponding cycle service level : The store manager reorders when the inventory is 650. What is the z-value you need to use to calculate the corresponding cycle service level?

What is the semi-annual coupon amount : Evergreen Inc. has issued a semi-annual coupon bond. What is the semi-annual coupon amount? What is the price of this bond?

Show how the funds will be distributed : show how the funds will be distributed to each media you've chosen. Please include a detailed, itemized breakdown of your budget in the appendix

Which do you think would have the better result : Which do you think would have the better result - meaning more cars sold within six months as a result of marketing efforts (aka improved ROI for marketing

Calculate present worth of the weekly payment : Calculate the present worth of the weekly payment for a given weekly period and inflation values. Create proper line plot of your data table.

Describes how green ocean cruises are more relaxing : Describes how Green Ocean cruises are more relaxing than traditional ones. This email failed to generate the response rate they were hoping

What role does power play in the text we call history : What role does power play in the text we call history? How does history influence intercultural interactions? Use at least one example.

Why people buy the products : Why people buy the products? What drives them to purchase one product and not another? In general, we can say that people "hire" the products to do a specific

Why is seagate undertaking this transaction : Why is Seagate undertaking this transaction? Is it necessary to divest the Veritas shares in a separate transaction?

User Account

All Pages