Financial Modeling and Valuation
Financial Modeling and Valuation BU.230.620.W4.SP16
Popular in Financial Modeling and Valuation
verified elite notetaker
Popular in Finance
This 3 page Class Notes was uploaded by Kwan on Wednesday March 23, 2016. The Class Notes belongs to BU.230.620.W4.SP16 at Johns Hopkins University taught by Dr. Ken Yook in Spring 2016. Since its upload, it has received 53 views. For similar materials see Financial Modeling and Valuation in Finance at Johns Hopkins University.
Reviews for Financial Modeling and Valuation
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 03/23/16
Financial Modeling and Valuation Thursday, March 17, 2016 09:02 Mr. Lu Project: 40% (2rd), submit Exam: 60% (9-‐10 Q in 2h, similar to examples and hw) Attendance A or C: follow; practice (reproduce the models repeatedly) FILL HANDLE: Select: Shift + arrows Shift + control + arrows Fill Down/Across: Eg. ABC down & to the left Fill down sequence: Eg. 1-‐3-‐… Cmd+Y: redo Cmd+Z: undo Eg. insert an entire row, and redo/undo Cmd-‐1: format REFERENCE: Eg: =a*b, Fill down, Ctr ~: formulas Eg. Fill series from 2015 to 2020 Absolute cell reference: Cmd+T IF: If function: Eg. Fill series from 2015 to 2020 Absolute cell reference: Cmd+T IF: If function: Eg. =if(a<>0, b, c) or =if(a,b,c) More than 2 conditions=ifs Eg. =AND(a<100, c>50) or a>50 =Min =Max(a:d, 40) IFERROR: =iferror "NA" CHOOSE: Eg. =ifs or =choose or =offset (the best stating point? Eg.B4) SUMIF: Eg. =sumif & cmdT =sumifs (sum_range comes first) =sumproduct LOOKUP: =hlookup, cmd T Table array: without titles =vlookup NPV: NPV: Cash flow from Y1!!! NB. Different dates XNPV & XIRR COMBO: Developer tap -‐combo b-‐ format control -‐-‐ a drop down list =offset TABLE: Sensitivity analysis: C15 -‐ Select (including C15)-‐Data -‐ what-‐if analysis-‐ data table -‐ Row/column Select -‐ insert chart (the steeper the slope, the more important the variable) TABLE: Sensitivity analysis: C15 -‐ Select (including C15)-‐Data -‐ what-‐if analysis-‐ data table -‐ Row/column Select -‐ insert chart (the steeper the slope, the more important the variable) Hide: ctrl 1-‐ ;; IF + data table Two IRR's: Cash flows changed signs twice = 2 irrs =IRR, guess Loan Set Up: =pmt or insert function Negative -‐-‐payment Pension: =pv: type 1 =pm: monthly-‐ *!2 or /12 Create a copy: pension 2 Date -‐what-‐if anal goal seek HM 1: No need to turn it in