Real Estate, Refinancing | HP 12C specs

Real Estate

Refinancing

It can be mutually advantageous to both borrower and lender to refinance an existing mortgage which has an interest rate substantially below the current market rate, with a loan at a below-market rate. The borrower has the immediate use of tax-free cash, while the lender has substantially increased debt service on a relatively small cash outlay.

To find the benefits to both borrower and lender:

1.Calculate the monthly payment on the existing mortgage.

2.Calculate the monthly payment on the new mortgage.

3.Calculate the net monthly payment received by the lender (and paid by the borrower) by adding the figure found in Step 1 to the figure found in Step 2.

4.Calculate the Net Present Value (NPV) to the lender of the net cash advanced.

5.Calculate the yield to the lender as an IRR.

6.Calculate the NPV to the borrower of the net cash received.

Example 1: An investment property has an existing mortgage which originated 8 years ago with an original term of 25 years, fully amortized in level monthly payments at 6.5% interest. The current balance is $133,190.

Although the going current market interest rate is 11.5%, the lender has agreed to refinance the property with a $200,000, 17 year, level-monthly- payment loan at 9.5% interest.

What are the NPV and effective yield to the lender on the net abount of cash actually advanced?

What is the NPV to the borrower on this amount if he can earn a 15.25% equity yield rate on the net proceeds of the loan?

Keystrokes Display

CLEAR
17	-1,080.33	Monthly payment on existing
	-1,080.33	mortgage received by lender.
6.5		mortgage received by lender.
6.5
133190
	0

2

Image 3

HP 12C manual Real Estate, Refinancing

Contents

Page Introduction Refinancing Real Estate Wrap-Around Mortgage PMT Cash flow occurs 39 times Final cash flowRate of return to lender Number of periods and monthly Income Property Cash Flow Analysis Before-Tax Cash FlowsDerivation of these cash flows follows a set sequence Vacancy Loss Before-Tax Reversions Resale ProceedsDerivation of these reversions are as follows After-Tax Cash Flows Keystrokes Display 30-43 33-44 35-43 40-44 42-45 48-44 53-44 Registers 3291.75 ATCF1 After-Tax Net Cash Proceeds of Resale 18-44 33-44 39-44 48-43 Key in the number of years after purchase and press Atncpr Lending Loan With a Constant Amount Paid Towards PrincipalLoan Reduction Schedule Add-On Interest Rate Converted to APR APR Converted to Add-On Interest Rate Add-On Rate Loan with Credit Life Page 53-43 77-45 78-43 PMT PMT Credit life Interest Rebate Rule of 78s 26-43 Graduated Payment Mortgages Keystrokes Display 34-44 38-43 39-43 68-44 69-44 72-43 73-43 77-43 Keystrokes Display Variable Rate Mortgages Keystrokes Display Skipped Payments Group of payments is skipped Initial Deposit with Periodic Deposits Savings Periodic Deposits and Withdrawals FV = ? Cash flow diagram looks like this PV = Savings Account Compounded Daily Keystrokes Display 27-44 37-43 Compounding Periods Different From Payment Periods Clear 519.61 Future value Lease vs. Purchase Investment Analysis 16-44 18-44 27-44 30-45 32-45 34-45 Instructions Year Maintenance Lease Payment Tax Credit Buy Back 200 1700 1000 1500 300 750 Break-Even Analysis Profit To calculate the gross profit at a given volume Find the gross profit if 2500 units are sold 04-43 09-43 15-43 23-43 Gross Profit Operating Leverage 10-43 Profit and Loss Analysis 11-43 28-43 37-43 42-43 47-43 Page 100.00 48% tax rate Manufacturing cost $ After-Tax Yield Securities Purchase price Discounted Notes 30-43 Settl. date Maturity dtae Simple Moving Average Forecasting Keystrokes Display 26-45 29-45 30-44 32-45 33-44 Unused PV Unused PMT Unused FV Unused R .4 Unused 12-43 Seasonal Variation Factors Based on Centered Moving Averages 25-43 Sales in $K Quarterly 1st 2nd 3rd 4th 98.86 99.95 99.41 1st quarter average seasonal Variation, % 02-2 28-45 31-45 32-44 34-45 35-44 37-45 38-44 Gompertz Curve Trend Analysis 02-44 05-44 08-44 10-44 12-43 Page 71-43 Year III Forecasting with Exponential Smoothing 07-44 Page Forecasting Selecting the best smoothing constant α 22.00 23.00 23.25 25.25 23.69 27.13 25.95 Procedure is repeated for several αs Markup and Margin Calculations Pricing Calculations 02-43 14-43 Calculations of List and Net prices With Discounts 100 10.51 3rd discount rate % 05-44 06-43 16-43 Page Statistics Curve FittingExponential Curve Fit 100 101 102 Logarithmic Curve Fit 104 Power Curve Fit Formula that best expresses h as a function of t is Standard Error of the Mean Mean, Standard Deviation, Standard Error for Grouped Data 108 Use the following HP-12C program for the previous example 109 Chi-Square Statistics 111 112 Normal Distribution Relative error less than 0.042% over the range 0 x Reference114 115 116 Covariance Example Find Qx for x = 1.18 and x =117 118 Try the previous example using the following HP-12C program Permutation 120 121 Combination 122 Random Number Generator 123 Example Generate a sequence of 5 random numbers Personal Finance Homeowners Monthly Payment Estimator124 125 Following HP-12C program may be used instead of the above Example Solve the previous example using the HP-12C program What if the down payment is increased to 20%?126 127 Tax-Free Individual Retirement IRA of Keogh Plan 128 129 Stock Portfolio Evaluation and Analysis 131 132 133 134 Example Evaluate the following portfolio 135 Canadian Mortgages Periodic Payment Amount136 137 Number of Periodic Payments to Fully Amortize a MortgageEffective Interest Rate Yield Balance Remaining at End of Specified Period 138 Miscellaneous Learning Curve for Manufacturing Costs139 140 141 142 143 Queuing and Waiting Theory Intensity factor 145 146 147 148 149 150 AppendixReal Estate Wrap-Around Mortgage Add-On to APR with Credit Life LendingLoans with a constant amount paid towards Principal Add-On Interest Rate to APR 152 SavingsRule of 78s Rebate Skipped Payments Break-Even Analysis and Operating Leverage Investment AnalysisCompounding Periods Different From Payment Periods Lease vs. Purchase Discounted Notes Price given discount rate SecuritiesForecasting Profit and Loss Analysis Simple Moving Average Gompertz Curve Trend Analysis155 156 Forecasting With Exponential Smoothing 157 Pricing CalculationsForecast of next period expected usage Markup and Margin Calculations 158 Statistics Calculations of List and Net Prices with Discounts159 160 For tax-free investment Personal FinanceTax-Free Retirement Account IRA or Keogh Plan For ordinary taxable investment Learning Curve for Manufacturing Cost Canadian MortgagesMiscellaneous Portfolio beta coefficient Queuing and Waiting Theory Graduated Payment Mortgage163 + C 164