Question

how do i solve this with excel and what function/s do i use Suppose you can...

how do i solve this with excel and what function/s do i use Suppose you can deposit $186.29 on each January 1st from 1988 through 1991, but you need $1000 on January 1, 1991. What interest rate with annual compounding must you have to achieve this goal?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You want to have $2.5 million in real dollars (HINT: it means we need to use...
You want to have $2.5 million in real dollars (HINT: it means we need to use the real interest rate in the calculation) in an account when you retire in 40 years. The nominal return on your investment is 10.3% and the inflation rate is 3.7% (HINT: do not use the approximation when finding the real interest rate). What real amount must you deposit each year to achieve your goal? Can anyone solve this without using excel formulas? Thanks!
How to use excel function to solve this problem? Bill and Cathy will be retiring in...
How to use excel function to solve this problem? Bill and Cathy will be retiring in fifteen years and would like to buy an Italian villa. The villa costs $500,000 today, and housing prices in Italy are expected to increase by 6.5% per year. Bill and Cathy wants to deposit an equal amount at the end of every year so that they can buy this villa in 15 years.
In excel solve the following: 1.)What is the Future Value of an annual payment of 300,...
In excel solve the following: 1.)What is the Future Value of an annual payment of 300, for 5 years, with a rate of 3%: 2.) In what time, if I deposit B / .1000.00 are equivalent to B / .8,000.00, with 20% interest 3.)How much money would I have to deposit today, so that in 10 years I can withdraw B / .5,000.00, the bank pays me 2.5% interest.
In this part, calculate the present values. Use the Excel PV function to compute the present...
In this part, calculate the present values. Use the Excel PV function to compute the present values. You are committed to owning a $200,000 home. If you believe your mutual fund can achieve an annual return of 10 percent, and you want to buy the home in 15 years, how much must you invest today? Calculate the present values in the table below using the PV Excel function. Future value Years Interest rate Present value $19,500 16 6% ? $47,390...
Can you Solve it in Excel Please Today is your 25th birthday.  You have decided that it...
Can you Solve it in Excel Please Today is your 25th birthday.  You have decided that it is necessary to plan your own retirement since you are not confident that government benefits will be available when you retire.  You will make annual payments into an account earning 5% APY starting on your next birthday (26th) a year from now.  Your last payment will occur on your 70th birthday.  You have decided that you need to plan for payments of $500,000 per year and that...
i am trying to solve a past paper and we can't use any excel so have...
i am trying to solve a past paper and we can't use any excel so have to solve this question on paper. If the spot price of an underlying is $50 and its volatility is 20%. Interest rates are at 10% with continuous compounding. What is the fair price for a three month call option with a strike price of $52. Show and explain your calculations.
Assume that 4 years from now you will need $1,000. Your bank compounds interest at an...
Assume that 4 years from now you will need $1,000. Your bank compounds interest at an 8% annual rate. a. How much must you deposit 1 year from now to have a balance of $1,000 4 years from now? b. If you want to make equal payments at Years 1 through 4 to accumulate the $1,000, how much each of the 4 payments be? c. If your father were to offer either to make the payments calculated in part b...
How do you solve for covariance? Can you provide an example(s) on how to solve the...
How do you solve for covariance? Can you provide an example(s) on how to solve the following three problems: Cov(7X,Y)= Cov(X, 4Y)= Cov(.05X, .2Y)=
***Note need answer using Excel and also tell what function you used (PMT, PRICE, etc.) and...
***Note need answer using Excel and also tell what function you used (PMT, PRICE, etc.) and under WHAT CATEGORY i.e. FINANCE Listing a bunch of numbers for financial calculators is not a help, I use EXCEL only for these. Thanks! Haswell Enterprises' bonds have a 10-year maturity, a 6.25% semiannual coupon, and a par value of $1,000. The going interest rate (rd) is 10.5%, based on semiannual compounding. What is the bond's price? Select the correct answer. a. $735.42 b....
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for...
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for retirement in 40 years. You deposit $20,000 in a bank account today that pays 3.5% interest, compounded semiannually. You leave those funds on deposit until you retire. You also contribute $5,000 a year to a pension plan for 20 years and then you stop making contributions to the fund. You leave your money in the pension fund until you retire. The pension plan grows...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT