13. If you botrow $1823 and pay back $2,728 in three years, what annual rate of interest are you paying? Use opposite signs for PV and FV. EXCEL FUNCTION 14. How long will it take you to triple your money af 6% ? EXCEL FUNCTION 10. You agree to finance your new SUV with an auto loan of $51623. This loan will be repaid over four years with monthly payments and compounding at a 4% Annual interest rate. What will your monthly loan payment be? Assume PV to be negative so that the PMT is positive. I need the correct EXCEL FUNCTION.

13. If you botrow $1823 and pay back $2,728 in three years, what annual rate of interest are you paying? Use opposite signs for PV and FV. EXCEL FUNCTION 14. How long will it take you to triple your money af 6% ? EXCEL FUNCTION 10. You agree to finance your new SUV with an auto loan of $51623. This loan will be repaid over four years with monthly payments and compounding at a 4% Annual interest rate. What will your monthly loan payment be? Assume PV to be negative so that the PMT is positive. I need the correct EXCEL FUNCTION.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 14P

See similar textbooks

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
you are analyzing a GPM. the terms are $60,000 loan amount, 9% note rate, 30 years, monthly payments, OFV, payments in year one based based upon 7%, and payment in year two based on 8%. how much will you owe on this loan at the end of the second year? Please assist, using HP 10bII+.
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $989 per month, and the total finance charge is $9,504. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) Need Help? Read It Watch It Master It
You want to buy a bus. Cost is $180,000 with 10% down and the rest in 7 equal annual payments which include interest at 6%. The payments begin in one year. How much are the payments? Amortize the loan. Record the Journal Enteries.
Suppose you borrow $15,000 and then repay the loan by making 12 monthly payments of $1,297.92 each. What rate will you be quoted on the loan? NO EXCEL
You take out a 14-year personal loan for $13000 at rate of 8.1% which compounds 4 times per year. After 1 years, you refinance the loan and get a 13-year loan at a rate of 6.48%. a) When you first get the loan, how much is your payment? $ 390.24 Correct b) Make a spreadsheet for your loan balance, interest, and payments. After 1 years of paying, how much do you owe? $ c) Adjust your spreadsheet for the new interest rate starting when you refinance in year 1. What is your new payment? $
there is a house on sale for $800,000. You believe you can finance the home for $500,000 for 20 years at a 2% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel.
Suppose you lend $11,500 to a friend at an APR of 10.00%. Your friend will pay you back beginning next month with 60 monthly installments. You can reinvest the payments you receive in your money market account at an APR of 1.10%, calculated monthly. a. How much will your friend pay you each month? ______________ b. How much will you have in your account at the end of 60 months? (to nearest $___________________ c. What is your effective annual return (EAR), _._ _%?______________
You need a home loan of $65,000 after your down payment. How much will your monthly house payment be in the bank charges 6.25% APR for a loan of 15 years?( simplify your answer completely. Round your answer to the nearest cent)
4. Today you purchase a previously owned Tesla Model 3 for $40,000. You take out a 0.25% per month loan for the full amount to be repaid using 48 equal monthly payments. The first payment is due one month from today. How much of your second monthly payment is interest and how much is principal? You'll need to compute the monthly payment first.
2. You purchase a basic package, 4-door sedan for your company's fleet for $18,000. The 3 year loan has an interest rate of 13.75%. You make 10 payments and decide the 11th will be the payment to pay off the loan in its entirety. How much does the 11" payment need to be, using the Actuarial Method?
If Your bank _offers to lend y~u $100,000 at_ an 8.5% annual interest rate to start your new business. The terms reqwre you to amortize the loan with 10 equal end-of-year payments. How much interest would you be paying in Year 2?