Cash inflow-outflow and net cash flow

Assignment Help Financial Management

Reference no: EM132028734

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.50%.

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.

She forecasts four possible scenarios for house price appreciation (HPA).

Optimistic Case: 4.5% annual HPA, hence 4.5/12% monthly HPA

Base Case: 2.5% annual HPA, hence 2.5/12% monthly HPA

Pessimistic Case: 0% annual HPA, hence 0/12% monthly HPA

Very Bad Case: -6% annual HPA, hence -6/12% monthly HPA

Reference no: EM132028734

Questions Cloud

Annualized irr for the mortgage in spreadsheet : Compute Ann’s annualized IRR for the mortgage in the spreadsheet.

Firm right after the firm completes the stock issuance : What is the total value of the firm right after the firm completes the stock issuance?

External sources to fund the expected growth : What amount of additional funds will Super Fun Toys need from external sources to fund the expected growth?

The company first international order : This is the company’s first international order. On the other hand, the company in China is willing to pay only $125 per unit.

Cash inflow-outflow and net cash flow : 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.

What about sensitivity of npv to change in quantity supplied : What is the sensitivity of the project OCF to changes in the quantity supplied? What about the sensitivity of NPV to changes in quantity supplied?

The firm normally issues long-term debt : How valid is an estimate of the cost of debt based on 15-year bonds if the firm normally issues 30-year long-term debt?

The coupon payments and principal payment of the bond : Compute the present value of the coupon payments and the principal payment of the bond. What is the price of this bond?

The president of high performing division : You are the president of high performing division and the Chief Executive Officer tells you in order increase the profits by another $260M over forecast;

User Account

All Pages