I have the first 2 but struggling with the last 2. Please do NOT round answers. 12345ASelling Price of Home$160,000.00BDown Payment$20,000.00Required:Please use the above information to answer the below questions:4. What is the monthly mortgage payment?Note: Use cells A2 to D3 from the given information to complete this question.$4.50$630.00360$140,000.00C6789101. How many total payments on this mortgage?11 2. What is the principal (loan)?12 3. What is the payment per $1,000?1314151617 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to s18 Nothing in this area will be graded, but it will be submitted with your assignment.1936020140000214.522630230000Rate of Interest3.50%DYears30 TABLE 15.1Amortization table (mortgage principal and interest per $1,000)TerminYears 3½% 5%1012151720222530355½% 6%62% 7%71%8%82%9%9.89 10.61 10.8611.88 12.1412.6712.4011.11 11.398.529.259.5111.1111.36 11.629.76 10.02 10.29 10.56 10.838.99 9.28 9.568.40 8.69 8.997.157.918.188.448.728.126.52 7.29 7.567.849.859.298.685.80 6.60 6.88 7.177.46 7.768.06 8.377.448.078.395.44 6.20 6.515.01 5.85 6.15 6.457.757.396.76 7.077.72 8.064.50 5.375.68 6.006.33 6.667.007.343.995.05 5.38 5.71 6.05 6.39 6.757.11INTEREST6.82 7.139¹12% 10% 10%% 11%13.2213.50 13.7812.9411.67 11.9612.2512.5410.15 10.45 10.7511.0611.379.59 9.90 10.2210.5410.869.66 9.9910.339.00 9.338.72 9.05 9.39 9.73 10.088.40 8.747.69 8.05 8.417.849.09 9.45 9.818.78 9.15 9.538.22 8.60 8.99 9.377.47

To Find: Loan amount Total number of payments Payment per $1000 Monthly payment

B 1 5 7 3 A Selling Price of Home $160,000.00 B Down Payment $20,000.00 Required: Please use the above information to answer the below questions: Note: Use cells A2 to D3 from the given information to complete this question. Rate of Interest 3.50% Years 30

B 1 5 7 3 A Selling Price of Home $160,000.00 B Down Payment $20,000.00 Required: Please use the above information to answer the below questions: Note: Use cells A2 to D3 from the given information to complete this question. Rate of Interest 3.50% Years 30

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter5: Making Automobile And Housing Decisions

Section: Chapter Questions

Problem 7FPE

See similar textbooks

Similar questions

er A https://player-ui.mheducation.com/#/epub/sn_7cac#epubcfi(%2F6%2F326%5Bdata-uuid-ab153a0624d544c2822 6. Comparing Total Mortgage Payments. Which mortgage would result in higher total payments? Mortgage A: $970 a month for 30 years Mortgage B: $760 a month for 5 years and $1,005 for 25 years 1.1 20 far $120.000 storts ot 4.01
This is financial mathematics, please helpppp
ments deo Policies ources ct Question 3 You want to purchase a home costing $150,000; the mortgage interest rate is 4% for a 30 year mortgage. How much interest would you pay over the life of the loan? $116.373.76 $110,383.88 O$97,384.27 5 pts $107,803.20
Complete the following table, which shows the monthly payments on a $100,000, 30-year mortgage at the interest rates shown. Use this information to answer the following questions. (Round your answers to the nearest cent.) Amount of Mortgage ($) 100,000 100,000 100,000 100,000 100,000 100,000 Interest Rate (%) 3 4 5 Need Help? 6 7 Read It 8 Monthly Payment ($) 421.60 477.42 536.82 599.55 665.30 (a) What is the difference in monthly payments between a $100,000, 30-year mortgage secured at 7%/ year and one secured at 3%/year? $ 243.70 733.76 (b) Use the table to calculate the monthly mortgage payments on a $140,000 mortgage at 6% / year over 30 years. $ 386.2 Use the table to calculate the monthly mortgage payments on a $30,000 mortgage at 6%/year over 30 years. $
The following formula is used for figuring out a monthly home mortgage payment: 7(12t) r Lr1+ 12 M = 12t 12 1+ 12 -1 Where: L = the loan amount in dollars the annual interest rate expressed as decimal t = the number of years of the loan M= the monthly payment in dollars r = You are looking to buy a $275,599.00 home in Haverhill. If Bank of America will give them a 30-year mortgage at 6.75% annual interest rate for the cost of the house after they receive a 10% down payment. A. Determine the loan amount? B. How much their monthly payment will be? C. At the end of the 30-years, how much total money will you have paid to Bank of America for your home? In another word how much did the $275,599.00 house really cost the couple? D. How much interest will they have paid? E. How many of her monthly payment go toward the interest? F. What percent increase over the cost of the home does this interest represent? G. Redo and re-answer all questions, but this time for 15 years? Do analysis…
dit View @ Window History Bookmarks standing Loans and Simple Interest - 21516 MAT142 Topics In Coll... W DERIVITA Tiana Klughart Principal a) What is the principal of her mortgage? Nellie wants to buy a $1,110,000.00 house. She makes a $140,000.00 down payment and takes out a 25-year mortgage to pay for the rest. Her monthly mortgage payment is $4,350.00. π ab va sin b) How much interest will she pay over the life of her loan? Total interest- $ aº C CHECK ANSWER 3 8 c) How much will she pay in total for her house? Total paid $ J E 80 Help b $ d21.pima.edu D2L 5.2 Understanding Loans and Simple Interest - 21516 MAT142 Topics... 4 R % 5 T 3D 6 3 MacBook Pro Y & 7 U 8 Question 3 of 15 DZL Chapter 5.2 - 21516 Preview ( 9 www BALKAN BACK Question 1 H Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9 Question 1 Question 1 Question 1 Question 1 Question 1 Question 1 Summary 0 0
Years Annual interest rate financed 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 10 9.66 9.77 9.89 10.01 10.12 10.24 10.36 10.48 10.61 10.73 10.85 10.98 11.10 11.23 11.35 11.48 12 8.28 8.40 8.51 8.63 8.76 8.88 9.00 9.12 9.25 7.91 7.29 9.37 9.50 9.63 9.76 9.89 10.02 10.15 8.85 8.71 7.52 6.89 6.19 8.57 7.97 15 6.91 7.03 7.15 7.27 7.40 7.65 7.78 8.04 8.17 8.30 8.44 17 6.26 6.39 6.64 6.76 7.42 7.56 6.51 5.80 5.44 7.02 7.15 7.69 7.83 8.11 8.25 5.55 5.93 7.02 7.16 6.83 7.46 7.60 7.28 20 5.67 6.06 6.33 6.46 6.60 6.74 6.88 7.31 6.98 6.60 7.13 6.75 22 5.97 5.18 4.74 5.31 5.57 5.70 5.84 6.11 6.25 6.39 6.54 6.68 25 4.87 5.01 5.14 5.28 5.42 5.56 5.70 5.85 5.99 6.14 6.29 6.44 6.91 30 4.22 4.35 4.49 4.63 4.77 4.92 5.07 5.22 5.37 5.52 5.68 5.84 6.00 6.16 6.32 6.49 35 3.85 3.99 4.13 4.28 4.43 4.58 4.73 4.89 5.05 5.21 5.37 5.54 5.70 5.87 6.04 6.21
Question 16 Your friend is going to borrow $87,500 using a 15 year mortgage with a 5.25% APR. Which of the following could you type into Excel to find her monthly mortgage payment? O =FV(0.0525/12,12*15,-87500) 12x15 .0525 = 875000 (1+ 12 12x15 .0525 87500 12 O 0.0525 12 x 15 x 12 x 87500 O =PV(0.0525/12,12*15,-87500) O=PMT(0.0525/12,12 15,-87500) 梦 $ a brt sc 6 69 bac 近

Calculation need to be done in "Excel format"
I need help with part D, E, F, and G please.
Using mortgage calculator Compare the following scenarios: a. Loan amount of; $800,000 @ 3.00% 30-year mortgage b. Loan amount of; $800,000 @ 6.50% 30-year mortgage c. Loan amount of; $800,000 @ 2.50% 20-year mortgage d. Loan amount of; $800,000 @ 5.50% 20-year mortgage e. Loan amount of; $800,000 @ 2.00% 10-year mortgage f. Loan amount of; $800,000 @ 5.00% 10-year mortgage
Find the indicated amounts for the fixed-rate mortgages. Monthly payment Mortgage рayment Purchase Total Down Mortgage Interest payment amount Interest price of home paid for mortgage Years rate paid per $1,000 $85,000 $8,000 6.00% 25 Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed. The mortgage amount is S 77000 . (Round to the nearest dollar as needed.) The monthly payment per $1,000 is S 6.44'. (Round to the nearest cent as needed.) The monthly mortgage payment is S (Round to the nearest cent as needed.)