Excel Financial Ratios

Fitch Releases Annual Public Power Peer Study

NEW YORK -- In its annual U.S. Public Power Peer Study, Fitch Ratings says debt service coverage remained stable overall as improved electric sales and selective rate increases offset slightly higher debt service costs. The report highlights the fiscal 2010 financial performance of Fitch-rated wholesale and retail public power systems, as well as rural electric cooperatives.

According to the study, cash on hand decreased slightly for U.S. public power issuers as funds were used to finance capital plans, and extremely low interest earnings discouraged high short-term balances. While capital expenditures declined slightly, capital spending levels remained above asset depreciation. Additionally, debt levels increased as many issuers took advantage of favorable rates and/or the expiring Build America Bond Program in fiscal 2010 to pre-fund expenditures. Variable-rate debt issuance remained low as the trend to convert outstanding variable-rate debt to fixed-rate continued.

The study utilizes eight financial ratios that are calculated from the most recent annual audits. The ratios are presented by utility type, rating category, and region. A utility's financial measures, relative to an appropriate Fitch-designated regional and national peer group, constitute an important component of Fitch's credit analysis. Along with the Annual Peer Study, Fitch is also publishing an Excel Addendum for the second year. This year, the Addendum has been expanded to include three years of financial data for retail, wholesale, and rural electric cooperative utilities, along with improved sorting functionality which should add greater flexibility when comparing utilities and metrics.

Sunherald.com encourages an open exchange of affirming and dissenting opinions on our stories, and we consider it an important element of the user experience on sunherald.com. We invite you to comment on our content as part of our interactive community, but please keep the discourse civil and refrain from profanity, obscenity, spam, name-calling or attacking others for their views.   Read more Read less

Do not resort to personal abuse. You may disagree with the content of an article, with the reporter or with other readers’ comments, but do not attack anyone personally. Do not libel or defame anyone or violate their privacy. Keep your comments succinct and stay on topic. Comments that bear no relation to the story will be deleted. Do not use foul language. And don't try to camouflage profanity with asterisks or other symbols or foreign phrases. Avoid hate speech. Abusive comments, racist rants or defamatory statements about any group will be deleted. Do not use threatening language. Use standard English grammar and observe accepted rules for capitalization, punctuation and spelling. Do not post a comment using all capital letters. Do not post spam or advertising of any kind. Do not add images to your comments. Do not report comments as abusive simply because you disagree with them. Report them only if they violate these guidelines. Do not use profanity or obscenities. Talk of violence won't be tolerated. No racial, gender or sexual-orientation name-calling. Do not attack other commenters for their views. Spam is not welcome here. And finally, as Mark Twain said: "Always do right. This will gratify some people and astonish the rest.

Financial Statement Ratios Template | Microsoft Excel Template ...

This financial statement ratios template allows you to carry out financial investigation in three areas:, debt, investment and profitability. One of the basic advantages of this template is that you can carry out basic ratio analysis on one spreadsheet such as asset, revenue, receivable ratios etc. This financial ratios and budget template can be utilized for existing and proposed businesses, products, or services. Outputs include a forecast with sensitivity analysis and a budget by Month in graphical and tabular form.

Pro Excel Financial Modeling: Building Models for Technology Startups

Business Math Using Excel

Building Financial Models with Microsoft Excel, A Guide for Business Professionals

Financial Analysis with Microsoft Excel 2007

Corporate Financial Analysis with Microsoft Excel