John and Peggy recently bought a house. They financed the house with a $195,000, 30-year mortgage...
John and Peggy recently bought a house. They financed the house with a $195,000, 30-year mortgage with a nominal interest rate of 7.47%. Mortgage payments are made at the end of each month. What total dollar amount of their mortgage payments during the first 5 years will go towards repayment of principal?
Homework Answers
SEE THE SCREENSHOT. ANY DOUBTS, HAPPY TO HELP YOU. THANK YOU. THUMBS UP PLEASE.
![Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard BG208 AY Font Alignment Number Cells AZ BA BC BD BE BF BG BH Bl BJ BK 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 LOAN YEARS RATE PMT 195000 30 7、47% 1359.46 [EXCEL PMT(BC197/12,BC196 12,-BC195)] PRESENT VALUE OF LOAN AFTER 5 YEARS YEARS LEFT LOAN BALANCE= 184449.02[EXCEL-PV(BC197/12,BC201*12,-BC 198)] 25 REPAYMENT OF PRINCIPAL IN 5 YEARS ANSWER REPAYMENT = $ 10,550.98 [BC195-BC202] CALCULATOR | LOAN OPTIONS fv. ann CAP STRU VALUE BOX DILUTION DOLLAR COST AVGMORTGAGE EXPO SheetiSheet2ShlI 福 130% 22-01-2019](http://img.homeworklib.com/questions/79ef7a20-78ac-11ea-b79d-69d8b82f5175.png?x-oss-process=image/resize,w_560)
Add Answer to:
John and Peggy recently bought a house. They financed the house
with a $195,000, 30-year mortgage...
33 John and Peggy recently bought a house. They financed the house with a $236,000, 30-year...
33 John and Peggy recently bought a house. They financed the house with a $236,000, 30-year mortgage with a nominal interest rate of 6.38%. Mortgage payments are made at the end of each month. What total dollar amount of their mortgage payments during the first 7 years will go towards repayment of principal? $21,061.49 $100,693.06 $23,047.75 $112,000.89 $29,693.34
Barb bought a house with 20% down and the rest financed by a 30-year mortgage with monthly payments calculated at a nomi...
Barb bought a house with 20% down and the rest financed by a 30-year mortgage with monthly payments calculated at a nominal annual rate of interest 8.4% compounded monthly. She notices that one-third of the way through the mortgage she will still owe 200,000. Determine the purchase price of the house. 252,706 262,706 272,806 282,706 292,706
A friend bought a house 15 years ago, taking out a $195,000 mortgage at 6% interest...
A friend bought a house 15 years ago, taking out a $195,000 mortgage at 6% interest for 30 years. How much does she still owe on her mortgage?
Assume you’ve recently purchased a home for $129,000 and you will be making monthly payments on...
Assume you’ve recently purchased a home for $129,000 and you will be making monthly payments on the mortgage. If the mortgage is for 30 years at an interest rate of 5%, what will be the monthly payment? For the first monthly payment, how much will go towards interest payment and how much will go towards repayment of the principal?
Izzy bought a house for $200,000 which she financed for 30 years at 3%, annual payments....
Izzy bought a house for $200,000 which she financed for 30 years at 3%, annual payments. How much Principal did she pay on the loan the first year? $4,203.85 $6,000.00 $8,319.61 $10,203.85
Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 8%, annual payment,...
Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 8%, annual payment, ly amortize term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places Loan Amortization Assume that your aunt sold her house on December 31, and to his close the sale she took a second mortgage in the amount of $30,000 as part...
Laura and Martin obtain a 30-year, $1 10,000 conventional mortgage at 10.5% on a house seling for S15 a) Determine the...
Laura and Martin obtain a 30-year, $1 10,000 conventional mortgage at 10.5% on a house seling for S15 a) Determine the total amount they will pay for their house. b) How much of the cost will be interest? c) How much of the first payment on the mortgage is applied to the principal? The r month 31, 65 mortgage payment including principal and inte est a) The total amount that Laura and Martin will pay for their house is s...
Mortgage Information Annual Interest Rate 4.90% Repayment Years 30 Price of House $275,000 Down Payment $55,000...
Mortgage Information Annual Interest Rate 4.90% Repayment Years 30 Price of House $275,000 Down Payment $55,000 Principal of Loan Monthly Payments On the Mortgage worksheet, use the PMT function in cell B7 to calculate the monthly payments of the mortgage. Use cell locations from this worksheet to define each argument of the function. Assumethat payments are made at the end of each month.On the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the...
You are buying a house that costs $440000 and plan on taking out a 30-year fixed...
You are buying a house that costs $440000 and plan on taking out a 30-year fixed rate mortgage at an annual interest rate of 2.4%. 1)You make a 15% down payment of 66000, and take out a loan for the remaining $374000. How much would your mortgage payments be? (Ignore taxes, fees, and other charges, and round to the nearest penny.) . 2)You make this mortgage payment at the end of the first month. Your mortgage payment at the end of...
John and Katie bought a house in Edmonton exactly 7 years ago. They took out a...
John and Katie bought a house in Edmonton exactly 7 years ago. They took out a mortgage of $500,000 at that time. The mortgage has a 25-year amortization period, monthly mortgage payments, and a quoted interest rate of 5% (APR, semi-annually compounded). John and Katie recently decided to buy a new house, also in Edmonton. Today they will receive payment from the buyer of their old home and make a down payment on the new house. If the old house...
Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 8%, annual payment, ly amortize term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places Loan Amortization Assume that your aunt sold her house on December 31, and to his close the sale she took a second mortgage in the amount of $30,000 as part...
Laura and Martin obtain a 30-year, $1 10,000 conventional mortgage at 10.5% on a house seling for S15 a) Determine the total amount they will pay for their house. b) How much of the cost will be interest? c) How much of the first payment on the mortgage is applied to the principal? The r month 31, 65 mortgage payment including principal and inte est a) The total amount that Laura and Martin will pay for their house is s...
Most questions answered within 3 hours.
-
Assume one of your finals has 50 questions on it, and
lucky for you, it's all...
asked 1 hour ago -
Rice Products in Bangladesh
Business behavior is derived in large part from the basic cultural
environment...
asked 2 hours ago -
The following base sequence is found for a mRNA fragment from
wild-type E. coli: 5'- UAUCAGUAGAUAAUGUAACC-3'...
asked 2 hours ago -
For this exercise, round all regression parameters to three
decimal places.
One of the two tables...
asked 3 hours ago -
What is the 5% level of significance for mean = 3.60, standard
deviation = 0.94, and...
asked 3 hours ago -
Prior to beginning work on this discussion, please read the
article by Hayley Peterson, 15 Companies...
asked 3 hours ago -
Which pair of aqueous solutions, when mixed, will form a
precipitate?
A) NaNO3 and AgC2H3O2
B)...
asked 3 hours ago -
1-Write an algorithm to get two numbers from the user (as
inputs) and calculate the sum...
asked 7 hours ago -
Define white-collar crime. What is the difference between
offender and offense-based definitions of white-collar crime? What...
asked 7 hours ago -
Consider a reaction which is 1st order with respect to A and 1st
order with respect...
asked 8 hours ago -
c++
The length of the hypotenuse of a right-angled triangle is the
square root of the...
asked 8 hours ago -
When a metal rod is heated, not only its resistance but also its
length and cross‐sectional...
asked 8 hours ago