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,...
-
On January 1, 2012, Gustin Inc. changed from the LIFO method of inventory pricing to the FIFO method. Explain how this change in accounting principle should be treated in the companys financial...
-
Suppose there is an election for Soft Drink Commissioner. The field consists of one candidate from the Pepsi party and four from the Coca-Cola party. This would seem to indicate a strong preference...
-
Aussie Steaks Inc. operates a chain of steak restaurants in the United States. On January 1, 2015, the company had \($500\) million in assets. On January 1, 2015, the company acquired 25 percent of...
-
Shirleys Beauty Store records sales and purchase transactions in the general journal. In addition to a general ledger, Shirleys Beauty Store also uses an accounts receivable ledger and an accounts...
-
For which type of financial decision you undertake an analysis for ABC Limited? a) Investment decision b) Financing decision c) Dividend decision d) Both investment and financing decisions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Aqua Construction Ltd is a construction company with five directors. Phil Jackson is the managing director and only executive director of the company. The non-executive directors are Damian Westford...
-
Nishi Corporation's common stock just paid $0.79 dividend recently and dividends are expected to grow at a constant rate for the foreseeable future. The investors' required rate of return on the...
-
6. Given the following C program. Fosc = 8MHz. Answer the following questions. #include int main(void) { DDRC = 0xff; TCCR0=0x02; TCNT0 = -128; while(1) { } return 0; while (!(TIFR & (1
-
When the following code is run: def my Function (aStr): result = len(aStr.split(' ')) return result exclamation = "As easy as 123 " print (myFunction (exclamation)) What output will be displayed?
-
Part 6: Match the sources of bias with the type of study design and the best way to minimize the bias. Type of study design: a. Case-Control b. Cohort Way to minimize bias a. Obtain controls from the...
-
The revenue from the sale of x units of a product is given by R(x)=12x-0.04x^2 thousand dollars, where 0 x 250. How many units should be sold to maximize the revenue?
-
Solve the following inequality. x-15x > -50
-
Rowland Textile Inc. manufactures two products: sweatshirts and T-shirts. The manufacturing process involves two activities: cutting and sewing. Expected overhead costs and cost drivers are as...
-
How did the U.S. secondary mortgage markets evolve?
-
What is convexity?
-
What was Bank Transfer Day?
-
Using Rules 5.1, show that if \(x>0\) and \(y <0\) then \(x y <0\), and that if \(a>b>0\) then \(\frac{1}{a}
-
For which values of \(x\) is \(x^{2}+x+1 \geq \frac{x-1}{2 x-1}\) ?
-
For which values of \(x\) is \(-3 x^{2}+4 x>1\) ?
Study smarter with the SolutionInn App