a)
The bi-weekly payment on the loan is calculated using the following equation
Bi-weekly loan payment = $ 549.70
---------------------------------------------------------------------------------------------
b)
Interest paid over 10 years of the loan = $ 549.70 26 10 - $ 105,000
Interest paid over 10 years of the loan = $37,922.78
------------------------------------------------------------------------------------------------
c)
The amortization schedule for the first loan payment is shown as
$ 287.20 of the first payment is used to pay down the loan, rather than pay interest.
Period | Beginning balance | Bi-weekly payment | Interest | Principal | Ending balance |
1 | $105,000 | $549.70 | (0.065 26) $ 105,000 = $ 262.50 | $ 549.70 - $ 262.50 = $ 287.20 | $105,000 - $287.20 = $104,712.80 |
6. Best Boots is planning to purchase a new commercial sewing machine for $105,000. They plan...
Doggie Delights is planning to purchase a new commercial oven for $125,000. They plan to finance the oven through a loan at 6.5% APR compounded bi-weekly (every 2 weeks) over 12 years a. What is the bi-weekly loan payment? b. How much interest will be paid over the 12 years of the loan? c. How much of the first payment is used to pay down the loan, rather than pay interest? d. Doggie Delights is considering upgrading the machine after...
Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. 1. Use function "PMT" to calculate your mortgage payment. 2. Calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest.) 3. Calculate how much interest you will pay in total? 4. Assume that you...
6. Savings Payment Dean is planning to purchase a new Nissan Altima which costs $26,865. He has saved up $3,200 to put toward it. He is thinking about getting a loan for it from his credit union, but he could also keep driving his beat-up old car for a while longer and save up cash for the new one. Dean is surprised when he sees how much he will spend on interest if he buys his car with the loan....
Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use the function “PMT” to calculate your mortgage payment. Calculate the total cost of the home purchase. (Down payment plus principal (loan amount) plus interest.) Calculate how much interest you will pay in total? Assume that you plan to pay...
Mortgage Analysis You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.25% on a 30-year mortgage. (Use Excel) Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1550 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given...
Use Excel (PV, FV, or PMT) Let's say you are planning to purchase a house as soon as your student loans are paid off in 8 years. After graduation, you plan to live in an apartment for $820 a month and your dream is to buy a home worth $240,000 in 8 years. Once your debt is paid off, you will combine your apartment payment with your former debt payment to pay for the mortgage. That does not mean it...
The Martinezes are planning to refinance their home (assuming that there are no additional finance charges). The outstanding balance on their original loan is $175,000. Their finance company has offered them two options: Option A: A fixed-rate mortgage at an interest rate of 6.5% per year compounded monthly, payable over a 30-year period in 360 equal monthly installments. Option B: A fixed-rate mortgage at an interest rate of 6.25% per year compounded monthly, payable over a 12-year period in 144...
You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1700 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given a payment of $1700...
2. You purchase a home for $240,000, putting 10% down, and financing the rest with a fixed APR of 5.9% for 30 years. a) Find the amount that you finance. 12 pts) b) Calculate the monthly payment. [4 pts] c) What was the total amount that you paid to the bank for your loan? [2 pts) d) How much did you pay in interest over the term of the loan? [2 pts
Olivia plans to secure a 5-year balloon mortgage of $260,000 toward the purchase of a condominium. Her monthly payment for the 5 years is calculated on the basis of a 30-year conventional mortgage at the rate of 5%/year compounded monthly. At the end of the 5 years, Olivia is required to pay the balance owed (the "balloon" payment). What will be her monthly payment for the first 5 years, and what will be her balloon payment? (Round your answers to...