Create amortization schedule

Assignment Help Financial Management

Reference no: EM131904046

Ann would like to buy a house. It costs $800,000. Her down payment will be $40,000. She will take out a mortgage for $760,000. It will be a 30 year, fully amortizing, FRM, with constant monthly payments and monthly compounding. The annual interest rate is 4.00%. She must pay 2.5% in fees at the time of the loan.Note: the home is bought and the loan is taken in month 0, the first payment is due in month 1.

1. Create an amortization schedule

2. Compute Ann’s annualized and monthly IRR for the mortgage in the spreadsheet.

Reference no: EM131904046

Questions Cloud

What should fatima do in the given case : Team Effectiveness Colin and Raouf had been having one of their typical sidebar conversations during the meeting when an obviously irritated Henri looked.

Known as current procedural terminology codes : Procedure codes, known as Current Procedural Terminology (CPT) codes, are most commonly used to group cost centers for:

Discuss the stages of team development : Discuss the stages of team development. Address the process, problems, and level of productivity of each. What are the benefits of a project kickoff meeting?

What is the company cost of preferred stock : Barton Industries can issue perpetual preferred stock at a price of $58 per share. what is the company's cost of preferred stock?

Create amortization schedule : Create an amortization schedule. Compute Ann’s annualized and monthly IRR for the mortgage in the spreadsheet.

What are some common barriers to team effectiveness : What are some common barriers to team effectiveness? Think of a team project on which you have worked. Discuss any barriers to success.

Negotiate spot currency rate or forward currency rate : Would you try to negotiate a spot currency rate or a forward currency rate? If the latter, what maturity date would you use?

Describe some of the dimensions of diversity : Describe some of the dimensions of diversity. List some ways you can capitalize on diversity in order to achieve your project objective.

What is the equipment after-tax salvage value : Kennedy can sell the used equipment today for $5.5 million, and its tax rate is 30%. What is the equipment's after-tax salvage value?

User Account

All Pages