Define the annual percentage rate (APR). Suppose you borrow $3,621.15 and take out a loan with an 8% nominal interest rate. You must repay the loan with 48 monthly payments of $90 each. In addition, you must pay an initial loan processing fee of $100. What is the APR for this loan? How would this be done in excel?

Define the annual percentage rate (APR). Suppose you borrow $3,621.15 and take out a loan with an 8% nominal interest rate. You must repay the loan with 48 monthly payments of $90 each. In addition, you must pay an initial loan processing fee of $100. What is the APR for this loan? How would this be done in excel?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

If you borrow $9000 at an annual percentage rate (APR) of r (as a decimal) from a bank, and if you wish to pay off the loan in 3 years, then your monthly payment M (in dollars) can be calculated using: M = 9000 (er/12-1) / 1 - e-3r 1) Describe what M (0.035) would represent in terms of the loan, APR, and time. 2) If you are only able to afford a max monthly payment of $300, describe how you could use the above formula to figure out what the highest interest rate the bank could offer you and you would still be able to afford the monthly payments. In addition, determine the maximum interest rate that you could afford.
You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is the amount of interest? What is the true interest rate cost of this loan? If you could pay the same loan above at a compound rate: What would the monthly payment be? What would the amount of interest be? 3. Prepare a monthly payment schedule for each loan above using Excel, and submit it.
Use the appropriate function(s) in Excel to answer the following questions. How much would your monthly payment be on a 3-year loan if the following assumptions were true? You borrowed $7,400. The fixed APR on the loan is 3.2%. Note: A fixed APR is an annual interest rate that does not change during the 3-year period. You will make equal monthly payments to repay both the loan amount and the monthly interest charges. You want to completely pay off the loan in exactly 3 years. (Round to the nearest cent, do not include a negative sign) Note: while this money is "leaving your wallet" the negative sign should not be included in the numeric answer because it is already implied by the word "payment" What is the total amount that you would pay to the bank over this 3-year period? Hint: Be sure to use your rounded answer from the previous step in the calculation of this answer. (Round to the nearest cent, do not include a negative sign) How much total interest would you have paid…
Suppose you want to borrow $90,000 and you find a bank offering a 20-year loan with an APR of 5%. a. Find your regular payments if you pay n = 1, 12, 26, 52 times a year. b. Compute the total payout for each of the loans in part (a). c. Compare the total payouts computed in part (b). a. The payment for n = 1 would be $ The payment for n = 12 would be $ The payment for n = 26 would be $ The payment for n= 52 would be $ (Do not round until the final answer. Then round to the nearest cent as needed.)
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
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $983 per month, and the total finance charge is $9,288. 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.)
To payoff a loan of $1000 you need to make 40 payment of $36.56 per month. What rate of interest are you paying? What is the stated or quoted rate? What is the annual percentage rate? What is the effective annual rate? What rate is bank likely to use to state its rate?
Use the Loan Payoff Table to determine both the finance charge and the payment required to amortize a loan of $4100 at an annual interest rate of 11% with a term of 36 monthly payments. What is the amount of each payment? What is the finance charge?
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $987 per month, and the total finance charge is $9,432. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $).
If you borrow $8,637 and are required to pay back the loan in five equal annual installments of $2,700, what is the interest rate associated with the loan? Use Appendix D or a financial calculator to solve this problem. (Round your answer to the nearest whole percent.) Interest rate %
In a discount interest loan, you pay the interest payment up front. For example, if a 1-year loan is stated as $42,000 and the interest rate is 8.50%, the borrower “pays” 0.0850 × $42,000 = $3,570 immediately, thereby receiving net funds of $38,430 and repaying $42,000 in a year. a. What is the effective interest rate on this loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) b. What is the effective annual rate on a 1-year loan with an interest rate quoted on a discount basis of 18.50%? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)
Find the APR (true annual interest rate), to the nearest half percent, for the following loan. Amount Finance Number of Financed Charge Monthly Payments $2800 $100 12 Click the icon to view the annual percentage rate table. The annual percentage rate is %. Enter your answer in the answer box.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS