TI-BASIC:Bal - Revision history

Maintenance script: Automated superscript correction

2016-02-24T22:24:02Z

Automated superscript correction

← Older revision		Revision as of 22:24, 24 February 2016
Line 29:		Line 29:
	Now, we use the finance solver to solve for PMT. Since you intend to pay out the entire loan, FV is 0. Using either the interactive TVM solver, or the [[TI-BASIC:Tvm\|tvm_Pmt]] command, we get a value of about -$733.76 for PMT.		Now, we use the finance solver to solve for PMT. Since you intend to pay out the entire loan, FV is 0. Using either the interactive TVM solver, or the [[TI-BASIC:Tvm\|tvm_Pmt]] command, we get a value of about -$733.76 for PMT.

	We are ready to use bal(. We are interested in the payment made after 15 years; this is the 15*12=180^^th^^ payment. bal(180) gives us the result $76781.55 -- as you can see, most of the loan amount is still left to pay after 15 years.		We are ready to use bal(. We are interested in the payment made after 15 years; this is the 15*12=180<sup>th</sup> payment. bal(180) gives us the result $76781.55 -- as you can see, most of the loan amount is still left to pay after 15 years.

	= Formulas =		= Formulas =

KermMartian at 19:19, 24 February 2016

2016-02-24T19:19:34Z

← Older revision		Revision as of 19:19, 24 February 2016
Line 35:		Line 35:
	The calculator uses a recursive formula to calculate bal():		The calculator uses a recursive formula to calculate bal():

	~~[[TI-BASIC:Math\|Math]]~~		<math>
	\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}		\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}
	\operatorname{bal}(0)=\operatorname{PV}		\operatorname{bal}(0)=\operatorname{PV}
	~~[[TI-BASIC:~~/math\|/math]]		</math>
	~~[[TI-BASIC:Math\|Math]]~~
			<math>
	\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}		\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}
	\operatorname{bal}(m)=\left(1-\frac{I\%}{100}\right)\operatorname{bal}(m-1)+\operatorname{PMT}		\operatorname{bal}(m)=\left(1-\frac{I\%}{100}\right)\operatorname{bal}(m-1)+\operatorname{PMT}
	~~[[TI-BASIC:~~/math~~\|/math]]~~		</math>

	In the case that ''roundvalue'' is given as an argument, the rounding is done at each step of the recurrence (which virtually forces us to use this formula). Otherwise, if no rounding is done (and assuming I% is not 0), we can solve the recurrence relation to get:		In the case that ''roundvalue'' is given as an argument, the rounding is done at each step of the recurrence (which virtually forces us to use this formula). Otherwise, if no rounding is done (and assuming I% is not 0), we can solve the recurrence relation to get:

	~~[[TI-BASIC:Math\|Math]]~~		<math>
	\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}		\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}
	\operatorname{bal}(m)=\frac{1-\left(1-\frac{I\%}{100}\right)^m}{\frac{I\%}{100}}\operatorname{PMT}+\left(1-\frac{I\%}{100}\right)^m\operatorname{PV}		\operatorname{bal}(m)=\frac{1-\left(1-\frac{I\%}{100}\right)^m}{\frac{I\%}{100}}\operatorname{PMT}+\left(1-\frac{I\%}{100}\right)^m\operatorname{PV}
	~~[[TI-BASIC:~~/math~~\|/math]]~~		</math>

	= Error Conditions =		= Error Conditions =
Line 59:		Line 60:
	* [[TI-BASIC:Sigmaprn\|ΣPrn(]]		* [[TI-BASIC:Sigmaprn\|ΣPrn(]]
	* [[TI-BASIC:Sigmaint\|ΣInt(]]		* [[TI-BASIC:Sigmaint\|ΣInt(]]
	* [[TI-BASIC:Tvm\|tvm_Pmt]][[Category:TI-BASIC]]		* [[TI-BASIC:Tvm\|tvm_Pmt]]
			[[Category:TI-BASIC]]
	[[Category:TIBD]]		[[Category:TIBD]]

Maintenance script: Initial automated import

2016-02-24T18:19:27Z

Initial automated import

New page

{{Template:TI-BASIC:Command
|picture=BAL.GIF
|summary=Calculates the remaining balance after ''n'' payments in an [wikipedia:Amortization_schedule amortization schedule].
|syntax=bal(''n'',[''roundvalue'']
|location=On the TI-83, press:
# 2nd FINANCE to access the finance menu.
# 9 to select bal(, or use arrows and ENTER.

On the TI-83+ or higher, press:
# APPS to access the applications menu.
# 1 or ENTER to select Finance...
# 9 to select bal(, or use arrows and ENTER.
|compatibility=TI-83/84/+/SE
|size=2 bytes
}}

The bal( command calculates the remaining balance after ''n'' payments in an [wikipedia:Amortization_schedule amortization schedule]. It has only one required argument: ''n'', the payment number. However, it also uses the values of the finance variables PV, PMT, and I% in its calculations.

The optional argument, ''roundvalue'', is the number of digits to which the calculator will round all internal calculations. Since this rounding affects further steps, this isn't the same as using [[TI-BASIC:Round|Round(]] to round the result of bal( to the same number of digits.

Usually, you will know the values of '''N''', PV, and I%, but not PMT. This means you'll have to use the finance solver to solve for PMT before calculating bal(); virtually always, FV will equal 0.

= Sample Problem =

''Imagine that you have taken out a 30-year fixed-rate mortgage. The loan amount is $100000, and the annual interest rate (APR) is 8%. Payments will be made monthly. After 15 years, what amount is still left to pay?''

We know the values of '''N''', I%, and PV, though we still need to convert them to monthly values (since payments are made monthly). '''N''' is 30*12, and I% is 8/12. PV is just 100000.

Now, we use the finance solver to solve for PMT. Since you intend to pay out the entire loan, FV is 0. Using either the interactive TVM solver, or the [[TI-BASIC:Tvm|tvm_Pmt]] command, we get a value of about -$733.76 for PMT.

We are ready to use bal(. We are interested in the payment made after 15 years; this is the 15*12=180^^th^^ payment. bal(180) gives us the result $76781.55 -- as you can see, most of the loan amount is still left to pay after 15 years.

= Formulas =

The calculator uses a recursive formula to calculate bal():

[[TI-BASIC:Math|Math]]
\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}
\operatorname{bal}(0)=\operatorname{PV}
[[TI-BASIC:/math|/math]]
[[TI-BASIC:Math|Math]]
\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}
\operatorname{bal}(m)=\left(1-\frac{I\%}{100}\right)\operatorname{bal}(m-1)+\operatorname{PMT}
[[TI-BASIC:/math|/math]]

In the case that ''roundvalue'' is given as an argument, the rounding is done at each step of the recurrence (which virtually forces us to use this formula). Otherwise, if no rounding is done (and assuming I% is not 0), we can solve the recurrence relation to get:

[[TI-BASIC:Math|Math]]
\definecolor{darkgreen}{rgb}{0.90,0.91,0.859}\pagecolor{darkgreen}
\operatorname{bal}(m)=\frac{1-\left(1-\frac{I\%}{100}\right)^m}{\frac{I\%}{100}}\operatorname{PMT}+\left(1-\frac{I\%}{100}\right)^m\operatorname{PV}
[[TI-BASIC:/math|/math]]

= Error Conditions =

* '''[[TI-BASIC:Errors#domain|ERR:DOMAIN]]''' is thrown if the payment number is negative or a decimal.

= Related Commands =

* [[TI-BASIC:Sigmaprn|ΣPrn(]]
* [[TI-BASIC:Sigmaint|ΣInt(]]
* [[TI-BASIC:Tvm|tvm_Pmt]][[Category:TI-BASIC]]
[[Category:TIBD]]