use excel to answer You have two options for paying your home insurance: 1) Pay $11,000 annually at the beginning of the year; or 2) Pay $1,000 monthly at the beginning of each month. calculate the effective annual interest rate for the recurring payments, and then highlight it in yellow. Repeat the calculations using the incremental rate of return analysis, find AAIIR, then calculate the effective annual interest rate and highlight it in yellow. Assume MARR = 8%.

use excel to answer You have two options for paying your home insurance: 1) Pay $11,000 annually at the beginning of the year; or 2) Pay $1,000 monthly at the beginning of each month. calculate the effective annual interest rate for the recurring payments, and then highlight it in yellow. Repeat the calculations using the incremental rate of return analysis, find AAIIR, then calculate the effective annual interest rate and highlight it in yellow. Assume MARR = 8%.

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

Give typing answer with explanation and conclusion to all parts If $387674 is used to purchase an annuity earning 5.5% compounded monthly and paying $3102 at the end of each month, what will be the term of the annuity? Include the final, smaller annuity payment in the total. (Just state total months as a number, not years and months) What is N? What is I/Y? What is C/Y? What is P/Y? What is PV? What is PMT? What is FV?
Find the future value of an annuity due of $650 semiannually for four years at 8% annual interest compounded semiannually. What is the total investment? What is the interest? E Click the icon to view the Future Value of $1.00 Ordinary Annuity table. The future value is $. (Round to the nearest cent as needed.)
Find the periodic withdrawals PMT for the given annuity account. (Assume end-of-period withdrawals and compounding at the same intervals as withdrawals. Round your answer to the nearest cent.) $200,000 at 6%, paid out monthly for 11 years PMT = $ Need Help? Read It Watch It
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.
Find the future value of an annuity due of $1,500 semiannually for six years at 7% annual interest compounded semiannually. What is the total investment? What is the interest? E Click the icon to view the Future Value of $1.00 Ordinary Annuity table. The future value is $. (Round to the nearest cent as needed.)
Find the amount accumulated FV in the given annuity account. (Assume end-of-period deposits and compounding at the same intervals as deposits. Round your answer to the nearest cent.) $200 is deposited monthly for 10 years at 6% per year in an account containing $9,000 at the start FV = $ 49150 Need Help? Read It Watch It Submit Answer
Use the monthly payment formula to answer the question. Round your answer to two decimal places, if necessary. A home is purchased for $648,000 with a 10% down payment. Find the monthly payment if the mortgage has a 7.92% interest rate for 29 years. The monthly payment is $ X Ś oo BA K
Calculate the future value of the following annuities, assuming each annuity payment is made at the end of each compounding period. (FV of $1. PV of $1, EVA of $1, and PVA of $1) (Use tables, Excel, or a financial calculator. Round your answers to 2 decimal places.) 1. Annuity Payment $ 3,700 Annual Rate Interest Period Compounded Invested Future Value of Annuity 7.0% Semiannually 9 years 2. 6,700 8.0% Quarterly 5 years 3. 5,700 12.0% Annually 6 years
Percentages need to be entered in decimal format, for instance 3% would be entered as .03 in cell B12.) Set up an amortization schedule for a $60,000 loan to be repaid in equal installments at the end of each of the next 20 years at an interest rate of 20%. What is the annual payment? After you input the data for each scenario, click on the Graph tab (second tab on the worksheet) and look at the Principal and Interest portions of the payments throughout the years. What do you notice about the amount of Principal and Interest over the years (which amount is higher in the early years, and which amount is higher in the later years) of the loan? What do you notice about the difference in Principal and Interest in the 10% scenarios compared to 20% scenarios?
You are given the following about two annuities-immediate: Annuity A pays 300 at the end of each year for 18 years. d ofc Annuity B pays 399.865 at the end of each year for 9 years. At an annual effective rate of interest i, the PV of both annuities are equal. Calculate i. Ponible Answers 12% 11% C 10% D 13% 14%
Find the amount accumulated FV in the given annuity account. (Assume end- of-period deposits and compounding at the same intervals as deposits. Round your answer to the nearest cent.) $300 is deposited monthly for 10 years at 5% per year in an account containing $9,000 at the start FV = $ Need Help? Read It Watch It
Find the annual simple interest rate of a loan, where $900 is borrowed and where $1008 is repaid at the end of 18 months. Annual simple interest rate = %. Preview My Answers Submit Answers

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