Determine your monthly mortgage payment

Reference no: EM131896991

Assignment -

You have found your desired house for $500,000 and you like to purchase it. You approached a mortgage company for loan. The company asked you that if you pay 20% down, you are able to get a 30 years loan for the remaining balance with interest rate of 4.75% with zero points. You accepted the deal. Assuming the mortgage is payable at the end of each month.

Required: Develop an excel spread sheet and:

On the first couple of lines of your worksheet enter all the necessary information. Then Use these information to apply for the following requirements. Make sure to avoid typing in any unnecessary information. You need to use appropriate cells.

1. Determine your monthly mortgage payment

2. Prepare a worksheet as follows:

Period	Monthly Payments	Monthly Interest	Principle	Balance
0
1
2
3
. .
360

3. What is the total amount of interest that you have to pay over 30 years?

Reference no: EM131896991

Questions Cloud

What is the e-sign act : What is the UCC and why do we have it? Define what Course of Performance, Course of Dealing, Usage of Trade, and Requirement Contracts are and how they relate.

What is the name for this characteristic of the test : You have to use "R Software". Use the model to classify the subjects into predicted outcomes using a 0.5 cutoff. What is name for this characteristic of test

Disucss about a corporation freedom of speech : The United States Constitution is the supreme law of the land. In 2010, the US Supreme Court (the highest court in our country) ruled that the First Amendment.

What should be the discount rate to be used for cash flows : What should be the discount rate to be used for the cash flows from this project?

Determine your monthly mortgage payment : You have found your desired house for $500,000 and you like to purchase it. Determine your monthly mortgage payment

Develop a case for your contention : As the human resources manager, develop a case for your contention that the selection of Mary Younger did not violate the contract.

What should be the discount rate to be used for cash flows : What should be the discount rate to be used for the cash flows from this project?

What is estimate of bigoil weighted average cost of capital : What is the estimate of BigOil’s weighted average cost of capital, RWACC?

What are the broad categories of development methods : What are the three roles of a coach? How is coaching different from mentoring? What are some advantages of using someone outside the organization as a coach?

User Account

All Pages