Question

In: Finance

For Problems 1-3: Use the TVM solver on the calculator as needed, fill in the information...

For Problems 1-3: Use the TVM solver on the calculator as needed, fill in the information from the calculator.

The Taylor’s have purchased a $270,000 house. They made an initial down payment of $40,000 and secured a 30-year mortgage with interest charged at the rate of 6% per year compounded monthly.

  1. What monthly payment will the Taylors be required to make?

Work Here (Keyboard only):

_____________________________________________

N =

FV =

I% =

P/Y =

12

PV =

C/Y =

12

PMT =

PMT:

(End/Begin)

End

Answer Here (Keyboard only):

Calculator display:

  

Final Answer:

  1. What is their outstanding balance after 10 years?

Work Here (Keyboard only):

N =

  

FV =

  

I% =

P/Y =

12

PV =

C/Y =

12

PMT =

PMT:

(End/Begin)

End

Answer Here (Keyboard only):

Calculator display:

Final Answer:

  1. What is their equity after 10 years?

Work Here (No images of written work):

  

Answer Here (No images of written work):

  


Solutions

Expert Solution

1)

N = 30*12=360

FV = 0

I% = 6/12= 0.5

P/Y = 12

PV = - (270000-40000)= -230000

C/Y = 12

End

PMT = 1378.97 (Monthly payment)

2)

N = 360-120=240  

FV = 0

  I% = 0.5

P/Y = 12

C/Y = 12

PMT = -1378.97

End

Solve for PV as 192477.17 (Loan outstanding after 10 years)

3) Equity on the house= Down payment + (Loan taken-Loan outstanding)

= 40000+ (230000-192477.17)

= $ 77522.83


Related Solutions

3. Use both the TVM equations and a financial calculator to find the following values. (Hint:...
3. Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used...
Use both the TVM equations and a financial calculator to findthe following values. (Hint: If...
Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in...
Use both the TVM equations and a financial calculator to find the following values. (Hint: If...
Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in...
Use both the TVM equations and a financial calculator to find the following values. Round your...
Use both the TVM equations and a financial calculator to find the following values. Round your answers to the nearest cent. (Hint: Using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure...
Present Value. Use a calculator for each of these problems. (a) You are moving to Bozeman...
Present Value. Use a calculator for each of these problems. (a) You are moving to Bozeman and you are going to stay here forever. You would like to find an apartment. You can either buy it or rent it. The monthly rent is $500 and the monthly interest rate is 0.1%. Alternatively, you can purchase the apartment, paying $600,000. How are you going to finance your new accommodation? Argue using the PV formula. (b) You take a loan to buy...
Assignment - Fill in the blanks Use the information provided in Kinn's Chapter 3 "Legal Principles"...
Assignment - Fill in the blanks Use the information provided in Kinn's Chapter 3 "Legal Principles" of the text and/or any other sources you have. Copy and Paste your assignment on a separate MS word document or compatible file, and submit your completed assignment electronically via Moodle prior to due date. Please highlight your answers. Word Pool • implied contract • patient abandonment • insurer • contract • premium • third party • minor • liable • expressed contract •...
Use calculator or Excel to solve the following problems. DO NOT USE MINITAB (except e). Do...
Use calculator or Excel to solve the following problems. DO NOT USE MINITAB (except e). Do NOT use Excel built-in functions or solvers (except t.inv() and f.inv() to obtain critical t and f values). The tensile strength of Portland cement is being studied. Four different mixing techniques can be used economically. A completely randomized experiment was conducted and the following data were collected: Technique Tensile Strength Tensile Strength Tensile Strength Tensile Strength 1 3129 3000 2865 2890 2 3200 3300...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s stock...
Use the information in problems 2 and 3 to complete the following 2-trait cross.             A...
Use the information in problems 2 and 3 to complete the following 2-trait cross.             A male, raised-nose sasquatch is heterozygous for nail color. A flat-nosed, black-nailed female sasquatch who is heterozygous for nose bridge form and is homozygous for nail color. a. What are the genotypes of the male and female sasquatches? b. Report all possible genotypes of potential offspring. Give the phenotype for each genotype. c. Calculate the expected genotype ratio and the expected phenotype ratio for the...
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use...
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use interim rounding, state your answers as positive values, to two decimal places for dollar or period values and four places for percentages stated as decimals; do not label answers with symbols such as $ or %. For example, “10.5%” should be input as “.1050” 1. Jacinda Herschel wants to buy a car and determines she can afford to pay $295.02 a month for a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT