Question

20. Hauser Trucking recently purchased a new truck costing $157,800. The firm financed this purchase at 6.6 APR interest with
0 0
Add a comment Improve this question Transcribed image text
Answer #1

To calculate the period in which the debt will be paid off use the formula of Nper (period) in excel

=nper(Rate,pmt,pv,fv)

Where:

Rate = 6.6%/12 (Since compounded monthly)

pmt = $4200 (use - sign before this since this is an outflow)

pv = $157800

fv = 0

=nper(6.6\%/12,-\$4200,\$157800,0)

Nper = 42.203 Months

To calculate this above figure in years divide it by 12 months

Nper in Years = \frac{42.203}{12}

Nper in Years = 3.52 Years

I hope this clear your doubt.

Feel free to comment if you still have any query or need something else. I'll help asap.

Do give a thumbs up if you find this helpful.

Add a comment
Know the answer?
Add Answer to:
20. Hauser Trucking recently purchased a new truck costing $157,800. The firm financed this purchase at...
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
  • Intel recently purchased a new office building costing $200 million. The firm financed this purchase at...

    Intel recently purchased a new office building costing $200 million. The firm financed this purchase at 8.25 percent interest with monthly payments of $1,839,789. How many years will it take the firm to pay off this debt. Explain Please show with a financial calculator.

  • 20. A truck costing $111,000 is paid off in monthly installments over four years with 8.10%...

    20. A truck costing $111,000 is paid off in monthly installments over four years with 8.10% APR. After three years the owner wishes to sell the truck. How much he needs to pay on his loan before he can sell the truck? 19. Your firm needs to invest in a new delivery truck. The life expectancy of the delivery truck is five years. You can purchase a new delivery truck for an upfront cost of $300,000, or you can lease...

  • Q A truck costing $112000 is paid off in monthly installments over four years with 8%...

    Q A truck costing $112000 is paid off in monthly installments over four years with 8% APR. After three years owner wishes to sell the truck. What is the closest amount from the following list that he needs to pay on his loan before he can sell the truck? Joseph buys a Hummer for $60000, financing it with a five-year 6.5% APR loan paid monthly. He decided to pay an extra $50 per month in addition to his monthly payments....

  • Your firm needs to invest in a new delivery truck. The life expectancy of the delivery...

    Your firm needs to invest in a new delivery truck. The life expectancy of the delivery truck is five years. You can purchase a new delivery truck for an upfront cost of $200,000, or you can lease a truck from the manufacturer for five years for a monthly lease payment of $4,000 (paid at the beginning of each month). Your firm can borrow at 7% APR with quarterly compounding. a. Calculate the effective annual rate on your firm's borrowings. b....

  • Question 9 Task 28 v5 Your firm needs to invest in a new delivery truck. The...

    Question 9 Task 28 v5 Your firm needs to invest in a new delivery truck. The life expectancy of the delivery truck is five years. You can purchase a new delivery truck for an upfront cost of $200,000, or you can lease a truck from the manufacturer for five years for a monthly lease payment of $4,100 (paid at the beginning of each month). Your firm can borrow at 8% APR with quarterly compounding. a. Calculate the effective annual rate...

  • our firm is purchasing a new telephone system, which will last for four years.There are two...

    our firm is purchasing a new telephone system, which will last for four years.There are two alternatives: purchase outright or lease. If the system is purchased, there is an upfront cost of 150K. If the system is leased from the manufacturer, then the firm must pay 4K at the end of each month for four years. Your firm can borrow from its local bank at an interest rate of 5% APR with semiannual compounding. With alternative is best? Can someone...

  • 20. Simon recently received a credit card with a 12% nominal interest rate. With the card,...

    20. Simon recently received a credit card with a 12% nominal interest rate. With the card, he purchased an Apple iPhone 7 for $370.44. The minimum payment on the card is only $20 per month. If Simon makes the minimum monthly payment and makes no other charges, how many months will it be before he pays off the card? Do not round intermediate calculations. Round your answer to the nearest whole number. ______ month(s) If Simon makes monthly payments of...

  • Simon recently received a credit card with a 15% nominal interest rate. With the card, he purchased an Apple iPhone 7 fo...

    Simon recently received a credit card with a 15% nominal interest rate. With the card, he purchased an Apple iPhone 7 for $373.15. The minimum payment on the card is only $10 per month. If Simon makes the minimum monthly payment and makes no other charges, how many months will it be before he pays off the card? Do not round intermediate calculations. Round your answer to the nearest whole number. ______ month(s) If Simon makes monthly payments of $35,...

  • D) 7.9% You are considering purchasing a new home. You will need to borrow $270,000 to purchase the home. A mortga...

    D) 7.9% You are considering purchasing a new home. You will need to borrow $270,000 to purchase the home. A mortgage company offers you a 20- year fixed rate mortgage at 6 % APR. If you borrow the money from this mortgage company, your monthly mortgage payment will be closest to: 14) A) $3094 B) $1934 C) $1547 D) $2708 5 A bank offers a loan that will requires you to pay 8% interest compounded semiannually. Which of the following...

  • PAYING OFF CREDIT CARDS Simon recently received a credit card with an 20% nominal interest rate....

    PAYING OFF CREDIT CARDS Simon recently received a credit card with an 20% nominal interest rate. With the card, he purchased an Apple iPhone 5 for $480. The minimum payment on the card is only $20 per month. a. If Simon makes the minimum monthly payment and makes no other charges, how many months will it be before he pays off the card? Do not round intermediate calculations. Round your answer to the nearest month. month(s) b. If Simon makes...

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