• finac
    )(1 – tC)] QF = [$90,852.46 + $150,000(1 – .34) – $70,000(0.34)] / [($60 – 27) (1 – .34)] QF = 7,624.08 Intermediate 11. a. At the accounting breakeven, the IRR is zero percent since the project recovers the initial investment. The payback period is N years, the length of the project...
    Premium 5736 Words 23 Pages
  • Fi Questions
    . Calcuate payback period. (b) A Project costs Rs.40,00,000 and yields annually a profit of Rs.6,00,000 after depreciation at 12.5% but before tax at 40%. Calculate the payback period. 30. The capital structure of a company consists of the following sources of funds. Calculate the...
    Premium 1615 Words 7 Pages
  • Vba for Beginner
    serve to make programming more fun. After all, what’s the first thing anybody does when a new computer is purchased? xii Microsoft Excel VBA Programming for the Absolute Beginner, Second Edition The answer: find the games that are installed and start playing. With this book, you get to write...
    Premium 30042 Words 121 Pages
  • Object-Oriented
    Programming A valuable advantage of the GIS software utilized (ArcGIS Desktop 9.0) is that both applications come with Visual Basic for Applications (VBA) embedded. This option pro- 978-1-4244-2708-6/08/$25.00 ©2008 IEEE 2590 Sasso and Biles vides an integrated programming environment...
    Premium 3512 Words 15 Pages
  • Stqa Mannual
    KJSCE/BE//IT/SemVII/2012-13 K. J. Somaiya College of Engineering, Mumbai-77 Lab Manual: BE (I.T. Semester VII) Instructions to the students 1. Every student is expected to bring printout of write-up of his/her experiment to be performed at the time of practical/tutorial session as per the...
    Premium 15653 Words 63 Pages
  • Model of Greed
    sphere. For p > 3 there are similar parametrizations of unit hyperspheres of dimension p which can be used. Exercise: 2 Write VBA routines that return correlation matrices using the method of 6.3.1 and also of 6.3.2 for p = 2, 3. Input the parameters from the spreadsheet.  sin θ1 sin φ1 sin θ2 sin...
    Premium 9075 Words 37 Pages
  • Mddw Formula
    , and write me a check – thank you! But imagine for a moment, it was a family member – you would be on your guard then wouldn’t you? You would obviously want to know if this is a better deal than what your bank gives you, and for that you can calculate the Net Present Value of these cash flows on the...
    Premium 2277 Words 10 Pages
  • Case Solutions for Corporate Finance Ross, Westerfield, and Jaffe 9th Edition
    note, it may be advantageous to delay the mine opening because of real options, a topic covered in more detail in a later chapter. 3. There are many possible variations on the VBA code to calculate the payback period. Below is a VBA program from http://www.vbaexpress.com/kb/getarticle.php?kb_id...
    Premium 25022 Words 101 Pages
  • Chapter 7— Net Present Value and Other Investment
    rate of return the project is rejected. 4) Payback period: Payback period is the exact amount of time required for a firm to recover its initial investment in a project as calculated from inflows. It is a non-discounted cash-flow technique. 5) Discounted payback period: The time required...
    Premium 1143 Words 5 Pages
  • envorimental studys
    drawings needs to be plotted a certain way, you can write a script that opens each drawing, hides and displays various layers, and issues PLOT commands. You can use scripts with slides to create automated presentations like those used at trade shows. A slide is a “snapshot” of the drawing area...
    Premium 66553 Words 267 Pages
  • Sweco Case Write Up
    equipments, revenue generated will be $1000,000 per equipment. Assuming the rental fee equals $100 per day, rental for one year generates $36500 per equipment. Thus we need at least 1000000*2/36500=55 sand separators for the two service center needed. Secondly, we have to calculate the payback period...
    Premium 606 Words 3 Pages
  • Microsoft Database Security
    Access applications, create database templates, and integrate source code control with Microsoft Visual SourceSafe. 3 Features Users can create tables, queries, forms and reports, and connect them together with macros. Advanced users can use VBA to write rich solutions with advanced data...
    Premium 21393 Words 86 Pages
  • Excel Bible 2010
    need to enter the cell’s contents manually — or write a VBA macro to perform this operation before the sheet is printed. Other header and footer options When a header or footer is selected in Page Layout view, the Header & Footer ➪ Design ➪ Options group contains controls that let you specify...
    Premium 165210 Words 661 Pages
  • Excel for Auditor
    for Auditors Automating Excel with VBA Macro to Color Every Third Row Red Putting the above information together, you should be able to write a simple macro that will loop through the rows in your dataset. Change the Step command to look at every third row. Instead of the “Do Something...
    Premium 20500 Words 82 Pages
  • Report
    the firm over the life of the transport fleet project. (5 marks) b Calculate the following for the transport fleet project: (i) Payback period (ii) Accounting rate of return (iii) Net present value (13 marks) c Write a short report to the Investment Manager in your company outlining whether...
    Premium 16601 Words 67 Pages
  • fIN302
    : Cumulative cash flows Year 1 = $6,500 Cumulative cash flows Year 2 = $6,500 + 4,000 107 = $6,500 = $10,500 Companies can calculate a more precise value using fractional years. To calculate the fractional payback period, find the fraction of year 2‘s cash flows that is needed for the...
    134767 Words 540 Pages
  • MATLAB PROGRAMMING
    program that can calculate the simple interest of the following 1. Principal=$400, Interest=10% per annum, over a period of 5 years. 2. Principal=$700, Interest=8% per annum, over a period of 6 years. Solution Using script we solve as follows %A program that calculates simple interest using scripts...
    Premium 2214 Words 9 Pages
  • capital budgeting
    how long it will take the cash inflows expected from an investment to repay (payback) the initial outlay” (Pringle and Harris, 1984, p. 289). One calculates payback period by using this: PP ¼ net investment : average annual operating cash flow Because the discounted payback period is...
    Premium 2473 Words 10 Pages
  • Corporate Finance
    Cumulative cash flows Year 2 = $2,500 + 1,200 Cumulative cash flows Year 3 = $2,500 + 1,200 + 3,000 = $2,500 = $3,700 = $6,700 = $4,000 = $7,500 Companies can calculate a more precise value using fractional years. To calculate the fractional payback period, find the fraction of year 3’s cash flows...
    Premium 174189 Words 697 Pages
  • Business
    .   For this investment, calculate: Part (a) The net present value. Part (b) The internal rate of return. Part (c) The payback period. (Points : 30)               | 4. (TCO 7) Roswell Company has budgeted sales revenue as follows for the next 4 months as follows:   February | $150,000...
    Premium 1493 Words 6 Pages