SPREADSHEET MODELING IN CORPORATE FINANCE

《SPREADSHEET MODELING IN CORPORATE FINANCE》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、SPREADSHEETMODELINGINCORPORATEFINANCEToaccompanyPrinciplesofCorporateFinancebyBrealeyandMyersCRAIGW.HOLDENRichardG.BrinkmanFacultyFellowandAssociateProfessorKelleySchoolofBusinessIndianaUniversityPrenticeHall,UpperSaddleRiver,NewJersey07458ToKathryn,you’retheinspiration,andtoDianaandJimmy,withjoy

2、andpride.CraigCONTENTSPrefacePART1TIMEVALUEOFMONEYChapter1SingleCashFlow1.1PresentValue1.2FutureValueProblemsChapter2Annuity2.1PresentValue2.2FutureValue2.3SystemofFourAnnuityVariablesProblemsChapter3NetPresentValue3.1ConstantDiscountRate3.2GeneralDiscountRateProblemsChapter4RealandInflation4.1Co

3、nstantDiscountRate4.2GeneralDiscountRateProblemsChapter5LoanAmortization5.1Basics5.2SensitivityAnalysisProblemsPART2VALUATIONChapter6BondValuation6.1Basics6.2ByYieldToMaturity6.3SystemOfFiveBondVariables6.4DynamicChartProblemsChapter7StockValuation7.1TwoStage7.2DynamicChartProblemsChapter8TheYiel

4、dCurve8.1ObtainingItFromBondListings8.2UsingItToPriceACouponBond8.3UsingItToDetermineForwardRatesProblemsChapter9U.S.YieldCurveDynamics9.1DynamicChartProblemsPART3CAPITALBUDGETINGChapter10ProjectNPV10.1Basics10.2ForecastingCashFlows10.3WorkingCapital10.4SensitivityAnalysisProblemsChapter11Cost-Re

5、ducingProject11.1Basics11.2SensitivityAnalysisProblemsChapter12Break-EvenAnalysis12.1BasedOnAccountingProfit12.2BasedOnNPVProblemsChapter13ThreeValuationMethods13.1AdjustedPresentValue13.2FlowsToEquity13.3WeightedAverageCostofCapitalProblemsPART4FINANCIALPLANNINGChapter14CorporateFinancialPlannin

6、g14.1Actual14.2Forecast14.3CashFlow14.4Ratios14.5Sensitivity14.6Full-ScaleRealDataProblemsChapter15DuPontSystemofRatioAnalysis15.1BasicsProblemsChapter16Life-CycleFinancialPlanning16.1BasicsProblemsPART5OPTIONSANDCORPORATEFINANCEChapter17BinomialOptionPricing17.1SinglePeriod17.2Multi-Period17.3Ri

7、skNeutral17.4Full-ScaleRealDataProblemsChapter18BlackScholesOptionPricing18.1Basics18.2DynamicChart18.3ContinuousDividend18.4ImpliedVolatilityProblemsChapter19DebtandEquityValuation19.1TwoMethods19.2ImpactofRiskProblem