Consider you just graduated college and want to purchase a house. Your dream home is a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider you just graduated college and want to purchase a house. Your dream home is a 4 bedroom, 2 bath, with 2,000 square feet house and is listed at $315,000. Assume you have enough money to put a 5% down payment ($315,000 * 5% = $15,750). You will qualify for a 30-year fixed mortgage of 5.05% APR. You will make monthly payments. Fill in the Loan Terms table and make a loan amortization table for financing the house in the Exercise 2 worksheet. When calculating the monthly payment, the periodic interest rate and the repayment term become: Periodic interest rate = APR / 12 (i.e., Monthly Interest Rate is Annual Percentage Rate / 12) Number of payments = Number of years * 12 When calculating the monthly payment, the periodic interest rate and the repayment term become: Periodic interest rate = APR / 12 (i.e., Monthly Interest Rate is Annual Percentage Rate / 12) Number of payments = Number of years * 12 Grading for Loan Terms table (6 points): 2 points for Borrowed, 2 points for Monthly Interest Rate, 2 points for Term in months. for the Loan Amortization Table (9 points): 3 points for Interest Payment Column, 3 points for Principle Payment column, 3 points for Loan Balance column a) What is the monthly payment? (3 points) b) How much total interest will you pay when paid in full according to the loan terms? (3 points) c) How much principal will you pay when paid in full? (3 points) d) How much will the house cost in total (principal + interest) when paid in full. (3 points) e) What is the interest payment for period 12 using the excel IPMT function? (3 points) f) What is the principal payment for period 12 using the excel PPMT function? (3 points) g) How much money would you save in interest over the life of the loan if the interest rate was 3.25%, instead of 5.05%? (3 points) Change cell c6 according to the new interest rate, excel automatically re-does all the calculations. Now write down the number associated with part (b), let's call this number X, undo this change (so now everything goes back to the initial value), subtract X from what you initially calculated for part (b). Consider you just graduated college and want to purchase a house. Your dream home is a 4 bedroom, 2 bath, with 2,000 square feet house and is listed at $315,000. Assume you have enough money to put a 5% down payment ($315,000 * 5% = $15,750). You will qualify for a 30-year fixed mortgage of 5.05% APR. You will make monthly payments. Fill in the Loan Terms table and make a loan amortization table for financing the house in the Exercise 2 worksheet. When calculating the monthly payment, the periodic interest rate and the repayment term become: Periodic interest rate = APR / 12 (i.e., Monthly Interest Rate is Annual Percentage Rate / 12) Number of payments = Number of years * 12 When calculating the monthly payment, the periodic interest rate and the repayment term become: Periodic interest rate = APR / 12 (i.e., Monthly Interest Rate is Annual Percentage Rate / 12) Number of payments = Number of years * 12 Grading for Loan Terms table (6 points): 2 points for Borrowed, 2 points for Monthly Interest Rate, 2 points for Term in months. for the Loan Amortization Table (9 points): 3 points for Interest Payment Column, 3 points for Principle Payment column, 3 points for Loan Balance column a) What is the monthly payment? (3 points) b) How much total interest will you pay when paid in full according to the loan terms? (3 points) c) How much principal will you pay when paid in full? (3 points) d) How much will the house cost in total (principal + interest) when paid in full. (3 points) e) What is the interest payment for period 12 using the excel IPMT function? (3 points) f) What is the principal payment for period 12 using the excel PPMT function? (3 points) g) How much money would you save in interest over the life of the loan if the interest rate was 3.25%, instead of 5.05%? (3 points) Change cell c6 according to the new interest rate, excel automatically re-does all the calculations. Now write down the number associated with part (b), let's call this number X, undo this change (so now everything goes back to the initial value), subtract X from what you initially calculated for part (b).
Expert Answer:
Answer rating: 100% (QA)
To calculate the loan terms and create a loan amortization table I will follow the given information and formulas Heres the Loan Terms table Loan TermsValue Borrowed299250 Monthly Interest Rate00421 T... View the full answer
Related Book For
Financial Markets and Institutions
ISBN: 978-0077861667
6th edition
Authors: Anthony Saunders, Marcia Cornett
Posted Date:
Students also viewed these accounting questions
-
You plan to purchase a house for $ 115,000 using a 30-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price. You will not pay off the mortgage...
-
You plan to purchase a house for $ 195,000 using a 30-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price. You will not pay off the mortgage...
-
You plan to purchase a house for $ 175,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 25 percent of the purchase price. You will not pay off the mortgage...
-
Find the value of each. If a limit does not exist, state DNE. y = g(x) a) lim g(x) = z-1+ m lim g(x)= z-1- lim g(x)= 241 b) g(1) = c) Is g continuous at x =1 Select an answer d) lim g(x) = 24-2 No,...
-
Which simple statistical model yields some of the best exchange rate predictions available? What does this imply for the value of models of exchange rate determination to multinational businesses?
-
Determine the heat rejected in kJ / kg to a simple ideal steam Rankine cycle with a condenser pressure of 2 0 kPa and a steam generator with a pressure of 2 MPa. ( The steam leaves the steam...
-
You are conducting a survey on the number of people per house in your region. From a sample with n = 60, the mean number of people per house is 3 and the standard deviation is 1 person. Using...
-
Out of Eden, Inc. is planning to invest in new manufacturing equipment to make a new garden tool. The new garden tool is expected to generate additional annual sales of 9,000 units at $42 each. The...
-
Mastery Problem: CVP and the Contribution Margin Income Statement For planning and control purposes, managers have a powerful tool known as cost-volume-profit (CVP) analysis. CVP shows how revenues,...
-
Consider an infinite 1D chain of H 2 molecules where the molecular axis is oriented perpendicular to the chain direction, as shown below. (a) How many bands are there in the band structure? (b)...
-
Which of the following statements is true? The FASB has concluded that obligations that are due on demand should be classified as current liabilities, even though liquidation of the liabilities is...
-
Companies have different cost structures, both companies currently show a profit of $ 2 1 , 0 0 0 based on sales of 1 4 , 0 0 0 units as shown in the following financial statements for the month of...
-
Prewer, Inc. received a $ 1 6 0 , 0 0 0 dividend on its investment consisting of 1 6 percent of the outstanding stock of TKS , Inc., a taxable domestic corporation. Before considering this dividend,...
-
Giovanna is 1 3 and has a YouTube channel that she uses to generate sales of her handmade craft items. She is currently earning $ 5 , 0 0 0 a year in sales. Her parents also made investments in her...
-
(a) E(B) = mc 1-8 with m = 5.64910 20 kg and c = 3 108 m/s. (b) x(t) = A sin (g/L t + y) with A = 3 mm, g = 9.81 m/s2, L = 60 cm and p = 0.4 rad. (Calculator must be in radians.)
-
1. A firm has a production function y = KVL, where K, L are positive quantities of capital and labor and y is the quantity of output. Given a positive input prices r for K and w for L, a producer...
-
The unique characteristics of reptilian eggs (shell thickness, size, and shape).
-
Gopher, Inc. developing its upcoming budgeted Costs of Quality (COQ) with the following information: Expense Item Budget Raw Materials Inspection $ 15,000 EPA Fine 200,000 Design Engineering 15,000...
-
How did the U.S. secondary mortgage markets evolve?
-
What is convexity?
-
What was Bank Transfer Day?
-
A mixture of benzene and monochlorobenzene is to be separated into almost pure products by distillation. Determine an appropriate operating pressure at the top of the tower.
-
The feed to a distillation tower consists of \(14.3 \mathrm{kmol} / \mathrm{hr}\) of methanol, \(105.3 \mathrm{kmol} / \mathrm{hr}\) of toluene, \(136.2 \mathrm{kmol} / \mathrm{hr}\) of ethylbenzene,...
-
In a reboiled absorber, operating as a deethanizer at 400 psia to separate a light hydrocarbon feed, conditions at the bottom tray are: Liquid Phase Molar flow = 1, \(366 \mathrm{lbmol} /...
Study smarter with the SolutionInn App