Refinance Refinance Loans Home Equity 0 Loan

Www Refinanceloanshomeequity C Refinance Szh Donghuapian 5375 Gongfuxiongmaogaishichuanqidiyiji Refinance Loans Home Equity 财务金融建模—图表(39xls) －元妙企业管理网

Www Refinanceloanshomeequity C Refinance Szh Donghuapian 5375 Gongfuxiongmaogaishichuanqidiyiji Refinance Loans Home Equity

951 3.1951 4.1951 5.1951 6.1951 7.1951 8.1951 9.1951 10.1951 11.1951 12.1951 1.1952 2.1952 3.1952 4.1952 5.1952 6.1952 7.1952 8.1952 9.1952 10.1952 11.1952 12.1952 1.1953 2.1953 3.1953 4.1953 5.1953 6.1953 7.1953 8.1953 9.1953 10.1953 11.1953 12.1953 1.1954 2.1954 3.1954 4.1954 5.195…………

Gongfuxiongmaogaishichuanqidiyiji on Szh fsearchx Refinanceloanshomeequity o Www g Gongfuxiongmaogaishichuanqidiyiji a Szh g Gongfuxiongmaogaishichuanqidiyiji i Refinanceloanshomeequity h Www c Gongfuxiongmaogaishichuanqidiyiji u Szh C3 Www F9 Gongfuxiongmaogaishichuanqidiyiji C %C3%F9%C8%CB%C7%BF%BC%E9%D0%A1%D3%A3%D0%A1%D3%CE%CF%B7%

B Donghuapian C 5375 %B Szh % Refinanceloanshomeequity C 5375 E%BE%AD%B5%E4%BE%E7%C7%E9%C6%AC%CC%D8%C3%FC%82S%E9L-%C4%A6%C1%BC%D2%B0%C8%CA% Www 0%BE%AD%B5%E4%BE%E7%C7%E9%C6%AC%CC%D8%C3%FC%82S%E9L-%C4%A6%C1%BC%D2%B0%C8%CAA Donghuapian % Refinance 3 Refinanceloanshomeequity A3

D Gongfuxiongmaogaishichuanqidiyiji % 5375 1%D Refinance %searchE%C Szh %Bsearchn 5375 idi Gongfuxiongmaogaishichuanqidiyiji i Gongfuxiongmaogaishichuanqidiyiji i searchs

a Www c Szh 3

1%C3%F9%C8%CB%C7%BF%BC%E9%D0%A1%D3%A3%D0%A1%D3%CE%CF%B7 Szh � Www � Donghuapian )%BE%AD%B5%E4%BE%E7%C7%E9%C6%AC%CC%D8%C3%FC%82S%E9L-%C4%A6%C1%BC%D2%B0%C8%CAP%BE%AD%B5%E4%BE%E7%C7%E9%C6%AC%CC%D8%C3%FC%82S%E9L-%C4%A6%C1%BC%D2%B0%C8%CAg%C3%F9%C8%CB%C7%BF%BC%E9%D0%A1%D3%A3%D0%A1%D3%CE%CF%B7 Refinance 5 Gongfuxiongmaogaishichuanqidiyiji b

P%BE%AD%B5%E4%BE%E7%C7%E9%C6%AC%CC%D8%C3%FC%82S%E9L-%C4%A6%C1%BC%D2%B0%C8%CAg%BE%AD%B5%E4%BE%E7%C7%E9%C6%AC%CC%D8%C3%FC%82S%E9L-%C4%A6%C1%BC%D2%B0%C8%CA search5searchearch�0� Donghuapian � Gongfuxiongmaogaishichuanqidiyiji searcha%C3%F9%C8%CB%C7%BF%BC%E9%D0%A1%D3%A3%D0%A1%D3%CE%CF%B7e Refinanceloanshomeequity 5 Www searchasearchk0rsearchx%BE%AD%B5%E4%BE%E7%C7%E9%C6%AC%CC%D8%C3%FC%82S%E9L-%C4%A6%C1%BC%D2%B0%C8%CAy%C3%F9%C8%CB%C7%BF%BC%E9%D0%A1%D3%A3%D0%A1%D3%CE%CF%B7y Refinanceloanshomeequity %C3%F9%C8%CB%C7%BF%BC%E9%D0%A1%D3%A3%D0%A1%D3%CE%CF%B7I Donghuapian (searcha Refinance k

r<>0,marker,(x-2)/4) =(10-3*y)/2 GAUSS-SEIDEL METHOD--SOLUTION BY ITERATIVE SUBSTITUTION =(E4-2)/4 =(10-3*D5)/2 GAUSS-SEIDEL METHOD--SHORTCUT Marker To start the recalculation, let Marker = 0. To start the recalculation, let Marker = 0. 高斯-塞德尔方法--迭代求解高斯-赛得尔方法--简便 Page .00 .55 .00 2.00 4.00 4.18 10.00 3.00 2.00 Page 1.00 1.00 .00 2.00 4.00 3.50 10.00 3.00 2.00 UN-21A .00 5.00 10.00 3.00 2.00 .75 2.00 4.00 3.88 10.00 3.00 2.00 .47 4.30 .57 4.14 .53 4.20 .55 4.18 .54 4.18 .55 4.18 .55 4.18 .55 4.18 .55 4.18 .55 4.18 UN-21A .00 5.00 .75 3.88 .47 4.30 .57 4.14 .53 4.20 .55 4.18 .54 4.18 .55 4.18 .55 4.18 .55 4.18 .55 4.18 .55 4.18…………
Page 75-78 (中文) Page 75-78 Page 71-73 (中文) Page 71-73 Page 71 (中文) Page 71 Page 70 (中文) Page 70 FARMERS BAGELS, INC. Current assets Cash and cash equivalents Accounts receivable Inventory Prepaid expenses and other current assets Property and equipment At cost Less accumulated depreciation Net property and equipment Total assets Current liabilities Accounts payable and accrued expenses Income taxes payable Other current liabilities Long-term debt Stockholders" equity Common stock Retained earnings Total liabilities and equity Income statement Sales Product sales Other income Total sales Operating expenses Cost of products sold Depreciation Selling, general, and administrative expenses Interest expense Interest income Earnings before income taxes Provision for income taxes Profit after taxes FARMERS BAGELS: FREE CASH FLOWS FOR 1995-1996 Add back depreciation Add back interest expenses, net of taxes Subtract interest costs, net of taxes Free Cash Flow FARMERS BAGELS, INC. Ratio Analysis New property and equipment at cost, % of new sales Income taxes payable (as % of income tax) Provision for income taxes (as % of earnings before taxes) FARMERS BAGELS PROJECTED SALES year sales Predic…………
Page 335 (中文) Page 335 Page 333 chart Page 332 (中文) Page 332 Page 331 (中文) Page 331 Page 330b (中文) Page 330b Page 330, (中文) Page 330, Page 329 (中文) Chapter25_code Page 329 benny benny eelapsed eelapsed elapsed elapsed ooutput ooutput output output output output rruns rruns runs runs runs runs sbenny sbenny sstarttime sstarttime sstoptime sstoptime starttime starttime stoptime stoptime Most Elementary Random List Runs Output Random numbers Bin Frequency Uniformly Distributed Random Numbers Using VBA"s Rnd function Starttime Stoptime Elapsed To replace the random numbers, Tools|Data Analysis|Random Number Generation More <-- This cell is named "output," and this name is used in the VBA routine in clearing previous results. USING EXCEL"S FREQUENCY FUNCTION Each cell contains thefunction Rand(). Each time you updatethe spreadsheet or press F9 the block ofcells will produce a new set of randomnumbers. <-- Rand() To run VBA "randomlist": press [Ctrl]+q Each cell in the range A5:A14 contains the formula Rand(). Pressing F9 will produce a new set of random numbers and frequencies. To run VBA program "uniformrandom", use [Ctrl]+a . Sub randomlist() "Produces a simple list of random numbers…………
Data for page 40 Page 40 (中文) Page 40 Page 39g (中文) Page 39g Page 39 (中文) Page 39 Page 35（中文） Page 35-36 (中文) Page 35-36 Page 34 (中文) Page 34 Page 33(中文） `Page 33 Page 30－32 (中文) Page 30－32 Page 29 (中文) Page 29 Page 26 (中文) Page 26 Pages 26-28 (中文) Pages 26-28 Page 25 (中文) Page 25 Page 24 (中文) Page 24 Page 23 (中文) Page 23 Page 22-23 (中文) Page 22-23 Date High <-- Ending 1998 share price P0 Gordon model D0 rE Risk premium Risk free rate Compound growth, 10 yr. Compound growth, 5 yr. 10-yr. growth 5-yr. growth <-- =COVAR(C5:C124,G5:G124)/VARP(C5:C124) Classical CAPM cost of equity Benninga-Sarig tax-adjusted CAPM Corporate tax <-- =J9+J5*J8 Number of shares, end 1998 Share price, end 1998 Market value of equity, end 1998, $billion Calculation of end-1998 market value of equity End-1998 value of debt (book value of debt assumed = market value) Long-term debt Short-term debt and current portion of long-term debt Total debt Less cash and cash equivalents Less investment securities Net debt, $billion Enterprise value = equity + debt, $billion COST OF CAPITAL CALCULATIONS Using Gordon model % of equity % of debt Cost of equity Cost of debt 1998 interest expense WACC Using the CAPM 1997 fig…………
chapter examples Page 325 chart Data for page 319 Page 324b chart Data for page324b Page 324 chart Data for page 324 Page 323 chart Data for page 323 Page 323 (中文) Page 323 c_ c_ c_ c_ c_ c_ c_ M M M M M M M r_ r_ r_ r_ r_ r_ r_ T_ T_ T_ T_ T_ T_ T_ tt tt tt tt tt tt tt T c M r Payments per year g <-- =(c_/r_*(1-EXP(-r_*(M-T_)))+EXP(-r_*(M-T_)))/(c_/0.08*(1-EXP(-0.08*(M-T_)))+EXP(-0.08*(M-T_))) Duration--continuous time <-- =(EXP(r_)*(-c_+c_*EXP(M*r_)-c_*M*r_+M*r_^2))/(r_*(-c_+c_*EXP(M*r_)+r_)) Using Excel to automatically adjust the graph titles Case <-- =IF(AND(r_<8%,c_r_),2,IF(AND(r_>8%,c_>8%),3,4))) Graph title ="Case "&B13&": "&" r = "&B5&", "&IF(B5<8%," max "," min ")&"c = "&B3 =B7, but hidden Data Table Duration =B9, but hidden Step =C22+$B$22 情形情形用EXCEL自动调整图形名称每年支付久期-持续时间图形名称模拟运算表 UN-17B 2.00 .02 25.00 .18 4.00…………
Data for page 99 Page 99 Page 98 (中文) Page 98 Page 97 (中文) Page 97 Page 96 (中文) Page 96 Page 94,, (中文) Page 94,, Page 94, Page 93, bottom Page 93 Page 92（中文） Page 92 solver_adj solver_adj solver_adj solver_adj solver_cvg 1.00E-04 solver_cvg 1.00E-04 solver_cvg 1.00E-04 solver_cvg 1.00E-04 solver_drv 1.00 solver_drv 1.00 solver_drv 1.00 solver_drv 1.00 solver_est 1.00 solver_est 1.00 solver_est 1.00 solver_est 1.00 solver_itr 100.00 solver_itr 100.00 solver_itr 100.00 solver_itr 100.00 solver_lin 2.00 solver_lin 2.00 solver_lin 2.00 solver_lin 2.00 solver_neg 2.00 solver_neg 2.00 solver_neg 2.00 solver_neg 2.00 solver_num .00 solver_num .00 solver_num .00 solver_num .00 solver_nwt 1.00 solver_nwt 1.00 solver_nwt 1.00 solver_nwt 1.00 solver_opt solver_opt solver_opt solver_opt solver_pre 1.00E-06 solver_pre 1.00E-06 solver_pre 1.00E-06 solver_pre 1.00E-06 solver_scl 2.00 solver_scl 2.00 solver_scl 2.00 solver_scl 2.00 solver_sho 2.00 solver_sho 2.00 solver_sho 2.00 solver_sho 2.00 solver_tim 100.00 solver_tim 100.00 solver_tim 100.00 solver_tim 100.00 solver_tol .05 solver_tol .05 solver_tol .05 solver_tol .05 solver_typ 3.00 solver_typ 3.00 solver_typ 3.00 solver_typ 3.00 solver_val…………
Page376-377 (中文) Page376-377 Page 375-376 (中文) Page 375-376 Page 374 (中文) Page 374 Page 373 Section 371 (中文) Section 371 Page 370 bottom (中文) Page 370 bottom Page 70 top (中文) Page 370 top Page 369, (中文) Page 369, tax 税 Double-clicking on the "fill handle" of a cell will fill in the rest of the column provided there‘s a filled cell next to it. Growth Year Cash flow <-- B6*(1+$B$3) Hint: To put in a new line, use [Alt]+[Enter] (this creates the little box you see in cell D21) <-- B3+3 PUTTING LINE BREAKS IN CELLS NAMED CELLS Income Tax rate Tax paid Sales Margin Profit <-- =Sales*Margin <-- =B4*B3 <-- =tax*B3 Taxes owed Tax rate as text <-- =TEXT(B4,"0.00%") <-- =TEXT(B4,"0.0") Income as date <-- =TEXT(B3,"mmm. dd, yyyy") x2 x2i Cannot put superscript and subscript in same column. SUPERSCRIPTS/SUBSCRIPTS IN CELLS HIDING CELLS Payment Number of payments Discount rate Present value <-- =PV(B5,B4,-B3) Data table <-- Data table header, =B6 PV of payments This is a multi-line cell. The break was entered by inserting [Alt]+[Enter] at the desired break points. GRAPH TITLES THAT UPDATE AUTOMATICALLY AUTO FILL/COPY 自动填充/复制如果存在一个填充单元格。双击单元格的“填充处理”将会填充到该列的其余单元格中将一行断开放到单元格中这是一个多行单元格。在一行你想在断…………
Page 367 (中文) Page 367 Page 366b (中文) Page 366b Page 366 (中文) Page 366 Page 363-364 (中文) Page 363-364 Page 363 chart Page 362-365 (中文) Page 362-365 Page 361 (中文) Page 361 Page 360, bottom (中文) Page 360, bottom Page 360, top (中文) Page 360, top Page 359, (中文) Page 359, Page 357b(中文) Page 357b Page 357(中文) Page 357 Page 356(中文) Page 356 Page 355-356 (中文) Page 355-356 Page 355, (中文) Page 355, Page 354 (中文) Page 354 Year Cash flow Discount rate NPV IRR <-- =IRR(B13:G13,0) step Payments made at the end of the period Rate Number of periods Payment Present value Payments made at the beginning of the period Principal Loan Table Interest Principal at Split of payment between beginning Repayment of year of principal Original matrix Transposed matrix =TRANSPOSE(B4:C7) Return Minimum Bins Frequency start Maximum a b Simon Howie q Jack Observation X Y Average Sample variance Population variance Sample standard deviation Population standard deviation Correlation Covariance Regression intercept Regression slope Regression r-squared USING =LINEST( ) slope intercept Slope (also =slope(D4:D13,C4:C13) )--> <-- Intercept Standard error of slope --> <-- Standard error of intercept R2 (also =Rsq(D4:D13,C…………
Page 298 chart Page 297 (中文) Page 297 Page 295 chart Page 290 (中文) Page 290 VBA dduration function Page 290 chart Page 294-295(中文) Page 294-295 Illustration, page 293 (中文) Illustration, page 293 bondprice dduration secondDur BASIC IMMUNIZATION EXAMPLE WITH 3 BONDS Yield to maturity Bond 1 Bond 2 Bond 3 Coupon rate Maturity Face value Bond price Face value equal to $1,000 of market value Duration New yield to maturity Reinvested coupons Total Multiply by percent of face value bought Product data table bond 1 bond 2 bond 3 bond 1 & 3 portfolio multiply by percent of face value bought Bond portfolio Bond 4 When the interest rate increases: When the interest rate decreases: THE IMMUNIZATION PROBLEM EXPERIMENTING WITH BOND PORTFOLIOS AND CONVEXITY Yield to maturity (YTM) New YTM Portfolio of bonds 1 and 3 BOND CONVEXITY Second derivative of duration Calculating the bond portfolio: Matrix of coefficients Vector of constants Solution Illustrated for the 30-year bond. Proportion of bond 1 Proportion of bond 3 Data table Explanation of the above: We want to invest proportions x1, x3, and x4 in bonds 1, 3 and 4 respectively, in order that: a) The total investment is $1000; this means x1+x2+x…………
Data for CML chart, p. 137 Page 137 (中文) Page 137 Page 137 chart (中文) Page 137 chart Page 135-136 (中文) Page 135-136 Page 134 chart Page 131-134 (中文) Page 126-129 Chart data127-130 Page 130 chart (中文) Page 130 chart Page 128 chart (中文) Page 128 chart Page 127 chart (中文) Page 127 chart solver_adj solver_adj solver_cvg 1.00E-04 solver_cvg 1.00E-04 solver_drv 1.00 solver_drv 1.00 solver_est 1.00 solver_est 1.00 solver_itr 100.00 solver_itr 100.00 solver_lin 2.00 solver_lin 2.00 solver_neg 2.00 solver_neg 2.00 solver_num .00 solver_num .00 solver_nwt 1.00 solver_nwt 1.00 solver_opt solver_opt solver_pre 1.00E-06 solver_pre 1.00E-06 solver_scl 2.00 solver_scl 2.00 solver_sho 2.00 solver_sho 2.00 solver_tim 100.00 solver_tim 100.00 solver_tol .05 solver_tol .05 solver_typ 2.00 solver_typ 3.00 solver_val .00 solver_val .07 Mean minus Variance-covariance matrix returns constant Constant z x y Transpose x Transpose y Mean(x) Mean(y) Var(x) Var(y) Sigma(x) Sigma(y) Cov(x,y) Corr(x,y) DATA TABLE A single portfolio calculation FOR EFFICIENT FRONTIER Proportion of x GRAPH p‘s mean return Sigma Return p‘s sigma <--data table header "jumps" in table <-- {} <-- {}…………
Page 341 (中文) Page 341 Page 340b Page 340 (中文) Page 340 Page 338-341 (中文) Page 338-341 discount discount discount discount discount discount discount discount growth growth growth growth growth growth growth growth CF1 Growth rate Discount rate Year Cash flow NPV <-- =+B6+NPV(B3,C6:I6) =B8 =B9 IRR <-- =IRR(B6:I6,0) Growth rate for Section 19.6 art: 增长率折现率年现金流量 CF1 UN-19J 234.00 .10 .15 .00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 -1150.00 234.00 257.40 283.14 311.45 342.60 376.86 414.55 101.46 .18 .00 101.46 .18 .00 -176.46 .10 .05 -47.82 .14 .10 101.46 .18 .15 274.35 .22 101.46 .07 .10 .12 .00 .05 .10 .15 101.46 .18 .00 -176.46 .10 .05 -47.82 .14 .10 101.46 .18 .15 274.35 .22 UN-19J 234.00 .10 .15 .00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 -1150.00 234.00 257.40 283.14 311.45 342.60 376.86 414.55 101.46 .18 .00 101.46 .18 .00 -176.46 .10 .05 -47.82 .14 .10 101.46 .18 .15 274.35 .22 101.46 .07 .10 .12 .00 .05 .10 .15 101.46 .18 .00 -176.46 .10 .05 -47.82 .14 .10 101.46 .18 .15 274.35 .22 UN-19J 234.00 .10 .15 .00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 -1150.00 234.00 257.40 283.14 311.45 342.60 376.86 414.55 101.46 .18 .00 101.46 .18 .00 -176.46 .10 .05 -47.82 .14 .10 101.46 .18 .15 274.35 .2…………
Page 234 chart （中文） Page 234 chart Page 233-234 (中文) Page 233-234 Page 233 (中文) Page 233 Page 231b (中文) Page 231b Page 231(中文) Page 230 (中文) Page 230 Page 228-229 (中文) VBA functions, pp. 199-200, 203 Page 228-229 Call Call CallOption CallVolatility implied_call_volatility implied_call_volatility interest interest PutOption r_ r_ S S sigma sigma solver_adj solver_adj solver_adj solver_cvg 1.00E-04 solver_cvg 1.00E-04 solver_cvg 1.00E-04 solver_drv 1.00 solver_drv 1.00 solver_drv 1.00 solver_est 1.00 solver_est 1.00 solver_est 1.00 solver_itr 100.00 solver_itr 100.00 solver_itr 100.00 solver_lin 2.00 solver_lin 2.00 solver_lin 2.00 solver_neg 2.00 solver_neg 2.00 solver_neg 2.00 solver_num .00 solver_num .00 solver_num .00 solver_nwt 1.00 solver_nwt 1.00 solver_nwt 1.00 solver_opt solver_opt solver_opt solver_pre 1.00E-06 solver_pre 1.00E-06 solver_pre 1.00E-06 solver_scl 2.00 solver_scl 2.00 solver_scl 2.00 solver_sho 2.00 solver_sho 2.00 solver_sho 2.00 solver_tim 100.00 solver_tim 100.00 solver_tim 100.00 solver_tol .05 solver_tol .05 solver_tol .05 solver_typ 3.00 solver_typ 3.00 solver_typ 3.00 solver_val 4.00 solver_val 4.00 solver_val 4.00 T T target_call_price target_call_pri…………
Page 15-16 (中文) Page 15-16 Page 12-14 (中文) Page 12-14 Page 10b (中文) Page 10b Page 10 (中文) Page 10 Page 9（中文） Page 9 Page 8（中文） Page 8 Page 7 (中文) Page 7 Page 5-6 (中文) Page 5-6 Page 4 (中文) Page 4 solver_adj solver_adj solver_cvg 1.00E-03 solver_cvg 1.00E-03 solver_drv 1.00 solver_drv 1.00 solver_est 1.00 solver_est 1.00 solver_itr 100.00 solver_itr 100.00 solver_lin 2.00 solver_lin 2.00 solver_neg 2.00 solver_neg 2.00 solver_num .00 solver_num .00 solver_nwt 1.00 solver_nwt 1.00 solver_opt solver_opt solver_pre 1.00E-06 iWww Refinanceloanshomeequity C Refinance Szh Donghuapian 5375 Gongfuxiongmaogaishichuanqidiyiji Refinance Loans Home Equity 财务金融建模—图表(39xls) －元妙企业管理网i e r r Refinance Refinance Loans Home Equity Fast bWww Refinanceloanshomeequity C Refinance Szh Donghuapian 5375 Gongfuxiongmaogaishichuanqidiyiji Refinance Loans Home Equity 财务金融建模—图表(39xls) －元妙企业管理网c Forex