Question: I need help on excel reverse mortgage Calculate monthly payment received from reverse mortgage over a 20 year time period. Starting with a 3 million

I need help on excel reverse mortgage

Calculate monthly payment received from reverse mortgage over a 20 year time period. Starting with a 3 million dollar house value and an rate of 6.5%

Show this on an annuity table with monthly payment information.

I don't need specific answers, just help with the formula and input

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Data Auditing As a member of the audit team examining MPLs payroll expense, you have gathered a list of current employees names and salary amounts. Prepare a descriptive analysis of payroll expense...

Q:

Please work using excel spreadsheet, and providing functions for review. Please and thank you, can you provide this quickly, greatly appreciate it. **The problems have already been worked, just need...

Q:

Its micro... explain every part 8. Overhaul of a production line generates the following incremental cash inflows over the line's 5-year remaining life. C1 C2 C3 CA C's Cash inflow ($ million) +1.5...

Q:

Help in the following You are the IT director for a large school system. The school has decided that students can bring in their own devices to do school work with. Your organization uses Microsoft...

Q:

I need help with these problems. The details are included in the attached files. Thank you Submit a spreadsheet displaying how the answers were calculated. Each problem should be answered on a...

Q:

nance Suppose that the current spot rate is S0 = usd/gbp 2 and the one-period interest rates today are r is 5 percent and r is 10 percent. Also, you are given that in the next period the spot rate...

Q:

:Help me with the following questions. Suppose that the depreciation rate increases. In the Solow growth model, determine the effects of this on the quantity of capital per worker and on output per...

Q:

FINANCE52627.. Present Value You are awarded $500,000 in a lawsuit, payable immediately. The defendant makes a counteroffer of $50,000 per year for the first three years, starting at the end of the...

Q:

Abdallah and Maria have to play arm wrestling. The game goes like this. Maria must decide whether or not to confront Abdallah. If she doesn't fight him, she has to pay him $50. If she decides to...

Q:

mortgage calculations in section one need to chose home section 2- down payment section 3- CMHC calculation section 4- mortgage calculation section 5- also mortgage calculation section 6- mortgage...

Q:

Use the table provided below as a starting point to answer the following questions. a. How sensitive is the decision to the amount of the down payment for the purchase option? If a down payment of...

Q:

Use the value of the linear correlation coefficient r to find the coefficient of determination and the percentage of the total variation that can be explained by the regression line. r = 0.837

Q:

What are the distinguishing characteristics of an executive information system (EIS)? Why have these systems become a part of business intelligence in many companies?

Q:

An amortization table separates time value of money tables into present value and future value Is a special table used in a break room to make people feel equitable breaks each payment into the...

Q:

Free cash flow valuation You are evaluating the potential purchase of a small business with no debt or preferred stock that is currently generating $ 4 2 , 7 0 0 of free cash flow ( F C F 0 = $ 4 2 ,...