THIS IS A LIST OF EXCEL PROGRAMS THAT YOU MIGHT FIND USEFUL. THEY ARE NOT COPY PROTECTED. FEEL FREE TO MODIFY THEM TO YOUR OWN NEEDS. Corporate Finance Spreadsheets 1. capbudg.xls: This program allows you to do a basic capital budgeting analysis for a project‚ and compute NPV‚ IRR and ROI. (For Macintosh version) 2. risk.xls: This program allows you to use past returns on a stock and a market index to analyse its price performance (Jensen’s Alpha)‚ its sensitivity to market movements
Premium Discounted cash flow Cash flow Corporate finance
Forecast of Revenue and Expense Besides Supply and Demand analysis which provides a general concept of measuring performance in the market share‚ revenues and expenses forecast gives the investors the overview of the future cash flow which reflects the return as the crucial metrics of the investment‚ helping investor to make a good decision. According to the proposal plan‚ the proposed hotel located in 22nd street will have following facilities: 238 hotel rooms‚ 53 off-street parking spaces in
Premium Real estate appraisal Hotel Net income
been conservative in financing its growth with debt‚ and thus contributes to stable earnings as a result of less additional interest expense. Above all‚ the company is in a good condition and enjoys a promising future development. Alternative Valuation Method Since Evolution Petroleum Corp. is an E&P company‚ DCF model
Premium Financial ratio Free cash flow Cash flow
Chapter 6 Bond Valuation 6.5 Duration and Convexity Problem Given a 4-yr treasury bond with a face value of $1‚000‚ an annual coupon rate of 3.20%‚ which had a yield to maturity of 2.53%‚ this bond makes 2 semi-annual coupon payments. Thus has 8 periods until maturity and we are required to determine what the duration‚ modified duration‚ and convexity of this bond is‚ based on the Annual Percentage Rate (APR) and the Effective Annual Rate (EAR). Also‚ we are asked to explain an intuitive interpretation
Premium Bond Time Balance sheet
greater technical resources in wireless service‚ and it is one of the largest regional wireless companies in the US. This report will analyse the initial valuation of ATC based on discounted cash flow analysis as well as market multiples approach‚ based on the analyse‚ it will decide whether the acquisition should be made or not. Body The valuation of Air Thread Connections can be divided into two separate projection periods. During the first five years from 2008 to 2012‚ ACC borrowed 3758 million
Premium Discounted cash flow Cash flow Free cash flow
results of operations based primarily on its audited financial statements information from 2009-2013. Wal-Mart overshadows its competitors‚ with its US retail sales being over three times those of its nearest rival (in FY2013). We attempt to identify what is driving this business model by analyzing the firm’s asset management‚ capital structure and its ability to generate cash. In doing so we include 2 peer comparisons‚ namely Costco and Target. 1.1 The company and the industry. Wal-Mart market position
Premium Wal-Mart Revenue Financial ratios
HW Bond Valuation and Bond Yields Clifford Clark is a recent retiree who is interested in investing some of his savings in corporate bonds. His financial planner has suggested the following bonds: • Bond A has a 7% annual coupon‚ matures in 12 years‚ and has a $1000 face value. • Bond B has a 9% annual coupon‚ matures in 12 years‚ and has a $1000 face value. • Bond C has an 11% annual coupon‚ matures in 12 years‚ and has a $1000 face value. Each bond has a yield to maturity (YTM) of 9%
Premium Bond Bonds
Valuation of equity Example based on dividend discount model : Vardhman limited’s earnings and dividends have been growing at a rate of 18% per annum. This growth rate is expected to continue for 4 years. After that the growth rate will fall to 12 % for the next 4 years. Thereafter‚ the growth rate is expected to be 6 % forever. If the last dividend per share was RS. 2.00 And the investor’s required rate of return on verdhman’s equity is 15% what is the intrinsic value per share? Step 1: the
Premium Generally Accepted Accounting Principles Investment Stock
Skills competency fairs are held annually by most healthcare facilities. They are usually organized and managed by nursing managers and nursing educators. Skills competency fairs allow staff to demonstrate competence with nursing skills that are used daily to provide optimal patient care. The primary goal of these fairs is to ensure competency of the staff‚ to achieve positive outcomes for patients (Roman‚ 2015). Before planning the fair‚ nursing managers and nursing educators come together and collaborate
Premium Nursing Patient Nurse
named HFCL Infotel and promoted by Anant Nahata. It started as a provider of landline services under the brand name ‘Connect’ in 2000. It launched CDMA services in 2007 and GSM operations in Punjab in 2010. The HFCL group held 36% in a joint- Valuation Ratios (Consolidated) EPS +/EV / Sales (X) EV / EBITDA (X) 2013E 2013A Negative Negative 1.69 -15.41 Negative Negative - venture with the Videocon group under the name Datacom – this company had licenses in all circles except
Premium Balance sheet Asset GSM