)(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 paybackperiod is N years, the length of the project...
. Calcuate paybackperiod.
(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 paybackperiod.
30. The capital structure of a company consists of the following sources of funds. Calculate the...
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...
KJSCE/BE//IT/SemVII/201213
K. J. Somaiya College of Engineering, Mumbai77
Lab Manual: BE (I.T. Semester VII)
Instructions to the students
1. Every student is expected to bring printout of writeup of his/her experiment to be performed at the time of practical/tutorial session as per the...
sphere. For p > 3 there are similar parametrizations of unit hyperspheres of dimension p which can be used. Exercise: 2 WriteVBA 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...
, 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...
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 paybackperiod. Below is a VBA program from http://www.vbaexpress.com/kb/getarticle.php?kb_id...
rate of return the project is rejected.
4) Paybackperiod: Paybackperiod 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 nondiscounted cashflow technique.
5) Discounted paybackperiod: The time required...
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...
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 paybackperiod...
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...
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...
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...
the firm over the life of the transport fleet project. (5 marks) b Calculate the following for the transport fleet project: (i) Paybackperiod (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...
:
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
paybackperiod, find the fraction of year 2‘s cash flows that is needed for the...
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...
how long it will take the cash inﬂows expected from an investment to repay
(payback) the initial outlay” (Pringle and Harris, 1984, p. 289). One calculatespaybackperiod by using this:
PP ¼
net investment
:
average annual operating cash flow
Because the discounted paybackperiod is...
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 paybackperiod, find the fraction of year 3’s cash flows...
.
For this investment, calculate:
Part (a) The net present value.
Part (b) The internal rate of return.
Part (c) The paybackperiod. (Points : 30)

4. (TCO 7) Roswell Company has budgeted sales revenue as follows for the next 4 months as follows:
February  $150,000...