Fianance

Jake is looking at refinancing his mortgages and paying off his credit cards at the same time. Currently, his debt situation is as follows:
First mortgage: 6%, 30 years due 20xx (15 years left) $269,238
Second mortgage: 8%, interest only due in 15 years $80,000
Credit cards: 21%, minimum payments made $12,000
Total refinanced: $361,238

Jake is trying to decide between:
a. 5.5% loan with a 15- or 30-year mortgage with 1 point
b. 6% loan with a 15- or 30-year mortgage with 0.5 points
c. 6.5% loan with a 15- or 30-year mortgage with no points
Calculate the monthly payment for all six mortgages and the interest that will be paid over the life of the mortgage to decide which is Jake’s best option and what amount he will save with this option. You know that Jake’s take-home pay is $8,332 per month and the new financing should not be more than 36 percent of that value.
Procedure/Steps:
1. Use the time value of money to calculate the mortgage payment on all loans.
2. Calculate the total interest expense of each new loan by using the amortization schedule in Microsoft Excel.
3. Calculate the total interest expense on his current loans for the credit cards; assume that he pays interest for only 15 years.
4. Use the time value of money to calculate which loan saves Jake the most money.
5. Compare the best alternative to how much his current loans cost.
Outcome:
• You should be able to use the time value of money to determine mortgage payments.
• You should be able to calculate the total interest expense of a mortgage loan.
• You should be able to compare old and new financing costs.
• You should be able to perform a mortgage loan amortization schedule in Excel.
• You should be able to compare interest savings on different types of loans.



Note: If you don’t have the amortization schedule in Excel, go to microsoft and download Loan amortization schedule. You can download the schedule from this site for free.

asked by Stephanie

Respond to this Question

First Name

Your Response

Similar Questions

  1. com155

    Having a credit card could get someone into much trouble if it is not used responsibly. I personally have nightmares when it concerns credit cards. I do not like paying interest on something when it is not necessary. I learned how
  2. comm 155

    Describe your experience with credit and credit cards in a brief paragraph using at least five adverbs and five adjectives in your description. Bold the adverbs and underline the adjectives. What is the most effective way to
  3. com155

    Have I used adjectives and adverbs correctly here? Adjectives() Adverbs"" have I got them all? When I was (younger) I learned that I had to be "very" (careful) with credit cards. (Managing) debt can be a (difficult) task. I know
  4. english

    Please help me identify the adjectives and adverbs in this: My experiences with credit and credit card started at age 18. I had several credit cards by the time I was in my mid-twenties. I did not realize that I over extended
  5. Probability - PLEASE HELP

    From industry statistics, a credit card company knows that 0.8 of its potential card holders are good credit risks, and 0.2 are bad credit risks. The company uses discriminant analysis to screen credit card applicants and
  6. 3rd grade math

    Marlon has 4 cards, Jake has 4 cards, and Sam has 3 cards. Can you write a multiplication sentence to find how many cards they have in all? Explain
  7. math

    Marion has 4 cards, Jake has 4 cards, and Sam has 3 cards. Can you write a multiplication sentence to find how many cards they have in all? Explain.
  8. Civics

    Why might it be better to save up some money and buy something later than to buy it on credit now? You may get protection for purchases that are lost, damaged, or stolen. Buying anything on credit will damage your credit rating.
  9. Pronoun Pratice

    I have written a paragraph about credit cards using at least five different pronouns. Could you please look over it and let me know if you see any errors, if my pronoun use is correct and if the sentences are complete. If you have
  10. Comm 155

    I need help identifying the adverbs and adjectives. I am not sure which are which. Can someone please help me figure this out? In my early years, I was not really thinking about the importance of credit. My credit was severely

More Similar Questions