What is the monthly mortgage payment during month

Assignment Help Financial Management

Reference no: EM131324696

Create the amortization spreadsheet and answer the following questions for a $350,000 15-year fixed-rate, constant-payment mortgage loan that is partiallyamortizing with a balloon payment of $100,000. The contract interest rate is 4% with monthly payments. Up-front discount points on the loan are 4%, and there is a 1% prepayment penalty.

please post spreadsheet with formulas visible

a) What is the APR (annual percentage rate) on the loan – assuming that there is no early prepayment on the mortgage?

b) What is the EAR (effective annual rate) on the loan if it prepaid at the end of year 7?

c) What is the monthly mortgage payment during month 160?

d) How much cumulative interest is paid during the 14th year of the mortgage?

Reference no: EM131324696

Questions Cloud

What will be the new degree of operating leverage : At an output level of 18,000 units, you have calculated that the degree of operating leverage is 2.10. The operating cash flow is $46,500 in this case. Ignore the effect of taxes. What will be the new degree of operating leverage for output levels of..

What is the cost of equity from retained earnings : Amber Inc. hired you as a consultant to estimate its cost of equity. You've collected the following data: The stock price, P0, is $22.5 and the most recent dividend, D0, was $0.8. Dividends are expected to grow at a constant rate of g = 8%. what is t..

The risk premium for securities in market : Market A deals in low-risk securities with an average interest rate of 5%. Market B deals in high-risk securities with an average interest rate of 7%. Suddenly there is a financial crisis and the economy enters recession. Before the recession, the ri..

Bonds one year ago at coupon rate : App Store Co. issued 16-year bonds one year ago at a coupon rate of 6.2 percent. The bonds make semiannual payments. If the YTM on these bonds is 5.4 percent, what is the current bond price?

What is the monthly mortgage payment during month : Create the amortization spreadsheet and answer the following questions for a $350,000 15-year fixed-rate, constant-payment mortgage loan that is partiallyamortizing with a balloon payment of $100,000. What is the APR (annual percentage rate) on the l..

Show the compound interest overal growth rate : Mr. Richards needs more analysis to update his client presentations. He would like additional future value calculations. Using the same framework, calculate the future value pf the bank CD's that would pay 1% and 2% annual interest. Show the compound..

What did the video card cost : Gary is building a computer for a customer. Of the money he spent on parts, 20% went into buying the video card. If the rest of the computer cost $650, what did the video card cost?

Assume that risk-free rate of interest : Assume that the risk-free rate of interest is 3% and the expected rate of return on the market is 14%. A share of stock sells for $61 today. It will pay a dividend of $5 per share at the end of the year. Its beta is 1.5. What do investors expect the ..

What must be the beta of a portfolio : What must be the beta of a portfolio with E(rP) = 18%, if rf = 4% and E(rM) = 14%?

User Account

All Pages