Financial Projections Excel Spreadsheet – You can download this sheet that carries out Financial Projections, this Spreadsheet Model for the generation of financial statements projected along the valuation based on or based on the WACC (a compressed file is downloaded, the lower you have the link For the download), you know that the WACC is translated, more or less, by WACC (Average Weighted Cost of Capital), according to the wiki in the wikipedical bible is (we quote literally):
Obtaining the WACC discount rate The Weighted Average Cost of Capital (WACC) is the discount rate that must be used to discount operating cash flows to value a company using the discount of cash flows , In the “enterprise approach”.
The need to use this method is justified by the fact that the operating cash flows obtained are financed by both own capital and third-party capital. The WACC is to weigh the costs of each of the sources of capital.
The book in Excel has four sheets or tabs, the titles are, in the first model of financial projection, the second free cash flow, valuation of the firm (by dcf or method of discounted cash flows, in this case in method Indirect) and the last tab or sheet of the spreadsheet where there is the instructions in the model itself.
In the first tab of the book of the financial spreadsheet that concerns us, the financial projection model, we will see that it asks for data, as, for example, we put some:
Sales growth (1 TO 5 YEARS), Cost of sales / sales (% of sales), SALES EXPENSES (% of sales),
ADMINIST. EXPENSES (% of sales), Depreciation expense (% fixed / assets), INTEREST OF LAST YEAR INTEREST ($), LAST YEAR INTEREST EXPENSES ($), INTEREST RATE – DEBT (%), INTEREST RATE – INVESTMENTS (%), Tax rate (% of B / T INCOME), LAST DIVIDEND preferred stock, Preferred future bonus, LAST DIVIDEND COMMON SHARES, COMMON future dividends, initial cash balance, MINIMUM cash balance (SALES%), BALANCE OTHER CURRENT ASSETS (% SALES), BEGIN FIXED ASSETS DOLLARS, CHANGES IN FIXED ASSETS FROM YEAR 1 TO FOURTH, ACCUMULATED DEPRECIATION (AAIM), Accounts Payable (Accounts Payable) % SALES), TAXES AND OTHER ACCOUNTS PAYABLE,
START OF DEBT TO SHORT TERM AND NOTES, Short term loans – (this is not to be entered) -, OTHER CURR. LIABS. (SALES%) LONG-TERM DEBT AND LIABILITIES LONG-TERM DEBT year 1 to 4, preference shares, HOME ORDINARY SHARES, PARTIDA RETAINED EARNINGS, STOCK Year 1 to Year 4, PROFIT OR LOSS OF THE YEAR 0 to 4, And also some INFORMATION FOR VALUATION OF THE COMPANY as BETA DE STOCK of the companies (already existing), Annual GROWTH RATE, RISK free rate. We quote up here many inputs to be introduced as inputs into the model spreadsheet financial projections for generating projected financial statements along assessment based on the WACC, cost or weighted average cost of capital.
Financial Projections Excel Spreadsheet
( Click Image to Enlarge )
- Compare Two Excel Spreadsheets For Differences
- Convert Pdf To Excel Spreadsheet
- Excel Spreadsheet Training Free Online
- Excel Spreadsheet Practice Exercises
- Excel Spreadsheet Parts