Question

**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 10 years at 10%

$300 per year for 5 years at 5%

$600 per year for 5 years at 0%

A 4 Find the
*present value* of the following ordinary annuities:

$600 per year for 10 years at 10%

$300 per year for 5 years at 5%

$600 per year for 5 years at 0%

Answer #1

**A1)Future Value of Deposit** = Deposit*(1 + r)^n
= 12,000 x (1 + 10%)^7 = $23,384.60

N=No of periods

R= rate of interest per period

**A2)Present Value of Security**= Future value / (1
+ r)^n = 10,000 / (1 + 8%)^20 = $2,145.48

**A3) Future Value of Ordinary Annuity**

Formula Amount=P(1+r)^{n}-1 / r

a. N = 10, PMT = 600, r = 10%, PV =

Future Value =600(1+.10)^{10}-1/0.1= $9,562.45

b. N = 5, PMT = 300, r = 5%, Future Value
=300(1+.05)^{5-}1/0.05= $1,657.69

c. N = 5, PMT = 600, r = 0%, Future Value =600*5= $3,000.00

A4) **Present Value of ordinary Annuity**

a. N = 10, PMT = 600, r = 10%,Present Value=600*6.14456 = $3,686.74

b. N = 5, PMT = 300, r = 5%, Present Value=300*4.32947= $1298.84

c. N = 5, PMT = 600, r= 0%, Present Value=600*5= $3,000.00

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:
a. $600 per year for 10 years at 10% b. $300 per year for 5 years
at 5% c. $600 per year for 5 years...

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

PRESENT VALUE
OF AN ANNUITY
Find the present
values of these ordinary annuities. Discounting
occurs once a year. Round your answers to the nearest cent.
$600 per year for 10
years at 6%.
$
$300 per year for 5
years at 3%.
$
$800 per year for 10
years at 0%.
$
Rework previous parts
assuming that they are annuities due. Round your answers
to the nearest cent.
$600 per year for 10
years at 6%.
$
$300 per year...

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?

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

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

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

PRESENT VALUE OF AN ANNUITY Find the
present values of these annuities. First assume they are
ordinary annuities, then assume they are annuities
due
Compounding occurs once a year.
$400 per year for 10 years at 10%
$200 per year for 5 years at 5%
$400 per year for 5 years at 0%

ITS AN EXCEL PROBLEM, PLEASE ATTACH SCREENSHOT OF EXCEL OR
EXPLAIN THE EXCEL FORMULAS YOU USED
Suppose a company is about to start
the following project, where all the dollar figures are in
thousands of dollars. In year 0, the project requires a fixed cost
of $12,000. The fixed costs is depreciated on the straight-line
basis over five years, and there is a salvage value of $1,500 in
year 5. The sales generated in years 1-5 are estimated to be...

Present value of a annuity. Find the present values of these
ordinary annuities. Discounting occurs once a year.
$400 per year for 10 years at 10%.
$200 per year for 5 years at 5%.
$400 per year for 5 years at 0%.
REWORK PARTS A,B,C assuming they are annuities due.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 5 minutes ago

asked 7 minutes ago

asked 36 minutes ago

asked 39 minutes ago

asked 51 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago