What is your annual compounded interest rate

Assignment Help Financial Management

Reference no: EM132036478

Use Excel to solve the following problems

i. You invest $ 5,000.00 8 years ago, and it is now $ 8,450.00. What is your annual compounded interest rate? (6.779).

ii. You deposit $ 4,500.00 in a bank earning 10% monthly compounded interest rate, how much will you have in 8 years?

iii. You deposit $25,000.00 in a deposit taking institution some time ago, earning 6% monthly compounded interest. It has grown to $ 48,500.00. How many years it took the money to grow to this level?

iv. Suppose you wind a lottery ticket which pays you $ 250,000.00 after tax. You would like to use some of this money to pay for your child's educational expenses for the next 6 years.

The educational expenses will be $ 25,000.00 per year for the next 6 years. If the annual compounding interest is 6%, how much do you need to deposit today to be able to cover the expenses for your child in the next 6 years (assuming that you will pay for all expenses once a year, i.e., this is an annuity)?

Reference no: EM132036478

Questions Cloud

How many pounds would you receive : How many pounds would you receive for 50,000 euros on 2/19? Round intermediate steps to four decimals and your final answer to two decimals.

Calculate the expected monetary values : Calculate the Expected monetary values for the three options and give the recommendation based on EMV.

Develop a compelling strategy and proposal for the NFL : Develop a compelling strategy and proposal for the NFL and NBA to expand their operations and teams into three global markets

How many new boards per month will they need to sell : If the fixed costs stay at $5300 and they want to have at least $1000 per month in profit how many boards should they sell?

What is your annual compounded interest rate : You deposit $ 4,500.00 in a bank earning 10% monthly compounded interest rate, how much will you have in 8 years?

Determine the monthy mortgage payment : Determine the monthyl mortgage payment on a $150,000 mortgage if the Sampsons obtain a new mortgage at the 4.9% interest rate.

Evaluate each of the following statements : Financial statements do not need to be analyzed because the numbers speak for themselves.

How many of the september contracts are currently open : How many of these contracts should you sell if you wish to deliver 85,000 bushels of corn in September?

Calculate the investors before-tax irr : Calculate the investor's before-tax IRR. Show and explain all calculations. Should the building be purchased? Why or why not?

User Account

All Pages