Question

6. Best Boots is planning to purchase a new commercial sewing machine for $105,000. They plan to finance the sewing machine t
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

The bi-weekly payment on the loan is calculated using the following equation

Present value of the loan PMT = 1- (1+ interest rate) interest rate -nt

$105,000 PMT -26x10 0.065 1-(1+º 26 0.065 26

Bi-weekly loan payment = $ 549.70

---------------------------------------------------------------------------------------------

b)

Interest paid over 10 years of the loan = $ 549.70 \times 26 \times 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 \div 26) \times $ 105,000 = $ 262.50 $ 549.70 - $ 262.50 = $ 287.20 $105,000 - $287.20 = $104,712.80
Add a comment
Know the answer?
Add Answer to:
6. Best Boots is planning to purchase a new commercial sewing machine for $105,000. They plan...
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
  • Doggie Delights is planning to purchase a new commercial oven for $125,000. They plan to finance...

    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...

    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...

    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...

    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...

    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...

    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 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...

    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...

    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

     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...

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