Question

DATA GIVEN FOR THE OLD LOAN AND THE NEW LOAN RUSH RUSH FINANCE ....PERSONAL Marginal tax...

DATA GIVEN FOR THE OLD LOAN AND THE NEW LOAN

RUSH RUSH FINANCE ....PERSONAL Marginal tax rate 6% Resale Plan (Months) 60 MORTGAGE TERMS Original Mortgage Amount $150,000.00 Current Mortgage Rate 5.75% Original Term (Years) 20 Months Paid 117 New Mortage Rate 3.00% New Term (YEARS) 15 Points 0 REFINACING FEES Application $200.00 Title $2,000.00 Legal $200.00 Other $10,779.85 Points 0 Total Fees $13,179.85 ANALYSIS CURRENT PROPOSED Mortgage Amount 97, 703.26 $97,703.26 ANALYSIS Mortgage Payment Months to Recover Refinancing cost Mortage Balance at Resale (Valor Presente del MA - c26 Principal Repaid to Resale ( - MA - MBAR = c26 c29) Total Payments to Resale Total Interest to Resale Tax Deduction on Interest Net Interest Costo to Resale Interest Savings (COSTS) TOTAL SAVINGS COST (COSTS)

COURSE : FINANCE: INCLUDED DATA FOR OLD LOAM AND NEW LOAN TO RECALCULATE MORTGAGE PAYMENTS ETC

PERSONAL
MARGINAL TAX RATE 6%
RESALE PLAN (MONTHS) 60
MORTGAGE TERMS
ORIGINAL MORTGAGE AMOUNT $150,000.00
CURRENT MORTGAGE RATE 5.75%
ORIGINAL TERM (YEARS) 20
MONTHS PAID 117
NEW MORTGAGE RATE 3.00%
NEW TERM (YEARS) 15
POINTS 0
REFINANCING FEES
APPLICATION $200.00
TITLE $2,000.00
LEGAL $200.00
OTHER $10,779.85
POINTS 0
tOTAL FEES $13,179.85
ANALYSIS CURRENT PRPOSED
NORTGAGE AMOUNT $97,703.26 $97,703.26
   ANALYSIS FOR THE NEW LOAN : FIND
MORTGAGE PAYMENT
MONTHS TO RECOVER REFINANCING COST
MORTGAGE BALANCE AT RESALE (PRESENT VALUE)
PRINCIPAL REPAID TO RESALE
TOTAL PAYMENTS TO RESALE
TOTAL INTEREST TO RESALE
TAX DEDUCTION ON INTEREST
NET INTEREST COST TO RESALE
INTEREST SAVINGS (COSTS)
TOTAL SAVINGS COST
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Soln :

ANALYSIS For New loan
MORTAGE AMOUNT 97703.26
MORTGAGE PAYMENT 674.72
MONTHS TO RECOVER REFINANCING COST 180
MORTGAGE BALANCE AT RESALE (PRESENT VALUE) 69865
PRINCIPAL REPAID TO RESALE 27838.26
TOTAL PAYMENTS TO RESALE 40483.2
TOTAL INTEREST TO RESALE 12644.94
TAX DEDUCTION ON INTEREST 758.70
NET INTEREST COST TO RESALE 11886.24
INTEREST SAVINGS (COST) 10749.76
TOTAL SAVINGS COST 13179.85

Please refer the table, here we have calculated mortgage payment for new loan a sPMT (3%/12,180,-97703.26,0) = 674.72

Total payments to resale that is at 60 months = 674.72*60

Also, we have calculated the interest cost for 60 months for old loan adding interest of each month .

Use Excel to calculate PMT, principal paid, interest and principal remaining, you will get these values for both old and new loan

Interest of previous loan = 22636 and hence interest cost savings = 22636 - interest paid on new loan = 22636-11886 = 10749

Total savings cost = Interest savings - total fee = 10749 - 13180 = -2431

Add a comment
Know the answer?
Add Answer to:
DATA GIVEN FOR THE OLD LOAN AND THE NEW LOAN RUSH RUSH FINANCE ....PERSONAL Marginal tax...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem 3 Barb and John Walton took out a $ 110,000 30 year loan for their...

    Problem 3 Barb and John Walton took out a $ 110,000 30 year loan for their home exactly three years ago. Their interest rate on the 30 year loan is 5.00% fixed rate. The Walton's loan payment is S 590.50 which includes principal and interest. Their remaining balance on their loan is $ 104,879. They are considering refinancing their original 30 year loan. Liberty National Bank is currently offering a 15 year 3% fixed loan for mortgage refinancing. First, determine...

  • After-tax cost of debt Personal Finance Problem Bella Wans is interested in buying a new motorcycle....

    After-tax cost of debt Personal Finance Problem Bella Wans is interested in buying a new motorcycle. She has decided to borrow the money to pay the $25,000 purchase price of the bike. She is in the 33% income tax bracket. She can either borrow the money at an interest rate of 4% from the motorcycle dealer, or she could take out a second mortgage on her home. That mortgage would come with an interest rate of 6%. Interest payments on...

  • After-tax cost of debt Personal Finance Problem Bella Wans is interested in buying a new motorcycle....

    After-tax cost of debt Personal Finance Problem Bella Wans is interested in buying a new motorcycle. She has decided to borrow the money to pay the $20,000 purchase price of the bike. She is in the 25% income tax bracket. She can either borrow the money at an interest rate of 6% from the motorcycle dealer, or she could take out a second mortgage on her home. That mortgage would come with an interest rate of 7%. Interest payments on...

  • After-tax cost of debt Personal Finance Problem Bella Wans is interested in buying a new motorcycle....

    After-tax cost of debt Personal Finance Problem Bella Wans is interested in buying a new motorcycle. She has decided to borrow the money to pay the $25,000 purchase price of the bike. She is in the 28% income tax bracket. She can either borrow the money at an interest rate of 4% from the motorcycle dealer, or she could take out a second mortgage on her home. That mortgage would come with an interest rate of 8%. Interest payments on...

  • The mortgage on your house is five years old. It required monthly payments of SEK 12,000,...

    The mortgage on your house is five years old. It required monthly payments of SEK 12,000, had an original term of 30 years, and had an interest rate of 6.5% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance - that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 3.5% (APR). (a)...

  • The interest paid on which type of loan is not tax deductible? Multiple Choice Home equity loan interest for home impr...

    The interest paid on which type of loan is not tax deductible? Multiple Choice Home equity loan interest for home improvements Credit card interest Mortgage interest to buy a home Mortgage interest to build a home Investment interest up to the amount of investment income oan Martin expects interest rates to decline over the next few months. To achieve her long-term financial goals, she will trade off liquidity for a higher return by using a: Multiple Choice regular savings account....

  • eBook A few years back, Dave and Jana bought a new home. They borrowed $230,415 at...

    eBook A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their 25th payment, and the current balance on the loan is $208,555.87, Interest rates are at an all-time low, and Dave and Jana are thinking of refinancing to a n of-pocket costs of $2,937. The out-of-pocket costs must be paid in full at the time of refinancing Build...

  • 1. [5 points total] Drs. Bhattacharya and Malinowski are expecting their third child and therefore are...

    1. [5 points total] Drs. Bhattacharya and Malinowski are expecting their third child and therefore are in the market for a new, larger, home. They are looking at a traditional colonial style home with a swimming pool on Nottingham Terrace that will cost $999,000 to purchase. They are now comparing lending options and have identified two potential options. They have asked for your expert opinion to help them make an informed decision. Option A: A 30-year adjustable rate mortgage (ARM)...

  • P9-6 (similar to) Question Help * After-tax cost of debt Personal Finance Problem Bella Wans is...

    P9-6 (similar to) Question Help * After-tax cost of debt Personal Finance Problem Bella Wans is interested in buying a new motorcycle She has decided to borrow the money to pay the $30,000 .urchase price o the bike She is in the 28% income tax racket She can either borrow the money at an interest rate o 4% from the motorcycle dealer, or she could take out a second mortgage on her home. That but interest payments on the loan...

  • Sam inherited $2 million at age 20 and put this amount in an investment account earning an rate of return of 5.5%, compounded monthly. Today, Sam turns to age 50 and deposits the accumulated amount from the inheritance in a 25-year annuity due plan at an

    Sam inherited $2 million at age 20 and put this amount in an investment account earning an rate of return of 5.5%, compounded monthly. Today, Sam turns to age 50 and deposits the accumulated amount from the inheritance in a 25-year annuity due plan at an interest rate of 5.5% that he can withdraw a set amount of monthly income immediately to pay for mortgage payments, property tax and living expenses on the first day upon his retirement.Sam loves nature...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT