Question: please show how to solve not just answers from excel :) Q4. You have obtained a $135,000, 6.5%, 30-year mortgage? What is your monthly payment?

please show how to solve not just answers from excel :)

Q4. You have obtained a $135,000, 6.5%, 30-year mortgage? What is your monthly payment? How much will you pay into principal the 3rd month of this mortgage? How much interest will you pay in the 3rd month of this mortgage? How much will you pay into principal the 3rd year of this mortgage? How much will you pay into interest in the 3rd year of this mortgage? What will your balance be at the end of year 3? If your bank charged you 2.5 points to obtain this loan, and you keep it for 30 years, what yield (APR) will the bank earn? What will the Federal Truth in Lending APR be (Hint: Round to the nearest 1/8%)? If you must pay $850 in other fees to close this loan, what is the cost to you of this loan (expressed as an APR), assuming you keep the loan for 30 years? If you keep the loan only 3 years, what will the lender yield be (APR)? If you keep the loan 3 years, what will your Effective Borrowing Cost be (APR)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Williams Company is a merchandiser and its accounting department has finished preparing a flexible budget to better understand the differences between its actual results and the master budget. The...

Q4. You have obtained a $135,000, 6.5%, 30-year mortgage a) Monthly Payment- 853.29 b)Principal in 3 rd month 123.37 c) Interest in 3rd month 729.92 d) Principal paid in 3rd year of mortgage 14744 e)...

Q4. You have obtained a $135,000, 6.5%, 30-year mortgage a) Monthly Payment = 853.29 b)Principal in 3 rd month = 123.37 c) Interest in 3rd month = 729.92 d) Principal paid in 3rd year of mortgage =...

Hello, Can you please solve "if your bank charged you 2.5 points to obtain this loan question" and "the 4 sub questions following it".. please don't answer the top part as I already know the answers,...

Need help answering the problems in the attached PDF. Some of the answers can be found online and the problems are not difficult, but you MUST show all mathematical work/formulas used to reach...

please show how to solve Q4. You have obtained a $135,000, 6.5%, 30-year mortgage? What is your monthly payment? How much will you pay into principal the 3rd month of this mortgage? How much interest...

Hello, I know that these are simple easy questions, but I unfortunately keep making mistakes in them and I can't finally understand them properly.. Will you please show me handwritten calculations,...

Please show all work and calculations. 04. You have obtained a $135,000, 6.5%, 30-year mortgage? What is your monthly payment? How much will you pay into principal the 3 month of this mortgage? How...

please show handwritten calculations You have obtained a $135,000, 6.5%, 30-year mortgage? What is your monthly payment? How much will you pay into principal the 3rd month of this mortgage? How much...

Need help figuring out problem #40, #42, and #45 in the attached document. I have the answers for the problems, but need to see how they are worked out. FIN 142 - Real Estate Finance Problem Set 2 1....

i am taking Cooperate finance which is FIN222 can help me to answer.. ? Tutorial 1 Topic 1 Chapter 1 4. What are the main advantages and disadvantages of organising a firm as a corporation? 6. You...

5. Calculate the minimum amount of kinetic energy needed by an electron to stay inside a nucleus of mass number A 100. (The radius of the nucleus is given by r =roA/3 where ro = 1.35 10-13 cm).

Consider the stocks of two companies, Groggy Snapps Ltd (GS), and Dizzy Donglers, Inc. (DD). It has been estimated that the variance of the GS stock is 230%^2, corresponding to a standard deviation...

Listed below are statements about internal control. Please discuss why you believe each statement is a myth , fact, or somewhere in between, and your reasoning and basis: 1 . Internal control starts...

7-18 Miller-Orr model STIC Corporation uses the Miller-Orr model to manage its cash account. Recently, someone asked how sensitive is the solution for the return point and upper limit to changes in...