Financial Analysis using Excel Function Information requirements for function Dates Prices and par values Frequency‚ and related Yields and interest/ discount rates Discount Any amount paid at maturity ? Frequency of payme nts pa First coupon Redemption amount Investment amount # of periods Settlement Par/coupon Maturity COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPPCD COUPNUM DURATION MDURATION PRICE PRICEDISC PRICEMAT RECEIVED YIELD YIELDDISC YIELDMAT ACCRINT
Premium Spreadsheet
Comparison of Sage‚ Excel and other packages Accounting can be very time consuming and complex therefore accounting software has been created in order to make this more straightforward and less time consuming for those using it. Features of accounting software range from program to program but all provide basic features which usually include accounts payable‚ accounts receivable‚ inventory‚ fixed assets and analysis. Software can be simply bought off-the-shelf‚ purpose built‚ or purchased
Premium Accounting software Accounts receivable Accounts payable
5. INTRODUCTION TO LINEAR PROGRAMMING (LP) Learning Objectives 1. Obtain an overview of the kinds of problems linear programming has been used to solve. 2. Learn how to develop linear programming models for simple problems. 3. Be able to identify the special features of a model that make it a linear programming model. 4. Learn how to solve two variable linear programming models by the graphical solution procedure. 5. Understand the importance of extreme points in
Premium Optimization Linear programming Operations research
Taja Charrier LSP 120 11/4/13 Activity 12 1. Suppose that you deposit $500 in a bank that offers an annual percentage rate of 6.0% compounded annually. a. What is your account balance after one year? 530 b. What is your account balance after 10 years? 895.42 2. How long will it take your money to triple at an annual percentage rate of 8% compounded annually? 14.27 years 3. Suppose that you deposit $750 in a bank that offers an annual percentage rate of 4.0% compounded monthly. a
Premium Compound interest
2. Costing aircraft components A British Aerospace case study Introduction When we think about the cost of an aircraft‚ we tend to think of the cost of buying the product rather than the costs of running it! British Aerospace’s service to the customer does not stop at the aircraft acquisition stage‚ when the aeroplane is sold to the customer. If anything‚ this is when the customer relationship begins. This case study focuses upon the processes involved in costing aircraft components. Given the
Premium Cash flow Cost
Table of Contents 1. INTRODUCTION Tinekhu Khola Small Hydropower Project (TKSHP) with an Installed Capacity of 990 kW utilizes flow from Tinekhu Khola which is located at Suri and Jhyaku VDC’s of Dolakha District‚ Janakpur zone in Eastern Development Region of Nepal. Tinekhu Khola Small Hydropower Project (The Project) is Run off River (RoR) type with its headworks located in Tinekhu River at some 3 km upstream from the confluence of Tamakoshi River and Tinekhu River. The distance
Premium Net present value Sea level Energy
Preface This project traces the detergent market and the demand for one particular detergent in Mahabalipuram‚ a small township in Tamil Nadu. Surf Excel is a leading detergent brand produced by Hindustan Unilever Ltd in India. This product is marketed in different price ranges and quantities. There is a wide range of categories under surf excel which are designed for different types of washing machines‚ fabric‚ and needs. The decision to choose this brand came from a quick scan of the most
Premium Marketing Laundry detergent Laundry
Name‚ protect and use data validation on cells as appropriate. g) Set up the following Scenarios Best If the best market conditions are prevalent sales will initially 60‚000 units at £23 per unit. And sales prices will grow at 5% per annum Worst If the worst market conditions are prevalent sales will initially 40‚000 units at £16 per unit. And sales prices will decline by 1% per annum h) Produce a scenario summary table showing the results cell as the profit/Loss figure for each of the
Free Assessment Evaluation Income statement
The hardest part about this assignment is finding the center line. The center line is always X-bar-bar. (An x with two bars above it). It’s the mean of all the sample means. I’ve attached an Excel spreadsheet showing how to calculate X-bar-bar. First‚ you find the average of each sampe. There were four in this case. The average is at the bottom. Then you take those four numbers and find the average for those. I rounded up to 5.1 to make it easier to graph. So X-bar-bar = 5.1. Once you X-bar-bar
Premium Arithmetic mean Standard deviation Normal distribution
Microsoft Excel supports many kinds of charts to help you display data in ways that are meaningful to your audience. When you use the Chart Wizard to create a chart — or when you use the Chart Type command to change an existing chart — you can easily select the type you want from a list of standard or custom chart types. For an overview of some standard chart types and their subtypes‚ click any or all of the following: Column charts A column chart shows data changes over a period of time or illustrates
Free Chart Bar chart Pie chart