Question: I need help figuring out the Refinance Amortisation table, I already did the Origonal loan Amortisation Table. which i will give the information below. i

I need help figuring out the Refinance Amortisation table, I already did the Origonal loan Amortisation Table. which i will give the information below. i need it in this format

the Origonal loan Amortisation Table. which i will give the information below.

JX EB1 A D D $ E F Loan Amount 2 Original Interest Rate (APR) 3 Loan Term (Months) 4 PMT B 115,000.00 6% 360.00 $6,440.00 S 6 Original Loan Amortisation Table: 7 9 Beginning Principal 115,000.00 PMT 10 Interest Principal deductiorEnding Principal 11 Month 1 2 3 4 5 12 13 14 15 6 7 16 8 17 B D E A 1 Refinanced after 'X' months 144 2 New Loan Amount I. 3 Refinanced Interest Rate (APR) 4.27% 4 New Loan Term (Months) 360 5 PMT 6 7 Refinanced Loan Amortisation Table: B 9 Month Beginning Principal 10 1 11 2 12 3 13 4 14 5 PMT Interest Principal deductiorEnding Principal 15 6 16 7 17 8

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!

I have already done number one i need help solving number 2. ive given all information needed 1. origonal loan amortisation table loan amount 115000 origonal intrest rate .50% loan term(months) 360...

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...

Question: CW1 for reference CW3 Instructions: WRITING THE BUSINESS PLAN for transformational entrepreneurship start-up Nature: Any company, whether a start-up business or an existing firm, will...

Tax Return #3Schedule A John and Susie Ryan are married and file a joint return. John's social security number is 412-34-5670 and his date of birth is May 12, 1976. Susie's social security number is...

Case Analysis 1. Compute the yield to maturity of Land'o'Toys' bonds before the purchase announcement and use it to determine the likely current bond rating. (Compare YTM to the table on p. 269)....

Prepare a 2013 gift tax return (Form 709) for Natalie (Social Security number 123-45-6787). Natalie made no taxable gifts in prior years Hint: A correct submission for this assignment will include...

Ramrod, Inc., sells a warehouse for $350,000. It purchased the warehouse 10 years ago for $250,000 and had taken $75,000 in depreciation on the building to the date of sale. Identify the tax issue(s)...

David has a quasi-linear utility function of the form U(x, y) = x + y, with associated marginal utility functions MUx = 1/(2x) and MUy = 1. a) Derive David's demand curve for x as a function of the...

An audit report for a public client indicates that the audit was performed inaccordance with: ( 1 ) Generally accepted auditing standards ( United States ) . ( 2 ) Standards of the Public Company...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

7-17 How do social search, semantic search, and mobile search differ from searching for information on the Web using conventional search engines?

7-16 Compare Web 2.0 and Web 3.0.

4. What solutions have been proposed for this problem? Do you think they will be effective? Why or why not? In July 2010, reports surfaced about a Stuxnet worm that had been targeting Irans nuclear...