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,...
-
The top of a round wooden table has the edge profile shown. Knowing that the diameter of the top is 44 in. before shaping and that the specific weight of the wood is 0.025 5 lb/in.3, determine the...
-
The tank in the previous problem feeds two lines, a 4-cm pipe that exits 10 m below the water level in the tank and a second line, also 4 cm in diameter runs from the tank to a station 20 m below the...
-
Algoma Metals Inc. uses a standard cost system. The months data regarding its cast iron vats follow: Prepare schedules of all variances, using the format of Exhibit 12-9 (the general three-column...
-
An aluminum calorimeter with a mass of 100 g contains 250 g of water. The calorimeter and water are in thermal equilibrium at 10.0C. Two metallic blocks are placed into the water. One is a 50.0-g...
-
Exercise C-3 Calculate the present value of a single amount (LOC-2) The four actors below have just signed a contract to star in a dramatic movie about relationships among hospital doctors. Each...
-
Real option analysis can be used to alter the timing, scale, or other aspects of an investment in response to market conditions. Businesses face the dilemma of whether to invest in a project or...
-
Kim Distribution Services (KDS) distributes food purchased in bulk to small retailers. The firm is divided into two divisions: Purchasing and Distribution. Purchasing is responsible for ordering...
-
Why do organizations have difficulty dealing with change resistance? How can this be fixed? Make sure to draw clear linkages between specific aspects of resistance and specific means to address them.
-
What is the main usage of Six Sigma in SCM?
-
T 1 FO product. For the following reaction, draw a complete mechanism and predict the major + HCI For the product shown, suggest a good starting alkene. Br
-
Why was King Louis - Philippe of France called the "bourgeois monarch"?
-
Sam recently took over as the controller of IC Manufacturing. Last month, the previous controller left the company with little notice and left the accounting records in disarray. Sam needs the ending...
-
2. Suppose Thompson Inc. purchased all the outstanding shares of Panna Corporation for $250,000 on January 1, 2018. The amount is paid partly by cash of $125,000 and the rest by issuing 10,000...
-
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?
-
Discuss the nature and relevance of culture to financial reporting classifications, making special reference to the financial reporting values identified by Gray. By what process is culture likely to...
-
Critically evaluate Grays proposed classification of culture areas according to the authority and enforcement aspects of financial reporting systems. How does your own country fit in with this...
-
Discuss the nature of Nobess hierarchical classification scheme. What are the critical factors involved? How easy is it to fit countries into the categories suggested?
Study smarter with the SolutionInn App