Business Finance

Lease/Loan Organizer 2006 for Excel.
Time saving Excel add-in organizes up to 100 lease/loan accounts into combined month end reports.
Calculates and combines current period payments of principal and interest, provides outstanding balances, months remaining, payments remaining and asset book values (S/L or DDB depreciation).
Starting information includes the loan/lease principal, interest rate, repayment months, salvage percent and depreciation years.
Program calculates the monthly repayment, and at each month end the periodic repayment of principal, interest charges, balance c/f and book value c/f.
<Consolidates all leases/loans into one overall month end summary report.
Organizes multiple accounts using Excel tables that provides quick and easy look up/drill down any lease/loan account and report current balances. Transforms all accounts into yearly principal and interest payments schedules based on daily interest to a maximum 20 year repayment period.
Includes lease or loan repayment amortization schedules that accrues interest on the daily balance method for a maximum of up to 7,755 days ?– over 21 years, with daily accruals of interest/360 days/365 days/366 days.
Each account is created by entering the draw down date, repayment months, principal amount, annual interest rate, depreciation years and residual asset salvage value percent. The program creates the year by year repayment of principal and interest expense schedule for each account whether created in the past or anticipated in the future.
The download zip file contains a demo/tutorial with easy instructions.

buy now

-----------------------------------------------

Job Timer

This is a Project or Job Timer that will keep track of your time spent on a job, plus it will calculate the hourly rate on which you charge, It has it's own built in Invoice which you can print and it stores your customers information to be recalled later for future projects. Save as you go and recall each job as you go. One click start, or One click and it opens up your favorite application while starting the clock automatically.

buy now

INSTANT BALANCE SHEETS FOR EXCEL
Instant Balance Sheets provides 12 monthly linked balance sheet templates which always balance. You can quickly and easily create 12 month profit & loss schedules and cash flows (source and application of funds) which automates all the figures in your 12 monthly balance sheets.
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 templates provided.
The balance sheet templates balance by transferring changes that occur between successive monthly periods into the monthly cash flow schedule. The cash flow schedule tracks changes that take place within all twelve balance sheets and this 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.
Instant Balance Sheets are delivered with separate Excel files A & B, plus a tutorial version. You can choose which application best suites your purposes (or both).
Version A 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.
Version B provides an historical suite that converts unit sales, revenues and company expense data into monthly balance sheets and income schedules. The program calculates average price yield per product, average cost of sale, and monthly break even volumes. You can enter actual sales days outstanding, inventory levels and percentage of sales supporting receivables.
CURRENCY > You can set the currency to any symbol by opening the Format menu in Excel and selecting Cells from the drop down list, which produces the Format Cells table. Click Currency and then choose the currency you want to work with from the Symbol panel.
The delivered file is zipped. There are three separate excel files enclosed.

buy now

Pricing and Breakeven Analysis Excel will determine the impact of a price change on your business. It calculates current breakeven points using revenue, variable cost, and fixed cost inputs. These are combined with estimates for price and sales volume variations to produce revenue and surplus (profit/loss) forecasts by price. The model determines the Optimum Pricing to maximize your surplus and can be applied to new or established businesses, product/service lines, or individual items. It is compact, easy to use, and requires minimal inputs. Outputs include Breakeven Charts for Current, Increased, Decreased, and Optimum pricing. Analysis determines the Optimum Price to maximize your business surplus, and the Revenue, Surplus, and Number of Sales are calculated for prices ranging from -50% to +50% of the current price.
Quantity: The Number of Licenses you purchase is the maximum Number of Users and the maximum Number of Computer Systems the purchased software can be installed on or that can access the software if on a network.
License Type: Non-Commercial Licenses are for private and internal business use only. They do not cover the commercial use of software for inter-business support, advice, or consulting. Commercial Licenses allow you to use your software for inter-business support, advice, or consulting. This license type is generally suitable for Accountants, Consultants, Valuers, Realtors and other professionals providing a service to their clients.
Software is in Microsoft Excel format and Excel is required for use.
All software is offered with a 30 day money back guarantee.

buy now

Budget Compiler QuickBooks Excel

The Budget Compiler will apply and format your Profit and Loss data from QuickBooks. Using this information it will compile a flexible Excel Profit and Loss report allowing you to select the amount of detail displayed and use the data for performance review and budget formulation. The created budget can be imported to the Quickbooks budget or used as a standalone tool.
Applying your existing data in a flexible and easy to read layout with the capacity to automate budget creation provides substantial benefits. These include an improved understanding of business operations, enhanced budget development, and significant time saving in performance reviews and budget creation. Display view options include by Month, Quarter, and Full Year with Current Year, Last Year, and Budget values. Charts display both Actual and Budget values.
Quantity: The Number of Licenses you purchase is the maximum Number of Users and the maximum Number of Computer Systems the purchased software can be installed on or that can access the software if on a network.
License Type: Non-Commercial Licenses are for private and internal business use only. They do not cover the commercial use of software for inter-business support, advice, or consulting. Commercial Licenses allow you to use your software for inter-business support, advice, or consulting. This license type is generally suitable for Accountants, Consultants, Valuers, Realtors and other professionals providing a service to their clients.
Software is in Microsoft Excel format and Excel is required for use.
All software is offered with a 30 day money back guarantee.

buy now

Universal Pricing Calculations for Excel.
The Universal Pricing Excel Spreadsheets calculate price - demand relationships and uses standard accounting formula to give you the exact price which will produce the maximum profit for any product.
The user supplies two datasets, demand1@price1 and demand2@price2.
The program calculates elasticity of demand (change in demand for $1 change in price) and the price which yields the maximum profit.
The second part of the program calculates discount price required to create additonal demand that will sell unused spare capacity or stock at maximum profit.
The third part of the program supplies a costing calculator for Excel. Input these unit cost values in the pricing calculators.
Excel finds the exact Price which maximizes this standard profit formula:
Profit for period = Demand*Price (Revenues) - Demand*Unit Costs = Maximum value.
An easy way to understand the relationship of price - demand - profit for any product is to use the program to drive the Price - Demand - Profit schedule and charts provided. You will see that as prices start to rise in the chart, profits increase, reaching a maximum plateau, then decline as demand falls away. The program calculates the maximum price point of any product curve that produces the maximum profit
The Excel costing calculator works out unit product costs for the optimum pricing - profit calculations.
After purchase customers can submit a free web advertisement for inclusion in our financial web site which will reach all our customers. If you want to make new contacts internationally, this is a way forward. When you receive your email order confirmation, contact us with your order number and we will supply you with your login passwords to the free submit page.

buy now

QUICK FIVE AND TEN YEAR FINANCIAL PLAN TEMPLATES FOR EXCEL
With FastPlan 9.0 (Five Year Planner) you create a complete set of budgets, profit & loss forecasts, balance sheets and cash flows on a monthly basis for five years.
The 1-5 years budget templates help you develop your forecasts on a monthly basis over any 60 month period. You can vary unit volumes for each separate product, unit prices, unit cost of sales and company expenses.
The Budget forecasts that you create automatically generates 60 monthly profit and loss forecasts, balance sheets and cash flows, plus closing cash balances each month.
You can easily vary unit volume forecasts, prices and cost of sales and FastPlan instantly recalculates monthly and profit & loss forecasts, balance sheets, month end closing cash balances.
Plus all the key operating ratios.
The Management Summary spreadsheet consolidates the entire five year plan into one spreadsheet so that you can see at a glance as a presentation all the forecast financial details and year end balances.
No accounting knowledge is required.
FREE GIVEAWAY
Ten year financial plan - quick preparation.
The extra ten year financial plan provides you with templates to enter (and vary) all yearly forecasting assumptions (prices, cost of sales, asset purchases, working capital, loans).
The budget planner spreadsheet helps you create a detailed ten year unit volumes, sales and expenses forecast.
The Summary page consolidates the ten year plan into Unit sales, Revenues, Cost of sales, Company expenses, EBITDA, Pre and post tax income, operating cash flows and closing cash balances.
If you need to incorporate loans into your plan, FastPlan (10 years) calculates all repayments and yearly closing balances and inserts these plus interest charges into the plan forecast.
The download file contains the five years and ten years plans plus demo tutorials for both.

buy now

Budget Presentations with Charts for Excel 2007.
Excel 2007 charts have a really great new look?…their board room quality
enables your budget presentations to be really sharp. Use the power of Excel 2007 with our Budget Presentation spreadsheets to develop some really great budgets.
Budget Presentation Spreadsheets guides you through developing a comprehensive 12 month business budget in Excel 2007. It provides you with a quick way to produce a smart looking presentation of forecast monthly sales, orders, expense, income and cash flow with accompanying charts.
Enter unit forecasts and delivery forecasts into the Orders & Sales forecast template.
Calculates monthly back order forecast schedule.
Enter product prices, direct cost of sales and variable costs to create your profit margin forecasts for each product (or for each customer, project, process, or transaction...a unit can be any revenue generating activity).
Adjust the percentage changes in volume units when you want to modify your original forecast for changes in demand. This creates adjusted revenue forecasts for each product and an alternative budget forecasts at a different demand level.
Add semi variable costs into each product costing with the Semi Variable expenses template.
Monthly receivable and payable forecast are exported into the monthly cash flow budget. Enter your fixed expense budget, taxes, insurances, rent, capital expenditures and monthly loan repayments.
You can now output your complete 12 months budget and produce some stunning charts, in any style or format, and with any combination of budget data that you want.
The download file is zipped. It contains a tutorial workbook containing an imaginary company budget to show you where everything fits.
You can change the layout and format of any of the budget templates and create a budget presentation which suits your requirements exactly.
The download file iz zipped. In addition the user file you will find a tutorial demo presentation containing an imaginary company budget, plus sample Excel 2007 charts.

buy now

User-friendly accounting program for small businesses and private users. The program is multi-system (British/American and European), multi-currency, and multilingual with English, German, French, Spanish, Italian, Danish, Swedish and Dutch. Numerous options (such as automatic tax transactions, recurring transactions, cost centers, foreign currencies, etc., allow that the programs functionality can be adapted to practically any accounting needs anywhere in the world.

buy now

Profit Loss Report Spreadsheet

Looking for a better way to keep track of your small business expenses? Are you sending too much of your hard-earned money to the IRS each year because you are not taking all of your qualified deductions? This award-winning Excel spreadsheet, created by a DynoTech executive, is a simple alternative to accounting software for a home business to track expenses. Make it easier for you or your tax preparer to fill out Schedule C when tax time rolls around. For Home Business, Small Business, Self Employed. If you've outgrown the shoebox organization method, but aren't quite ready for full-blown accounting software, this spreadsheet is for you! Designed to save you time and money. And, YES, it may even help prevent those Tax Time Headaches. 1. Enter data. No complicated setup to customize your report. Be ready in a few minutes. 2. Enter expenses. Easily organize expenses for business management and tax preparation.3. Enter income. Save time. Only one entry per month. All other data automatically calculated for you. Quick and Easy Navigation. Select main report, data entry page or specific month buy clicking on a tab. No complicated navigation required. Everything is quick and easy. NOTE. Requires MS Excel.

buy now

QuikCalc Amortization Premium Edition

Mortgage and loan software includes the powerful Amortization Schedules Plus! feature that allows you to override, skip or add any number of payments. The Loan Management feature allows you to track actual loan terms and varying interest rates, as well as your actual payments made and projected payments. The Loan Manager also allows you to assess late fees and charges and track insurance, taxes, etc. Includes 14 different Day Count Conventions including 30/360 and Actual/Actual, plus many different Payment Types including Normal, Continually Adjusting Payments, Fixed Principal plus Interest and Interest Only. Also includes dozens of powerful calculators as well as many reports including annual summaries and a Solve for Missing Number Calculator. Data file backup, integrated calculator. Also available in three additional versions, QuikCalc Home Edition that includes only the Solver and Amortization Schedules, QuikCalc Plus! Edition that includes everything the Premium Edition has except it is limited to only tracking 5 loans with the Loan Manager and QuikCalc Office Edition that allows any number of users, a client manager and advanced reporting capabilities.

buy now