Question

In: Finance

You got a new job as a university professor and want to settle down at East...

You got a new job as a university professor and want to settle down at East Lansing. You found a nice house which is selling for $500,000. You decided to pay a down payment of 10% (no closing cost), and borrow rest of the amount from the bank. This is a fixed payment loan that lasts for 10 years with annual payments. Interest rate is 6%.

Build the amortization table in Excel and show all the numbers.

Solutions

Expert Solution


Related Solutions

"Business Law" Dr. A quits her job at ABC University because she got a better job...
"Business Law" Dr. A quits her job at ABC University because she got a better job at XYZ University. Can ABC University get an injunction prohibiting her from teaching at XYZ University?
If you were starting a new job, would you want to be paid at the top...
If you were starting a new job, would you want to be paid at the top of your pay range or in the middle? What are the advantages and disadvantages to both? Provide an explanation for your response. Support your response with an APA cited reference(s).
You got a new job with Home Paint Pte Ltd who is selling paints to various...
You got a new job with Home Paint Pte Ltd who is selling paints to various retailers. The company is able to produce number of unique colours based on blending with several colour based pigments like yellow,red and blue. In order to produce magenta colour product,P, a paint mixture stream,F1,is mixed with another paint mixture stream,F2.F1 contains 30wt% of blue pigment in water whereas F2 contains 12.0wt%red pigment in water.It is given the cost of F1and F2 are $35.00/kg and...
You just got a new job at Six Flags to test roller coasters. The first roller...
You just got a new job at Six Flags to test roller coasters. The first roller coaster you test has a vertical circular loop with a diameter of 25 m. The empty car you are using has a mass of 135 kg. You can measure the speed of the empty car at all points along the loop and you find it has a speed of 27 m/s at the bottom and 9.5 m/s at the top of the loop. (a)...
You just got your first job and are buying a new car. After making a sizeable...
You just got your first job and are buying a new car. After making a sizeable down payment, you are borrowing the remaining $12,000 from your credit union at a loan rate of 6% APR over a five-year period. What are your monthly car loan payments?
You want to buy a new car for $25,000. You put $2000 down and are given...
You want to buy a new car for $25,000. You put $2000 down and are given $2000 as trade-in for your current car. You take out a loan for the remaining $21,000. The terms of the loan are an annual interest rate of 4.8% compounded monthly. You are to make 60 equal monthly payments (end of month) to pay off the loan. how can i get the answer using excel
You have always wanted to settle down on a different planet. NASA has recently announced that...
You have always wanted to settle down on a different planet. NASA has recently announced that it plans to construct and sell houses on the planet MARS. The current price of the house is $100,000 which is expected to increase every year at the inflation rate. You have just graduated from College and are currently 20 years old, you plan on working till the age of 40, save enough money and then move to MARS. You can earn 10% annually...
You bought a house for $150,000 and put down 10% and got a mortgage at an...
You bought a house for $150,000 and put down 10% and got a mortgage at an interest rate of 4.35 % per year. You would pay it back by paying an equal amount at the end of each month for 15 years? (Show all work) How much is your loan amount? How much is your monthly loan payment? How much is your loan balance after 2 years? How much is your total interest payment by the end of year 3?
Congratulations! You have just graduated from your University. Your first day on your new job involves...
Congratulations! You have just graduated from your University. Your first day on your new job involves a lot of paperwork including your decision to participate in the company 401K plan. First, should you participate? Second, describe the benefits of diversification if any including adding international stocks to your investment portfolio? You must include a full explanation to support your answer.
Job Stress Rating Mathematician 24 University Professor(Tenured) 4 Statistician 54 Actuary 54 Audiologist 1 Dental Hygienist...
Job Stress Rating Mathematician 24 University Professor(Tenured) 4 Statistician 54 Actuary 54 Audiologist 1 Dental Hygienist 11 Software Engineer 18 Computer Systems Analyst 58 Occupational Therapist 28 Speech Pathologist 17 l. Find the standard deviation.             m. Find the coefficient of variation.             n. What is the 80th percentile of this data set?             o. Does this data set have any outliers? Use statistics in answering this question (not just your opinion).             p. Would you use the Empirical rule...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT