Question

Juliet has a 10-year mortgage of $500,000 with an interest rate of 3.5% APR, compounded quarterly. Mortgage payments are made at the beginning of each month. What is the balance remaining on this mortgage after the 60th payment? PLEASE DO NOT GIVE THE INCORRECT ANSWER of

Find first month rate as given rate is compounded quarterly (1 + r)^12 = (1 + 0.035/4)^4 r = (1 + 0.035/4)^(1/3) – 1 = 0.002908 = 0.2908% Set up the TVM parameters PV = $500,000, r = 0.002908, N = 120, FV = 0; compute PMT =? PV = 500,000 = (PMT/0.002908)*(1 – 1/1.002908^120) PMT = 4941.91 Monthly payment = $4941.91 Again setup the TVM parameters PV = $500,000, r = 0.002908, N = 60, PMT = 4941.91; compute FV =? PV = 500,000 = (4941.91/0.002908)*(1 – 1/1.002908^60) + FV/1.002908^60 FV = 271,724.92 Amount left after 60th payment = $271,724.92 Thank you.

Answer #1

Effective annual rate = (1+r/n)^n - 1

= (1 + 3.5% / 4)^4 - 1

= 3.5462%

Monthly rate = (1 + 3.5462%)^(1/12) - 1 = 0.2908%

PV = 500000

Nper = 10 * 12 = 120

FV = 0

Monthly pauments can be calculated by using the following excel
formula:

=PMT(rate,nper,pv,fv,beginning of the period)

=PMT(0.2908%,120,-500000,0,1)

= $4927.58

Monthly payments = $4927.58

Balance remaining on this mortgage after the 60th payment can be
calculated by using the following excel formula:

=PV(rate,nper,pmt.fv)

=PV(0.2908%,120-60,-4927.58,0)

= $270,936.98 or $270,937

**Balance remaining on this mortgage after the 60th
payment = $270,936.98 or $270,937**

How many years does it take for $1,000 grow to be
$1,500, if interest rate is 12% compounded monthly?
BGN or END MODE ( choose one ) P/Y =
N= ?
I/Y=
PV=
PMT=
FV=
CPT , N =
Can you explain how you computed it for compunded monthly.
2. How many years does it take for $1,000 to grow to be
$1,500, if interest rate is 12%?
BGN or END MODE ( choose one ) P/Y =
N= ?...

Ann gets a fully amortizing 30-year fixed rate mortgage with
quarterly payments for $1,000,000. The interest rate is 4%,
compounded quarterly. She prepays the mortgage in 1 quarter (i.e.
she makes the 1st payment and immediately prepays the remaining
balance).
There is still an origination fee of 2 points, but now Ann
decides to keep the mortgage for the whole term, i.e. she no longer
plans to prepay it. What is Ann’s APR?

1) Consider a $126,714 35-year mortgage with an interest rate of
8% compounded monthly.
a) Calculate the monthly payment.
b) How much of the principal is paid the first, 25th, and last
year?
c) How much interest is paid the first, 25th, and last year?
d) What is the total amount of money paid during the 35
years?
e)What is the total amount of interest paid during the 35
years?
f) What is the unpaid balance after 25 years?
g)How...

1. Julia purchased an investment grade gold coin today for
$375,000. She expects it to increase in value at a rate of 4.5%
compounded annually for the next 6 years. How much
will the coin be worth at the end of the sixth year?
N
I/Y
PV
PMT
FV
2. Moon has been investing $2,500 quarterly for the past 10
years in an equity mutual fund. How much is the fund worth now
assuming she has earned 8.5% compounded...

Mandy would like to buy an apartment and needs a mortgage for
$280,000. She was able to qualify for a loan at 7.2% for 30 years.
What is the amount of her monthly payment?
Use a spreadsheet program like Microsoft Excel. Start with a
blank worksheet.
In your spreadsheet, create a TVM DataFrame
TVM DataFrame
c
n
i
PV
PMT
FV
1
From the problem, fill-in the values for Mandy's mortgage
annuity into your spreadsheet. Place a question mark in...

The Begays finance $200,000 for a 30-year home mortgage at an
annual rate of 5% compounded monthly.
Find the monthly payment needed to amortize this loan in 30
years
Assume that the Begays make the payment found in part (a) every
month for 30 years, find the total interest they
will pay.
Suppose the Begays pay an extra 15% every month ( using Q=d+dr =
d + 15%d = (1+ 0.15)d = 1.15d).
Find the time needed to amortize the...

In
your answers, you should properly show your work by writing down
your entries into the calculator. For instance, if you use the TVM
worksheet of your financial calculator to compute how long it takes
to double your account balance given 5% annual interest rate, you
should write down your entries as: I/Y=5, PV=-1, PMT=0, FV=2, CPT
N=? --- the question mark here stands for your answer to the
question.
Question 6 – PV, Ordinary Annuity, Compounding [2 points]:
Find...

I was looking at the solution to the following question on this
site. I could not understand why use 12 when working out the NPER.
Since the monthly payments start 1 month after should you not use
11?
Question 3. (a) A family member is thinking about
funding his granddaughter’s university education in 8 years when
she is expected to enrol at UWI, St. Augustine. He opens a special
savings account, where he can receive a lump sum in 8...

1. A man has a loan of 50,000 in a bank that gives 12% simple
interest. How much is the interest if he plans to pay after 5
years?
2. A man can save 10,000 per month for 2years, If the bank
offers 5% compounded monthly, what is n?
3. A man has a loan of 50,000 in a bank that gives an interest
rate of 12% compounded quarterly? If he plans to pay after 6months,
how much is the...

Unlike the coupon interest rate, which is fixed, a bond’s yield
varies from day to day depending on market conditions. To be most
useful, it should give us an estimate of the rate of return an
investor would earn if that investor purchased the bond today and
held it for its remaining life. There are three different yield
calculations: Current yield, yield to maturity, and yield to
call.
A bond’s current yield is calculated as the annual interest
payment divided...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 3 minutes ago

asked 11 minutes ago

asked 14 minutes ago

asked 20 minutes ago

asked 23 minutes ago

asked 27 minutes ago

asked 29 minutes ago

asked 36 minutes ago

asked 51 minutes ago

asked 51 minutes ago

asked 51 minutes ago

asked 51 minutes ago