Financial Excel Spreadsheets

Sheet1 Page This spreadsheet analyzes the lease/purchase decision. In the case of a purchase, it is assumed sales tax is paid on the negotiated price at the time of purchase, and property taxes are paid annually. In the case of a lease, it is assumed sales tax is paid on the difference between the list price and the payoff at the time o ...  more>>

Overview of Excel's Chart Wizard

Financial Excel Spreadsheets

NewFCFE3Stage Do you want to change any of these inputs for the stable growth period? If yes, specify the values for these inputs Specify weights to be assigned to each of these growth rates: Historical Growth Rate = Outside Prediction of Growth = Fundamental Estimate of Growth = Growth Rate during the transition period Enter length of th ...  more>>

Financial Excel Spreadsheets

NPV Infl factor Real rate Page NPV CAN BE CALCULATED IN NOMINAL OR REAL TERMS Interest rate 0.12 Inflation rate 0.05 Real interest rate 0.07 1.00 1.00 1.00 Year 0.00 1.00 2.00 3.00 Cash flow -400000.00 100000.00 200000.00 300000.00 PV factor 1.00 0.89 0.80 0.71 PV of cash flow -400000.00 89285.71 159438.78 213534. ...  more>>

Excel III Cheat Sheet

Financial Excel Spreadsheets

Cash flows Balance sheet Income Financing Operations Instructions solver_adj solver_lhs1 solver_lhs2 solver_lhs3 solver_lhs4 solver_lhs5 solver_lhs6 solver_lhs7 solver_lhs8 solver_lhs9 solver_lin 0.00 solver_num 9.00 solver_opt solver_rel1 3.00 solver_rel2 3.00 solver_rel3 3.00 solver_rel4 3.00 solver_rel5 3.00 solver ...  more>>

EXCEL Gantt_v4[3]

Project Schedule -Gantt Chart (48-Week Window) Version 4.0 Yellow cells = cells for data entry. WBS Tasks Owner Plan Start Plan Finish Days FTEs Hrs. 1 Project Name 1886 1.1 Project planning & prep 3-May-05 1-Aug-05 1.1.1 Supervison & coord Sue 3-May-05 1-Aug-05 65 0.40 208 1.1.2 Develop plan Sue 4-May-05 28-May-05 19 0.30 46 1.1.3 Develop budget B ...  more>>

Excel Quick Reference, Microsoft Excel 2000 Cheat Sheet