Question

Nalu and Kamaile take-out a mortgage in the amount of $260000 to purchase an apartment as...

Nalu and Kamaile take-out a mortgage in the amount of $260000 to purchase an apartment as their principal place of residence. They are able to obtain a 15-year mortgage at a fixed rate of 6%. Below, you will be asked for the amount of their monthly payment and for a aggregated amount of interest that they paid.

Clearly, this is a TVM (time value of money) problem, so get started by completing the table of "TVM Basic Data"

c n i pv pmt fv

Which TVM Factor must be used to solve this problem?

  • Present value of 1

  • Present value of an ordinary annuity of 1

  • Present value of an annuity due of 1

  • Future value of 1

  • Future value of an ordinary annuity of 1

  • Future value of an annuity due of 1

What is the value of that factor?

What is their monthly payment?

The (dollar) amount of interest paid on a mortgage annuity for a principal residence is tax-deductible. Suppose that their mortgage annuity was issued on November 1. In order to determine the amount of their interest deduction, write-out the first two lines of the amortization table of their mortgage annuity. Include dollar signs only for amounts in the first row (n = 1) For rows below the first, do not include dollar signs.

n Outstanding Principal INTEREST Amount Excess PMT
1
2

What is there deduction for interest for this mortgage annuity in the year that it was issued?

Homework Answers

Answer #1

As per rules I am answering the first 4 subparts of the question

1: c= 12

N = 15

I=6

Pv = 260000

FV = 0

PMT = ?

2: Present value of an ordinary annuity of 1

This problem involves calculation of the annuity which is the monthly payment for a loan of 260000 which represents the present value of the annuity.

3: Value of the factor = (1-1/(1+rate)^number of terms)/rate

=1 divided by (1-1/(1+0.06/12)^(15*12))/ (0.06/12)

=1/118.5035

=0.008439

4: Monthly payment = PV * Value of the factor

= 260000*0.008439

= 2194.14

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Mandy would like to buy an apartment and needs a mortgage for $280,000. She was able...
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...
Make an amortization table to show the first two payments for the mortgage. Amount of mortgage...
Make an amortization table to show the first two payments for the mortgage. Amount of mortgage = $407,579 Annual Interest rate = 5.00% Years in mortgage = 35 Monthly payment = $2057.00 Month 1 Monthly Payment = 2057.00 Interest = $___ Principal = $___ End-of-month principal = $___ (Round to the nearest cent as needed.) Month 2 Monthly Payment = 2057.00 Interest = $___ Principal = $___ End-of-month principal = $___ ?(Round to the nearest cent as? needed.)
Juliet has a 10-year mortgage of $500,000 with an interest rate of 3.5% APR, compounded quarterly....
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...
3. You take a $500,000 mortgage to buy a vacation home. The mortgage entails equal monthly...
3. You take a $500,000 mortgage to buy a vacation home. The mortgage entails equal monthly payments for 10 years, 120 payments in all, with the first payment in one month. The bank charges you an interest rate of 9.6% (APR with monthly compounding). a. How much of your first payment is interest, and how much is repayment of principal? b. What is the loan balance immediately after the 10th payment? (Calculate the loan balance using the annuity formula.) c....
I was looking at the solution to the following question on this site. I could not...
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...
A. Julio has taken out a 25-year mortgage for $82,000.       The interest rate is 8.5%...
A. Julio has taken out a 25-year mortgage for $82,000.       The interest rate is 8.5% and the down payment is 20%.       Calculate the monthly payment. Purchase Price $82,000.00 Interest Rate 8.5% Length of Loan in Years 25 Down Payment Percent 20% Down Payment Amount Financed Units Factor 8.0528 Monthly Payment B. Complete the amortization schedule for the first three months of Julio’s mortgage. Month Monthly Payment Interest Portion Principal Portion Loan Balance ––––– ––––– ––––– ––––– 1 2...
Please create a Variable Interest Rate Loan Amortization schedule with the columns: Year, Amount owed on...
Please create a Variable Interest Rate Loan Amortization schedule with the columns: Year, Amount owed on the principal at the beginning of the year, Annuity payment, Interest portion of the annuity, Repayment of the principal portion of the annuity, outstanding loan balance at year end For the following: You obtain a $6,000 loan from a furniture dealer at a variable interest rate. The loan payments is adjusted every year based on the annuity amount implied by interest rate of year...
​(Components of an annuity​ payment) You take out a 25​-year mortgage for ​$280 comma 000 to...
​(Components of an annuity​ payment) You take out a 25​-year mortgage for ​$280 comma 000 to buy a new house. What will your monthly payments be if the interest rate on your mortgage is 7 ​percent? Use a spreadsheet to calculate your answer.  ​Now, calculate the portion of the 108th monthly payment that goes toward interest and principal. Use five decimal places for the monthly interest rate in your calculations?
You buy a $200,000 house and have a 20% down payment (hence the mortgage is for...
You buy a $200,000 house and have a 20% down payment (hence the mortgage is for $160,000). A 15 year mortgage has a rate of 3.5% and 0 points. The monthly mortgage payment is $1,143.81. How much (give the dollar amount) of the first month’s mortgage payment pays off principal on the mortgage? To answer, first compute how much of the first month’s payment is used to pay interest. Then, the remainder of the mortgage payment is used to pay...
An individual borrows $100,000 for 30 years at a simple annual rate of interest of 3...
An individual borrows $100,000 for 30 years at a simple annual rate of interest of 3 percent. Payments are in the form of a monthly regular or ordinary annuity. 1. What is the payment on principal at the end of the first month? 2. What is the dollar amount of each monthly regular or ordinary annuity payment? a. $422.66 b. $421.60 c. $420.55 d. $171.60