Course Notes Week #3 Oct. 5th-9th
Course Notes Week #3 Oct. 5th-9th CSE 1111
Popular in Intro to Computer Problem Solving
verified elite notetaker
Popular in Computer Science and Engineering
verified elite notetaker
This 2 page Class Notes was uploaded by Megan Hageman on Thursday October 8, 2015. The Class Notes belongs to CSE 1111 at Ohio State University taught by Cindy Grimme in Summer 2015. Since its upload, it has received 59 views. For similar materials see Intro to Computer Problem Solving in Computer Science and Engineering at Ohio State University.
Reviews for Course Notes Week #3 Oct. 5th-9th
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 10/08/15
CSE 1111 Lecture Notes Week 3 Oct 5th9th Course Notes Ch 19 Reference Functions LOOKUP Function function designed to look up values from a given list and return a corresponding value Vector form of the LOOKUP function LOOKUPookupvaue ookupvectorresutvector Lookupvaue value that is searched for in the rst vector Lookupvector range of cells used to search for the lookup value must be in ascending order Resultvector range of cells that contain values you wish to return must be the same size as the ookupvector Course Notes Ch 110 Financial Functions nterest borrowers pay for the use of money they have borrowed Rate of interest principalcurrent value of the loaninvestmentinterest fee amount Time value of money what you expect to be paid for use of your money Risk the uncertainty of getting this money back from the borrower Simple interest interest that is paid solely on the original amount invested or lent Simple interest Principalnterest rate per time periodNumber of time periods Compound interest when interest earned each period is added to the principal for purposes of computing interest for the next period when calculating compound interest it is critical that the calculations are broken up into the periods of compounding using the corresponding interest rate per period Using Financial Functions to Calculate Compound Interest 5 different functions Present ValuePV amount of money into or out of a nancial transaction at the beginning of the transaction RateRATE interest rate per period Number of PeriodsNPER the duration of the loan PaymentPMT amount that is paid in equal installments each period Future ValueFV the nal amount into or out of this transaction FVratenperpmtpvtype When cash is received it is POSITIVE When cash is paid out it is considered NEGATIVE Present Value PVrate nper pmt fv type Number of periods NPERrate pmt pv fv type Interest rate per Period RATEnper pmt pv fv type Periodic Payment PMTrate nper pv fv type Lecture Notes Oct 6 CLASS CANCELLED Lecture Notes Oct 8 Reference Functions LOOKUP function Use to look up a value based on speci c criteria LOOKUPookupvaue ookupvector resultvector Lookupvaue the criteria Lookupvector range of the stated criteria Resultvector range with the values you re trying to nd The values can be from a row or a column Algorithm will give you the greatest value that does NOT EXCEED the value searched for Won t work if the look up vector is NOT in ascending order Financial Functions Simple vs Compound interest Simple based on original amount Compound based on latest amount Func ons PV present value FV future value PMT payment each period RATE interest rate per period NPER number of payment periods PVltrategt ltnpergt ltpmtgt ltfvgt Outgoing H Incoming FVltrategt ltnpergt ltpmtgt ltpvgt PMTltrategt ltnpergt ltpvgt ltfvgt RATEltnpergt ltpmtgt ltpvgt ltfvgt NPERltrategt ltpmtgt ltpvgt ltfvgt make sure all units match Type argument at the end of functions 0 if payment made at the end of the period 1 if payment made at the beginning of the period Assume it is at the end unless speci ed