Saturday, May 15, 2010

Business Dashboard XLS

Dashboard is a term now being used generally to refer to a web-based technology page on which real time information is collated from various sources in the business. The metaphor of dashboard is adopted here to emphasize the nature of the data being displayed on the page, it is a real-time analysis as to how a business is operating, just like on an automobile dashboard real time information is displayed about the performance of that vehicle.

Rapidly rising in popularity as the new "face" of business intelligence is the enterprise dashboard due to the user-centric nature of its visually-based approach.
In many of the earlier "dashboard" applications the emphasis of creating a dashboard was the integration of information as in this Microsoft white paper.

A digital dashboard is a customized solution for knowledge workers that consolidates personal, team, corporate, and external information and provides single-click access to analytical and collaborative tools. It brings an integrated view of a company's knowledge sources to an individual's desktop, enabling better decision making by providing immediate access to key business information.

Business Dashboard Excel sheets can be downloaded from


Mutual Fund XLS

A mutual fund is a professionally managed type of collective investment scheme that pools money from many investors and invests typically in investment securities (stocks, bonds, short-term money market instruments, other mutual funds, other securities, and/or commodities such as precious metals).[1] The mutual fund will have a fund manager that trades (buys and sells) the fund's investments in accordance with the fund's investment objective. In the U.S., a fund registered with the Securities and Exchange Commission (SEC) under both SEC and Internal Revenue Service (IRS) rules must distribute nearly all of its net income and net realized gains from the sale of securities (if any) to its investors at least annually. Most funds are overseen by a board of directors or trustees (if the U.S. fund is organized as a trust as they commonly are) which is charged with ensuring the fund is managed appropriately by its investment adviser and other service organizations and vendors, all in the best interests of the fund's investors.

Mutual Fund Excel sheets can be downloaded from


Vanguard Mid-Cap Index Fund XLS

Vanguard is a United States investment management company that manages approximately $1 trillion in assets, based in Malvern, Pennsylvania. It offers mutual funds and other financial products and services to individual and institutional investors in the United States and abroad. Founder and former chairman John C. Bogle is credited with the creation of the first index fundavailable to individual investors, the popularization of index funds generally, and driving costs down across the mutual fund industry.

Vanguard Mid-Cap Index Fund Excel sheets can be downloaded from



Stock Market XLS

A stock market or equity market is a public market (a loose network of economic transactions not a physical facility or discrete entity) for the trading of company stock and derivatives at an agreed price; these are securities listed on a stock exchange as well as those only traded privately.

The size of the world stock market was estimated at about $36.6 trillion US at the beginning of October 2008.The total world derivatives market has been estimated at about $791 trillion face or nominal value,11 times the size of the entire world economy.The value of the derivatives market, because it is stated in terms of notional values, cannot be directly compared to a stock or a fixed income security, which traditionally refers to an actual value. Moreover, the vast majority of derivatives 'cancel' each other out (i.e., a derivative 'bet' on an event occurring is offset by a comparable derivative 'bet' on the event not occurring.). Many such relatively illiquid securities are valued as marked to model, rather than an actual market price.

Stock Market Excel sheets can be downloaded from


Sample Income Statement XLS

Income statement, also referred as profit and loss statement (P&L), earnings statement, operating statement or statement of operations,[1] is a company's financial statement that indicates how the revenue (money received from the sale of products and services before expenses are taken out, also known as the "top line") is transformed into the net income (the result after all revenues and expenses have been accounted for, also known as the "bottom line"). It displays the revenues recognized for a specific period, and the cost and expenses charged against these revenues, including write-offs (e.g., depreciation and amortization of various assets) and taxes.[1] The purpose of the income statement is to show managers and investors whether the company made or lost money during the period being reported.

Sample Income Statement Excel sheets can be downloaded from


Scripps clinic torrey pines XLS

The Scripps Research Institute (TSRI) is a medical research facility that focuses on research in the basic biomedical sciences. Primarily located in La Jolla, California, with a sister facility in Jupiter, Florida, the institute is home to 3,000 scientists, technicians, graduate students, and administrative and other staff, making it among the largest private, non-profit biomedical research organizations in the world.

Scripps clinic torrey pines Excel sheets can be downloaded from


MSCI index XLS

The MSCI World is a stock market index of 1500 'world' stocks. It is maintained by MSCI Inc., formerly Morgan Stanley Capital International, and is often used as a common benchmark for 'world' or 'global' stock funds.
The index includes a collection of stocks of all the developed markets in the world, as defined by MSCI. The index includes securities from 23 countries but excludes stocks from emerging economies making it less worldwide than the name suggests. A related index, the MSCI All Country World Index (ACWI), incorporated both developed and emerging countries.
The MSCI World Index has been calculated since 1969 in various forms: without dividends (Price Index), with net or with gross dividends reinvested (Net and Gross Index), in both US dollars and local currencies.

MSCI index XLS can be downloaded from