Tuesday, April 26, 2011

Excel Budgeting & Financial Forecasting

Budgeting & Financial Forecasting collection includes the following Excel workbooks:
Master Budgets 4.6 helps you combine up to 10 department budgets quickly and easily and tracks actuals and variances. Create seperate 12 monthly budgets and Excel consolidates to a Year to Date summary tracking actuals vs budgets.
Cash Flow Forecasting 2008.xls will convert any list of AR-AP accounts into a daily and calendar month cash flow forecast up to 150 days ahead from users starting date. Import accounts payable and receivable into this Excel workbook from any accounting package and generate an instant 150 day cash flow forecast. Manage slow payers and accounts payable more effectively with closer identification of cash flow forecasts.
Everything is so easy with Excel. Excel links all your receivable and payable accounts together to provide a day by day and month by month cash flow summary.
If you need to calculate your cash burn each day for 150 days ahead use the extra CASH BURN budgeting & forecasting spreadsheet provided within this zip file.
New! Quick Budget Forecasting PRO. Excel is brilliant at consolidating actual transactions into separate fixed and variable cash flow categories, enabling quick monthly budget forecasts to be developed based on real actual results and trends. This extra workbook helps you assign transactions to fixed and variable categories. Excel consolidates actual transaction data into monthly cash flow reports presented in fixed and variable categories. The year to date report continually updates the 12 months Budget Forecast spreadsheet so that your forecasts are always current, based on latest results.

Google Spreadsheets Excel Templates Collection

Google Spreadsheets Excel Templates Collection: 25 Excel files in total - 23 upload and run in Google Docs Spreadsheets, plus 2 Cash Flow Forecasting with file sizes that are greater then the Google Docs limit which enables larger data volumes.
  • GoogleDocsCalendar
  • GoogleDocsEnquiriesTracking
  • GoogleDocsDailyDollarResults
  • GoogleDocsOrdersForecasts
  • GoogleDocsForecasting
  • GoogleDocsReceivableCash Forecast (Part 1)
  • GoogleDocsPayableCashForecast (Part 2)
  • GoogleDocsCashFlowForecast
  • GoogleDocsEBITValuation
  • GoogleDocsCommRealEstate
  • GoogleDocs12MonthsCostCenterBudgets
  • GoogleDocs12MonthsPLBudget
  • GoogleDocsCostingSpreadsheets
  • GoogleDocsQuickCalcNPV-IRRCashFlows
  • GoogleDocsNewProjectAnalysis
  • GoogleDocsPortfolioCalc
  • GoogleDocsROR
  • GoogleDocsRatios
  • GoogleDocsCostSavingProjects
  • GoogleDocsAcqustionsIRR
  • GoogleDocsMAForecasting
  • GoogleDocsPromoPricingTables
  • GoogleDocsSolvencyTest

Tuesday, April 12, 2011

Excel Templates | Spreadsheet Templates | The Spreadsheet Store

The Spreadsheet Store

Excel templates at The Spreadsheet Store.

The Spreadsheet Store is the place for Microsoft Excel templates to help you run your business and your life. These Excel spreadsheet templates for Excel 2003 and 2007 are packed with features and easy to use.
Download Excel spreadsheet templates, including Excel Gantt chart templates, invoice templates, budgets, business valuation models and more.

JoomBlog - JoomPlace Joomla extensions, components, modules, software, plugins, addons

JoomBlog

$59.00

JoomBlog

- JoomPlace Joomla extensions, components, modules, software, plugins, addons

[add-ons and plugins, Belitsoft, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace]

Featured Photos - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Plugin allows user to place favorite images to JomSocial profile - You can select what images from your uploaded photos should be shown on the profile page for visitors.

[add-ons and plugins, Belitsoft, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace]

Featured Photos - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Profile Guests - JoomPlace Joomla extensions, components, modules, software, plugins, addons

 Subscription to Profile Guests, Featured Photos, Profile Designer, JomSocial Drag'n'Drop, JomSocial Classifieds, JomSocial Graffiti Wall, their code, updates, documentation and helpdesk support. The subscription is valid for 1 year.

If the plugin is installed on the site a user will be able to add it in his Applications>Browse, e.g.: Admin can make this a core default application in the BE. Then a user won't have to add it. Once added a user will see people who visited his profile on his Profile tab. Please note that you will see your guests only when at least one user visited your profile after the plugin was added:

[add-ons and plugins, Belitsoft, download, Joomla, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace, order, secure, software, technology]

Profile Guests - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Profile Designer for JoomSocial plugin - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Use profile designer for JoomSocial to change the background colour, add a wallpaper, etc.

Subscription to Profile Designer, it's code, updates, and helpdesk support. The subscription is valid for 1 year.

[add-ons and plugins, Belitsoft, download, Joomla, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace, order, secure, software, technology]

Profile Designer for JoomSocial plugin - JoomPlace Joomla extensions, components, modules, software, plugins, addons

JomSocial Classifieds - JoomPlace Joomla extensions, components, modules, software, plugins, addons

JomSocial Classifieds

For JomSocial 2.0 - 2.2

The plugin is a simple application for posting small classifieds and sharing them with other users. The plugin doesn't have extended functionality, except for the search option. It is just a nice app to store some personal advertisements on the profile.

[add-ons and plugins, Belitsoft, download, Joomla, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace, order, secure, software, technology]

JomSocial Classifieds - JoomPlace Joomla extensions, components, modules, software, plugins, addons

JomSocial Drag'n'Drop - JoomPlace Joomla extensions, components, modules, software, plugins, addons

 Subscription to Profile Guests, Featured Photos, Profile Designer, JomSocial Drag'n'Drop, JomSocial Classifieds, JomSocial Graffiti Wall, their code, updates, documentation and helpdesk support. The subscription is valid for 1 year.

If the plugin is installed on the site a user will be able to add it in his Applications>Browse. Admin can make this a core default application in the BE. Then a user won't have to add it. Once added a user will be able to drag and drop the application in different positions on his profile:

[add-ons and plugins, Belitsoft, download, Joomla, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace, order, secure, software, technology]

JomSocial Drag'n'Drop - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Cars template - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Cars template

$20.00

Cars template

- JoomPlace Joomla extensions, components, modules, software, plugins, addons

[add-ons and plugins, Belitsoft, download, Joomla, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace, order, secure, software, technology]

JomSocial Plugins (bundle) - JoomPlace Joomla extensions, components, modules, software, plugins, addons

JomSocial Plugins (bundle)

$51.00

JomSocial Plugins (bundle)

- JoomPlace Joomla extensions, components, modules, software, plugins, addons

JomSocial Graffiti Wall - JoomPlace Joomla extensions, components, modules, software, plugins, addons

The Graffiti Wall will become the favorite place for your users to communicate. One can find so many funny and interesting inscriptions there starting with congratulations and ending with wicked jokes. With this special graffiti application a user will be able to select the color, brush size, its opacity, add noise and draw whatever he wants on his, friends' and other users' walls. Graffiti plugin for JomSocial is a way to express yourself for your friends, with the help of these drawings one can add emotionality and vividness to their words, and vice versa. Such images are used very frequently by other social networks so we decided to implement it for JomSocial. Besides the graffiti itself, a user will be able to leave simple text messages on the wall, add images,photos, and even video!

PLEASE PAY ATTENTION! This plugin doesn’t work separately along with the default JomSocial wall plugin but it replaces the default plugin and extends its functionality (you won’t experience any data loss because of that).

Subscription to Profile Guests, Featured Photos, Profile Designer, JomSocial Drag'n'Drop, JomSocial Classifieds, JomSocial Graffiti Wall, their code, updates, documentation and helpdesk support. The subscription is valid for 1 year.

JomSocial Graffiti Wall - JoomPlace Joomla extensions, components, modules, software, plugins, addons

JomSocial Plugins (bundle) - JoomPlace Joomla extensions, components, modules, software, plugins, addons

JomSocial Plugins (bundle)

$51.00

JomSocial Plugins (bundle)

- JoomPlace Joomla extensions, components, modules, software, plugins, addons

Professional template - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Professional template

$20.00

Professional template

- JoomPlace Joomla extensions, components, modules, software, plugins, addons

[add-ons and plugins, Belitsoft, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace]

Joomla testimonials component - JoomPlace Joomla extensions, components, modules, software, plugins, addons

 With the component that comes in the package you will be able to add a page with testimonials anywhere on your site with an ability to add a testimonial by users either with auto-approve option or with admin's notifications. You can select whether it will be just registered users who leave the messages on not, and you can always enable captcha to protect yourself from spam.

There is also an ability to manage testimonials from the front-end - if you add users to the component's managers they can edit and approve testimonials from the front-end UI.

The component supports Joomla! 1.6 Advanced Control Levels.

[Belitsoft, component, joomla, joomla 1.5 poll, Joomla components, Joomla extensions, joomla poll, joomla polls, Joomla software, joomla survey, joomla survey component, joomla surveys, JoomPlace, testimonials]

Joomla testimonials component - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Joomla Quiz Deluxe joomla component - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Joomla Quiz Deluxe is a comprehensive and easy-to-use quiz component. It will empower you to author great looking media-rich Joomla quizzes online. Choose from a wide range of questions types, modes and styles and insert videos and audio into questions.

With Joomla Quiz Deluxe tool you can create learning paths and make simple online courses, charge for taking them, give certificates and get rewarding reports. JomSocial plugin is included to show user's progress on the profile!

[Belitsoft, Joomla components, Joomla extensions, joomla quiz, joomla quiz component, joomla quiz module, Joomla software, JoomPlace]

Joomla Quiz Deluxe joomla component - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Swout template - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Swout template

- JoomPlace Joomla extensions, components, modules, software, plugins, addons

[Belitsoft, joomla 1.5 poll, Joomla components, Joomla extensions, joomla poll, joomla polls, Joomla software, joomla survey, joomla survey component, joomla surveys, JoomPlace]

Simple template - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Simple template

$20.00

Simple template

- JoomPlace Joomla extensions, components, modules, software, plugins, addons

[add-ons and plugins, Belitsoft, download, Joomla, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace, software, technology]

Cnation template - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Cnation template

- JoomPlace Joomla extensions, components, modules, software, plugins, addons

[add-ons and plugins, Cnation template, joomla components, Joomla extensions, joomla modules, joomla software, Joomla templates, JoomPlace]

Joomla! Flash Magazine component to make online flipping book or magazine

Quite often a magazine has to be created out of PDF files. The Flash Magazine component doesn't convert PDF to .jpg or any other graphical format, though. Therefore we offer a simple solution to help you insert PDF files into your magazines. For more information, see How to turn your PDF into a Flipping Magazine QUICKLY?.

Among features you will find:

The component comes with two plugins which allow you easy inserting the magazine directly into content pages, or links to magazines as you wish. See more in the PLUGINS tab info.

[flash magazine, joomla 1.5 poll, Joomla components, Joomla extensions, joomla flash magazine component, joomla flipping book component, joomla poll, joomla polls, Joomla software, joomla survey, joomla survey component, joomla surveys, online flipping pages, online magazine]

Joomla! Flash Magazine component to make online flipping book or magazine - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Joomla Comparison Chart - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Compare anything! Use HTML tags to insert pictures, links or any other useful information in your charts! The component uses JavaScript hiding effect which allows to collapse columns and rows (it can be very useful if you have big charts).

You can easily create a new chart, just copying the existing one and making the necessary improvements. You can import a csv file into existing chart. You can enable the 'User ports' feature then users will help you update and add information to your chart (they will be shown once approved by admin).

Make sure your site's URL is equal to mosConfig_live_site i.e.www.site.com will work, but not site.com.Maybe your server has denied the rule to run scripts outside the www root folder.Please make sure all comparison charts files have 644 permissions and folders 755.

[chart, charts, comparison, component, copy, free, html, insert, joomla, joomla 1.5 poll, Joomla components, Joomla extensions, joomla poll, joomla polls, Joomla software, joomla survey, joomla survey component, joomla surveys, show, site, trial, user]

Joomla Comparison Chart - JoomPlace Joomla extensions, components, modules, software, plugins, addons

Survey Force Deluxe joomla survey component - JoomPlace Joomla extensions, components, modules, software, plugins, addons

 Compatible with JomSocial version 1.8 , 2.0 The plugin opens a new opportunity for your JomSocial community when it will now be possible to ask questions anyone about anything you want: the car you want to buy, the opinion on a particular movie, any kind of thing:

Users can create surveys and ask others stupid or philosophical things like 'Which capital should you live in?' to recommendations and opinion questions, like 'What camera should I choose?' People who have social networks accounts should just love the ability to respond and ask such questions:

Survey Force Deluxe is a comprehensive and easy-to-use Survey and Polling Tool. Choose from a wide range of questions types, modes and styles then place the survey/poll online available for any number of users. The component enables you to create surveys , collect data and analyze results online. Make informed business decisions and collect real-time feedback using online surveys. No more mail-out survey campaigns. Survey Force Deluxe makes surveys creation a snap. The component is integrated with JomSocial. So community members can create surveys/polls from the front-end (check more on the plugin's tab). This possibility will engage both community members and informal e-learning students! Front-end authoring is supported!

Survey Force Deluxe joomla survey component - JoomPlace Joomla extensions, components, modules, software, plugins, addons

JomSocial | Open Source Community Software | Social Networking with Joomla

Open Source Community Software | Social Networking with Joomla

JomSocial - Award-winning open-source social networking component for Joomla!
Get a copy of the award winning open source community software by JomSocial. This social networking software is widely used by many Joomla users.

Thursday, October 7, 2010

Spreadsheets Direct | Expert Excel Custom | Business Spreadsheet & VBA Freelance Consultancy Service

Spreadsheets Direct

Spreadsheets Direct is an Excel spreadsheet consultancy business based in the UK trading since July 2007. Spreadsheets Direct can provide quality professional Excel files, improvements to your existing files and data analysis at competitive prices.
Improve your business spreadsheets with the use of VBA and high level Excel techniques. Spreadsheets Direct can save you hours by automating your daily processes. Files can be updated with a simple click of a button saving you time and money.

INVESTMENT-CALC PRO for IRR & NPV Solutions

INVESTMENT-CALC PRO for IRR & NPV Solutions
This complete collection of Investment Return workbooks now comes with free document and spreadsheet connectivity as well. Spreadsheet connectivity will help you share spreadsheets more effectively.
Includes a 30 page Guide fully explaining all the calculations and equations required for time based value of investing. Includes Quick IRR - NPV spreadsheets and Future Values.
Investment Appraisal simulations. This spreadsheet will run 3,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.
The library of investment analysis spreadsheets incorporate present value beyond the cash flow forecasting horizon. With our quick and easy to use spreadsheets terminal values are automatically added to project net worth and included in the real return on capital values.
Quick calculation of your firms cost of capital using beta risk look up values from the database included within the workbook. Your firms or your project cost of capital is the real discount rate to apply to all net present value spreadsheets.
Synergy Value schedule calculates the economic and net present value of the financial benefits of an acquisition or merger.
Insurance buy out schedules value any bond to its terminal value.
This workbook includes lots of Present values calculators, and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, and present value of periodic investments.
Quick NPV and IRR spreadsheets provide present values and IRR of any project for up to 40 years
Plus rate of return of investment portfolios with any buy/sell patterns.
New Excel Finance Spreadsheets for Investment Cash Flow Forecasting – NPV & IRR

Investment-Calc Solutions for IRR & NPV

Investment-Calc Solutions for IRR & NPV
This complete collection of Investment Cash Flow workbooks for NPV & IRR Solutions includes:
30 page Guide fully explaining all the calculations and equations required for time based value of investing. Includes Quick IRR –NPV spreadsheets and Future Values.
Investment Appraisal simulations. This spreadsheet will run 3,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.
The library of investment analysis spreadsheets incorporate present value beyond the cash flow forecasting horizon. With our quick and easy to use spreadsheets terminal values are automatically added to project net worth and included in the real return on capital values.
Quick calculation of your firms cost of capital using beta risk look up values from the database included within the workbook. Your firms or your project cost of capital is the real discount rate to apply to all net present value spreadsheets.
Project cash flows rate of return targeting using Excel Goal Seek. Adjust any individual income/cost/sale/recovery forecast and drive your project to the desired rate of return.
Synergy Value schedule calculates the economic and net present value an acquisition or merger.
Insurance buy out schedules value any bond to its terminal value.
This workbook includes lots of Present values calculators, and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, and present value of periodic investments.
Quick NPV and IRR spreadsheets provide present values and IRR of any project for up to 40 years.
FILE CONVERSION. Convert Excel, Word files to pdf documents without any requirement for Acrobat using our web software add https:// web inks for safe secure document transmissions. Converts PowerPoint 2003-2007 to Flash presentations.
Zip file download or select CD edition shipping. Investment-Calc will run in Excel 2003-2007 and Excel 2008.

Inventory Manager PRO For Excel

Inventory Manager provides manufacturing and operations decision support for inventory management and scheduling with Excel. Maximum 10,000 inventory items capacity.

Determine the best inventory re-order schedules (includes safety stocks), optimize the lowest cost re-order quantities, establish ordering frequencies and lot sizes, receive alerts when you need to re-order, includes seasonality, trends and forecasting, quality control inventory analysis. Improve efficiencies and enhance customer service with INVENTORY MANAGER PRO.
  • You can establish which inventory items should be re-ordered on a daily basis with INVENTORY MANAGER.
  • You can establish least cost ordering quantities with INVENTORY MANAGER taking account of storage costs, administration of purchasing costs and the cost of finance.
  • You can create Excel lists of inventories in categories and storage locations.
  • You can export inventory lists from QuickBooks (and Quattro Pro and barcode readers which interface with Microsoft Excel) to create your own inventory management control system which will include supplier delivery lead time, re-order quantities, safety levels.
  • When you want to evaluate buying inventory in larger quantities to gain volume discounts, use INVENTORY MANAGER to determine the inventory level s for each product item that will deliver profit gains after storage costs are taken into account.
  • Analyze quality control data of incoming stock with INVENTORY MANAGER Statistic spreadsheets.
  • Generate re-order schedules for all stock items.

Worked examples and full guidelines provided in a separate demo tutorial version download.

Seeking help to raise business finance? The CD edition provides the following extra document files:
  • Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital.
  • Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes.
  • Share subscription agreements are supplied.
  • Help provided for non US companies how to structure an offering to secure finance.
  • Popular with start ups, franchises, entrepreneurs and small businesses.
  • List of capital sources supplied.

Cash Forecasting plus Leases Organiser - Cash Forecasting, Credit Controls, Scheduling

Cash Forecasting plus Leases OrganizerExcel Cash forecasting and management spreadsheets provides:
1. Cash Forecasting – 150 days spreadsheet, auto updating forecasts daily.
2. Cash Solvency Predictive Ratios
3. Cash Management spreadsheets
Cash forecasting spreadsheet provides a quick and easy way to transfer payable, receivable and fixed obligations into Excel, set aging days and Excel places each item into the exact day of settlement to forecast rolling cumulative cash flows.
Invaluable as cash forecasting spreadsheets.
Cash Solvency Prediction Spreadsheet. Need to know if your suppliers, customers, applicants for credit are financially strong or weak, use this workbook to analyze their strengths with built in Altman and Ohlsen formulae.
Cash Management. Manage payable, receivable accounts, invoice and settlement dates to calculate your forward working capital requirements.
Extra: Lease Organizer for Excel will manage all your leases for you.

Business Solvency & Financial Ratios 2008

You can run quick and easy checks on the solvency of companies you rely on to deliver services to you and to buy from you using this Business Solvency & Financial Ratios 2008 workbook.

Business Solvency:

The Business Solvency & Financial Ratios 2008 workbook employs all the multivariate analysis equations published by Edward Altman. Altman is the Max L. Heine Professor of Finance at the Stern School of Business, New York University.

In the workbook supplied you can simply enter two comparative sets of financial data for any company (including your own). The Altman Z scores are readily computed using the multivariate formulas provided by Professor Altman.

Bonus Addition:

Financial Ratios with Excel

Windex 2008 calculates all major financial ratios in Excel.

Calculates these financial ratios from balance sheet, income statement and cash flow templates provided:
  • Rate of Return on Assets (ROA)
  • Rate of Return on Common Equity (ROE)
  • Return on Capital (ROIC)
  • Common Earnings Leverage
  • Cash Flow from Operations/Total Cash Flow Ratio
  • Cash Flow from Investments/Total Cash Flow Ratio
  • Cash Flow from Financing/Total Cash Flow Ratio
  • Operating Cash Flow/Current Liabilities Ratio
  • Operating Cash Flow/Total Liabilities
  • Operating Cash Flow/Capital Expenditures
  • Working Capital/Current Liabilities Ratio
  • Working Capital/Long Term Liabilities Ratio
  • Working Capital/Total Debt Ratio
  • Working Capital/Current Assets Ratio
  • Working Capital/Total Assets Ratio
  • Income Tax Expense/Revenues Ratio
  • Total Assets Turnover Ratio
  • Fixed Assets Turnover
  • Current Ratio
  • Acid Test (See note for Quick Ratio)
  • Accounts Payables Turnover
  • Days Accounts Payables outstanding
  • Accounts Receivable Turnover Ratio
  • Days Receivables Outstanding Ratio
  • Inventory Turnover
  • Days Inventory Outstanding
  • Total Debt to Equity Ratio
  • Total Debt Coverage ratio
  • Long Term Debt Ratio
  • Long Term Debt to Total Assets
  • Long Term Debt to Shareholder Equity
  • Total Liabilities/Total Assets
  • Interest Coverage Ratio

Instant Balance Sheets Excel Templates


Instant Balance Sheets provides 12 month revenue and expense forecasts spreadsheet, linked to working capital forecasts, fixed asset purchases with monthly depreciation. Creates monthly balance sheets and cash flow forecasts from your plans.

Ideal for when you want to turn your monthly profit and loss forecasts or last 12 months data into monthly and year end balance sheets and cash flows.

Start by entering monthly inputs of Unit Volumes/Prices/Cost of Sales and Company Expenses (100 rows). There are quick and easy working capital and fixed capital forecast spreadsheets provided.

All monthly balance sheets “balance” by transferring changes occurring between successive monthly periods into the monthly cash flow spreadsheet. The cash flow schedule tracks changes for all twelve monthly balance sheets and calculates the balancing cash position at the end of each month.

If you want to transform 12 month financials (historical or forecast) into neat income schedules and balance sheets to display to management, investors, lenders, banks, use Instant Balance Sheets for really quick results.

Provides a forward looking planning suite which accepts monthly unit volume forecasts, different product prices and cost of sales for the 12 month period and a monthly company expenses forecast. You can predict sales days outstanding, inventory levels and percentage of sales supporting receivables.

Provides a demo version which shows you how everything fits together.

Budgeting Spreadsheets for Excel

A collection of Budgeting Spreadsheets for Excel (workbooks) provides 50 business finance spreadsheets plus 9 Excel Add-ins and full Excel Training Course to help you create, control and value your budgets quickly and easily. The following is a partial summary:

Master Budgets 4.6 helps you combine up to 10 department budgets quickly easily

Everything is so easy with Excel. Excel links combine separate budgets into the Master Budget. You can track your budgets with actual performance. Master Budgets reports monthly variances and year to date totals.

If you need to calculate your cash burn each day for 150 days ahead use the cash forecasting spreadsheet.

If you need to look further ahead use the Cash Flow accounting spreadsheets which make it really quick and simple to prepare a detailed monthly budget plan and forecast how your balance sheets and cash flows will look for 5 years x 12 monthly periods ahead.

You can value your company based on your budget forecasts using the valuation spreadsheet.

The CD edition provides the following extra document files:

Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital. Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes. Share subscription agreements are supplied. Help provided for non US companies how to structure an offering to secure finance. Popular with start ups, franchises, entrepreneurs and small businesses. List of capital sources supplied.

Bank & Loan Refund Software

If you think you have been overcharged for a loan, mortgage, bank account through incorrect repayment amounts or wrong interest rate, unauthorised loan insurance charges, or incorrect penalty charges this dual software package is for you.

With the Bank & Loan Account Refund package you are acquiring 2 programs that will help you challenge lenders calculations, debits from your accounts and possible asset seizures.

The two programs are CheckMyBank 2008 (Excel workbook) and Loan Amortization Manager (web software).

With CheckMy Bank you can quickly verfiy all the calculations which lead to your monthly interest charges. Compare the real ending balance totals with your actual balances and challenge your account deductions if this is justified.

Loan Amortization Manager will store up to 100 current loan account repayment statements for you. You can change any rate or payment within any loan account during its repayment period and check that the current loan balance is correct.

Five Keys To Business Success (Excel Add-Ins)


Excel add-ins provide ready made solution for forecasting, investment economics, portfolio optimization, business resource optimization and material planning.
  • Forecasting.xla. Calculates moving averages, exponential smoothing moving averaging, linear regression and seasonal trend analysis.
  • Investment Economics.xla. Calculates net present values and internal rate of return after tax for any capital investment projects. Selects projects that in aggregate meet users objectives.
  • Portfolio Optimization.xla. Optimises any investment portfolio to meet users objectives. Both business investments and securities investments are catered for.
  • Process.xla. Creates computer models to mirror business flows. Calculates the optimized scheduling of materials and resources which maximise profits. Use Process Flow to work with your line managers on each business step for scheduling the the highest optimization of scarce resources.
  • MRP.xla. Creates dynamic materials requirement planning (MRP) spreadsheets which optimizes the least cost solution for users' manufacturing requirements. Including material purchasing, defines minimum inventory levels, least cost production scheduling.
  • Free Giveaway. Business Statistics for Excel. Instant calculation of Averages, Moving Averages, Mean, Median, Mode, Range, Frequency, Seasonality Trends, Correlation, Variance, Regression formula, Significance (T-Test), Sigma and Six Sigma values, Least Squares, Best Fit Forecasting. Supression of unwanted zeros in data range, set upper and lower boundaries for calculations.

Asset & Lease Accounting With Excel

Fixed Asset Accounting workbook provides all you need to keep track of a maximum 3,000 asset depreciation records, book values and disposals with Excel 97-2003. It will save you hours of work calculating MACRS depreciation for tax purposes and deferred tax balance values for any month end date. It also includes capital lease accounting.

You can select straight line depreciation or the declining/double declining deprecation methods.

You can wind the month end back and forwards to calculate accounting depreciation, MACRS depreciation and deferred tax balances at any month end. The default calculation period is the current month end.

The MACRS depreciation rates are variable. They are set for US tax depreciation rules but you can enter any MACRS rates into the database which will apply to your calculations.

In the first workbook each asset is defined by location, accounting depreciation life, MACRS class and salvage percentage.

Individual assets can have their own unique depreciation life.

Everything is so easy with Excel. Excel links location, asset class, depreciation lives together and you can filter and sort records just anyway you want.

Disposal accounting included.

The Lease accounting section reports repayment status, interest and remaining balances for all capital leases at any month end. Lease terms can include pre-payments and final balloon payments.

The Zip download is a 6.67 MB file. After downloading unzip the three Excel Asset Accounting workbooks including the tutorial edition. The MACRS accounting is provided in a separate workbook (No: 2). CD shipping is also an option.

Financial Statement Forecasting PRO

When you need a quick snap way to create your financial statement forecasts for your senior managers, bank manager or investors, use Financial Statement Forecasting PRO.

Financial Statement Forecasting PRO enables you to set up a 12 month forecast of your financial statements starting at any month of your choice. As well as calculating monthly balance sheets, income statements and cash flows (source and application of funds) the workbook outputs all key operating, financial and shareholder ratios and financing covenant ratios.

Plus the FinExcelSoft 10 year financial statement forecasting workbook.

Quick and simple to use. No accounting knowledge is required.

Financial Ratios with Excel


Windex 2008 calculates all major financial ratios in Excel from balance sheet, income statement and cash flow templates provided:
  • Rate of Return on Assets (ROA)
  • Rate of Return on Common Equity (ROE)
  • Return on Capital (ROIC)
  • Common Earnings Leverage
  • Cash Flow from Operations/Total Cash Flow Ratio
  • Cash Flow from Investments/Total Cash Flow Ratio
  • Cash Flow from Financing/Total Cash Flow Ratio
  • Operating Cash Flow/Current Liabilities Ratio
  • Operating Cash Flow/Total Liabilities
  • Operating Cash Flow/Capital Expenditures
  • Working Capital/Current Liabilities Ratio
  • Working Capital/Long Term Liabilities Ratio
  • Working Capital/Total Debt Ratio
  • Working Capital/Current Assets Ratio
  • Working Capital/Total Assets Ratio
  • Income Tax Expense/Revenues Ratio
  • Total Assets Turnover Ratio
  • Fixed Assets Turnover
  • Current Ratio
  • Acid Test (See note for Quick Ratio)
  • Accounts Payables Turnover
  • Days Accounts Payables outstanding
  • Accounts Receivable Turnover Ratio
  • Days Receivables Outstanding Ratio
  • Inventory Turnover
  • Days Inventory Outstanding
  • Total Debt to Equity Ratio
  • Total Debt Coverage ratio
  • Long Term Debt Ratio
  • Long Term Debt to Total Assets
  • Long Term Debt to Shareholder Equity
  • Total Liabilities/Total Assets
  • Interest Coverage Ratio
  • Altman's Z (Solvency) Ratio.

Excel Add-ins & Training Bible Complete Collection


Nine Excel add-ins plus the Complete Excel Training Bible modules 101-701.

Plus Free Workbook Bonus - Learn how to develop your own Excel Currency Converter with this extra free workbook.

Convert any of your financial records or lists into any one of 81 cross currency exchange rates updated via the Excel import function – In today’s environment of volatile exchange rates, instant recalculation into your home currency from different currencies is an essential tool.

Free workbook with the Combined Collection.

FASTPLAN Version 9.6

FastPlan version 9.6 provides a complete five year financial plan incorporating monthly fixed asset schedules with depreciation spreadsheets, 60 x monthly sales forecasts for multi products, forecast expenses, share capital inputs, three loan notes providing monthly interest charges and declining loan balances, plus working capital forecasts to generate five annual and monthly balance sheets, income statements and cash flow forecasts with supporting financial ratios and five years financial summary overview. With FastPlan you can quickly and easily change any variable input and drive the financial statements and cash flows to your target goals. No accounting knowledge is required.

Plus three separate and additional workbooks.
  • Twelve months income statements, balance sheets and cash flows forecasting spreadsheet to develop high - low forecast scenarios to analyse your sales, profits, accounts receivable, accounts payable and total cash flows for each year for all possible outcomes.
  • Sales and Profits Risk Forecasting using Monte Carlo formulas.
  • Forecasting Risk analysis (probability of reaching goals) using Monte Carlo formulas.
FastPlan and the three additional bonus workbooks all run in Excel 2003-2007.

Wednesday, October 6, 2010

Excel Skills Pack - COMPLETE MICROSOFT EXCEL CORE KNOWLEDGE PACK


Core fundamentals 1. Keyboard functions, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function.

Core fundamentals 2. Improved working with Formulas, Worksheet Formulas, Extracting Data for Decision Making, Data Validation, Importing external data. Core fundamentals of Advanced Filters, AutoFilters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining.

Core fundamentals 3. Learn Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files, Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the Web, Macros 1, Macros 2.

Plus Core Knowledge chapters 4, 5, 6 and 7 VBA and Macro developments.

Special Bonus: Excel Add-Ins improve your spreadsheets presentations and reduce your spreadsheet working hours.
  • Duplication Manager
  • Formula Manager
  • Number Manager
  • Text Manager
  • Excel Plus
  • Named Range Manager
  • Formula Reference Changer
  • Sheet Index Creator
  • File Size Reducer Download or CD shipping.

Excel Costing 2010

Excel Costing 2010 provides new and free document and connectivity software for Excel spreadsheets : Spreadsheet connectivity will help you share financial more effectively.

The standard costing workbooks include:
  • Standard costs, activity based costs, overhead cost recovery ratios, cost drivers, absorption costs and cost allocation ratios in Excel.
  • Complete range of product costing formula with eight ready to use costing templates iin the first workbook with Excel costing formula provide unit costs for pricing and profit recovery calculations.
  • Excel database supplies accurate costs into costing formula.
  • Benchmark costing ratios.
  • A – Z spreadsheets for Marginal costing - Standard costing – Activity based costing – Cost drivers – Absorption Costing values and Most economic quantity.
  • Formula and equations each step of the way.
  • Incorporate risk analysis of reaching your gross profit margin goals when customer spending patterns change and these changes impact your unit costs. Runs Monte Carlo simulations of the most probable outcomes and returns the probability of achieving whatever target is set.

FastPlan 2010 Five Year Company Forecasting

FastPlan version 9.6 provides a complete five year financial plan incorporating monthly fixed asset schedules with depreciation spreadsheets, 60 x monthly sales forecasts for multi products, forecast expenses, share capital inputs, three loan notes providing monthly interest charges and declining loan balances, plus working capital forecasts to generate five annual and monthly balance sheets, income statements and cash flow forecasts plus all core ratios and five years financial summary overview.

With FastPlan you can quickly and easily change any variable input and drive the financial statements and cash flows to your target goals.

No accounting knowledge is required.

Plus three separate and additional workbooks.
  1. Twelve months income statements, balance sheets and cash flows forecasting spreadsheet to develop high - low forecast scenarios to analyse your sales, profits, accounts receivable, accounts payable and total cash flows for each year for all possible outcomes.
  2. Sales and Profits Risk Forecasting using Monte Carlo formulas.
  3. Forecasting Risk analysis (probability of reaching goals) using Monte Carlo formulas.
FastPlan and the three additional bonus workbooks all run in Excel 2003-2007.

Excel Add-Ins File Collection

With this powerful Excel Add-Ins File Collection for Microsoft Excel you enhance your Excel with extra capabilities that are well beyond standard Microsoft Excel features:
  • Add page indexes to link all spreadsheets together.
  • Add Reminder notes. Like those little yellow pads, bring reminders messages into your Excel at preset times and dates.
  • Add formulas list with links to each formula cell.
  • Manage cell ranges with more options than provided by Microsoft.
  • Convert imported numbers to true Excel formats.
  • Hide zeros, Hide text, hide numbers, hide negatives, hide positives with one click.
  • Create one year Excel 365 days calendars.
  • Manage List duplicates, number formats and equations much more efficiently and make Excel work faster for you.
  • Convert vertical number sequences into horizontal rows with one click.
  • Copy data to a different part of your spreadsheets keeping the orginal cell references. the same
  • File size reduction to save disk space.

Excel Scheduler

Project Management, Gantt Charting, and Employee Scheduling - For all versions of Microsoft Excel. To run Excel Scheduler, simply run Excel and read in template(s) of choice.

Project Management:
  • CPMDAILY.XLS
  • CPMHOUR.XLS
  • CPMWEEK.XLS
Gantt Charting
  • GANTDAY.XLS
  • GANTHOUR.XLS
  • GANTWEEK.XLS
Employee Scheduling
  • DAYSOFF.XLS

Operations Manager

Operations Manager contains 35 templates for manufacturing and operations decision support. All templates have a simple, consistent interface and include an actual application. Runs with Excel, Lotus & Quattro Pro.

Benefits include:
  • adjust for seasonality and predict trends,
  • optimize economic order quantity,
  • determine best inventory (includes reorder points & safety stocks) and workforce levels,
  • improve production throughput and enhance customer service.

Resource Manager for Excel/FULL

Resource Manager for Excel/FULL contains the functionality of high-end systems, without the complexity and expense. An add-on for existing systems, or stand-alone, Resource Manager adapts to your specific needs.

Key features include:
  • Easily integrates with all systems
  • General purpose resource management tool for projects that contain any combination of people, materials, and equipment
  • Dynamic finite capacity analysis
  • A great stand alone scheduler
  • Priority Scheduling
  • Costing & estimating
  • True Windows GUI
  • Inventory Management & MRP
  • Excel Integration
  • Planning
  • Rough-cut capacity planning
  • Bills-Of-Material/Resources containing material, workcenters, & labor requirements.

Spreadsheet QC

Spreadsheet QC is a collection of templates for use with Excel, Lotus & Quattro Pro. It is ideally suited for small operations which are just beginning to implement quality improvement programs, as well as for large operations, to complement existing Total Quality Management systems, for flexible, ad-hoc reporting and individual training. By automating the main techniques in a familiar spreadsheet format, Spreadsheet QC makes statistical process and quality control more accessible.

Spreadsheet Scheduler by User Solutions, Inc.


Low cost and easy-to-use spreadsheet templates for Project Management, Scheduling Customer Jobs and Employees, Generating Calendars and Gantt Charts.

The Spreadsheet Scheduler is a toolkit containing 14 ready-to-use, practical models for a variety of common scheduling problems. The models are spreadsheet templates that work with all popular spreadsheets. The 14 spreadsheet-based programs provide an easy-to-use set of tools to help any organization manage projects more efficiently, improve customer deliveries, and minimize work-in-process times.

Excel ActiveX

Excel ActiveX acts as an ActiveX document container for hosting Excel document in a custom form or Web page. Support Excel automation client and offer abundant sample codes.

Excel ActiveX can be easily integrated into applications written in languages that support ActiveX control such as Visual C++, Visual Basic, Delphi, C++ Builder and .Net languages.

ZRandom for Excel

ZRandom implements high quality random number generation for Microsoft Excel using the Merssenne Twister algorithm :
  • Use higher quality pseudo-random numbers than the Excel RAND() and VBA Rnd() functions.
  • Generate random numbers from 16 discrete and continuous distributions.
ZRandom implements the following discrete distributions: Uniform, Bernoulli, Geometric, Hypergeometric, Negative Binomial and Poisson.

ZRandom implements the following continuous distributions: Beta, Burr, Exponential, Gamma, Lognormal, Normal, Pareto, Triangular, Uniform and Weibull.
  • Create large batches of random numbers using the interactive user interface.
  • Excel functions for use in spreadsheet formulas.
  • Random Sort and Random Sample
  • Interactive distribution wizard
  • A VBA interface to generate random numbers in your code.

Excel Workbook Splitter

Excel Workbook Splitter is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. This excel tool changes the complicated, duplicate and boring excel works into easy ones. Especially it's used for financial affairs, legal affairs and so on. Excel Workbook Splitter supports Microsoft Excel only and Windows 2000/XP operating system.

With Excel itself, the operation requires opening each workbook, selecting entire sheet, creating a new workbook, pasting the sheet, saving... But with Excel Workbook Splitter, you just load any number of workbooks (or even some folders) into the program and see the list of all worksheets from all workbooks at once.

Budget Forecaster & Expense Tracker Combo Package

Budget Forecaster for Excel® is a household budgeting and finance management software was designed for Microsoft Excel® lovers who prefer using Excel-based household budgeting software to a stand-alone application to manage their family finances.

These users tend to enjoy the convenience of managing their household finances with the help of this VBA Excel tool without having to learn a new household finance management software application
  • Track where your money goes See where your money goes by tracking your daily expenses by type.
  • Get a clear picture of where your money is going by week or by month.
  • Track your income, investments and expenses for the selected time period, and analyze your income allocation and expenses distribution with efficient Budget Forecaster software tools - all in one place.
  • View colorful detailed charts & graphs.
  • View colorful, detailed charts and graphs and see visually by category where your money goes. If you prefer to see where your expenses go in a colorful easy to read pie chart, you will enjoy this feature.

Saturday, October 3, 2009

Complete Excel Templates Financial Management 2009

This Complete Excel Templates Financial Management 2009 Collection provides 180 business finance spreadsheets, Excel add–ins and Risk Analysis spreadsheets which will help you manage financial assets, analyse investments, control cash flows, set up budgets and model financial statements and forecasts quickly and effectively.

The 2009 Collection includes Cash Flow workbooks as follows:
  • Investment-Calc 2008 spreadsheets analyses Present values and internal rates of return 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, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values. Includes a 30 page Guide to Investment Rate of Return Calculations with formulas including worked examples.
  • Master Budgeting for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis. 12 months departmental budgets consolidated.
  • The Fixed Asset Accounting workbook provides all you need to keep track of and forecast depreciation for a maximum 3,000 assets. Use Excel 97-2003, 2007 & 2008 to work with depreciation records, book values and disposals. It will save you many hours of work with MACRS tax depreciation and deferred tax balances. Recalculate or model asset balances at any month end date.
  • Instant Balance Sheets.
  • Excel Costing templates provide standard costing models. Now includes Profit Margin risk analysis 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 ratios, including operating ratios, shareholder returns, working capital, debt, sales days, inventory turnover, and liquidity.
  • FastPlan 9.16 for five year financial plans. Develop your 5 year financial forecast and transfom these into simulated balance sheets, income forecasts and cash flows...
You can download (or order the CD version) all these financial workbooks as well within this collection : Financial Plan for Bankers & Investors – Risk Forecasting – Capital Project Justification - Future Values – Merger & Acquisition Synergy Values – Company Valuation - Rate of Return Solutions – Multi Variable Investment Forecasting – Net Return on capital After Cost of Capital Calculations – Present Value of Capital Investment - …and more

FES emailer

FES emailer - POP3 emailer with anti-SPAM, mass email, re-sender, and encryption tools.

Allows to send selected emails to another e-mail box, to encrypt all saved input and output e-mails with several user defined 2048 bit keys, to load 20, 200, 1000, or all rows of an email from POP3 server, to send personified email to many recipients, to remove e-mails without downloading, to archive old e-mails, to find an email in input, output and archive folders. and more.

And free addition: safe web viewer using default web browser and saver. This program can remove all active content from a web page - images, scripts, applets, objects, styles, and more before viewing. You will receive the register key within 1 day.

CreateCallBack (CreatefunctionCallBack)

You must create your callback windows functions for C (c++, c#) manually. Why? CreateCallBack will generate it automatically with adding all identifiers of this dialog using your resource.rc file!
  • You will need just add your code for your events.
  • Allows to save your time and to work with the comfort.
  • Create the dialog windows fast and easy! All you need is MS Word.
  • Run MS Word and open resource.rc file.
  • Then open callback.doc file and copy the text of your resource file to this document.
  • Then click on the "CreateCallBack" button.
  • Alternatively you can run "CreateCallBack" macro.
  • Then enter the dialog name in dialog window and the work is done! Just paste your callback function to your Visual C project.

FinExcelSoft Securities Excel Templates

FinExcelSoft Securities Excel templates - Contains 26 securities Excel templates:
  • templates for coupons (6 templates),
  • templates for price calculation (6 templates),
  • templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.
Free bonus:

10 Annuities Excel templates ann.xls contains Excel templates for: price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.

FinExcelSoft Safe Office

FinExcelSoft Safe Office - A set of financial, statistic Excel templates and software.

Contains:

  1. 5, 10 and 15 Year Project Investment NPV and EVA Excel templates
    Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.

  2. Financial Excel templates - business valuation, forecast, securities, amortization, loans, annuities, investment.
  3. Statistic Excel templates - regression and correlation analysis, partial correlation.
  4. FES emailer - safe POP3 email client with many features including: SPAM blocker, resender from one email account to another one, safe saving of emails - with 2048 bit encoding, multiple passwords, and much more. Allows to remove emails without downloading them.
  5. FES Notes - text editor with 2048 bit encoding, multiple passwords. Allows to safely save financial documents, passwords and so on.
  6. FES alarm - allows to set a month, day, year, hours, and minutes and track the time.
  7. Safe Web Browser - allows to download web pages, remove any dangerous
    content (scripts and more) from them, save them and pass them to default web browser.
  8. Alarm-Clock.
  9. Allows to encode the files with 2048 bit key.
  10. Accounting Excel add-in - accounting with hierarhic data. You may define several levels of hierarchy in your Excel list.
For example: assemblies, units, packs, details, subdetails, and so on. This add-in contains about 250 VBA macros.
Allows to set hierarchic and other dependencies between columns of your list(s).
And when you enter your data, this add-in will track these dependencies and offer you to correct your data.
Use this add-in for your data entry and save your accounting time!
Also, allows easy pivot table and subtotals creation, has a timer and more. This add-in is supplied by your inquiry within 1 day.

Special requirements: MS Excel 2000 or later. Platform: Windows 98 or later.

FinExcelSoft NPV & IRR Excel Templates

FinExcelSoft NPV & IRR Excel templates -

Ready to use 5 Excel templates for NPV/EVA and IRR/MIRR calculation and more.

1. 5, 10 and 15 Year Project NPV and EVA Calculation.

NPV and EVA Excel templates for 2 to 15 period projects.

Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.

2. NPV & IRR Excel template for periodic cash flows

3. NPV & IRR Excel Template for a schedule that is not necessarily periodic.

4. MIRR Excel template.

5. Additional Financial Excel Templates. Requires Excel 97 or later.

Additional templates allow:
  • effective annual interest rate,
  • annual nominal interest rate,
  • price per $100 face value of security that pays periodic interest,
  • yield on a security that pays periodic interest,
  • number of periods for an investment based on an interest rate and a constant payment schedule,
  • future value of an investment based on an interest rate and a constant payment schedule,
  • present value of an investment based on an interest rate and a constant payment schedule,
  • payment amount for a loan based on an interest rate and a constant payment schedule.

FinExcelSoft FinStat Excel Templates

FinExcelSoft FinStat Excel Templates -

5, 10 and 15 Year Project NPV and EVA Calculation.

NPV and EVA Excel templates for 2 to 15 period projects.

Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.

Plus 137 Excel templates for almost any financial & statistic calculations:
NPV, IRR, MIRR, amortization templates, securities templates, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule, and more. Also contains all statistic functions.

finExcelSoft.xls workbook contains also the spreadsheet for easy function navigation in all workbooks.

Use of some complex financial functions are simplified by VBA procedures.
Benefit:

with these Excel templates you can now do financial & statistic calculations more easily. For example, you enter your source data and the work is done! Now you can see, for example, NPV and IRR results. To receive a correlation matrix you just click one button. Moreover,
you will receive the partial correlation matrix too.

Please note also that some complex Excel functions are simplified by VBA code.

Please note also that Excel contains hundreds functions and you may have problems with a search of the function you need for your given task.

The finexcelsoft.xls workbook contains the links to all financial and statistic functions. And these links to financial functions are grouped in 6 groups (investment interest, annuities, securities, rates, amortization, date functions), the statistic functions are grouped in 14 groups.

Now you can review only functions in one group rather all list! Moreover, finexcelsoft.xls contains additional grouping of financial functions: interest rate, income, payment, price, number of periods.

To open the template you simply double click its name, and the work in done!

Therefore, Excel templates may be very useful as for professionals, as for students!

This unique collection of Excel templates (supplied in conjunction with examples and full instructions) allows you easily learn all financial and statistic Excel functions and easily use them for your needs.

FinExcelSoft Correlation and Regression Templates

FinExcelSoft Correlation & Regression Excel Templates -

Allows to calculate correlation matrix and partial correlation matrix, linear, exponential, polynomial regression analysis.

Additionally, contains 26 securities Excel templates:
  • templates for coupons (6 templates),
  • templates for price calculation (6 templates),
  • templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.
  • Full instructions.

NPV & IRR Excel Template for Periodic Cash Flows

NPV & IRR Excel Template for Periodic Cash Flows - Ready to use Excel Template for NPV & IRR & EVA calculations for periodic cash flows in Excel 97 or later.

Allows you to evaluate your business. The net present value of an investment is the current value of a future series of payments and receipts. The internal rate of return is the interest rate received for an investment consisting of payments and receipts that occur at regular intervals.

Here is the short description of NVP/IRR calculation.

You define a cash flow in Excel list, enter a rate of interest for NPV calculation, initial rate of interest for IRR calculation, and click on a button. NPV & IRR are calculated automatically and stored in special cells of this template.

Also contains the bonus:
- evacalc.xls - 5, 10 and 15 Year Project NPV and EVA Calculation. NPV and EVA Excel templates for 2 to 15 period projects. Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.
- MIRR.xls - MIRR (Modified Rate of Return) calculation
- Npvirrdate.xls - NPV & IRR calculations for non-periodic cash flows.
- finExcelSoft.xls - contains Excel templates for the following more usefull financial functions:

NPV, IRR, MIRR, future value of initial principal, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.

My Diigo

Twitter Updates

    follow me on Twitter