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

Calculate the DTI ratio (as a percent) for a borrower who has a gross monthly income of $5,330 and has a minimum credit card bill of $250.00, a car lease payment of $344.97, and a student loan payment of $187, and who is applying for a loan for which the monthly payment will be $2,584.64?
you were just informed of the interest rate on your student loan. it is started as 0.2% per month. determine nominal interest rate r per month. the nominal interest rate r is ..... %
Please include the excel formula If the following is a loan, identify a) the principal amount, b) the monthly interest rate, and c) the length of the loan in months. Determine if the following situation is an investment or a loan. If the following is an investment, identify a) if it is a one-time or recurring investment, b) the number of compounding periods per year and c) the total number of compounding periods. If the following is a loan, identify a) the principal amount, b) the monthly interest rate, and c) the length of the loan in months. Ashtyn purchased new appliances for her house for a total of $5,744. The store she buys the appliances from offers an annual simple interest rate of 8.5% with no down payment and monthly payments for 3 years. This situation represents a(n) . a) b) c) What will be your monthly payments? Use Excel to calculate the value.
What is the internal rate of return on a $3,000 loan to be repaid as $3,500 twoyears from now?
You borrow a GPM of $120,000 with annual payments and 30-year term. The interest rate is 10%. The payment rises by 2% each year. please show how to solve using excel to answer a. b. and c. below a. What are the annual payments for years 1 to 30? b. What is remaining balance at the end of each year? c. What are the interest payment and principal payment for years 1 to 30?
Suppose that you want to take out a loan and that your local bank wants to charge you an annual real interest rate equal to 3%. Assuming that the annualized expected rate of inflation over the life of the loan is 1%, determine the nominal interest rate that the bank will charge you. What was the actual real interest rate on the loan if, over the life of the loan, actual inflation is 0.5%?
You are looking at a one-year loan of $20,000. The interest rate is quoted as 10 percent plus two points. A point on a loan is 1 percent (one percentage point) of the loan amount. Quotes similar to this one are common with home mortgages. The interest rate quotation in this example requires the borrower to pay two points to the lender up front and repay the loan later with 10 percent interest. What rate would you actually be paying here? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. Answer is complete but not entirely correct. Interest rate 12:00 %
Use the Excel NPV() function to calculate the maximum loan you would be willing to give today for a borrower to make 8 years of $18,000 payments at 10 percent interest.
Find the following. (Round your answers to the nearest cent.) FinanceCharge Number ofPayments Frequency Amount Number ofPayments Left $9.10 12 Monthly $15 5 (b) the amount needed to pay off the loan
Please build an excel spreadsheet and show the formulas to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
Given the following loan information: Annual loan payment = $47,100 Number of remaining periods = 6 Interest rate = 12% What is the book value of the loan?
Suppose you take a 6 year loan of $50,000 with an annual interest rate of 13% and monthly payments starting at the end of year 1. What are the monthly loan payments? Enter your response below.

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