You are considering purchasing a new home with a price of $156,500. From the sale of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are considering purchasing a new home with a price of $156,500. From the sale of a previous home and your savings, you plan on a down payment of $30,000. Directions: 1. Insert house clip art here. 2. Create a worksheet similar to the one below to calculate your monthly house payment (not including any taxes). Calculating an Affordable House Payment 3. 4. Selling Price Down Payment Interest Rate $ 156,500 $ $ 156,500 S 30,000 30,000 Total Length of Monthly Total Loan in Years Payment Principal Interest 30 15 Research local mortgage rates to perform the calculations; find a fair rate for a 15-year and a 30-year mortgage and include them in your worksheet. Use a function to calculate the monthly house payment. Assume you decide that, if you take the 30-year mortgage, you cannot afford a monthly payment higher than $550. Use Goal Fook to determine how much of a down payment would be 3. 4. 5. Use a function to calculate the monthly house payment. Assume you decide that, if you take the 30-year mortgage, you cannot afford a monthly payment higher than $550. Use Goal Seek to determine how much of a down payment would be necessary to bring the house payment down to $550. Assume you decide that, if you take the 15-year mortgage, you cannot afford a monthly payment higher than $800. Use Goal 6. 7. 8. Seek to determine how low the interest rate must be to bring the house payment down to $800. Apply formatting of your choice to the worksheet. Add a header to the worksheet that includes your name in the center. Save the worksheet as EL2-U2-SA1-House Payment with the You are considering purchasing a new home with a price of $156,500. From the sale of a previous home and your savings, you plan on a down payment of $30,000. Directions: 1. Insert house clip art here. 2. Create a worksheet similar to the one below to calculate your monthly house payment (not including any taxes). Calculating an Affordable House Payment 3. 4. Selling Price Down Payment Interest Rate $ 156,500 $ $ 156,500 S 30,000 30,000 Total Length of Monthly Total Loan in Years Payment Principal Interest 30 15 Research local mortgage rates to perform the calculations; find a fair rate for a 15-year and a 30-year mortgage and include them in your worksheet. Use a function to calculate the monthly house payment. Assume you decide that, if you take the 30-year mortgage, you cannot afford a monthly payment higher than $550. Use Goal Fook to determine how much of a down payment would be 3. 4. 5. Use a function to calculate the monthly house payment. Assume you decide that, if you take the 30-year mortgage, you cannot afford a monthly payment higher than $550. Use Goal Seek to determine how much of a down payment would be necessary to bring the house payment down to $550. Assume you decide that, if you take the 15-year mortgage, you cannot afford a monthly payment higher than $800. Use Goal 6. 7. 8. Seek to determine how low the interest rate must be to bring the house payment down to $800. Apply formatting of your choice to the worksheet. Add a header to the worksheet that includes your name in the center. Save the worksheet as EL2-U2-SA1-House Payment with the
Expert Answer:
Answer rating: 100% (QA)
Purchasing a New home with a Price 156500 down Payment of 30000 without any taxes alculating An Affo... View the full answer
Related Book For
Money Banking and Financial Markets
ISBN: 978-0078021749
4th edition
Authors: Stephen Cecchetti, Kermit Schoenholtz
Posted Date:
Students also viewed these economics questions
-
You are considering purchasing a CNC machine which costs $ 150,000. This machine will have an estimated service life of 10 years with a net after tax salvage value of $15,000. Its annual after-tax...
-
You are considering purchasing a new injection molding machine. This machine will have an estimated service life of 10 years with a negligible aftertax salvage value . Its annual net aftertax...
-
A small manufacturing firm is considering purchasing a new machine to modernize one of its current production lines. Two types of machines are available on the market. The lives of machine A and...
-
Muskoka Boys Shaving Co. (MBSC") is a GST/HST registrant operating an online store in Ontario's cottage country region. The company specializes in selling fine grooming products for men. It is June...
-
The following events apply to Box Enterprises: 1. Acquired $30,000 cash from the issue of common stock. 2. Recognized $28,000 of service revenue on account. 3. Paid cash to rent office space for the...
-
Wheels on a passenger train car have a balance tolerance of G 40. Why is this acceptable?
-
Have world poverty and instability ended?
-
Cam and Anna are very satisfied with their first month of operations. Their major effort centered on signing various artists to live performance contracts, and they had more success than they had...
-
A power station generates electricity at 25,000 V, which is then stepped up to 500,000 V using a transformer for efficient transmission. If the primary coil has 200 turns, how many turns does the...
-
Two power plants are currently emitting 8,000 tons of pollution each (for a total of 16,000 tons) in City A. Marginal pollution reduction costs for Plant 1 are given by MCR 1 = 0.02 Q 1 and for Plant...
-
1. A company produces components for jet engines of commercial aircraft. One of its best-selling components is an aluminum alloy housing. Because of the many different jet engines that its customers...
-
Cherokee Incorporated is a merchandiser that provided the following information: Amount Number of units sold 13,000 Selling price per unit $ 18 Variable selling expense per unit $ 2 Variable...
-
Write a program named Admission for a college's admissions office. The user enters a numeric high school grade point average (0.00-4.00) and an admission test score (0-100). Display the message...
-
what will this code print out? 123456ROGDENE 7 8 9 10 11 1 public class TraceIf { public static void main(String[] args) { int var1 = 52; var1 %= 5; if (var1 == 0) { System.out.println("Hello"); }...
-
The output of the code below is #include #include int main(){ float x; x = floor(7.5); printf("%.2f ",x); return 0;}
-
Our friend River wrote the code shown with the intention of printing out a message to the user if the variable letter was a lowercase letter. However, upon testing it with the character 'A', the code...
-
When economists point out that you and millions of other people are interdependent, they are referring to the fact that we all A rely upon the government to provide us with the basic necessities of...
-
For a nonzero constant a, find the intercepts of the graph of (x 2 + y 2 ) 2 = a 2 (x 2 - y 2 ). Then test for symmetry with respect to the x-axis, the y-axis, and the origin.
-
You sell a bond futures contract and, one day later, the clearinghouse informs you that it had credited funds to your margin account. What happened to interest rates over that day?
-
You are sitting at the dinner table and your father is extolling the benefits of investing in bonds. He insists that as a conservative investor he will only make investments that are safe, and what...
-
Compare the impact of a given change in monetary policy in two economies that are similar in every way except that, in Economy A, the financial system has a large shadow banking system providing many...
-
\(f(t)=\delta(t-\tau)\) corresponds to a force applied at a. \(t-\tau=0\) b. \(t-\tau <0\) c. \(t-\tau>0\)
-
Find the response of a viscously damped system under the periodic force whose values are given in Problem 1.116. Assume that \(M_{t}\) denotes the value of the force in newtons at time \(t_{i}\)...
-
Find the displacement of the water tank shown in Fig. 4.43 (a) under the periodic force shown in Fig. 4.43 (b) by treating it as an undamped single-degree-of-freedom system. Use the numerical...
Study smarter with the SolutionInn App