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 | |
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
DATA GIVEN FOR THE OLD LOAN AND THE NEW LOAN RUSH RUSH FINANCE ....PERSONAL Marginal tax...
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. 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. 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. 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, 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 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 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 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 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 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...