Foundations Of Finance
10th Edition
ISBN: 9780134897264
Author: KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher: Pearson,
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 42SP
(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%: $
(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.)
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, use the PMT function to determine what your monthly payment will be. Submit the spreadsheet in Canvas.
Chapter 5 Solutions
Foundations Of 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 - Prob. 5SP
Ch. 5 - (Compound value) Stanford Simmons, who recently...Ch. 5 - (Future value) Sarah Wiggum would like to make a...Ch. 5 - Prob. 8SPCh. 5 - (Future value) Giancarlo Stanton hit 59 home runs...Ch. 5 - Prob. 10SPCh. 5 - Prob. 11SPCh. 5 - Prob. 12SPCh. 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 - Prob. 24SPCh. 5 - (Solving for PMT of an annuity) To pay for your...Ch. 5 - Prob. 26SPCh. 5 - Prob. 27SPCh. 5 - (Loan amortization) On December 31, Beth Klemkosky...Ch. 5 - (Solving for r of an annuity) You lend a friend...Ch. 5 - Prob. 30SPCh. 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. 34SPCh. 5 - Prob. 35SPCh. 5 - Prob. 36SPCh. 5 - Prob. 37SPCh. 5 - Prob. 38SPCh. 5 - (Compound interest uith nonannnal periods) a....Ch. 5 - (Compound interest with nonannual periods) After...Ch. 5 - Prob. 41SPCh. 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. 46SPCh. 5 - (Nonannual compounding using a calculator) Dennis...Ch. 5 - Prob. 48SPCh. 5 - (Calculating the effective annual rate) Youve just...Ch. 5 - Prob. 50SPCh. 5 - Prob. 51SPCh. 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. 56SPCh. 5 - Prob. 57SPCh. 5 - Prob. 58SPCh. 5 - Prob. 59SPCh. 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
- You 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_forwardI 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_forwardAnswer in text formatarrow_forward
- Please 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_forwardYou 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_forward
- 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)?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_forwardYou 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 in excel and the 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)?arrow_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_forwardSuppose your gross monthly income is $5,200 and your current monthly payments are $425. If the bank will allow you to pay up to 36% of gross monthly income (less current monthly payments) for a monthly house payment, what is the maximum loan you can obtain if the rate for a 30-year mortgage is 4.65%? (Round your answer to the nearest cent.) Need Help? Read It Submit Answerarrow_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