Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.

3 Pages

Critical anaylsis. Financial Functions

Course: FINANCE 35, Spring 2011
School: Abraham Baldwin...
Rating:

Word Count: 260

Document Preview

Value Present Function What is the present value of \$1,000 received 8 years from today if the discount rate is 5%? i 5% n 8 FV \$1,000 PV \$676.84 using the formula PV (rate, nper, pmt, FV) =PV(D6,E6,0,D8) \$676.84 Future Value Function You deposit \$1,000 today into an IRA. It will earn 4% for the next 25 years. What is the future value of your investment? i n PV FV 4% 25 \$1,000 ? FV = FV(rate, nper, pmt, -PV)...

Register Now

Unformatted Document Excerpt

Coursehero >> Georgia >> Abraham Baldwin Agricultural College >> FINANCE 35

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Value Present Function What is the present value of \$1,000 received 8 years from today if the discount rate is 5%? i 5% n 8 FV \$1,000 PV \$676.84 using the formula PV (rate, nper, pmt, FV) =PV(D6,E6,0,D8) \$676.84 Future Value Function You deposit \$1,000 today into an IRA. It will earn 4% for the next 25 years. What is the future value of your investment? i n PV FV 4% 25 \$1,000 ? FV = FV(rate, nper, pmt, -PV) FV(D16, D17, 0, -D18) \$2,665.84 Present Value Annuity Function What is the present value of a series of payments of \$3,000 each year for 20 years, discounted at 12%? i nper pmt 12% 20 \$3,000 Use PV function, (Rate, nper, pmt, FV) PV(.12,20,-3000,0) PV(c7, c8,-c9,0) \$22,408.33 Note that you have to put a negative in front of the PV amount to get a postive return. Future Value Annuity Function What will your value at retirement be you if deposit \$100 each month for the next 12 years? Your annual discount rate is 8%. i nper Payment 0.667% divide 8% by 12 240 multiply 20 years by 12 \$100 Use FV function FV(,667,240,-100,0) FV(c25,c26,-c27,0) \$58,902.04 Solving for Payment Over the next 15 years you want to pay off the balance on your home mortgage. If your mortgage value is 250,000 today, what will your payment be if your interest rate is 4.5%? Assume monthly compounding. n i PV FV 15 monthly 4.50% monthly \$(250,000) \$- 180 0.375% Use PMT =(.375,180,250000,0) \$1,912.48 monthly payment Solving for rate You are offered \$2,500 5 years from now in exchange for \$1,000 today. What annual rate of return would you earn if you take this offer? Assume annual compounding. n PV FV 5 \$1,000 \$2,500 Use RATE RATE(nper, pmt, pv, fv, 0, guess) 20% =RATE(5,0, 2500,-1000,0,.05)
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Abraham Baldwin Agricultural College - YGF - 567
In the social sciences, researchers often want to conduct studies in situations where they cannotcontrol certain aspects of the study. For example, they might want to compare critical thinkingskills for students taking an online class with those taking
Abraham Baldwin Agricultural College - FSF - PSY435WEEK
PSY 435 Week 4 Test1. To control rater bias in a performance rating system organizations are recommended to conduct propertraining of raters and _.A. Allow ratees to sign for their appraisalsB. Have supervisors of the raters also sign to validate the
Abraham Baldwin Agricultural College - FESF - 4325
Abraham Baldwin Agricultural College - ENGG - 54
Abraham Baldwin Agricultural College - GG - 435
Thank you for your interest in iGATE Patni. This form is intended to enableyou to record important points about yourself as a person, your experience,strengths, achievements and future plans for our reference while processingyour application.APPLICATI
Iowa State - ENG - 160
Classroom ExpectationsIn some respects college is much less formal than high school. One place this tends to bemost visible is in classroom expectations. Class attendance may not be as rigidly enforced as in high school Subjects which were avoided in
Iowa State - ENG - 160
ENGR 160: HW, Project, and Exam Preparation Guidance and Grading ProcedureGeneral Aspects of Presentation and LayoutAll HWs, projects, and exams need your name on the upper right corner,and your work should be organized, correctly laid out, with correc
Iowa State - ENG - 160
Engr 160/160H Reference SheetUnit Conversions: 2AREA - 1 acre = 43 560 ftAREA - 1 hectare = 10 000 m 2AREA - 1 square mile = 640 acreslbArea and Volume Equations:Triangle : A =kg1bh2()1b +b h221DENSITY - 1 m = 16.02 33ftmENERGY - 1 B
Iowa State - ENG - 160
ENGR_160_Fall_2011_Section_E1_Prof_AllemanClass Project @ 23 August 2011 (Tuesday)Step123445EffortMeet your new team members (NOTE: you will be told who is on your team for this effort)Teams will have 4 members each (although this may change)D
Iowa State - ENG - 160
Project 2011_10_04 MATLAB Program Application (General analysis PLUS Image Tool)1) Use Matlab to calculate the approximate daily water demand (in terms of both gallons and cubic meters volumes, as well as interms of both lbs and tons mass) within the ci
Iowa State - ENG - 160
Matlab BasicsScreenLayoutCommandWindow(enteringcommands)Workspace(trackingvariables)CommandHistory(trackingcommands)BasicEntering #sNOTE: when you do not specify a name for a variable, Matlab assumes a namecalled ansEntering #sw/ ;Disp
Iowa State - ENG - 160
ENGR_160_Fall_2011_Section_E1_Prof_AllemanClass Project @ 23 August 2011 (Tuesday)Step123445EffortMeet your new team members (NOTE: you will be told who is on your team for thiseffort)Teams will have 4 members each (although this may change)
Iowa State - ENG - 160
ENGR_160_Fall_2011_Section_E1_Prof_AllemanClass Project @ 25 August 2011 (Thursday)Learning Topic: Basic Spreadsheet UseStep12EffortConfirm your new permanent team memberYou will keep this team member for the duration of the semesterDownload the
Iowa State - ENG - 160
Iowa State - ENG - 160
ENGR_160_Fall_2011_Section_E1_Prof_AllemanClass Project @ 1 September 2011 (Tuesday)Learning Topic:1) Learn how to create dual plots2) Learn how to revise plots using select dataTeam Member Names:1)_2)_Step1234EffortDownload the I5_data_29
Iowa State - ENG - 160
ENGR_160_Fall_2011_Section_E1_Prof_AllemanClass Project @ 6 September 2011 (Tuesday)Learning Topic:1) Learn how to use Excels TRENDLINE process2) Learn how to evaluate data using TRENDLINETeam Member Names:1)_2)_Step1234EffortDownload the
Iowa State - ENG - 160
ENGR_160_Fall_2011_Section_E1_Prof_AllemanClass Project # 6 @ 8 September 2011 (Thursday)Learning Topic:1) Learn how to work with Mathcads variables and arrays and matrixes2) Learn how to work with Mathcads plotting procedures3) Learn how to use Math
Iowa State - ENG - 160
ENGR_160_Fall_2011_Section_E1_Prof_AllemanClass Project # 6 @ 8 September 2011 (Thursday)Learning Topic:1) Learn how to use Mathcads Given-Find function to solve a complex set of multiplesimultaneous linear equations2) Learn how to use Mathcads matri
Iowa State - ENG - 160
VBA PROJECT ASSIGNMENT @ 22 September 2011Write a program to compute the customer billing amount (BILL) for a given energy usage(EUSE) in kilowatt-hours (kWh), where the charges are a certain rate (RATE) in \$/kWhfor the first 100 kWh and are a differen
Iowa State - ENG - 160
ENGR 160 HOMEWORK ASSIGNMENT @ 29 September 2011Use any analytical tool you prefer to make the following determinations:123International Space Station water - two US astronaut at current ISSuse and cost- 10L/day water use per US astronaut- \$48,000
UIllinois - CHEM - 236
Lectures, exams, homework solutions, and examples.
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
First Three Letters of Last NameNAME _Network ID _Section _CHEMISTRY 236SPRING 2011EXAM IIMARCH 4, 2011Note: The last page of this exam is a periodic table.1 (12)2 (12)3 (10)4 (12)5 (15)6 (15)7 (15Nomenclature and structure drawingR
UIllinois - CHEM - 236
Alcohols and Thiols asNucleophiles and ElectrophilesMonday, March 7, 2011
UIllinois - CHEM - 236
Oxidation and Reduction ofAlcoholsFriday, March 11, 2011
UIllinois - CHEM - 236
Oxidation of Thiols andReactions of Ethers and SulfidesMonday, March 14, 2011
UIllinois - CHEM - 236
Epoxides Synthesis and Use asElectrophilesWednesday, March 16, 2011
UIllinois - CHEM - 236
Chemistry of Diols andSynthesis OverviewFriday, March 18, 2011
UIllinois - CHEM - 236
Lecture 25: InfraredSpectroscopy Pt. IWednesday, March 30, 2011chloroformchloroform-dhexane1-hexene1-hexene3-hexene1-hexene1-hexyne1-hexyne2-hexyne
UIllinois - CHEM - 236
Lecture 26: InfraredSpectroscopy, Pt. II andIntro to NMRFriday, April 1, 2011hexane1-hexanol1-hexanol1-hexylamine1-hexanolhexanalhexanal2-hexanonehexanalmethylhexanoatemethylhexanoatehexanoic acid
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
UIllinois - CHEM - 236
1) Propose a synthesis of each of the following targets from cyclodecyne and any reagents you choose.(Note: Most targets may be reached by multiple routes.)2) Propose a synthesis of each of the following targets from the indicated starting material and
UIllinois - CHEM - 236
1) Propose a synthesis of each of the following targets from cyclodecyne and any reagents you choose.(Note: Most targets may be reached by multiple routes.)2) Propose a synthesis of each of the following targets from the indicated starting material and
UIllinois - CHEM - 236
1CHEMISTRY 236: Fundamental Organic Chemistry IProf. Scott K. SilvermanSpring 2006University of Illinois at UrbanaChampaignThe Five Commandments of Organic Chemistry(as received by Prof. Silverman)1. Primary carbocations are too unstable to form in
UIllinois - CHEM - 236
IR Spectroscopy Slides for NotesWednesday, March 30, 2011andFriday, April 1, 2011chloroformchloroform-dhexane1-hexene1-hexene3-hexene1-hexene1-hexyne1-hexyne2-hexynehexane1-hexanol1-hexanol1-hexylamine1-hexanolhexanalhexanal2-hexanone
UIllinois - CHEM - 236
CHEMISTRY 236ORGANIC CHEMISTRYResonance HybridsMolecules which are not adequately represented by a single Lewis structure areoften described as a hybrid of two or more Lewis structures. A resonance hybridhas only a single stable structure. However, r
UIllinois - CHEM - 236
SN2Rate=k[alkyl halide][nucleophile]-Best for primary halides-Inversion of configuration-Need good nucleophile-NO intermediateSN1Rate=k[alkyl halide]-Best for tertiary halides-Racemic mixture-Carbocation intermediate (why tertiaryis best!)E2R