Ricardo and Miranda Ramos are considering whether to buy their first home, and have spoken to three lenders about taking out a mortgage for the house purchase. They now pay $1,500 per month in rent and can pay up to $1,600 per month for a mortgage. Miranda has created an Excel spreadsheet to compare the terms of the mortgage. She asks you to help her complete the analysis of their loan options. Go to the Mortgage Calculator worksheet. The cells in the range B5:B7 have defined names, but one is incomplete and could be confusing. Cell A2 also has a defined name, which is unnecessary for a cell that will not be used in a formula. Update the defined names in the worksheet as follows: Delete the Loan_Payment_Calculator defined name. For cell B7, edit the defined name to use Loan_Amt as the name. [Mac Hint: Delete the existing defined name "Loan_Am" and add the new defined name.] a. b. In cell B7, calculate the loan amount by entering a formula without using a function that subtracts the Down Payment from the Price. Miranda also wants to use defined names in other calculations to help her interpret the formulas. In the range D3:D7, create defined names based on the values in the range C3:C7.

Ricardo and Miranda Ramos are considering whether to buy their first home, and have spoken to three lenders about taking out a mortgage for the house purchase. They now pay $1,500 per month in rent and can pay up to $1,600 per month for a mortgage. Miranda has created an Excel spreadsheet to compare the terms of the mortgage. She asks you to help her complete the analysis of their loan options. Go to the Mortgage Calculator worksheet. The cells in the range B5:B7 have defined names, but one is incomplete and could be confusing. Cell A2 also has a defined name, which is unnecessary for a cell that will not be used in a formula. Update the defined names in the worksheet as follows: Delete the Loan_Payment_Calculator defined name. For cell B7, edit the defined name to use Loan_Amt as the name. [Mac Hint: Delete the existing defined name "Loan_Am" and add the new defined name.] a. b. In cell B7, calculate the loan amount by entering a formula without using a function that subtracts the Down Payment from the Price. Miranda also wants to use defined names in other calculations to help her interpret the formulas. In the range D3:D7, create defined names based on the values in the range C3:C7.

Personal Finance

13th Edition

ISBN:9781337669214

Author:GARMAN

Publisher:GARMAN

Chapter9: Obtaining Affordable Housing

Section: Chapter Questions

Problem 3FPC

See similar textbooks

Similar questions

Can Olivia and Anthony Afford This Home Using the Monthly Income Loan Criterion? Next week, your friends Olivia and Anthony want to apply to the Fourth Global Bank for a mortgage loan. They are considering the purchase of a home that is expected to cost $125,000. Given your knowledge of personal finance, they’ve asked for your help in completing the Home Affordability Worksheet that follows. (Note: When completing the form, round each dollar amount to the nearest whole dollar.) To assist in the preparation of the worksheet, Olivia and Anthony also collected the following information: • Their financial records report a combined gross before-tax annual income of $125,000 and current (premortgage) installment loan, credit card, and car loan debt of $1,823 per month. • Their property taxes and homeowner’s insurance policy are expected to cost $3,125 per year. • Their best estimate of the interest rate on their mortgage is 7.5%, and they are interested in obtaining a 15-year loan.…
Please show how to solve questions a. and b. using an excel spreadsheet, and please show the formulas for the cell inputs. Carly decides to buy a house with price of $450,000. Carly puts 20% down payment and consider a 30-year fixed rate mortgage to pay the remaining balance. The lender offers Carly two choices of the mortgage with monthly payments in the table provided. Suppose that the origination cost is $6,000. a. If Carly holds the loan for 30 years, what is the effective cost for each choice? b. How about the effective cost for each choice if the loan will only be outstanding for 5 years (60 months) (the borrower will pay off the loan at the end of 60 months)?
Please show how to solve questions a. and b. using an excel spreadsheet, and please show the excel formulas. Carly decides to buy a house with price of $450,000. Carly puts 20% down payment and consider a 30-year fixed rate mortgage to pay the remaining balance. The lender offers Carly two choices of the mortgage with monthly payments in the table provided. Suppose that the origination cost is $6,000. a. If Carly holds the loan for 30 years, what is the effective cost for each choice? b. How about the effective cost for each choice if the loan will only be outstanding for 5 years (60 months) (the borrower will pay off the loan at the end of 60 months)?
No Plagiarism Please! Enter your answer and show all the steps that you use to solve this problem in the space provided. Your parents are buying a house for $187,500. They have a good credit rating, are making a 20% down payment, and expect to pay $1,575/month. The interest rate for the mortgage is 4.65%. What must their realized income be before each month? Be sure to include the following in your response: the answer to the original question the mathematical steps for solving the problem demonstrating mathematical reasoning
Please provide working to the solution for the question below: Anna and Bob have decided to buy an apartment. The cost of the apartment is RM150,000. They can get a 25-year mortgage at 8% and plan to make a down payment of 20% of the selling price. What will be their monthly mortgage payment?
Please show how to solve this using excel and please show all formulas in the spreadsheet please!! Steven decides to buy a house with price of $500,000, Steven puts 20% down payment and considers a 15-year fixed rate mortgage to pay the remaining balance. The lender offers him 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?
Please show how to solve this using an excel spreadsheet and show the formulas in the cells for the problem below. Robin buys a house of $600,000 today. She puts a down payment of 20% and borrows a fixed-rate mortgage with interest rate of 3.5% and monthly payment for 30 years. After 3 years, Robin's house is appreciated to the value of $750,000 and market interest rate goes up to 6%. How much money will she make in book after 3 years from both mortgage gain and home price appreciation?
Suppose 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.
Use the following to solve questions a. and b. and please buid an excel spreadsheet and please show the formulas on the excel spreadsheet. A house with price of $250,000 20% down payment, loan amount $200.000 30-year fixed rate mortgage with interest rate as follows: Suppose that there is $2,500 origination cost. a. Which choice would you like to choose if you will live in the house for 30 years? b. Which choice would you like to choose if you will live in the house for 5 years?
Determine whether each scenario below is a savings/investments question or a loans question. 1. Sabrina finances a $21,999 car at 4.25% APR over 5 years. If she makes a down payment for $5,000, how much will she end up paying in interest for the car? 2. Alejandro deposits $1,500 into an investment account with an APR of 2.25% compounded monthly. How much does Alejandro need to put into his account each month in order to have $5,000 in 3 years to purchase a car in cash? 3. Amy wants to buy a house for $150,000. She doesn't have enough yet for a 20% down payment. If she puts $2,000 into the account now and $500 every month, how long will it take for her to have enough for a 20% down payment to buy this house? 4. Arnie paid $500 for his $1,200 laptop. If he finances the rest at 6.75% over 24 months, how much money will he end up paying in total for this laptop?
Use the following to solve questions a. and b. with an excel spreadsheet and please show the formulas on the excel spreadsheet. A house with price of $250,000 20% down payment, loan amount $200.000 30-year fixed rate mortgage with interest rate as follows: Suppose that there is $2,500 origination cost. a. Which choice would you like to choose if you will live in the house for 30 years? b. Which choice would you like to choose if you will live in the house for 5 years?
Be sure that you show all of your work to reach your answer. Each step must be on a separate line. Your method to reach your answer must be clear and include explanations. Be sure to only round at the last step for your final answer. You plan to purchase a house for $410,000 and you will make a 20% down payment. You are evaluating two mortgages a 30-year fixed mortgage at 2.87% and a 15-year fixed mortgage at 2.25%. Your goal is to have a monthly payment that fits within your budget. a. Which mortgage will give you the lowest monthly payment? What will that payment be? How much less will this be than the other monthly mortgage payment? b. Assuming you take the full term of the mortgage, which mortgage will result in you paying the most interest? What will that interest be? How much more will this be than the interest on the other mortgage?