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

Find the monthly house payment necessary to amortize the following loan. 9) In order to purchase a home, a family borrows $121,000 at 3.0% for 30 yr. What is their monthly payment? Round the answer to the nearest cent.
Angela's bank gave her a 2-year add-on interest loan for $6,120 to pay for new equipment for her antiques restoration business. The annual interest rate is 8.28%. How much interest will she pay? What are her monthly payments? Question content area bottom Part 1 She will pay $enter your response here in interest on the loan. (Round to the nearest cent.) Part 2 Her monthly payments are $enter your response here. (Round to the nearest cent.)
Hazel has taken out a 40,000 loan that requires quarterly payments of $2300 over over five years. What is the APR for this loan how do I answer this using the TVM function
A couple plans to purchase a vacation home. The bank requires a 5% down payment on the $230,000 vacation home. The couple will finance the rest of the cost with a fixed-rate mortgage at 6% annual interest with monthly payments over 30 years. Complete the parts below. Do not round any intermediate computations. Round your final answers to the nearest cent if necessary. If necessary, refer to the list of financial formulas. (a) Find the required down payment. s (b) Find the amount of the mortgage. s (c) Find the monthly payment. $0
o help purchase her new car, Nicole is taking out a S34,000 amortized loan for 6 years at 5.8% annual interest. Her monthly payment for this loan is $560.27. Il in all the blanks in the amortization schedule for the loan. Assume that each month is of a vear. Round your answers to the nearest cent. Payment number Interest Principal payment New loan payment balance 1 2$ 2 30 $104.91 $455.36 $21,250.60 31
Find the monthly payment for the loan indicated. yo purchase a home, a family borrowed $97,000 at an annual interest rate of 6.3% for 20 years. $____
To help purchase his new car, Alonzo is taking out a $23,000 amortized loan for 6 years at 6.1 % annual interest. His monthly payment for this loan is $382.26. Fill in all the blanks in the amortization schedule for the loan. Assume that each month is of a year. Round your answers to the nearest cent. 12 Payment number Principal payment Interest New loan balance payment %24 %24 35 S66.99 $315.27 $12.863,69 36
MY NOTES ASK YOUR TEACHER Teal and Associates needs to borrow $65,000. The best loan they can find is one at 11% that must be repaid in monthly installments over the next years. How much are the monthly payments? (a) State the type. O future value O ordinary annuity O amortization O sinking fund O present value (b) Answer the question. (Round your answer to the nearest cent.) 2$ Need Heln? Read It
please answer with correct calculations and explanations. QUESTION: Kari is purchasing a home for $220,000. The down payment is 25% and the balance will be financed with a year mortgage at 8% and 4 discount points. Kari made a deposit of $30,000 (applied to the doen payment) when the sales contract was signed. Kari also has three expenses: credit report, $70; appraisal fee, $110; title insurance premium, 1% of amount financed; title search, $200; and attorney's fees, $500. Find the closing costs (in $).
After starting your full-time job out of college, you decide to buy a new car for $85,000. Create a complete amortization table in excel for this car loan: You make 84 equal end-of-month payments. The discount rate is 6.5 percent compounded quarterly. How much would you owe after the 75 th payment? Please show both regualr and formula format of the spreadsheet.
K Wei-Jen needs to borrow $5000. She can borrow from a finance company at 6.90% add-on interest for 4 years. Or she can borrow from a credit union (48 monthly payments of $134.14 each.) Find each APR and determine the better choice. 10.0 APR 10.5 APR 11.0 APR 11.5 APR 12.0 APR # of monthly payments (n) 24 36 48 60 10.75 16.16 21.74 27.48 11.30 17.01 22.90 28.96 11.86 17.86 24.06 30.45 12.42 18.71 25.23 31.96 Use the table to find the APR for the finance company loan.% (Round to the nearest half percent.) Use the table to find the APR for the credit union loan. % (Round to the nearest half percent.) Which is the better choice? 12.98 19.57 26.40 33.47 12.5 APR 13.54 20.43 27.58 34.99 13.0 APR 14.10 21.30 28.77 36.52
Jina obtains a loan for home renovations from a bank that charges simple interest at an annual rate of 7.45%. Her loan is for $12,700 for 62 days. Assume eachday is365of a year. Answer each part below.Do not round any intermediate computations, and round your final answers to the nearest cent. If necessary, refer to the list of financial formulas.(a) Find the interest that will be owed after 62 days. (b) Assuming Jina doesn't make any payments, find the amount owed after 62 days.

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