Question

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?

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.00033^{360n} = 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.

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 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 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 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 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 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 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.
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 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 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.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 9 minutes ago

asked 15 minutes ago

asked 15 minutes ago

asked 15 minutes ago

asked 30 minutes ago

asked 30 minutes ago

asked 42 minutes ago

asked 55 minutes ago

asked 55 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago