Financial Modeling Guide

We would like to introduce to Financial Modeling Guide readers a pack of 150 Excel workbook templates, Excel add-ins and Learning Modules which allows you to perform quick and easy Financial Management functions and analysis in Excel, including financial risk analysis, profit margin analysis, advanced cash flow and cash burn forecasting.

The Complete Excel Financial Templates Collection provides 150 business finance spreadsheets, Excel add–ins and Excel Learning Modules plus 9 Monte Carlo Risk Analysis & Forecasting spreadsheets which will help you manage financial risks and set goals quickly and effectively.

The Investment-Calc series of spreadsheets allow financial analysts to quickly analyze and assess present values and the internal rate of return (IRR) of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments.

Also included are functions to help financial analysts calculate acquisition synergy net present values (NPV), cost of capital, terminal (to infinity) net present values plus an updated Quick Guide to Investment Decisions, as well as a Capital Project Cost Recovery Risk Analysis tool.

Applicable and highly recommended for all finance professionals, business & financial analysts, and financial modeling and analysis learners worldwide.

Available now for download or on CD – click here for details

More Information & Details:

• Project investment analysis tools allow financial analysts to calculate EBITDA, operating and after tax profits, average annual income, return on invested capital (ROIC), net present values and internal rates of return.
• 12 month budgeting spreadsheets for 1 to 10 company departments. Allows financial analysts to consolidate individual budgets on a year to date basis as well as perform monthly variance analysis.
• Asset Register PRO. Straight line depreciation register for up to 10,000 assets. Assets may be allocated to any one of 100 classes and 100 locations. Depreciation & book values for individual assets, classes and locations can be summed up. Any single asset record within a class can be adjusted to any depreciation rate.
• Excel costing templates provide equipment, employee and materials data values to calculate standard costs. Also includes Profit Margin risk analysis which is done by simulating probable profit outcomes when different cost variances are consolidated.
• Financial ratio analysis: Balance sheet, income statement and cash flow analysis calculates 50 key financial ratios, including operating ratios, shareholder returns, working capital, debt ratios, sales days, inventory turnover, and liquidity ratios.
• FastPlan 9.16 allows financial analysts to construct five year financial plans. First develop your 5 year monthly budgets, and FastPlan will transfom your inputs automatically into balance sheets, income forecasts and cash flows.
• The Cash Flow & Liquidity Forecasting tool creates a cash flow forecast for up to a 150 day horizon from an Excel based list of accounts payable and receivable with forecast banking dates. This allows financial analysts to set targets for late paying clients, and be notified of current late payers automatically.
• If you need to calculate a cash burn each day for 150 days ahead, use the extra CASH BURN forecasting spreadsheet provided within the pack.
• The pack also includes complete income statements, balance sheets and cash flows forecasting schedules which any financial analyst can use to enter best case, median case and worst case 12 month financial forecasts.
• The “Bank Cash Flows _ Budgets _ Actuals_Forecasts_Variances for Excel” workbook helps financial analysts identify each individual expense and income by category flowing through a bank account in each of 12 monthly periods. With this tool, you can budget and forecast your monthly cash flows ahead and track cash flow variances against budget.
• The pack also includes Monte Carlo Sales and Profit Simulators to help financial analysts set quantified goals and calculate the probability of achievement. The tools will allow analysts to combine Monte Carlo generated sales leads with costs per lead, lead conversion rates, price yields, profit margins, G&A recovery rates to yield most probable sales and profit results for up to 15 products or profit centers.

Available now for download or on CD – click here for details

All Files run in Excel 2003–2007, and both PC and Apple Mac versions are included in the download ensuring full compatibility for all users.

If you're new to Financial Modeling Guide, you may want to join our sister site, the Finance 3.0 network, to enroll in online financial training programs, ask questions, attend seminars, connect with others and download free finance spreadsheet templates about financial modeling, financial management, corporate finance & valuation, quantitative finance and accounting.
Over 50,000 finance professionals, entrepreneurs, analysts and investors from 195 countries have benefited.
Don't miss out on this outstanding opportunity for high quality, globally recognized financial education: Sign Up For Free Now!

After reading this article, people also reviewed these financial modeling and valuation resources: