Question: I need help with figuring out second part of the assignment ( refinancing). Thank you! Loan Amount Original Loan Rate (APR) Loan Term (Years) After

I need help with figuring out second part of the assignment ( refinancing). Thank you!

refinancing). Thank you! Loan Amount Original Loan Rate (APR) Loan Term (Years)

Loan Amount Original Loan Rate (APR) Loan Term (Years) After x month refinance rate (APR) Refinance Loan Term (Years) $200,000 6.50% 30 x= 68 4.13% 30 Mortgage Amortization Table Loan Amount APR PMT per Year Term Required PMT $200,000 6.50% 12 30 $1,264.14 Beg. Principal $200,000 $199,819.20 $199,637.42 $199,454.65 $199,270.89 $199,086.14 $198,900.39 $198,713.63 $198,525.86 $198,337.07 $198,147.26 $197,956.42 $197,764.55 $197,571.64 $197,377.68 $197,182.67 $196,986.61 $196,789.49 $196,591.29 $196,392.03 $196,191.68 $195.990.25 $195,787.73 $195,584.11 $195,37939 PMT $1,264.14 $1,264.14 $1,264.14 $1,264.14 $1,264,14 $1,264.14 $1,264,14 $1,264.14 $1,264.14 $1,264,14 $1,264.14 $1,264.14 $1,264,14 $1,264.14 $1,264.14 $1,264,14 $1,264,14 $1,264.14 $1,264,14 $1,264,14 $1,264.14 $1,264.14 $1,264.14 $1,264.14 51264.14 Loan Amount Original Loan Rate (APR) Loan Term (Years) After x month refinance rate (APR) Refinance Loan Term (Years) $200,000 6.50% 30 x= 68 4.13% 30 Mortgage Amortization Table Loan Amount APR PMT per Year Term Required PMT $200,000 6.50% 12 30 $1,264.14 Beg. Principal $200,000 $199,819.20 $199,637.42 $199,454.65 $199,270.89 $199,086.14 $198,900.39 $198,713.63 $198,525.86 $198,337.07 $198,147.26 $197,956.42 $197,764.55 $197,571.64 $197,377.68 $197,182.67 $196,986.61 $196,789.49 $196,591.29 $196,392.03 $196,191.68 $195.990.25 $195,787.73 $195,584.11 $195,37939 PMT $1,264.14 $1,264.14 $1,264.14 $1,264.14 $1,264,14 $1,264.14 $1,264,14 $1,264.14 $1,264.14 $1,264,14 $1,264.14 $1,264.14 $1,264,14 $1,264.14 $1,264.14 $1,264,14 $1,264,14 $1,264.14 $1,264,14 $1,264,14 $1,264.14 $1,264.14 $1,264.14 $1,264.14 51264.14

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!

Let closed curve C consist of the line segment from (0,0)to(3,1), followed by the line segment from(3,1)to(-1,1), followed by the piece ofy=x2 from (-1,1)to(0,0). Also, let...

B 1 Loan amount 2 interest rate (APR) Loan term years) $100 000 89 New loan interest (APR Retrancing costs $1000 4 Contractualet the end of years Maret value the end of your 5 New loans 5 a)...

Please Provide Equations. Thank you! 3. In the worksheet "Original Loan Amortization", use the "Loan Amount", "Original Interest Rate" and "Loan Term" to build a mortgage amortization table (for...

Please Answer in Excel Format with formulas! Mortgage and Refinance Excel Project Use Excel work sheet to build two Mortgage Amortization Tables. **In the excel sheet, update your data and answers in...

Please provide formulas so I can type in excel. Create a new worksheet "Original Loan Amortization Table". Use the "Loan Amount", "Original Interest Rate" and "Loan Term" to build a mortgage...

Create a new worksheet "Original Loan Amortization Table". Use the "Loan Amount", "Original Interest Rate" and "Loan Term" to build a mortgage amortization table (from Month 1-366) like shown below....

Check the Loan Information worksheet, you will find your unique loan information generated for you to further work with. You should build your mortgage amortization table using the information...

Use Excel work sheet to build two Mortgage Amortization Tables. Instructions: 1. Open the "Mortgage Project" Excel file. In the "Student ID" worksheet, please put in your Name, Student ID and select...

Hi, I have an Assignment which make me very confused about making it done. It is about how to make a budget assignment in accounting on Excel file. I have attached all files needs to support the...

PYTHON 2) (amoritization.py) In assignment #2, you created a program to calculate the monthly payment for a loan, given the starting amount, annual interest rate (APR) and term (in years). An...

I just want to remind you that all output formatting is done with fstrings. You should not be needing to use tabs (\t) in programs. 2) (amoritization.py) In assignment #2, you created a program to...

Find the speed of light in water and in glass.

1. Define monetary policy 2. Briefly discuss the South African Reserve bank(SARB), with specific reference to where it fits into the country's banking system as well as what its maonrole and...

Which of the following situations would be covered under the liability section of the 2 AP ? q , A mechanic is sued by a pedestrian who is infured when the mechanic has an accident while road testing...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

6. Identify seven types of hidden histories.

What is human nature?

. Like a coconut pudding, this food comes from Hawaii: a. Lomi lomi b. Poke c. Haupia d. Kalua