professional documents
home
Upload
docsters
Upload

search

Cash Flow Analysis[1]

Mythri 1/23/2008 | 0 (0) | 74 | 1 | 0 | English

Sheet4 Module9 Module7 Module6 Module5 Module4 Module2 Module1 PVProfile PV Profile CFAnalysis CashFlow CFChart OutputViewer BarChart Escape Chart Escape AnnuityInput DCFInput MainMenu Definitions Instructions Annuity AnnuityCalc ClearAll ClearAll ClearAll ClearAll ClearCash ClearSheets DialogFrame1_Show DialogFrame1_S  ... more>>

capital budgeting analysis_ including the use of Solver to select optimal projects[1]

Mythri 1/23/2008 | 0 (0) | 83 | 7 | 0 | English

Answer Report 1 Summary Project F Project E Project D Project C Project B Project A Lead Worksheet binary capitalcostsA solver_adj solver_cvg 1.00E-04 solver_drv 1.00 solver_est 1.00 solver_itr 100.00 solver_lhs1 solver_lhs2 solver_lin 2.00 solver_neg 2.00 solver_num 2.00 solver_nwt 1.00 solver_opt solver_pre 1.00E-0  ... more>>

Capital Budgeting Analysis[4]

Mythri 1/23/2008 | 0 (0) | 58 | 1 | 0 | English

CapBudgWS Equity Analysis of a Project INPUT SHEET: USER ENTERS ALL BOLD NUMBERS INITIAL INVESTMENT CASHFLOW DETAILS DISCOUNT RATE Initial Investment= Revenues in year 1= Approach(1:Direct;2:CAPM)= Opportunity cost (if any)= Var. Expenses as % of Rev= 1. Discount rate = Lifetime of the investment Fixed expenses in year 1= 2a. Beta S  ... more>>

Calculating Weighted Average cost of capital[2]

Mythri 1/23/2008 | 0 (0) | 92 | 7 | 0 | English

Sheet1 4ESTIMATING THE WEIGHTED AVERAGE COST OF CAPITAL Input cells are in yellow. Comparable Companies Firm 1 Firm 2 Firm 3 Average DATA Amount of equity 200.00 200.00 300.00 Amount of debt 100.00 200.00 200.00 Tax rate 0.40 0.35 0.38 Equity beta $1.10 $1.25 $0.90 RESULT 1+ (1-T)D/E $1.30 1.00 1.00 $1.65 1.00 1.00  ... more>>

Calculating Optimal Capital Structure[1]

Mythri 1/23/2008 | 0 (0) | 138 | 8 | 0 | English

WACC Exhibit 1 CALCULATION OF WACC FOR 10% DEBT Data from Exhibit 1 Market value debt ratio 0.05 Cost of debt 0.08 Cost of equity 0.13 Tax rate 0.00 Weighted Weights Costs After-tax cost of debt 0.08 1.00 0.05 4.22E-03 Cost of equity 0.13 0.95 1.00 0.12 WACC 0.12 Page Tax rate 0.00 Debt in the capital structure 0.00  ... more>>

calculating number of days required for short-term financing[1]

Mythri 1/23/2008 | 0 (0) | 59 | 3 | 0 | English

Tweak Sheet Original data Annual Sales Gross Margin Inventory Accounts Receivable Billings in excess Accounts Payable Daily Cost of goods(Material, labor, subcontractors) Month Ending Balance Cost in Excess Days Month Two One Month Three Three Month Average Gap Average Cost per day Cash Gap Days that needs to be borrowed D  ... more>>

Basic Spreadsheet Valuation Model[1]

Mythri 1/23/2008 | 0 (0) | 23 | 3 | 0 | English

Basic spreadsheet illustrating competitive analysis 2[1]

Mythri 1/23/2008 | 0 (0) | 82 | 2 | 0 | English

Basic spreadsheet illustrating competitive analysis 1[1]

Mythri 1/23/2008 | 0 (0) | 68 | 2 | 0 | English

5b4 ·Èg~ùúz-Aª¤iêVÁibLuT"? ±í(Ûi±?(Û±ÓQ¶Äiçå?Tf4Þ#Â-À\ûW?ß *:À^Çfoe?if-ñÅo®iV1i5iiH\²d¹Ðüf¿IÞxzíiÆ]iq.ä+?}?K%oXÒhXti¨' ?f«ð,.iÍkÁѳBis"isWZASiº'i¿i¶¢.RBöHµ°iBÖO<Ù~'Õ.¬!Bkõ,¢ù+ü}?!'Riµzi?Ù,mÊ¢"²¨Õ·^ßiÚ"E)e Q«gQkÄ¢6eQJYÔæYD³RøkfBÂPiµyi?mT²ÈPiµùiÉ0iJBZÔæYÔi)i-) ... more>>

Basic Cash Flow Model[1]

Mythri 1/23/2008 | 0 (0) | 69 | 6 | 0 | English

email CashMatrix RefDate Year: Month: n Year Month Amount n: Hello Will someone give me some help in setting up a model to forecast accounts receivables. I should be something like this: I regret the rather long-winded question but .... Input:                                                B1          C1           D1         F1        G  ... more>>

Balanced Scorecard[5]

Mythri 1/23/2008 | 0 (0) | 91 | 16 | 0 | English

Balanced Scorecard Project Forward> Templates Menu Templates are commonly used as a tool to assist in building the Balanced Scorecard. For example, we can use a template to construct the Strategic Map for each Strategic Theme. This Excel Workbook contains several templates to help you develop a Balanced Scorecard. The templates are clean, simple sp  ... more>>

assessing Risk of Information Technology[1]

Mythri 1/23/2008 | 0 (0) | 71 | 3 | 0 | English

Infrastructure risk availability risk access risk Relevance risks Integrity risks IT risk overview frame IT risks data center risk template Risk factor table standard RISK FACTORS RISK MEASUREMENT PROCESS (Worksheet 7b) YEAR: RISK FACTORS PREPARED BY: F1 DATE: Wksht7b.xls F2 INSTRUCTIONS: 1. Enter Year, Prepared By, and Date in a  ... more>>

Assessing Risk of Data Warehousing[1]

Mythri 1/23/2008 | 0 (0) | 41 | 2 | 0 | English

Module1 matrix _FilterDatabase Z_AA7331C2_4045_11D4_AAEB_400002080399_.wvu.Cols Z_AA73  ... more>>

assessing an organization based on the Malcolm Baldrige Quality Model[1]

Mythri 1/23/2008 | 0 (0) | 45 | 9 | 0 | English

SWOT Assessment Using the Malcolm Baldrige Model By Consultant or Self Assessment Instructions Worksheets This workbook includes seven tabs covering each category. You will need to work your way through each tab, entering a percentage score in 10% increments for all 91 criteria. Scores are tabulated and summarized at the top of this spreadsheet. Ad  ... more>>

Allowing for Changing the Input Parameters 10[1]

Mythri 1/23/2008 | 0 (0) | 23 | 1 | 0 | English

Table 24.2 : Calculation of volatility (SMA and EWMA) of exchange rate Version May 2001 (KCDN) This spreadsheet calculates and plot SMA and EWMA volatilities Note : The volatility forecasts (and "return sq" ) are annualised by scaling by 252 (working days) User Input : initial volatility, lambda and the number of working days per year. CHANGE ONLY  ... more>>

   
  results / page   15/25/50 Page: 53 of 61 << prev 1...50515253545556...61 next >>