My spreadsheet Essay example

For option 2 I calculated the savings I receive from reduced payment. For that I used difference between the mortgage payments as annuity payment for 180 months for Question A and for 60 months for Question B

You have been making payments for the last 25 years and have finally paid off your mortgage. Your original mortgage was for $345,000 and the interest rate was 5% per year compounded semi-annually for the entire 25 year period. How much interest have you paid over the last 5 years of the mortgage?

Home ownership is the American dream! It is one of the most costly purchases an individual or family can make in their lifetime. Some people save until they have cash to purchase however, many people borrow money from a bank or lending institution; when a person borrows money to purchase a home the loan is called a mortgage. The lender is called the mortgagee and the borrower is called the mortgagor; banks have several different types of mortgages: fixed rate mortgage, adjustable rate mortgage, investment mortgage and much more. Borrowers have to undergo the lender underwriting process to show financial capability of repaying the mortgage (Makarov & Plantin, 2013). In this article I will use a fictitious person named “Julianna,” she is in the process of buying her first home at age 30; I will be her lender and will use mathematical procedures to find out what is her down payment, principle, installment payment, points (closing cost), mortgage maturity value and total interest paid.

1. A condo in Orange Beach, Alabama, listed for $1.4 million with 20% down and financing at 5% for 30 years. What would the monthly payment be?

Risk of financial ruin is an important factor of having insurance. You Might face some health problems in later months like a sudden accident, cancer, diabetes, kidney stones or a car accident, this will leave with staggering medical bills. And not paying

15. The condominium at the beach that you want to buy costs $249,500. You plan to make a cash down payment of 20 percent and finance the balance over 10 years at 6.75 percent. What will be the amount of your monthly mortgage payment?

Indemnity insurance is nice in the aspect that you get to choose your health care provider as well as you will be reimbursed for you services that you received. I know that most people couldn’t afford that right away and with

Present market value of Simon’s home = $250,000. Simon can borrow up to 75 percent of the market value, or $187,500. Simon still owes $100,000 mortgage on his home. Therefore, he can borrow an additional $87,500.

However, as you get older, the pure cost to maintain policy increases. There is no need to worry because as long as you continue to pay a stated premium each year, life insurance remains in force. You will need more expensive life insurance protection; the accumulating cash will pay for it. Your move to purchase universal life insurance policy was very wise because it is used to cover temporary needs and permanent type of insurance.

4. (TCO C) Alan and Barbara are in the process of purchasing their first home. However, they cannot decide whether a 15-year fixed-rate mortgage or a 30-year fixed-rate mortgage is best for them. They have decided to finance $200,000 and can get the 15-year mortgage at 4.5% and the 30-year mortgage at 5%. (35 points total)

Insurance is a useful thing to invest in if you have possessions that are of value to you. It helps protect you from accidents that a person cannot necessarily prevent in everyday life. Although insurance does cost a large amount of money, in the long run the payback if an accident occurs, will be very useful in taking care of the damages. There are many companies out there that offer insurance coverage. The money invested helps a person keep things in order, so they are not scraping together when something goes wrong. If you shop around you may be able to find the cheapest price for you and then will be protected from many

8. If you want to purchase a home. You have $15,000 to put down. All you can afford is $1,500.00 per month and you do not want to finance for more than 15 years @ 6% interest, (your taxes will be $85.00 per month and insurance $200.00 a month), what is the amount you can pay for your home? (Show all your work)

In question four, Janet was asked to solve a question that deals with annuity payments, specifically, ordinary annuities. It starts by asking of how much you will make if you add $2,000 every year and it is compounded by 10% interest every year. These, for the most part, are future value problems. The first one comes out to be a future value of $12,210.20, which does not satisfy the need for $20,000. The next part asks what the value would be if the interest was compounded semiannually. You have to do an equation in order to find out what the effective annual interest rate. Through this equation you come out with a value of 10.25% and after the calculator calculations you come out with a future value of $12,271.11, also not meeting the demand for that first year of college. The next part asks what payment will you need in order to get to that $20,000 number and the present value comes to be $3,275.95. Next, the case asks what original payment you would need in order

Mortgage I 30 year fixed rate @ 7.58%/yr/mo, monthly payments, minimum 5% down payment, 1 point closing costs Mortgage II 15 year fixed rate @ 7.13%/yr/mo, monthly payments, minimum 5% down payment, 1 point closing costs Mortgage III 30 year fixed rate @ 7.08%/yr/2-weeks, bi-weekly payments, minimum 5% down payment, 1 point closing costs Mortgage IV 15 year fixed rate @ 6.63%/yr/2-weeks, bi-weekly payments, minimum 5% down payment, 1 point closing costs

The reason for life insurance is to safeguard the most valued asset a young investor has, human capital. The investor is protecting his future earnings against lifetime uncertainty. In the event of passing away, the insured’s heirs or dependents will be given a sum of money to replace the wages he provided. Commonly, policies are bought to hedge against the mortality risk, “so human capital affects both optimal asset allocation and demand for life insurance.” Mortality risk is hedged by life insurance because the more human capital an investor has, the more life insurance he will need. This is perfect because of the negative 100 percent correlation the consumption (alive) and bequest (dead) state have with one another.