(12C) 80:10:10 Loan
|
04-06-2018, 01:21 PM
Post: #1
|
|||
|
|||
(12C) 80:10:10 Loan
Inputs:
Store Loan Amount in R1 Large Loan (80%): Number of Years in R2, Annual Interest Rate in R3 Small Loan (10%): Number of Years in R4, Annual Interest Rate in R5 Output: Large Loan Payment, Small Loan Payment, Combined Payment (R6) Code:
Example: Terms: 80:10:10 Loan Amount: $200,000.00 80% Loan: Term: 30 years, Rate: 4.5% 10% Loan: Term: 15 years, Rate 5% Results: -810.70 (payment of 80% loan) -158.16 (payment of 10% loan) -968.86 (payment of combined loan) Sources Calculated Industries Real Estate Master IIIX: Resident Real Estate Finance Calculator Pocket Reference Guide Calculated Industries, LLC.: Carson City, NV 2010 Mortgage-Info.com “Piggy Back Mortgage Calculator” Mortgage Info.com 2011 http://www.mortgage-info.com/mortgage-ca...lator.aspx Accessed April 4, 2018. |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 1 Guest(s)