Business, 28.11.2019 04:31 KindaSmartPersonn

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 remainder. 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

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 14:30

Processors can be or which is an indicator of how much data the processors can handle at a given point in time, with the processor being more powerful.

Answers: 2

Answer

Business, 21.06.2019 18:00

Which of the following results from outsourcing jobs from the united states to other countries? a. increasing exports out the united states. b. lower wages for u.s. workers. c. reduced immigration to the united states. d. subsidies for goods made in the united states. 2b2t

Answers: 2

Answer

Business, 22.06.2019 01:20

For a multistate lottery, the following probability distribution represents the cash prizes of the lottery with their corresponding probabilities. complete parts (a) through (c) below. x (cash prize, $) p(x) grand prizegrand prize 0.000000008860.00000000886 200,000 0.000000390.00000039 10,000 0.0000016950.000001695 100 0.0001582930.000158293 7 0.0039114060.003911406 4 0.0080465690.008046569 3 0.012865710.01286571 0 0.975015928140.97501592814 (a) if the grand prize is $13 comma 000 comma 00013,000,000, find and interpret the expected cash prize. if a ticket costs $1, what is your expected profit from one ticket? the expected cash prize is $nothing.

Answers: 3

Answer

Business, 22.06.2019 08:10

The last time he flew jet value air, juan's plane developed a fuel leak and had to make an 4) emergency landing. the time before that, his plane was grounded because of an electrical problem. juan is sure his current trip will be fraught with problems and he will once again be delayed. this is an example of the bias a) confirmation b) availability c) selective perception d) randomness

Answers: 1

Answer

You know the right answer?

Ann would like to buy a house. it costs $2,500,000. her down payment will be $50,000. she will take...

Questions