A new homeowner is purchasing a living room set for $2,590 and must decide between two monthly installment financing offers. Offer 1: $200 down payment, remaining balanced financed at a 24.90% interest rate for 3 years. Offer 2: $425 down payment, remaining balanced financed at a 22.90% interest rate for 4 years. Part A: What is the total cost of offer 1? Explain which technology you used to solve and each step of your process. Part B: What is the total cost of offer 2? Explain which technology you used to solve and each step of your process. Part C: Which financing offer should the new homeowner choose?

A new homeowner is purchasing a living room set for $2,590 and must decide between two monthly installment financing offers. Offer 1: $200 down payment, remaining balanced financed at a 24.90% interest rate for 3 years. Offer 2: $425 down payment, remaining balanced financed at a 22.90% interest rate for 4 years. Part A: What is the total cost of offer 1? Explain which technology you used to solve and each step of your process. Part B: What is the total cost of offer 2? Explain which technology you used to solve and each step of your process. Part C: Which financing offer should the new homeowner choose?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter5: Making Automobile And Housing Decisions

Section: Chapter Questions

Problem 8FPE

See similar textbooks

Similar questions

Please solve using excel and please explaing the steps to find out the best choice for each market condition listed below (choices a, b, and c) You decide to buy a house of $250,000 with loan amount of $200,000 and you plan to sell the house in year 10. The lender offers the following three SAM choices with $5,000 origination cost for each choice: $200,000; 30 years; monthly payment; 0% interest rate; 50% of appreciated value of the property in year 10. In addition, if the property is sold for a loss in year 10, the lender pays nothing. $200,000; 30 years; monthly payment; 3% interest rate; 50% of appreciated value of the property in year 10 $200,000; 30 years; monthly payment; 5% interest rate; 25% of appreciated value of the property in year 10 The housing market conditions: a. Home price will appreciate 30% in total for the next 10 years; b. Home price will stay the same for the next 10 years c. Home price will decline 30% in total for the next 10 years.
You are assiting a newly hired employee. You begin explaning the process of utilizing excel to finance properties. Consider the following. A realator has a house on sale for $640,000. If possible you believe you can finance the home for $300,000 for 20 years at a 3% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel. How would you caluclate this in Excel using the PV function? Rate: Nper: Pmt: FV: Type:
2. They decide to shop for furnishings for the new house. They choose items that amount to $2400.00. The store has 2 fixed installment loan options for purchasing: Option 1: 20% down payment and financing at 7% simple interest per year for 2 years. Option 2: no down payment and financing at 7.75% simple interest for 3 years. Answer each of the following questions separately, showing all your work to reach each answer. A. Which option will result in smaller total finance charge? What will that total finance charge be? B. Which option will result in the smaller monthly payment? What will that monthly payment be? C. They decide to defer any purchases and invest in a savings account a $2400 bonus that Maria will be getting from work. The rate is 1.5% interest compounded every month. How much interest will they earn in 3 years? D. They decide to defer any purchases and loan the $2400 bonus to a needy relative at 3% simple interest per year. How long will the term of the loan need to be if…
2.They decide to shop for furnishings for the new house. They choose items that amount to $2400.00. The store has 2 fixed installment loan options for purchasing: Option 1: 20% down payment and financing at 7% simple interest per year for 2 years. Option 2: no down payment and financing at 7.75% simple interest for 3 years. Answer each of the following questions separately, showing all your work to reach each answer. A. Which option will result in smaller total finance charge? What will that total finance charge be? B. Which option will result in the smaller monthly payment? What will that monthly payment be? C. They decide to defer any purchases and invest in a savings account a $2400 bonus that Maria will be getting from work. The rate is 1.5% interest compounded every month. How much interest will they earn in 3 years? D. They decide to defer any purchases and loan the $2400bonus to a needy relative at 3% simple interest per year. How long will the term of the…
a purchaser makes a 20% down payment on a new home and obtains a loan for the balance. The lender charges two discount points which equals 1000. what was the sale price of the house? I would like a break down on how to obtain the answer
Exercise 2: You are buying a foreclosed house. Your income only allows you to make a payment of $800 per month. You can negotiate the price of the house or the annual percent rate (APR). Proceed as follows. a. Based on the information in columns B and C, use Goal Seek to find the price that drives the monthly payment to $800. b. Based on the information in columns E and F, use Goal Seek to find the APR that drives the monthly payment to $800. Adjust price Price APR Months of payments Monthly Payment Adjust APR House Cost APR Months of Payments Monthly Payment $130,000.00 7.00% 360 360 $0.00 $361.11 Target Payment $800.00 Target Payment $800.00 14 5 16
You need a loan of $110,000 to buy a home. Calculate your monthly payments and total closing costs for each choice below. = Choice 1: 15-year fixed rate at 4% with closing costs of$1600 and no points. Choice 2: 15-year fixed rate at 3.5% with closing costs of$1600 and 3 points. What is the monthly payment for choice 1? $_______ (Do not round until the final answer. Then round to the nearest cent as needed.) What is the monthly payment for choice 2? $_____ (Do not round until the final answer. Then round to the nearest cent as needed.) What is the total closing cost for choice 1? $_____ What is the total closing cost for choice 2? $_____ Why might choice 1 be the better choice? A.The monthly payment is lower. B. The closing costs are lower. C. The monthly payment is higher. D. The closing costs are higher. Why might choice 2 be the better choice? A. The closing costs are lower. B. The monthly payment is lower C. The monthly payment is higher. D. The closing…
Find the amount of the down payment (rounded to the nearest hundred dollars) necessary for the buyer to afford the monthly payments for the described home. (Use this table to calculate your answer.) Monthly salary of $1,680, with monthly bills of $235; $89,000 home with a 30-year 9% loan Need Help? Read It Watch It
Find the annual homeowners insurance premium on a masonry home located in zone 1 if the home is insured for $237,000. The owner chooses a $1,500 deductible and has good credit. E Click the icon to see a hypothetical table of Estimated Annual Homeowners Insurance Premium Rates per $100 of Face Value. The annual homeowners insurance premium is $ (Simplify your answer. Type an integer or a decimal.)
Kranscript You need a loan of $150,000 to buy a home. Calculate your monthly payments and total closing costs for each choice below. Briefly discuss how you would decide between the two choices Choice 1: 20-year fixed rate at 4% with closing costs of $1300 and no points. Choice 2: 20-year fixed rate at 3.5% with closing costs of $1300 and 3 points. What is the monthly payment for choice 1? (Do not round until the final answer. Then round to the nearest cent as needed.) What is the monthly payment for choice 27 (Do not round until the final answer. Then round to the nearest cent as needed.) What is the total closing cost for choice 17 What is the total closing cost for choice 27 CITT
Assume you are preparing to move into a new neighborhood. You are considering renting or buying. Divide your team into two groups. Requirements Group 1 will analyze the renting option. A suitable rental is available for $500 per month, and you expect rent to increase by $50 per month per year. Prepare a schedule showing rent payments for the next 15 years. To simplify the problem, assume rent is paid annually. Using 5% as the discount rate, determine the present value of the rent payments. Round present value amounts to the nearest dollar. Group 2 will analyze the buying option. A suitable purchase will require financing $105,876 at 5%. Annual payments for 15 years will be $10,200 (annual payments assumed to simplify the problem). Calculate the present value of the payments. Additionally, using Excel with appropriate formulas, prepare a payment schedule with the following columns (year 1 is completed as an example): After each group has prepared its schedule, meet as a full team to…
A new homeowner is purchasing a living room set for $2,590 and must decide between two financing offers.Offer 1: $200 down payment, 24.90% interest rate, compounded monthly, for 3 years, with no payments due for 6 months and then fixed payments of $121.96 for the remainder of the loan termOffer 2: $450 down payment, 22.90% interest rate, compounded monthly, for 3 years, with no payments due for 12 months and then fixed payments of $140.48 for the remainder of the loan termPart A: What is the total cost of offer 1?Part B: What is the total cost of offer 2? Part C: Which financing offer should the new homeowner choose?