answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
77julia77
1 month ago
11

Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a mortgage for the remai

nder. It will be a 30 year, fully amortizing, FRM, with constant monthly payments and monthly compounding. The annual interest rate is 4.00%. She will pay $5,000 in closing costs at origination. She will also pay 1.75% of the balance in buy-down points at origination. Note: the home is bought and the loan is taken in month 0, the first payment is due in month
1. In the spreadsheet where it says "cash inflow", "outflow" and "net cash flow" you should only take into account cash flow related to the mortgage.
2. Fill in the spreadsheet (sheet "FA AMORTIZATION SCHEDULE") for Ann. (It is called an amortization schedule or amortization calendar.)
3. Compute Ann's annualized IRR for the mortgage in the spreadsheet. (Use the net cash flow.)
(3.a) What is the annualized IRR for the mortgage?
(3.b) Is it higher or lower than the mortgage contract rate?
(3.c) Why? in excel
Business
1 answer:
soldi70 [3.6K]1 month ago
7 0
Please refer to the attached Excel file for the cash flow breakdown. The Equated Monthly Installment (EMI) is calculated by considering that there will be a balloon payment due at term's end. Additionally: 3b) The IRR is below the mortgage contract rate. 3c) This lower IRR is due to the presence of a balloon payment. You can find the cash flow calculations in the spreadsheet.
You might be interested in
CHERCRO Inc. is a startup. It is estimated that the company will not be paying any dividends for the coming 4 years. If the comp
Mariulka [3825]
Policy 1: The price at the end of year 4 is calculated as D5/(rs-g) = 3 /(.12-.02) = 3/.10 = $30 per share. The current price is determined using PVF12%,4* Price at year 4 =.63552 * 30 = $19.07 per share. Policy 2: The price at the end of year 4 is D5/(rs-g) = 2 /(.12-.06) = 3/.06 = $50 per share. The current price is then calculated as PVF12%,4* Price at year 4 =.63552 * 50 = $31.78 per share. Policy 2 should be favored as it offers a higher market price per share.
8 0
2 months ago
In early July, Damon Rutton purchased a $70 ticket to the December 15 game of the Sarasota Shippers. Parking for the game was ex
harina [3808]
The sunk cost amounts to $70. Sunk Cost describes an expense that has already been incurred and is non-recoverable. Typically, these costs are ignored in decision-making as they cannot be avoided regardless of the decisions made. In this scenario, Damon Rutton spent $70 on a ticket, which is the only pre-paid expense; any additional costs for parking or refreshments would only be incurred if he chooses to attend the game.
8 0
1 month ago
Your friends sees your answer #1 and assumes that each of those people has a high credit score . Why is your friend incorrect ?
Scilla [3833]

Answer:

To achieve a strong credit score, one must consistently manage debt repayments since they began borrowing.

Your friend is mistaken in thinking that everyone who made all payments on time within a single year has a high credit score, as this view overlooks prior years' activities.

Some individuals might have missed payments on earlier loans but managed to maintain timely payments in 2015. Although this can enhance their credit score, the score would still reflect a lower value due to previous behaviors that negatively impacted it.

5 0
2 months ago
Which concept of marketing is described in the following scenario?
stepan [3596]

Conclusion: Advertisement

Rationale: When they mention receiving consecutive awards, it essentially promotes the message "Purchase our vehicle; we consistently receive awards," which I view as a form of advertising.

7 0
2 months ago
Other questions:
  • On October 29, 2017, Lobo Co. began operations by purchasing razors for resale. Lobo uses the perpetual inventory method. The ra
    11·1 answer
  • Which of the following would be the main reason you use the task feature?
    11·2 answers
  • The HR director at Clearwater Electronics has been asked to advise the board on a proposal to implement a variable compensation
    7·2 answers
  • Athen tech., a software company, changed its pay structure from 3,000 job titles and 12 pay grades to a simpler structure with 1
    15·1 answer
  • Kristian has a family and is very comfortable in his hometown. He wants to work for the government but does not want to move awa
    13·1 answer
  • R. J. Graziano Wholesale Corp. uses the LIFO method of inventory costing. In the current year, profit at R. J. Graziano is runni
    8·1 answer
  • Above is a utility schedule for your grandmother. Assume the equilibrium price of Product A is $5 and the equilibrium price of P
    10·1 answer
  • In June 1985, Joseph Marcantuone and Robert Gieson purchased property located in East Orange, New Jersey. At the time of purchas
    15·1 answer
  • Even though the nation faces political instability, the island of Frollik with its wide, expansive beaches is a destination hub
    13·1 answer
  • Total surplus in a market is equal to a. value to buyers - amount paid by buyers. b. amount received by sellers - costs of selle
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!