Question

In: Finance

Question 1 (a)] Find the monthly payment on a $300,000 mortgage quoted at 14 percent and...

Question 1 (a)]

Find the monthly payment on a $300,000 mortgage quoted at 14 percent and amortized over 25 years.

(b) Someone promises to pay you $1,000,000 every year (at the end of the year) for the next 15 years. The first payment will be one year from today. The relevant effective annual interest rate is 7.0%. What does the time line look like for this problem? What would you pay, today, for this promise?

(c)   Show that the answer in Example 5 is the same as the difference between the present value of the following two perpetuities:

  • Perpetuity 1 pays $1,000,000 at the end every year with the first payment made in 1year.
  • Perpetuity 2 pays $1,000,000 at the end every year with the first payment made in 16years.

The relevant annual effective interest rate is 7.0%.

(d) You are quoted an interest rate of 12% per annum compounding semiannually. What is the equivalent effective annual interest rate? What is the equivalent per annum interest rate compounding monthly?

(e)   You expect to receive $10,000 as a bonus after 5 years on the job. You have calculated the present value of this bonus and the answer is $8000. What discount rate did you use in your calculation?

(f) Suppose you borrow $10,000 at the annual interest rate of 9%, and you are required to pay it back in 60 equal monthly installments, the first one is due at the end of the first month. How much is the monthly installment?

(g) You want to buy a piece of land for $12,000 cash. The owner would allow you to pay for it in six annual installments of $2300 each, the first one right now. Which method is cheaper for you if the time value of money is 12%?

Solutions

Expert Solution

Answer 1(a)

First of all we have to find the Annuity factor of 14% on monthly compounding basis for 25 years

monthly rate is 14%/12 = 1.167 and total months are 25 x 12 = 300 months

Annuity factor of 1.167% for 300 month is =1/(1+r)1+1/(1+r)2+1/(1+r)3......... up to 1/(1+r)300

=83.052

monthly payment = $300,000/83.052 = $ 3,612.29

Answer 1(b)

For this we have to calculate the present value of the total cash in flow at interest rate of 7% for 15 years

formula for this = cash in flow x P.V. annuity factor for 15 year @7%

Year P V Factor Amount   PV of Amount
1 0.935 10,00,000.00       9,35,000.00
2 0.873 10,00,000.00       8,73,000.00
3 0.816 10,00,000.00       8,16,000.00
4 0.763 10,00,000.00       7,63,000.00
5 0.713 10,00,000.00       7,13,000.00
6 0.666 10,00,000.00       6,66,000.00
7 0.623 10,00,000.00       6,23,000.00
8 0.582 10,00,000.00       5,82,000.00
9 0.544 10,00,000.00       5,44,000.00
10 0.508 10,00,000.00       5,08,000.00
11 0.475 10,00,000.00       4,75,000.00
12 0.444 10,00,000.00       4,44,000.00
13 0.415 10,00,000.00       4,15,000.00
14 0.388 10,00,000.00       3,88,000.00
15 0.362 10,00,000.00       3,62,000.00
   91,07,000.00

Today we will pay $ 91,07,000.00

time line

Beginning 1 year 2 year 3 year 4 year 5 year 6 year 7 year 8 year 9 year 10 year 11 year 12 year 13 year 14 year 15 year
$ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac $ 10 lac

Answer 1(d)

Compunding Interest Rate = (1+(R/100))n -1

here, R = Rate of interest (in our care R=6% ( i.e. 12% / 2)

n= time, (in our case n=2 as the interest rate is compounding on monthly basis)

then by applying the above formula = (1+(6/100))2 -1 = 12.36%

For monthly compounding the n = 12

and the interest rate = 12% /12 = 1%

= 1+(1/100))12 -1 = 12.68%

Answer 1(e)

Present Value of money = PV= FV/(1+r)n

then, 8000 = 10000/ (1+r)5

(1+r)5 = 10000/8000

1+r = (1.25)1/5 = 1.0456

now r = 4.56%

Answer 1(f)

First of all we have to calculate the annuity factor of the 0.75% (i.e. 9%/12 as the repayment on monthly basis) for 60 month

= 1/ (1+r)1 + 1/(1+r)2 .......... up to 1/(1+r)60  = 48.173

Now the amount of installment is = Loan amount / Annuity factor

=$10000/48.173 =$ 207.585 (approx.)

Answer 1(g)

In this case at 1st option total outflow of cash = $12000.00

At 2nd option our outflow of cash = 10591.50

Year PV factor Installment Adjusted Cash Outflow
1 1.0000       2,300.00         2,300.00
2 0.8930       2,300.00         2,053.90
3 0.7970       2,300.00         1,833.10
4 0.7120       2,300.00         1,637.60
5 0.6360       2,300.00         1,462.80
6 0.5670       2,300.00         1,304.10
      10,591.50

Hence in the given situations the 2nd option is profitable as it has less cash out flow as compare to 1st case.

Note : 1st installment given at starting of the year than here PV Factor = 1

and the 2nd installment given at starting of the 2nd year which is equal to end of 1year

Answer 1 (c)

as the given question have any 5 no example and it seems that it is 2 nd part of the same, which is not provided in the given question. so we have incomplete information to solve the said problem.


Related Solutions

What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an...
What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an interest rate of 5.125 percent. A friend who knows you have studied amortization asks your help to find the interest portion of their house payments for tax purposes (assuming they itemize). The monthly payments are $2,107.02 on a 30 year loan with a 5 percent interest rate. a) What was the total amount of interest paid during year 2? b) At what point in...
What is the monthly payment required to fulling amortize a $300,000 mortgage loan over a 30...
What is the monthly payment required to fulling amortize a $300,000 mortgage loan over a 30 years at an intrest rate of 3.5% annual rate compound monthly? $1,244 $1,367 $1,482 $1,390 $1,344
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years?
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years.
Find the monthly PITI payment for a mortgage of $93,500 at a rate of 9.25% for...
Find the monthly PITI payment for a mortgage of $93,500 at a rate of 9.25% for 25 years with annual property taxes and hazard insurance premium of $3,750 and $687 respectively.
1.(Level-Payment Mortgages) Compute the monthly payment on a 30-year level payment mortgage assuming an annual mortgage...
1.(Level-Payment Mortgages) Compute the monthly payment on a 30-year level payment mortgage assuming an annual mortgage rate of 5% and an initial mortgage principal of $400,000. (2147.29) 2.(Mortgage Pass-Throughs) Consider a $400 million pass-through MBS that has just been created (so the 'seasoning' of the pass-through is equal to 0). The underlying pool of mortgages each has a maturity of 20 years and an annual mortgage coupon rate of 6%. The pass-through rate of the mortgage pool is 5%. Assuming...
Monthly Mortgage Payments The average monthly mortgage payment including principal and interest is 982 in the...
Monthly Mortgage Payments The average monthly mortgage payment including principal and interest is 982 in the United States. If the standard deviation is approximately 180 and the mortgage payments are approximately normally distributed, find the probabilities. Use a TI-83 Plus/TI-84 Plus calculator and round the answers to at least four decimal places. (a) (a)The selected monthly payment is more than $1400 (a)The selected monthly payment is more than 1400 P(Z>1400)= 2) Prison Sentences The average prison sentence for a person...
Calculate the monthly payment on a $220,000 mortgage if payment is made at the beginning of...
Calculate the monthly payment on a $220,000 mortgage if payment is made at the beginning of each month, and the annual interest rate is 3.75 percent for 20 years. Group of answer choices $1,304.35 $1,300.29 $1,319.25 $1,355.65
Find the monthly payment needed to amortize principal and interest for each fixed-rate mortgage for a...
Find the monthly payment needed to amortize principal and interest for each fixed-rate mortgage for a $220,000 at 4.5% interest for 30 years.
Assuming a 5/1 ARM, calculate the monthly mortgage payment on a 30 year $200,000 mortgage with...
Assuming a 5/1 ARM, calculate the monthly mortgage payment on a 30 year $200,000 mortgage with an initial rate of 2.75%, a rate of 4% at the time of the first adjustment, a rate of 5% at second adjustment and a rate of 4% at the third adjustment.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT