Define on by setting(a) Show that is an algebraic system.(b) Show that the function h from the system to given byis a one-to-one function from the set of complexnumbers that is onto and is operation preserving.

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