Question

PLEASE SHOW WORK AND NO EXCEL! THANK YOU A deposit of $800,000 is made in February...

PLEASE SHOW WORK AND NO EXCEL! THANK YOU

A deposit of $800,000 is made in February 25, 2011. By what date the deposit will be worth $1.2M at 12% compounded annually? What would be the answer if interest was compounded daily? (Use 1 year=360 days.) Why does this date come earlier?

Homework Answers

Answer #1

The future value of the investment is calculated as follows

FV = Present value ( 1+interest rate)n

$ 1,200,000 = $ 800,000 ( 1+0.12)n

( 1+0.12)n = 1.5

n = 3.58 years

or by September 24, 2014 the deposit would be worth $ 1.2 million

________________________________________________________________________

If the interest was compounded daily

$ 1,200,000 = $ 800,000 [ (1+(0.12/360))360t  ]

1.00033360n = 1.5

360n ln 1.00033 = ln 1.5

n = 3.41 years

or on July 23, 2014 the desposit would be equal to $ 1.2 million

This date comes earler because the number of compounding periods is higher.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You deposit $800K on February 25, 2011. When will the investment be worth $1.2M at 12%...
You deposit $800K on February 25, 2011. When will the investment be worth $1.2M at 12% interest compounded annually? What if the interest were compounded daily with a standard conversion rate of 1 year = 360 days? Why is the second date earlier?
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...
Please show work, thank you in advance :) What is the present value of a semi-annual...
Please show work, thank you in advance :) What is the present value of a semi-annual ordinary annuity payment of $7,000 made for 12 years with a required annual return of 5%? $ 65,145 $128,325 $125,195 (correct) $ 62,043 You deposit $10,000 in a bank and plan to keep it there for five years. The bank pays 8% annual interest compounded continuously. Calculate the future value at the end of five years. $14,693 $15,000 $14,918 (correct) $14,500 What is the...
Please show all your work in Excel or written out. No graphing calculators thank you. At...
Please show all your work in Excel or written out. No graphing calculators thank you. At a large farm, the weights of all newborn pigs are recorded. Over the last 10 years, the daily rate has been in excess of 50 births per day. The mean and the sigma are listed below. Mu = 7.125 Sigma = 0.125 A.) What is the probability a baby pig born today will weigh 8 pounds or more? B.) What is the probability that...
Please show work step by step, no excel. Thank you! A machine that costs $10,000 new...
Please show work step by step, no excel. Thank you! A machine that costs $10,000 new can be replaced after being used from four to seven years. Annual maintenance costs are identical for all possible replacement cycles. The machine has a cost of capital of 12%. The alternative net salvage values at the end of four to seven years of use are, respectively, $3,800, $2,800, $1,000, and -$1,000. Ignoring taxes and inflation, what is the optimal replacement cycle?
Please show work step by step, NO EXCEL. Thank you! A2. (Recognize puts and calls) Indicate...
Please show work step by step, NO EXCEL. Thank you! A2. (Recognize puts and calls) Indicate whether the stock price, strike price, and exercise value given here are for a call option or a put option. stock price strike price exercise value type of option put or call? $65 $60 $0 25 20 5 15 30 15 97 105 0
You deposit $4,000 in the bank at the end of each year for 30 years. If...
You deposit $4,000 in the bank at the end of each year for 30 years. If the bank pays interest of 5.25% per annum, what amount will you have accumulated if interest is compounded: a. Annually b. Semi-Annually c. Quarterly d. Monthly e. Daily Please show all your work and explain your answers.
SHOW CLEAR WORK ON EXCEL A fully amortizing mortgage is made for $80,000 for 25 years....
SHOW CLEAR WORK ON EXCEL A fully amortizing mortgage is made for $80,000 for 25 years. Total monthly payments will be $900 per month. What is the interest rate on the loan?
Please use excel and show formulas used. Alice wants to deposit $35,000 now and at the...
Please use excel and show formulas used. Alice wants to deposit $35,000 now and at the end of 6 years she wants to deposit $45,000. The bank pays 10% interest compounded semiannually. For the first 6 years, she wants to withdraw an amount every year and for the following 4 years she wants to withdraw exactly $1000 more. What is the maximum amount she can withdraw in year 1?
On September 7, Simple Fitness opened a savings account with a deposit of $16,000. A withdrawal...
On September 7, Simple Fitness opened a savings account with a deposit of $16,000. A withdrawal of $5000 was made on October 12, and another withdrawal of $990 was made on November 20. The account earns 3.5% interest compounded daily. Find the balance on November 20 and the total interest earned through that date. Please include the formula used and supporting work.