Question

Please write formulas and not solve in excel, i need to hand write and show work on the test.

1. You invested $100 in investment B for 2 years, and $100 in
investment B for 1 year. Your rate of return for both years was
exactly the same. If at the end of the 2 years the money grew to
$215.25.

**What was your compound return**?

2. You invested $100 in investment A, Year 1 it grew by 10%,
Year 2 by -5%, Year 3 by 7%, and Year 4 by 9%.

**What was the compound return for this
investment**?

Answer #1

Any query in this then comment below.. i will explain you..

Please show formulas in Excel or work - My formulas keep getting
an Error and I don't know what I am doing wrong.
You want to compare two separate retirement savings scenarios:
(A) and (B). In scenario (A) you start immediately, contribute
for a few years, but then stop contributing. However, you leave
the accumulated savings to compound until retirement. In
scenario(B) you start later (after the end of savings in
scenario A) and contribute all the way to retirement....

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 the work in
excel be sure to use appropriate formulas to solve
each exercise or problem.
A1 If you deposit $12,000 in a bank
account that pays 10% interest annually, how much will be in your
account after 7 years?
A2. What is the present
value of a security that will pay $10,000 in 20 years at an
interest rate of 8%?
A3.
Find the future value of the following ordinary
annuities:
$600 per year for...

Show the work with formulas step by step
please.
- How many years will it take for $100,000 to grow to $500,000
if it is invested at an annual interest rate of 9.15%? Round to the
nearest 0.01.
- You are told that if you invest $5,000 per year for 35 years
you will have accumulated $1,000,000. What is the annual rate of
return on the latter investment? Round to the nearest 0.01%.

Show work through excel using formulas: but please actually show
each step you use to do it on excel!
1. Assume you have taken out a balloon mortgage loan for
$2,500,000 to finance the purchase of a commercial property. The
loan has a term of 5 years, but amortizes over 25 years. Calculate
the balloon payment at maturity (Year 5) if the interest rate on
this loan is 4.5%.
A. $5,637.99 B. $13, 895.82 C. $2,196,447.59 D.
$2,495,479.19

Show the work with formulas.
- How many years will it take for $100,000 to grow to $500,000
if it is invested at an annual interest rate of 9.15%? Round to the
nearest 0.01.
- You are told that if you invest $5,000 per year for 35 years
you will have accumulated $1,000,000. What is the annual rate of
return on the latter investment? Round to the nearest 0.01%.

Must show all work and be in EXCEL format-formulas must be
shown
Frenchies, Inc. is considering a major investment. The
investment will have an initial cost of $630,000 and will be
depreciated straight-line to a zero book value over the life of the
project. The cash inflows generated by the project are estimated at
$255,000 for the first three years and $25,000 for the following
five years. What is the internal rate of return?

Please SHOW YOUR Calculations and formulas in
Excel
A shareholder’s group, in lodging a protest, claimed that the
mean tenure for a chief executive officer (CEO) was at least 9
years. A survey of companies reported in the Wall Street Journal
found a sample mean tenure of ?̅= 7.27 years for CEOs with a
standard deviation of 6.38 years.
1) Formulate a hypothesis that can be used to challenge the
validity of the claim made by the shareholder’s group.
2)...

Please show all calculations and formulas. If using Excel (or
tables), please show data, formulas, etc.
Practice question 14:
Calculate the company’s w.a.c.c. using the info
below.
***assume this is a corporate bond that pays 2x annually when
calculating the PV of the bond
Harvey LLC’s capital structure consists of a 25-year bond issued
5 years ago with a coupon of 6% and a par value of $14,000,000. The
company’s main competitor just issued a similar bond paying 5%. The...

Write out the formulas, with the numbers filled in, to solve the
following problems. You do not have to do the actual calculations.
Find the yield-to-maturity of a zero-coupon 10-year bond (par =
$1,000) with a price of $622.44. (4 points). Find the present value
of an investment that has three payments: $400 in two years, $500
in four years and $600 eight years from today. The relevant market
interest rate is 4.20%. Find the future value of $100 invested...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 39 seconds ago

asked 40 seconds ago

asked 5 minutes ago

asked 5 minutes ago

asked 8 minutes ago

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 30 minutes ago