Building financial models with Microsoft Excel by K. Scott Proctor

By K. Scott Proctor

A finished consultant to construction monetary versions construction monetary types with Microsoft Excel + CD-ROM presents starting or intermediate point desktop clients with step by step directions on development monetary types utilizing Microsoft Excel-the preferred spreadsheet software to be had. The accompanying CD-ROM comprises Excel worksheets that song the process the ebook and make allowance readers to construct their very own monetary types. This accomplished source additionally covers very important subject matters equivalent to the concept that of valuation, the concept that of sensitivity research, the techniques of contribution margin and fiscal ratios and the fundamentals of creating and utilizing a Capitalization desk. ok. Scott Proctor, CFA, is the Director of Investor Analytics at SNL monetary, a monetary details supplier.

Show description

Read Online or Download Building financial models with Microsoft Excel PDF

Best corporate finance books

Real Options Analysis: Tools and Techniques for Valuing Strategic Investments and Decisions

Compliment for actual recommendations research ''This e-book is a must have and must-read . . . Mun’s new publication is a fresh, state-of-the-art examine a robust new decision-making technique . . . it isn’t usually you could in truth say a booklet breaks new flooring, yet [this ebook] has definitely performed that. '' –Glenn G.

New Venture Investment

New enterprise founders and their sponsors search to create financial worth via discovering and commercializing new and higher methods of doing issues. Their universal aim, which additionally defines the aim of the entrepreneurial strategy itself, calls for a greater snatch of the most important components that effect the alternatives serious about trying to create monetary price below hugely doubtful stipulations.

Capital Budgeting Financial Appraisal of Investment Projects

This publication for complex scholars and execs in administration and finance explains the monetary appraisal of capital budgeting tasks. It develops simple innovations, ideas and strategies and applies them to case experiences in forestry, estate and foreign investments. source constraints are brought to the capital budgeting judgements with a number of labored examples utilizing linear programming innovations.

Decision-Making in Private Equity Firms: An Empirical Study of Determinants and Rules

The choices of personal fairness companies impact the advance of industries and nationwide economies, but little is understood approximately how those judgements are made. Mark Broere makes use of proprietary survey information from 136 deepest fairness organizations (venture capital and buyout) situated within the US, Canada, and Europe to discover determinants and principles in their decision-making.

Extra info for Building financial models with Microsoft Excel

Example text

As I am building a financial model for only year X4, I will not address assumptions related to year X5. As such, this assumption represents a straightforward solution to the problem of including any information related to year X5. 9 offers an alternative view of the Inventory Budget in which the values and calculations underlying the worksheet are exposed. Only a portion of the columns of the worksheet are shown due to the length of the formulas associated with the underlying calculations. 10. 11 offers a view of the names of the input and output cells in the Inventory Budget.

22 offers a view of the input and output cells in the Accounts Receivable Budget itself. 22 Names of the Input and Output Cells in the Accounts Receivable Budget QUESTIONS Each of the questions for this chapter relates to a hypothetical company named Company XYZ. Company XYZ sells "tablet" Personal Computers (PCs) to the consumer market. As such, Company XYZ is a product-oriented (as opposed to a service-oriented) business. The questions will address the fiscal year X5 on a quarterly basis (four specific quarters, 1Q-4Q for the year X5).

5, note that equations such as that found in cell B7 (= B5 * B6) are to be interpreted as follows: the value in cell B7 is equal to the value in B5 multiplied by the value in B6. For the sake of clarity, remember that the following symbols are used to represent arithmetic operators: + (plus/addition), - (minus/subtraction), * (times/multiplication), and / (divided by or division). I provide many of these alternative views of worksheets over the course of this book so that you can see the specific calculations underlying Napavale's financial model.

Download PDF sample

Rated 4.83 of 5 – based on 10 votes