4. Your mom needs to borrow $45.500 for a house renovation. Her bank agrees to lend her the money over a 3-year term at an APR of 5% and will accept either annual, quarterly, or monthly payments. a. Calculate the periodic payment under each alternative (monthly. quarterly, and annual). For each alternative, you must do the following: i. Plug in the values in the formula. Annual Quarterly Monthly ii. Get the PMT in the calculator. Make sure you show me the keys you enter. iii. Write the Payment formula and arguments in Excel. b. Compare the total amount paid each year under each option. What option would your mom choose? Why?

4. Your mom needs to borrow $45.500 for a house renovation. Her bank agrees to lend her the money over a 3-year term at an APR of 5% and will accept either annual, quarterly, or monthly payments. a. Calculate the periodic payment under each alternative (monthly. quarterly, and annual). For each alternative, you must do the following: i. Plug in the values in the formula. Annual Quarterly Monthly ii. Get the PMT in the calculator. Make sure you show me the keys you enter. iii. Write the Payment formula and arguments in Excel. b. Compare the total amount paid each year under each option. What option would your mom choose? Why?

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

A friend of yours bought a new sports car with a $4,500 down payment plus a $27,000 car loan that is financed at an interest rate of 0.75% per month for 60 months. a. Calculate the required monthly loan payment on the car. b. How much does your friend still owe on the car loan immediately after she makes the 24th monthly payment? c. If, after the 24th payment, she decides to pay $100 more each month, how many months will it take her to payoff the remaining loan she owes? a. The required monthly payment is (Round to the nearest cent.) b. Your friend still owes $on the car loan. (Round to the nearest dollar.) c. It will take her months (Round-up to the nearest month)
Give me answer two questions please
Let’s assume that you plan to purchase a house which is selling for $350,000 today. You will make a monthly payment for the next 30 years, with an annual interest rate of 3%. What will be the amount of your monthly mortgage (i.e., home loan) payment? answer choices $1,890.37 $1,400.01 $1,475.61 $1,228.14
You need to borrow $750,000 to purchase a new house. JRE bank will loan you the money at an APR of 4.3% (monthly compounding) and a 15 year term (i.e. 180 monthly payments in total). After making exactly 27 payments, what is the total amount of interest you will have paid (rounded to the nearest dollar)? The total amount of interest is closest to: A. $63,309 OB. $84,140 c. $68,709 OD. $70,734 ...
A man borrows $60,000 to help pay for his college expenses. He intends to pay off the loan with regular monthly payments over the next 20 years. Find the monthly payment if he is being charged 4.7% interest per year, compounded monthly. Give the answer to 2 decimal places, and do not use the $ sign in the answer box. The monthly payment is Blank 1. Calculate the answer by read surrounding text. dollars.
You need a loan of $110,000 to buy a home. Calculate your monthly payments and total closing costs for each choice below. = Choice 1: 15-year fixed rate at 4% with closing costs of$1600 and no points. Choice 2: 15-year fixed rate at 3.5% with closing costs of$1600 and 3 points. What is the monthly payment for choice 1? $_______ (Do not round until the final answer. Then round to the nearest cent as needed.) What is the monthly payment for choice 2? $_____ (Do not round until the final answer. Then round to the nearest cent as needed.) What is the total closing cost for choice 1? $_____ What is the total closing cost for choice 2? $_____ Why might choice 1 be the better choice? A.The monthly payment is lower. B. The closing costs are lower. C. The monthly payment is higher. D. The closing costs are higher. Why might choice 2 be the better choice? A. The closing costs are lower. B. The monthly payment is lower C. The monthly payment is higher. D. The closing…
Harriet Marcus is concerned about the financing of a home. She saw a small cottage that sells for $75,000. Assuming that she puts 20% down, what will be her monthly payment and the total cost of interest over the cost of the loan for each assumption? (Use the Table 15.1) Note: Do not round intermediate calculations. Round your answers to the nearest cent. a. 25 Years, 5.00% b. 25 Years, 5.50% c. 25 Years, 5.75% d. 25 Years, 6.00% Monthly payment Total cost of interest e. What is the savings in interest cost between 5.00% and 6.00%? Note: Round your answer to the nearest dollar amount. Interest cost
Diane is deciding between two personal loans. For each loan, the loan amount is $7500. Use the ALEKS loan calculator for the following. Also use the regular ALEKS calculator, as necessary. Write your answers to the nearest cent. ALEKS Loan Calculator Loan amount: $ Loan term: Interest rate: Calculate years % Monthly payment: (a) For Loan A, the interest rate is 6.15% per year and the loan term is 7 years. Find the total amount to repay Loan A. S (b) For Loan B, the interest rate is 6.15% per year and the loan term is 5 years. Find the total amount to repay Loan B. (c) For which loan would she pay less, and by how much? Loan A The total amount paid is $ less. Loan B The total amount paid is $less. X Ľ
To help with a down payment on a home, Elsa is going to invest. Assuming an interest rate of 1.73% compounded annually, how much would she have to invest to have $36,800 after 7 years? Do not round any intermediate computations, and round your final answer to the nearest dollar. If necessary, refer to the list of financial formulas. $0 S oo E D
After starting your first full-time job out of college, you decide to buy a new car for $12,000. Using Excel, create a complete amortization table for this car-loan: You make 36 equal end- of-month payments. The discount rate is 7.25% compounded monthly. How much would you owe after the 15th payment is made? Use excel to solve
3. Chrissy is looking to buy a new bedroom set for $9674.99 She would also have to pay a $300 delivery fee. She is considering the following two credit options: Financing through the store at 3.7%, compounded monthly for a term of 2 years, with the incentive that the dealership will remove the shipping charge AND give a $500 rebate. • A bank loan at 3.5%, compounded monthly, for a term of 3 years. a. What are the monthly payments for each option? b. What is the total payment for each option? c. Which option should she choose and why? d. Why might she choose the other option?
Emily is buying a new car for $1,700. The dealer is charging her an annual interest rate of 10.2%. If she pays off the loan in 24 months, what are her monthly payments? If she makes a down payment of $210, how much will her monthly payments be? Round to two decimal places. OA. $170.57; $74.75 B. $170.57; $10.54 C. $85.28; $74.75 O D. $145.28; $10.54

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