Question: please do it on excel and show formulas. Q2 - Remaining Balance Suppose you have taken out a $1,648,145 fully amortizing fixed rate mortgage loan

please do it on excel and show formulas.

Q2 - Remaining Balance Suppose you have taken out a $1,648,145 fully amortizing fixed rate mortgage loan that has a term of 25 years and an interest rate of 5.15\%. After your first mortgage payment, how much of the original loan balance is remaining? Q3-Remaining Balance Assume you have taken out a partially amortizing loan for $7,158,435 that has a term of five years but amortizes over 20 years. Calculate the balloon payment if the interest rate on this loan is 4.75%

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 show work on Excel e 01 - Time Value of Money What is the present value of a five-year $25,000 ordinary annuity plus of a lump sum of $150,000 at the end of year 5. Discount rate of 11% Q2 -...

Q1 Time Value of Money What is the present value of a five-year $35,500 ordinary annuity plus of a lump sum of $580,000 at the end of year 5. Discount rate of 11.25% Q2 - Remaining Balance Suppose...

Q1 - Time Value of Money What is the present value of a five-year $35,500 ordinary annuity plus of a lump sum of $580,000 at the end of year 5. Discount rate of 11.25% - Remaining Balance Suppose you...

Q1 Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 5.25%. After your first mortgage payment, how much of the...

show calculation step by using input (N,PV,PMTFV) please 27. Suppose you have taken out a $200,000 fully- amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of...

Q1 Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 5.25%. After your first mortgage payment, how much of the...

7) Suppose you have taken out a $125,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original...

Suppose you have taken out a $1,648,145 fully amortizing fixed rate mortgage loan that has a term of 25 years and an interest rate of 5.15%. After your first mortgage payment, how much of the...

Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 5.25%. After your first mortgage payment, how much of the original...

A particular MOSFET has V = 50 V. For operation at 0.1 mA and 1 mA, what are the expected output resistances? In each case, for a change in vps of 1 V, what percentage change in drain current would...

What is the annual capital gains yield expected over the next year for a 12 year bond with a 6.9% coupon rate paying the coupons every six months and selling at $1,045 (enter the answer as a...

Roosevelt Company currently has the capacity to manufacture 2 5 0 , 0 0 0 widgets a year and 1 0 0 , 0 0 0 gadgets a year in its factory. Roosevelt Company has the following costs related to...

You are to read the scenario and then:1. List the entities2. Describe the relationship between the entities3. Draw a conceptual graph (ORM diagram)4. Draw constraints, Uniqueness and Mandatory5....

5. Suppose that the opportunity-cost ratio for fish and lumber is 1F 1L in Canada but 2F 1L in Iceland. Then should specialize in producing fish while should specialize in producing lumber. LO40.2...

2. First, imagine that both input and output prices are fixed in the economy. What does the aggregate supply curve look like? If AD decreases in this situation, what will happen to equilibrium output...

LO40.2 Define comparative advantage and demonstrate how specialization and trade add to a nations output.