Foundations of Finance (9th Edition) (Pearson Series in Finance)
9th Edition
ISBN: 9780134083285
Author: Arthur J. Keown, John D. Martin, J. William Petty
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 41SP
(Spreadsheet problem) To buy a new house you take out a 25-year mortgage for $300,000. What will your monthly payments be if the interest rate on your mortgage is an APR of 8 percent compounded monthly? Use a spreadsheet to calculate your answer. Now, calculate the portion of the 48th monthly payment that goes toward interest and the portion that goes toward principal.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Answer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%?
Maximum mortgage at 7%: $
Maximum mortgage at 3%: $
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.
(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.)
Chapter 5 Solutions
Foundations of Finance (9th Edition) (Pearson Series in Finance)
Ch. 5 - Prob. 1RQCh. 5 - The processes of discounting and compounding are...Ch. 5 - Prob. 3RQCh. 5 - Prob. 4RQCh. 5 - Prob. 5RQCh. 5 - Prob. 1SPCh. 5 - Prob. 2SPCh. 5 - Prob. 3SPCh. 5 - Prob. 4SPCh. 5 - (Compound value) Stanford Simmons, who recently...
Ch. 5 - (Future value) Sarah Wiggum would like to make a...Ch. 5 - Prob. 7SPCh. 5 - Prob. 8SPCh. 5 - Prob. 9SPCh. 5 - Prob. 10SPCh. 5 - Prob. 11SPCh. 5 - Prob. 13SPCh. 5 - Prob. 14SPCh. 5 - Prob. 15SPCh. 5 - Prob. 16SPCh. 5 - Prob. 17SPCh. 5 - Prob. 18SPCh. 5 - Prob. 19SPCh. 5 - Prob. 20SPCh. 5 - Prob. 21SPCh. 5 - Prob. 22SPCh. 5 - Prob. 23SPCh. 5 - (Solving for PMT of an annuity) To pay for your...Ch. 5 - Prob. 25SPCh. 5 - Prob. 26SPCh. 5 - (Loan amortization) On December 31, Beth Klemkosky...Ch. 5 - (Solving for r of an annuity) You lend a friend...Ch. 5 - Prob. 29SPCh. 5 - (Compound annuity) You plan on buying some...Ch. 5 - (Loan amortization) On December 31, Son-Nan Chen...Ch. 5 - (Loan amortization) To buy a new house you must...Ch. 5 - Prob. 33SPCh. 5 - Prob. 34SPCh. 5 - Prob. 35SPCh. 5 - Prob. 36SPCh. 5 - Prob. 37SPCh. 5 - (Compound interest uith nonannnal periods) a....Ch. 5 - (Compound interest with nonannual periods) After...Ch. 5 - Prob. 40SPCh. 5 - (Spreadsheet problem) To buy a new house you take...Ch. 5 - (Nonannual compounding using a calculator) Jesse...Ch. 5 - (Nonannual compounding using a calculator)...Ch. 5 - (Nonannual compounding using a calculator) Fords...Ch. 5 - Prob. 45SPCh. 5 - (Nonannual compounding using a calculator) Dennis...Ch. 5 - Prob. 47SPCh. 5 - (Calculating the effective annual rate) Youve just...Ch. 5 - Prob. 49SPCh. 5 - Prob. 50SPCh. 5 - (Present value) The Kumar Corporation is planning...Ch. 5 - (Perpetuities) What is the present value of the...Ch. 5 - (Complex present value) How much do you have to...Ch. 5 - (Complex present value) You would like to have...Ch. 5 - Prob. 55SPCh. 5 - Prob. 56SPCh. 5 - Prob. 57SPCh. 5 - Prob. 58SPCh. 5 - (Present value of a complex stream) Don Draper has...Ch. 5 - (Present value of a complex stream) Don Draper has...Ch. 5 - (Complex stream of cash flows) Roger Sterling has...Ch. 5 - (Future and present value using a calculator) In...Ch. 5 - Prob. 1MCCh. 5 - Prob. 2MCCh. 5 - Prob. 3MCCh. 5 - Prob. 4MCCh. 5 - Prob. 5MCCh. 5 - Prob. 6MCCh. 5 - Prob. 7MCCh. 5 - Prob. 8MCCh. 5 - Prob. 9MCCh. 5 - Prob. 10MCCh. 5 - Prob. 11MC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- I need help solving this on excel 9.You a buying a home for $425,000 and would like to determine the monthly mortgage payment. You can obtain a $340,000 30-year fixed-rate mortgage at 3.5%. What is your monthly payment?arrow_forwardIn the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, use the PMT function to determine what your monthly payment will be. Submit the spreadsheet in Canvas.arrow_forwardYou take out a 20-yearmortgage for $310,000 to buy a new house. What will your monthly payments be if the interest rate on your mortgage is 9 percent? Use a spreadsheet to calculate your answer. Now, calculate the portion of the 96th 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 arrow_forward
- Suppose you want to buy a rent to own house worth P450,000. You made a down payment of 15% of the purchase price and take a 25 year mortgage for the balance. a. What is your down payment? b. What is your mortgage amount? c. What is the total interest charged over the life of the loan if your monthly payment is P2,200? Solve manually in a paper.arrow_forward(Use Formula Approach or Calculator Approach) Suppose you borrow $10,000 from your parents to buy a car. You agree to pay $207.58 per month for 60 months. What is the monthly interest rate?arrow_forwardSuppose you need to borrow $200,000 to buy a home, and you are deciding between a 15 year mortgage and a 30 year mortgage. Research a bank offering 15 year and 30 year mortgage loans and find the interest rates on those loans. Use the techniques you learned in this Module to do the following: 1. Calculate the monthly payment for a 15-year mortgage and for a 30-year mortgage. 2. Find the total amount of interest you will pay on the 15 year mortgage and on the 30 year mortgage. 3. Describe some of the factors (financial and non-financial) that can influence whether to obtain a shorter term mortgage or a longer term mortgage. 4. Which mortgage would you take, the 15 year or the 30 year? Explain your decision.arrow_forward
- You are going to buy a house and borrow $542474 with a 30-year mortgage. Your interest rate is 3.37%. What will be your monthly payment? (Remember that you need a monthly "r" and a monthly "t".) Answer:arrow_forwardYou decide to purchase a house for $260,000. You have saved money so you are able to do a down payment of $20,000. You are able to finance your house by getting a 25 year mortgage with an interest rate of 7%. What are the monthly payments? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Part 2 - Six years later, you decide to calculate your loan balance? (Use a payment value rounded to 2 decimal places. Round your final answer to 2 decimal places.) (Hint. Use the remaining years for “N”). Part 3 - If the house appreciates at 3.12 percent per year, what will be the value of the house in eight years? (Round your final answer to 2 decimal places.) NOTE: Provide a format and show your work (example: N = 6, PV = XXX, I = X%, etc.)arrow_forwardYou can afford a $1400 per month mortgage payment. You've found a 30 year loan at 8% interest. a) How big of a loan can you afford? Round your answer to the nearest dollar. b) How much total money will you pay the loan company? Round your answer to the nearest dollar. c) How much of that money is interest? Round your answer to the nearest dollar. Question Help: D Post to forum Submit Questionarrow_forward
- 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)?arrow_forwardPlease show all steps and formulas in an excel spreadsheet 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)?arrow_forwardSuppose you take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author: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 ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
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
How To Calculate The Present Value of an Annuity; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=RU-osjAs6hE;License: Standard Youtube License