Canyou I solve using excel formulas please. If you have7% APR loan for 25,000, your monthly payments are300. How many months will it take to pay off loan if thebank changes monthly payments to 250 (same interestrate)?

Time, value of money refers to a concept used for evaluating the present value of an asset that will…

Answered: Can you solve using excel formulas…

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

You can afford a $1500 per month mortgage payment. You've found a 30 year loan at 5.7% interest.a) How big of a loan can you afford? (Round to the nearest cent, as needed.)b) How much total money will you pay the loan company? (Round to the nearest cent, as needed.)c) How much of that money is interest? (Round to the nearest cent, as needed.)
The formula below finds the monthly payment for a loan (car, mortgage, student): P=I (r/1-(1+r)-n ) 7. If you want to buy a car that costs $16,000 with a loan at 3% APR how many years should you finance the car if you want your payment to be below $230? Do this problem any way you want, but clearly communicate your thinking.
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)?
If a person has ATM fees each month of $22 for 8 years, what would be the total cost of those banking lees? Totalcost
A consumer loan requires monthly payments, in equal amounts, $700.00. The next payment is due in one month. Assume that the appropriate discount rate is 21% (APR). What is the effective annual rate? (show them in excel spreadsheet, write your own present value formulas, don't use Excel built-in functions.
A payday lender might lend you $350 now, and you'll be asked to pay them back when your paycheck comes. Of course, you'll have to pay interest. The median fee charged by these types of lenders is $15 per every 100 borrowed. How much would you have to pay back in ten days?
You have a credit card that has a balance of $6400 at an APR of 13.49%. You plan to pay $300 each month in an effort to clear the debt quickly. How many months will it take you to pay off the balance?
Assume that you have a balance of $4200 on your Discover credit card and that you make no more charges. Assume that Discover charges 25% APR and that each month you make only the minimum payment of 2.2% of the balance. What will the balance be after 10 years? (Enter your answer rounded to the nearest cent.)
Question 3: You just got a loan for $15,000 and you plan to pay it off in three years. Your monthly payments are $500 each. What is the interest rate that the bank is charging you? What if you did bi- monthly payments of $250? How much sooner will the loan be paid off?
You bought a house for $275,000. The bank required a 30% down payment and gave you a 30-year mortgage loan for the remainder. Assume an annual interest rate of 4.5% and a monthly repayment schedule. What is the monthly payment? Round to the nearest $ and use the $ symbol. Hint...the last digit is 5
A bank advertises car loans at 8% compounded monthly for 4 years. There is a 0.5% reduction in the rate if you apply for the loan through the Internet. Suppose you wish to borrow $35 000.1. Calculate the regular monthly paythent at each interest rate.2. What is the total amount repaid for each loan3. How much interest do you save by applying through the internet?
You have a credit card that has a balance of $8930 at an APR of 16.49%. You plan to pay $400 each month in an effort to clear the debt quickly. How many months will it take you to pay off the balance?

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

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

Can you solve using excel formulas please. If you have 7% APR loan for 25, 000, your monthly payments are 300. How many months will it take to pay off loan if the bank changes monthly payments to 250 (same interest rate)?