A mutual fund manager wishes to purchase a property that's been valued at $1.5 m. She has $200. deposit, and she will require a mortgage for the rest. The annual interest rate on the loan is 2.45% and the loan is for 25 years. Calculate the monthly payments. Round your answer to the nearest cent. NOT round until you have calculated the final answer.

A mutual fund manager wishes to purchase a property that's been valued at $1.5 m. She has $200. deposit, and she will require a mortgage for the rest. The annual interest rate on the loan is 2.45% and the loan is for 25 years. Calculate the monthly payments. Round your answer to the nearest cent. NOT round until you have calculated the final answer.

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

Please show how to solve this unsing excel and please show all formulas in the spreadsheet. You decide to buy a house with price of $500,000, You put 20% down payment and consider a 15-year fixed rate mortgage to pay the remaining balance. The lender offers you three choices of the mortgage with monthly payments shown in the table as a., b., and c. Assume that the origination cost is $8,000. A. If the loan will be outstanding for 15 years, what is the effective cost for each choice? Which choice is most ideal? explain? B. Which mortgage choices are not properly priced? explain?
Suppose Lydia needs to borrow $24,200 for the purchase of a car and is considering two loan options. Loan A is a seven-year loan at 8.8% interest while loan B is a six-year loan at 8.3% interest.Determine the monthly payment required to repay Loan A and the total interest paid over the life of Loan A. Round solutions to the nearest cent, if necessary.The monthly payment for Loan A is $ Incorrect.The total interest paid for Loan A is $ Incorrect.Determine the monthly payment required to repay Loan B and the total interest paid over the life of Loan B. Round solutions to the nearest cent, if necessary.The monthly payment for Loan B is $ Incorrect.The total interest paid for Loan B is $ Incorrect.Determine the lower-cost option of the two loans. Loan A is the lower-cost option. Loan B is the lower cost option. Determine the amount of savings Lydia will experience if she chooses the lower-cost loan option.Savings = $
An investor wants to save money to purchase real estate. He deposits $550 at the end of each year in an ordinary annuity that pays 4% interest, compounded annually. Answer each part. Do not round any intermediate computations nor answers. If necessary, refer to the list of financial formulas. (a) Find the total value of the annuity at the end of the 1 year. st 24 (b) Find the total value of the annuity at the end of the 2 nd year. (c) Find the total value of the annuity at the end of the 3 rd year.
The Allen's want to purchase a house. They can afford $1,025 a month for 20 years and a $23,000 down payment. They finance the loan with an APR of 5.23% mortgage rate for 20 years. Determine the amount of the Allen's loan using TVM Solver on calculator. N= I%= PV= PMT= FV= P/Y= C/Y=
We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $80,000 at 9.25%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
Teal and Associates needs to borrow $65,000. The best loan they can find is one at 12% that must be repaid in monthly installments over the next 5 1/2 1 2 years. How much are the monthly payments? (a) State the type. A. ordinary annuityB.sinking fund C.present valueD.amortizationE.future value (b) Answer the question. (Round your answer to the nearest cent.)
You plan to purchase a $160,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.75 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 20th payment c. Calculate the amount of interest and, separately, principal paid in the 150th payment d. Calculate the amount of interest paid over the life of this mortgage. (For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) a. Monthly payment b. Amount of interest Amount of principal C. Amount of interest Amount of principal d. Amount of interest paid Amount
You purchase a house in East Lansing, MI. You calculate the amount financed to be $203,315. You obtain a 15-year mortgage with an interest rate of 3.8% and have calculated a monthly payment of $1,062. For the following, round your answer to the nearest cent. The payment on the principle in the first month is $450.41 $403.56 $418.17 $643.83 $489.31 OOOO
I need help working this problem out. Figuring out what table to use, whether to use: compound value, present value, amount of annuity, present value of annuity, sinking fund value? Please explain in detail each step. Nina deposits $3400 into a savings account earning simple interest at 6.3% annually. She intends to leave the money in the bank for three years. How much money, including both principal and interest, can she withdraw at the end of this time?
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. Please show all steps and formulas in an excel spreadsheet. 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 are in the market to buy a home. You plan on borrowing $312,627 from the bank. Interest rates are currently 3% for a 30 year mortgage (hypothetically, not actually). How much money will you pay in interest over the lifetime of the loan? Round to the nearest whole number.
An accounting firm agrees to purchase a computer for $130,000 (cash on delivery) and the delivery date is in 270 days. How much do the owners need to deposit in an account paying 0.55%compounded quarterly so that they will have $130,000 in 270 days? (a) State the type. sinking fundamortization ordinary annuitypresent valuefuture value (b) Answer the question. (Round your answer to the nearest cent.)

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