Question: Most spreadsheets do not have a built in formula to calculate the payback period. Write a VBA script that calculates the payback period for a

Most spreadsheets do not have a builtin formula to calculate the payback period. Write a VBA script that calculates the payback period for a project.

Year Cash Flow

0 −$625,000,000

1       70,000,000

2     129,000,000

3     183,000,000

4     235,000,000

5     210,000,000

6     164,000,000

7     108,000,000

8       86,000,000

9    −   90,000,000 


Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Heres an example of a VBA script that calculates the payback period for a project based on the cash ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

663dc06a92863_962658.pdf

180 KBs PDF File

Word file Icon

663dc06a92863_962658.docx

120 KBs Word File

Students Have Also Explored These Related Finance Questions!

Q:

Telstar Communications is going to purchase an asset for $500,000 that will produce $240,000 per year for the next four years in earnings before depreciation and taxes. The asset will be depreclated...

Q:

Utilizing the estimated marginal distributions in (a), carry out a multivariate distribution fitting of the cdf-transformed returns for each of the following copula models Gaussian t Gumbel Clayton

Q:

A professor surveyed his statistics students about ho many hours they had spent on their work outside of class during the past week. The students gave the following answers: Calculate (a) the mode,...

Q:

Find the exponential model that fits the points shown in the graph or table. 1. 2. (3, 10) 10 8. 6. 2- -(0, 1) +++++ 1 2 3 4 5 (4, 5) 2 3 4

Q:

Case Two: Bullock Gold Mining Question 2: Based on your analysis, should the company open the mine? Yes. The profitability index is 1.15, which is greater than >1 Bonus Question: Most spreadsheets do...

Q:

Please Answer questions 1 and 2. CHAPTER CASE BULLOCK GOLD MINING ld be expected from acted the expense of open- expenses. If the 50 million today Seth Bullock, the owner of Bullock Gold Mining, is...

Q:

Bullock Gold Mining Case Project Analysis and Decision Making page 273 Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company's...

Q:

need work to show the equations for NPV,IRR, MRR, and pay back CHAPTER CASE Rullock Gold Mining en Bulloc Sevaluating a new gold mine in s Dorty, the como malysis of the mine mine would be productive...

Q:

CHAPTER CASE Rullock Gold Mining en Bulloc Sevaluating a new gold mine in s Dorty, the como malysis of the mine mine would be productive lack, the owner of Bullock Gold Mining, is ng a new gold mine...

Q:

CHAPTER CASE Bullock Gold Mining Bullock, the owner of Bullock Gold Mining, is eval- a new gold mine in South Dakota. Dan Dority, eth Alma has used the estimates provided by Dan to determine the...

Q:

Year Cash Flow 0 $ 6 2 5 , 0 0 0 , 0 0 0 1 7 0 , 0 0 0 , 0 0 0 2 1 2 9 , 0 0 0 , 0 0 0 3 1 8 3 , 0 0 0 , 0 0 0 4 2 3 5 , 0 0 0 , 0 0 0 5 2 1 0 , 0 0 0 , 0 0 0 6 1 6 4 , 0 0 0 , 0 0 0 7 1 0 8 , 0 0 0...

Q:

Unit VII Essay Instructions Although separate from adult corrections, the juvenile system is linked to it at many points, particularly in their methods of operation. What sets the juvenile...

Q:

The items below appear on a physicians intake form. Determine the level of measurement of the data. (a) Temperature (b) Allergies (c) Weight (d) Pain level (scale of 0 to 10)

Q:

find parametric equations for the line - 5 , 2 , 5 and 1 , 7 , - 4

Q:

Which following statements is false? U.S. GAAP requires that the costs of start-up activities be expensed as incurred. IPR&D is initially capitalized at fair value and treated as an intangible...

Q:

Future semiconductors is evaluating a new etching tool. The equipment costs $1.0m and will generate after-tax cash inflows of $0.4m per year for six years. Assume the firm has a 15% cost of capital....

Q:

Determine the total weight of any minimum spanning tree of the following weighted graph: 3 8. 11 9. 7. 4 13 6. 12 Eater your answer as an integer. 101

Q:

Read the Madison Gilmores Ethical Dilemma (a GVV CASE) And answer the following: Is the accounting for revenue in the Victor transaction a case of operational earnings management or accounting...

Q:

6 Theory of Machines 5. A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and...

Q:

Find an equation of the tangent line at the point specified. y = x 2 (1 sin x), x = 3/2

Q:

Estimate using the Linear Approximation or linearization, and use a calculator to estimate the error. 5 33

Q:

(a) Sketch the slope field of dy/dt = t/y in the region 2 t 2, 2 y 2. (b) Check that y = t 2 + C is the general solution. (c) Sketch the solutions on the slope field with initial conditions y(0)...

Q:

52. In Prob. 6, find the Hermite form of BA where $$ B = \begin{bmatrix} 1 & 2 & 1 \\ 1 & -1 & -1 \\ 1 & -1 & 1 \end{bmatrix} , $$ and show that it is the same as the Hermite form of A.

Q:

53. Prove Theorem 6.7.1.

Q:

59. In Prob. 56, show that A+ BB' is nonsingular and (A + BB')-1 = A' + BB'.