FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve in excel and show excel formula 3 Several years ago, a $. 2,000,000 fixed rate, monthly amortizing mortgage was issued for 20 years

Please solve in excel and show excel formula

image text in transcribed

3 Several years ago, a $. 2,000,000 fixed rate, monthly amortizing mortgage was issued for 20 years at 5.5% rate. The monthly payment is $13,758. 3.2% Prepayment penalty is applied to the loan balance. It is calculated at $34,130 Consider no friction costs during origination of the loan. What is the loan balance at this time? 3a 2 3b 2 What is the EBC if the loan is pre-paid now

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investing In Mortgage Backed And Asset Backed Securities

Investing In Mortgage Backed And Asset Backed Securities

Authors: Glenn M. Schultz, Frank J. Fabozzi

1st Edition

1118944003, 978-1118944004

More Books

Students also viewed these Finance questions

Question

★★★★★
Dollar-Value LIFO Retail Presented below is information related to Atrium Corporation. Compute the ending inventory under the dollar-value LIFO method at December 31, 2011. The cost-to-retail ratio...

Answered: 1 week ago

Question

★★★★★
The following data are available for Retique! Increase in accounts payable \(\$ 40,000\) Increase in bonds payable 100,000 Sale of investment 50,000 Issuance of common stock \(\quad 60,000\) Payment...

Answered: 1 week ago

Question

★★★★★
A tropical forest survey conducted by Conservation International included the following statements in the material that accompanied the survey: A massive change is burning its way through the earths...

Answered: 1 week ago

Question

★★★★★
"1. What were some of the key structural and infrastructural elements that defined Netflix's supply chain strategy before 2011? After 2011? 2. How have the customers' order winners for Netflix's...

Answered: 1 week ago

Question

★★★★★
Select one or more: a. Elise is bearish on the FINM stock. She can capitalize on her market view by: (1) buying a call on FINM and also selling a call on FINM with a higher strike (but otherwise...

Answered: 1 week ago

Question

★★★★★
Required: a . Compute the equivalent units for materials costs and for conversion costs using the weighted - average method. b . Compute the equivalent units for materials costs and for conversion...

Answered: 1 week ago

Question

★★★★★
sin x 3. Show step by step how you use tan x = - COS X and the compound formulas for sine and cosine to produce the addition formula for tangent, tan(A + B) = tan A + tan B 1-tan Atan B [4 marks]

Answered: 1 week ago

Question

★★★★★
Solve both parts showing work and provide an explanation (Hint: Rationalize twice) (ii) Use the result of part (i) to evaluate (Hint: It's a one line solution using part (i).) lim H 2 19-2x+5-4 x-2...

Answered: 1 week ago

Question

★★★★★
Differentiate the function. r(z) = 2-8 - 21/2 r'(z) =

Answered: 1 week ago

Question

★★★★★
on list K Find the angle between v and w. v=-3i+2j, w=3i+9j estion 14 The angle between v and w is . (Do not round until the final answer. Then round to the nearest tenth as needed.) uestion 15...

Answered: 1 week ago

Question

★★★★★
1- List five things a good CGL should have. 2- List 3 state in the United States to open LLC and state why. 2. According to your textbook, 1- List and explain the qualities to look for when choosing...

Answered: 1 week ago

Question

★★★★★
9. Are you able to integrate your presentation aids into your presentation effectively?

Answered: 1 week ago

Question

★★★★★
4. Are you articulating well? Are you mumbling? Can other people understand your words?

Answered: 1 week ago

Question

★★★★★
6. Are you effectively scanning as you rehearse? (If you have others present, are you making eye contact? If not, are you looking at different quadrants of the room you are rehearsing in?)

Answered: 1 week ago

Previous Question Next Question