(Components of an annuity payment) You take out a 20-year mortgage for $275,000 to buy a new house. What will your monthly payments be if the interest rate on your mortgage is 6 percent? Use a spreadsheet to calculate your answer. Now, calculate the portion of the 120th monthly payment that goes toward interest and principal. Use five decimal places for the monthly interest rate in your calculations. a. Using a spreadsheet to calculate your answer, your monthly payments will be $ ( Round to the nearest cent.)

(Components of an annuity payment) You take out a 20-year mortgage for $275,000 to buy a new house. What will your monthly payments be if the interest rate on your mortgage is 6 percent? Use a spreadsheet to calculate your answer. Now, calculate the portion of the 120th monthly payment that goes toward interest and principal. Use five decimal places for the monthly interest rate in your calculations. a. Using a spreadsheet to calculate your answer, your monthly payments will be $ ( Round to the nearest cent.)

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

Suppose you want to have $400,000 for retirement in 25 years. Your account earns 5% interest. Feel free to use the Online Basic Financial Calculator a) How much would you need to deposit in the account each month? es b) How much interest will you earn? $
K You have just taken out a five-year loan from a bank to buy an engagement ring. The ring costs $5,500. You plan to put down $1,200 and borrow $4,300. You will need to make annual payments of $1,200 at the end of each year. Show the timeline of the loan from your perspective. How would the timeline differ if you created it from the bank's perspective? Show the timeline of the loan from your perspective. (Select the best choice below.) OA. Year Cash Flow $4,300 0 OB. Year 0 Cash Flow - $1,200 OC. Year Cash Flow $5,500 0 OD. Year 1 - $1,200 1 $1,200 2 Cash Flow - $4,300 $1,200 - $1,200 2 $1,200 - $1,200 - $1,200 2 $1,200 3 - $1,200 3 $1,200 3 - $1,200 3 $1,200 - $1,200 4 $1,200 4 - $1,200 4 $1,200 5 - $1,200 5 $1,200 5 - $1,200 5 $1,200
How much money (to the nearest dollar) will you need to deposit in an account now in order to have $35,000 in the account after 5 years if the account earns 1.2% interest compounded weekly? Summarize the information provided, stating the interest rate in a decimal form. PN = r = N = k = Solve the problem and give your answer here:
Please show how to solve this using an Excel spreadsheet and please show the formulas. The maturity of the balloon loan is 5 years, amortization period is 30 years, loan amount is $85,000 with annual interest rate 4.5% and monthly payments. What is the monthly payment for this balloon mortgage? What is the balloon payment at the end of five years for this balloon mortgage?
Suppose you are buying your first home for $144,000, and you have $17,000 for your down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a 6.40% nominal interest rate, with the first payment due in one month. What will your monthly payments be? Group of answer choices $831.93 $857.64 $753.30 $714.27 $794.39
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)?
You can afford a $800 per month mortgage payment. You've found a 30 year loan at 8%6 interest a) How big of a loan can you afford? b) How much total money will you pay the loan company? c) How much of that money is interest?
You want to buy a new house. You can afford to pay $15,000 per year for 30 years with the first payment being due one year from today. If the interest rate on your loan is 3%, what price of home can you buy today? Enter your answer as a number rounded to 2 decimal places.
Tim wants to borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's monthly payments be on his mortgage? b. Amortize the loan and determine: Interest expense for the first quarter of the loan. Cash flows for the first quarter of the loan. Loan balance at the end of the first quarter of the loan. Please show your calculations, part b is very important. If you are using the TVM chart, please state whether you used PVoA, FVoA, PVoSA, FVoSA.
You plan to purchase an $80,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate offered to you is 8.00 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage.b. Calculate the amount of interest and, separately, principal paid in the 127th payment.c. Calculate the amount of interest and, separately, principal paid in the 159th payment.d. Calculate the amount of interest paid over the life of this mortgage.
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.
Kristy Joe deposits $130 each month in an ordinary annuity to save for a new car. If the annuity pays a monthly interest rate of 0.91%, how much will she be able to save in 5 years? Assume that the compounding is being done monthly. She will be able to save $ in 5 years. (Round to the nearest cent as needed.) Enter your answer in the answer box and then click Check Answer. All narts showing teljavascript:doExercise(7): Clear All Check Answer answers to questions asked by student like you 99 a

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