Question: question 12 :) please show excel functions 11. What is the draw (payment to the borrower) in a RAM for $200,000 at 4% interest and

question 12 :) please show excel functions 11. What is the draw question 12 :)

please show excel functions

11. What is the draw (payment to the borrower) in a RAM for $200,000 at 4% interest and a maturity of 10 years? Answer $2,024.90 Loan Amount Periods Per Year Interest Rate Years to Maturity $200,000 120 0.33% 12. What is the balance on the loan in the previous question 2 years after the original 10-year period ends? (assume the borrower stays in the house for 12 years after origination) (use the FV function) Answer Loan Amount Periods Per Year Interest Rate Years After Original Maturity

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!

please use excel functions 11. What is the draw (payment to the borrower) in a RAM for $200,000 at 4% interest and a maturity of 10 years? Answer Loan Amount Periods Per Year Interest Rate Years to...

if you could please provide the excel functions thank you! 95 96 10. What is the balance at EOM 34 of the loan in the previous question? 97 98 Loan Amount Answer 99 Years 100 Periods Per Year 101...

if you could please provide the excel functions thanks E 105 106 11. What is the draw (payment to the borrower) in a RAM for S200,000 at 4% interest and a 107 maturity of 10 years? 108 109 Loan...

Hi, I need help with these questions, I keep getting the wrong answer. please provide an excel function for the answer hint(the answer is on cell highlight with red) undefined 11. What is the draw...

11. What is the draw (payment to the borrower) in a RAM for $200,000 at 4% interest and a maturity of 10 years? Loan Amount $200,000 Answer Periods Per Year 12 Interest Rate 4% Years to Maturity 10...

how to get correct andwers for 11&12. thank you 11. What is the draw (payment to the borrower) in a RAM for $200,000 at 4% interest and a maturity of 10 years? Loan Amount $200,000 Answer $2,024.90...

11. What is the draw (payment to the borrower) in a RAM for $200,000 at 4% interest and a maturity of 10 years? Answer Loan Amount Periods Per Year Interest Rate Years to Maturity $200,000 12 4% 10...

A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800 origination fee and 2.5 discount points. A borrower wants a loan for $358,000. What is the yield to...

please show excel functions used and work 8. (10 points) Mr. Parker is interested in saving money for his two children, John and Anna, through college. John is currently five years old and Anna is...

1. The triangle in the figure has a homogeneous mass density o. The sides have length b: length c = 1:2 b, a Find the inertia tensor, the inertia tensor on the principal axis, angular moments when...

What steps would you take to prevent ADEA cases after a major restructuring or reduction in force?

3. Concurrent design teams also include the supplier's representatives.

swot analysis for five 9

5 Compare the strengths and weaknesses of the following: (a) management by objectives; (b) graphic rating scales; (c) 360- degree feedback.

1 D o you think having some parts of the appraisal process (such as 3 60-d egree feedback at Amersham Pharmacia and Biotech) is a good idea? Longenecker (1997) conducted a survey and found that the...

6 What is the balanced scorecard method?