Chapter 5: Avoiding Bad Programming Practices and Creating Effective Auditing Processes<\/b><\/span><\/p>\n\n

\n\t
• Show Formula Function<\/span><\/li>\n\t
• Add Text Function<\/span><\/li>\n\t
• Sheet Name Function<\/span><\/li>\n\t
• Generic Macros<\/span><\/li>\n\t
• Functions and Macros Collection with Short-cut List<\/span><\/li>\n\t
• List of All Functions in Book<\/span><\/li>\n<\/ul>\n\n

  Chapter 6: Developing and Efficiently Organizing Assumptions<\/b><\/span><\/p>\n\n

  \n\t
  • Port Model with Industry Analysis<\/span><\/li>\n\t
  • Exercise on Price and Marginal Cost<\/span><\/li>\n\t
  • GM Scatter Plots<\/span><\/li>\n\t
  • Wind Model with Assumptions Set Up in Project Finance Model<\/span><\/li>\n<\/ul>\n\n

    Chapter 7: Structuring Time Lines<\/b><\/span><\/p>\n\n

    \n\t
    • Project Finance Time Line Exercise<\/span><\/li>\n\t
    • Corporate Finance with History Exercise<\/span><\/li>\n\t
    • Holding Period in Acquisition Exercise<\/span><\/li>\n\t
    • Suntech Acquisition Model with Time Line Transfer<\/span><\/li>\n<\/ul>\n\n

      Chapter 8: Projecting Revenues, Expenses, and Capital Expenditures to Derive Pretax Cash Flow<\/b><\/span><\/p>\n\n

      \n\t
      • S-Curve Exercise<\/span><\/li>\n\t
      • Industry Capacity Corporate Exercise<\/span><\/li>\n\t
      • Corporate Model Exercise with Working Section<\/span><\/li>\n\t
      • Toll Way Model with Periodic Inflation<\/span><\/li>\n<\/ul>\n\n

        Chapter 9: Moving from Pretax Cash Flow to After-Tax Free Cash Flow<\/b><\/span><\/p>\n\n

        \n\t
        • Working Capital Exercise with Recession<\/span><\/li>\n\t
        • Alternative Depreciation Methods in Corporate Models<\/span><\/li>\n\t
        • Depreciation Functions<\/span><\/li>\n\t
        • Tax Exercise in Acquisition Model<\/span><\/li>\n<\/ul>\n\n

          Chapter 10: Adding Debt to Corporate or Project Finance Model by Programming Cash Flow Waterfalls<\/b><\/span><\/p>\n\n

          \n\t
          • Simple Cash Flow Plug in Corporate Model<\/span><\/li>\n\t
          • Waterfall in Acquisition<\/span><\/li>\n\t
          • Debt Default in Project Finance<\/span><\/li>\n\t
          • Mezzanine Debt in Acquisition Model<\/span><\/li>\n\t
          • ABC Debt in Acquisition Exercise<\/span><\/li>\n<\/ul>\n\n

            Chapter 11: Alternative Calculations of Equity Distributions<\/b><\/span><\/p>\n\n

            \n\t
            • Cash Flip in Project Finance<\/span><\/li>\n\t
            • Flip with Alternative Construction Funding<\/span><\/li>\n\t
            • Annual Solar Model<\/span><\/li>\n\t
            • Constant Capital Structure with Algebra<\/span><\/li>\n\t
            • Earn Out, Management Ratchet and Put Option to Existing Owners<\/span><\/li>\n\t
            • Financial Institution Exercise with Target Capital Adequacy<\/span><\/li>\n\t
            • Target Capital Structure with Solver in Corporate Finance<\/span><\/li>\n\t
            • Tax Equity Model<\/span><\/li>\n<\/ul>\n\n

              Chapter 12: Putting Together Financial Statements and Calculating Income Taxes<\/b><\/span><\/p>\n\n

              \n\t
              • Basic Tax Exercise<\/span><\/li>\n\t
              • Advanced NOL Exercise<\/span><\/li>\n\t
              • NOL and Deferred Tax<\/span><\/li>\n<\/ul>\n\n

                Chapter 13: Risk Assessment: The Centerpiece of All Valuation, Contracting, and Credit Issues in Finance<\/b><\/span><\/p>\n\n

                \n\t
                • Waterfall Graph Templates and Explanations<\/span>\n\n\t
                  \n\t\t
                  • Construction of Waterfall Graphs<\/span><\/li>\n\t\t
                  • Waterfall Template for Excel 2007<\/span><\/li>\n\t\t
                  • Waterfall Template for Excel 2010<\/span><\/li>\n\t<\/ul>\n\t<\/li>\n\t
                  • M&A Example - Kraft and Cadbury<\/span><\/li>\n<\/ul>\n\n

                    Chapter 15: Presentation of Risk Analysis through Adding Sensitivity Analysis to Financial Models<\/b><\/span><\/p>\n\n

                    \n\t
                    • Crimson Case with Graph from Cash Flow Sources and Distributions<\/span><\/li>\n\t
                    • Single Model with Monthly and Annual Aggregation<\/span><\/li>\n\t
                    • Mixed Use Model Aggregation with INDIRECT<\/span><\/li>\n\t
                    • End of Quarter Function<\/span><\/li>\n\t
                    • Dynamic Graph Exercise with #N\/A<\/span><\/li>\n\t
                    • Dynamic Graph Exercise with OFFSET<\/span><\/li>\n\t
                    • Flexible Print with OFFSET<\/span><\/li>\n<\/ul>\n\n

                      Chapter 16: Using Financial Models to Establish Break-Even Points for Key Input Variables with Data Tables<\/b><\/span><\/p>\n\n

                      \n\t
                      • DSCR, PLCR, and LLCR Exercise<\/span><\/li>\n\t
                      • One-Way and Two-Way Data Table Exercise<\/span><\/li>\n\t
                      • Break-Even Exercise with One-Way Data Table<\/span><\/li>\n\t
                      • LBO Featured Model with VBA Flexible Data Tables<\/span><\/li>\n\t
                      • Data Table with VBA and Goal Seek Exercise<\/span><\/li>\n<\/ul>\n\n

                        Chapter 17: Constructing Flexible Scenario Analysis for Risk Assessment<\/b><\/span><\/p>\n\n

                        \n\t
                        • Scenario Exercise<\/span><\/li>\n\t
                        • Off-Shore Wind Example with Custom scenario cases<\/span><\/li>\n<\/ul>\n\n

                          Chapter 18: Generating Tornado Diagrams, Spider Charts, and Waterfall Graphs<\/b><\/span><\/p>\n\n

                          \n\t
                          • Tornado Exercise with One-Way Data Table<\/span><\/li>\n\t
                          • Tornado Exercise with Two-Way Table<\/span><\/li>\n\t
                          • Spider Diagram Exercise and Example<\/span><\/li>\n\t
                          • Renewable Model with Spider Diagram<\/span><\/li>\n\t
                          • Downside Case with Value Build-up Waterfall Example<\/span><\/li>\n<\/ul>\n\n

                            Chapter 19: Adding Probabilistic Risk Analysis and Time Series Equations to Financial Models<\/b><\/span><\/p>\n\n

                            \n\t
                            • Exercise in Working with Statistical Distributions<\/span><\/li>\n\t
                            • Commodity Price Analysis File<\/span><\/li>\n\t
                            • Renewable Simulation Example<\/span><\/li>\n\t
                            • Hydro Resource Analysis<\/span><\/li>\n\t
                            • Wind Speed Resource Analysis<\/span><\/li>\n\t
                            • Solar Resource Analysis<\/span><\/li>\n<\/ul>\n\n

                              Chapter 20: Taking the Mystery out of Applying Time Series Analysis and Monte Carlo Simulation in Financial Models<\/b><\/span><\/p>\n\n

                              \n\t
                              • Single Column Model Exercise<\/span><\/li>\n\t
                              • Senior and Sub Debt without VBA<\/span><\/li>\n\t
                              • Time Series Exercise with Distributions<\/span><\/li>\n\t
                              • Monte Carlo Simulation Exercise with VBA<\/span><\/li>\n\t
                              • Lease Book with Monte Carlo Simulation<\/span><\/li>\n<\/ul>\n\n

                                Chapter 21: Constructing Probability Distributions with Trends, Mean Reversion, Price Boundaries, and Correlations among Variables<\/b><\/span><\/p>\n\n

                                \n\t
                                • Model with Monte Carlo Simulation<\/span><\/li>\n\t
                                • Comprehensive Monte Carlo Template<\/span><\/li>\n\t
                                • Retrieve Stock Prices General<\/span><\/li>\n\t
                                • Correlation Exercise<\/span><\/li>\n\t
                                • Cholesky Exercise and Proof<\/span><\/li>\n<\/ul>\n\n

                                  Chapter 22: The Difficult Problem of Estimating Volatility, Mean Reversion, Time Trends, Correlations, and Price Boundaries from Historical Data or Market Data<\/b><\/span><\/p>\n\n

                                  \n\t
                                  • Log Normal Distribution<\/span><\/li>\n\t
                                  • Simulation of Volatility and Time<\/span><\/li>\n\t
                                  • Volatility Function<\/span><\/li>\n\t
                                  • Mean Reversion Test<\/span><\/li>\n\t
                                  • Replication of Black Scholes with Simulation<\/span><\/li>\n<\/ul>\n\n

                                    Chapter 24: Computing the Return on Invested Capital for Historical and Projected Periods in Corporate Models<\/b><\/span><\/p>\n\n

                                    \n\t
                                    • Flower Foods Corporate Model with Summary Page<\/span><\/li>\n\t
                                    • Free Cash Flow and Equity Cash Flow Perspective and Reconciliation<\/span><\/li>\n\t
                                    • Example of using INDEX to Make Flexible Graphs of Assumptions and Outputs<\/span><\/li>\n<\/ul>\n\n

                                      Chapter 25: Calculation of Invested Capital<\/b><\/span><\/p>\n\n

                                      \n\t
                                      • Long-term Accounts Payable Simulation Exercise<\/span><\/li>\n\t
                                      • ROIC and ROE Reconciliation<\/span><\/li>\n\t
                                      • ROIC Analysis<\/span><\/li>\n<\/ul>\n\n

                                        Chapter 26: Complex Items in Balance Sheet Analysis: Deferred Taxes, Operating Cash, and Derivative Assets<\/b><\/span><\/p>\n\n

                                        \n\t
                                        • Proofs of Bridge Between Equity and Enterprise Value<\/span><\/li>\n\t
                                        • Bridge Between Equity Value and Enterprise Value<\/span><\/li>\n\t
                                        • Basic Deferred Tax Exercises without growth<\/span><\/li>\n\t
                                        • Modigliani and Miller and WACC<\/span><\/li>\n\t
                                        • Problems with Unleveraging and Releveraging Beta Exercise<\/span><\/li>\n<\/ul>\n\n

                                          Chapter 27: Four General Terminal Value Methods<\/b><\/span><\/p>\n\n

                                          \n\t
                                          • Corporate Valuation Concepts<\/span><\/li>\n\t
                                          • DCF Exercise with Retirements<\/span><\/li>\n\t
                                          • Alternative Terminal Valuation Methods<\/span><\/li>\n<\/ul>\n\n

                                            Chapter 28: Terminal Value and Philosophy: Company Growth Rates and Overall Economic Growth<\/b><\/span><\/p>\n\n

                                            \n\t
                                            • Discounting in DCF with Partial Year Factors<\/span><\/li>\n\t
                                            • Partial Year Discounting<\/span><\/li>\n\t
                                            • Exercise for Transition Factors<\/span><\/li>\n\t
                                            • Proof of Partial Year Discounting<\/span><\/li>\n\t
                                            • Variable WACC and Partial Year Discounting<\/span><\/li>\n\t
                                            • Transition Factors PE Ratio<\/span><\/li>\n\t
                                            • Transition Factors EV EBITDA Ratio<\/span><\/li>\n<\/ul>\n\n

                                              Chapter 29: Normalizing Terminal Year Cash Flows for Stable Working Capital Investment<\/b><\/span><\/p>\n\n

                                              \n\t
                                              • Working Capital Exercise<\/span><\/li>\n\t
                                              • Stable Working Capital<\/span><\/li>\n<\/ul>\n\n

                                                Chapter 30: Relationship of Growth, Capital Expenditures, Depreciation, and Return on Investment<\/b><\/span><\/p>\n\n

                                                \n\t
                                                • Stable Depreciation Rate<\/span><\/li>\n\t
                                                • Capital Expenditure Analysis<\/span><\/li>\n\t
                                                • Capital Expenditure to Depreciation with Historic Growth<\/span><\/li>\n\t
                                                • Cap Expenditure and Depreciation Functions<\/span><\/li>\n\t
                                                • Depreciation Functions.bas<\/span><\/li>\n<\/ul>\n\n

                                                  Chapter 31: Computing Normalized Deferred Tax Changes<\/b><\/span><\/p>\n\n

                                                  \n\t
                                                  • Stable Deferred Tax<\/span><\/li>\n\t
                                                  • Stable Deferred Tax - Historic Growth<\/span><\/li>\n\t
                                                  • Stable Deferred Tax Function<\/span><\/li>\n<\/ul>\n\n

                                                    Chapter 32: Terminal Value and the Ability of a Company to Earn Returns above the Cost of Capital<\/b><\/span><\/p>\n\n

                                                    \n\t
                                                    • Financial Ratio Download<\/span><\/li>\n\t
                                                    • Financial Ratio Analysis General<\/span><\/li>\n\t
                                                    • Downloading Saudi Stocks and INDIRECT Examples<\/span><\/li>\n\t
                                                    • Retrieve Interest Rate and Inflation<\/span><\/li>\n\t
                                                    • Retrieve Electricity Price Data<\/span><\/li>\n<\/ul>\n\n

                                                      Chapter 33: Errors and Distortions in Applying the Value Driver Formula<\/b><\/span><\/p>\n\n

                                                      \n\t
                                                      • Value Driver Analysis - Equity Basis<\/span><\/li>\n\t
                                                      • Value Driver Analysis Working Capital<\/span><\/li>\n\t
                                                      • Value Driver Analysis EV<\/span><\/li>\n<\/ul>\n\n

                                                        Chapter 34: Computing Implied Price\/Earnings Ratios for Use in Terminal Value Calculations<\/b><\/span><\/p>\n\n

                                                        \n\t
                                                        • P\/E Ratio Analysis<\/span><\/li>\n\t
                                                        • P\/E Analysis with Varying Growth<\/span><\/li>\n<\/ul>\n\n

                                                          Chapter 35: Computing an Implied EV\/EBITDA Ratio in Terminal Value Calculations<\/b><\/span><\/p>\n\n

                                                          \n\t
                                                          • EV\/EBITDA Exercise<\/span><\/li>\n\t
                                                          • PE and EV\/EBITDA Analysis - Linear<\/span><\/li>\n\t
                                                          • PE and EV\/EBITDA Analysis - Growth<\/span><\/li>\n\t
                                                          • ROIC and EV to EBITDA<\/span><\/li>\n<\/ul>\n\n

                                                            Chapter 36: Developing Value Drivers for P\/E and EV\/EBITDA Ratios with Benchmarking and Regression<\/b><\/span><\/p>\n\n

                                                            \n\t
                                                            • Workbooks.open Exercise<\/span><\/li>\n\t
                                                            • Slovenia Stock Exchange<\/span><\/li>\n\t
                                                            • Regression of Market Multiples<\/span><\/li>\n<\/ul>\n\n

                                                              Chapter 37: Resolving Circular References in Acquisition Models: Computing Interest Expense on the Average Balance of Debt<\/b><\/span><\/p>\n\n

                                                              \n\t
                                                              • Cash Flow Sweep Exercise without Taxes<\/span><\/li>\n\t
                                                              • Cash Flow Sweep Exercise with Taxes<\/span><\/li>\n<\/ul>\n\n

                                                                Chapter 38: Creating a Structured Cash Flow Process in a Corporate Model to Resolve Circular References<\/b><\/span><\/p>\n\n

                                                                \n\t
                                                                • Cash Flow Process with Minimum<\/span><\/li>\n\t
                                                                • Circular Resolution for Corporate Model<\/span><\/li>\n\t
                                                                • Circular Reference Nairobi Tea Company<\/span><\/li>\n<\/ul>\n\n

                                                                  Chapter 39: Overview of Complex Project Finance Modeling Structuring Issues<\/b><\/span><\/p>\n\n

                                                                  \n\t
                                                                  • Project Finance Concepts<\/span><\/li>\n\t
                                                                  • Function Model Function Library<\/span><\/li>\n\t
                                                                  • Renewable Project Finance Model with Instructions<\/span><\/li>\n<\/ul>\n\n

                                                                    Chapter 40: Funding Techniques in Project Finance and the Associated Circular Reference Problems<\/b><\/span><\/p>\n\n

                                                                    \n\t
                                                                    • Circular Fee Exercise<\/span><\/li>\n\t
                                                                    • Debt Funding Exercises - 1<\/span><\/li>\n\t
                                                                    • Debt Funding Exercises - 2<\/span><\/li>\n\t
                                                                    • Circular Logic from Equity First<\/span><\/li>\n\t
                                                                    • Circular Logic from Fixed Debt to Capital Ratio<\/span><\/li>\n\t
                                                                    • Bond Financing Exercise<\/span><\/li>\n<\/ul>\n\n

                                                                      Chapter 41: Debt Sculpting in a Project Finance Model<\/b><\/span><\/p>\n\n

                                                                      \n\t
                                                                      • Alternative Sculpting Method Methods without Tax<\/span><\/li>\n\t
                                                                      • Sculpting with Circularity<\/span><\/li>\n\t
                                                                      • Comprehensive Model with Sculpting Option<\/span><\/li>\n\t
                                                                      • Project Finance Concepts Advanced<\/span><\/li>\n<\/ul>\n\n

                                                                        Chapter 42: Automating the Goal Seek Process for Annuity and Equal Installment Repayments<\/b><\/span><\/p>\n\n

                                                                        \n\t
                                                                        • Debt Sizing with Goal Seek Macro<\/span><\/li>\n\t
                                                                        • Debt Sizing with Function<\/span><\/li>\n\t
                                                                        • Alternative Debt Sizing<\/span><\/li>\n<\/ul>\n\n

                                                                          Chapter 43: Modeling Debt Service Reserve Accounts<\/b><\/span><\/p>\n\n

                                                                          \n\t
                                                                          • DSRA Set-up Exercise<\/span><\/li>\n\t
                                                                          • DSRA with Cash Flow Sweep<\/span><\/li>\n\t
                                                                          • DSRA Circular Exercise<\/span><\/li>\n\t
                                                                          • Debt Service Reserve Exercise<\/span><\/li>\n<\/ul>\n\n

                                                                            Chapter 44: Modeling Maintenance Reserve Accounts<\/b><\/span><\/p>\n\n

                                                                            \n\t
                                                                            • MRA Exercise - Simple<\/span><\/li>\n\t
                                                                            • MRA Example<\/span><\/li>\n<\/ul>\n\n

                                                                              Chapter 45: Refinancing and Valuing a Project Given Risk Changes over the Life of a Project<\/b><\/span><\/p>\n\n

                                                                              \n\t
                                                                              • Refinancing Exercise with Cash Sweep<\/span><\/li>\n\t
                                                                              • Multiple Refinancing Exercise<\/span><\/li>\n\t
                                                                              • Refinancing Example<\/span><\/li>\n\t
                                                                              • Solar Project Finance Model with Refinancing<\/span><\/li>\n\t
                                                                              • Mini Perm Example<\/span><\/li>\n<\/ul>\n\n

                                                                                Chapter 46: Covenants and Cash Flow Sweeps in Project Finance Models<\/b><\/span><\/p>\n\n

                                                                                \n\t
                                                                                • Cash Sweep Exercise<\/span><\/li>\n\t
                                                                                • Lock-up Covenant Exercise<\/span><\/li>\n\t
                                                                                • Sweep and Trap Exercise<\/span><\/li>\n<\/ul>\n\n

                                                                                  Chapter 47: Asset Portfolios, Progress Payments, and Lease Rolls in Real Estate Models<\/b><\/span><\/p>\n\n

                                                                                  \n\t
                                                                                  • Comprehensive Real Estate with Mixed Use and Percent of Time Function<\/span><\/li>\n\t
                                                                                  • Commercial Lease Roll<\/span><\/li>\n\t
                                                                                  • Real Estate Exercises<\/span><\/li>\n\t
                                                                                  • Percent of Time Function<\/span><\/li>\n\t
                                                                                  • Mixed Use with Residential and Financing<\/span><\/li>\n\t
                                                                                  • Solar Roof Top Example<\/span><\/li>\n\t
                                                                                  • Hotel Project Finance<\/span><\/li>\n\t
                                                                                  • cResidential Mixed Use Model with Data Table Method<\/span><\/li>\n<\/ul>\n\n

                                                                                    \u672c\u4e66\u53ef\u5728\u4eac\u4e1c\u3001\u4e9a\u9a6c\u900a\u5e73\u53f0\u7b49\u7535\u5546\u5e73\u53f0\u8d2d\u4e70<\/span><\/span><\/p>\n","minPrice":"0.00","maxPrice":"0.00","discountId":"0","images":{"large":"https:\/\/www.baoma-online.com\/files\/course\/2021\/04-27\/1510328d7fe9424413.jpg","middle":"https:\/\/www.baoma-online.com\/files\/course\/2021\/04-27\/1510328d87e9231352.jpg","small":"https:\/\/www.baoma-online.com\/files\/course\/2021\/04-27\/1510328d8d44497528.jpg"},"ratingNum":"3","rating":"1.33333","hitNum":"132338","hotSeq":"0","maxPriceObj":{"currency":"RMB","amount":"0.00","coinAmount":"0.00","coinName":"\u91d1\u5e01"},"minPriceObj":{"currency":"RMB","amount":"0.00","coinAmount":"0.00","coinName":"\u91d1\u5e01"},"minDisplayPrice":"0.00","maxDisplayPrice":"0.00","minDisplayPriceObj":{"currency":"RMB","amount":"0.00","coinAmount":"0.00","coinName":"\u91d1\u5e01"},"maxDisplayPriceObj":{"currency":"RMB","amount":"0.00","coinAmount":"0.00","coinName":"\u91d1\u5e01"}}],"classroomCourses":[]}" data-current-user-id="" data-target-id="" data-is-user-login="0" data-current-url="http://baoma-online.com/goods/show/166" data-goods-setting="{"recommend_rule":"label","show_number_data":"visitor","show_student_review_num_enable":"0","leading_join_enabled":"1","leading":{"label":"\u626b\u7801\u6dfb\u52a0\u8bfe\u7a0b\u52a9\u7406bobo\u8001\u5e08","description":"\u9886\u53d688\u5143\u65b0\u4eba\u4f18\u60e0\u5238","qrcode":"public:\/\/default\/2023\/06-26\/120114ab51c8428458.jpg"},"show_review":"1"}" data-drp-recruit-switch="0" data-ugc-review-setting="{"enable_review":"1","enable_course_review":"1","enable_classroom_review":"1","enable_question_bank_review":"0","enable_open_course_review":"0","enable_article_review":"0"}" data-vip-enabled="1">