Question: Year Cash Flow 0 $ 6 2 5 , 0 0 0 , 0 0 0 1 7 0 , 0 0 0 , 0

Year Cash Flow
0$625,000,000
170,000,000
2129,000,000
3183,000,000
4235,000,000
5210,000,000
6164,000,000
7108,000,000
886,000,000
990,000,000
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 project.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Finance Questions!

Q:

PLEASE SHOW ALL WORK so that i can understand how to do future questions Bullock Gold; Mining eth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority,...

Q:

JS company is considering an investment that requires an outlay of $100,000 today. Cash inflow from the investment are expected to be $10,000 for year 1-3, and $30,000 for year 4, 5, 6, 7, and 8. You...

Q:

9.3 Consider the following net cash flows: Year Cash Flow 0 $2000 2 $2,000 3 1,500 4 2,500 5 4,000 a. What is the net present value of the stream if the opportunity cost of capital is 10 percent?...

Q:

What is the internal rate of return (IRR) of a project that has the following cash flows? The required return is 10.0%. Year Cash Flow 0 1 2 $ (16,000) $ 5,000 $5,000 $ 5,000 $ 5,000 $ 5,000 $ 5.000...

Q:

A. Based on the above, construct a spreadsheet to calculate the Net Present Value, modified internal rate of return (MIRR), the payback period and the discounted payback period (Assume a cut off of 5...

Q:

2) Capital budgetingAn investment requires an outlay of $100,000 today. Cash inflow from the investment are expected to be $40,000 per year at the end of year 4, 5, 6, 7, and 8. You require a 20%...

Q:

1. The financial manager at Starbucks Industries is considering an investment that requires an initial cost of $25,000 and is expected to result in cash inflows of $3,000 at the end of year 1, $6000...

Q:

Net Present Value Carsen Sorensen, controller of Thayn Company, just received the following data associated with production of a new product: Expected annual revenues: $740,000 Projected product life...

Q:

Investment A: Year: Cash flow: 0 - $14,000 2 $4,500 3 $4,500 4 $4,500 5 $4,500 $4,500 Investment B: Year: Cash flow: 0 - $15,000 1 $6,000 2 $6,000 3 $6,000 4 $6,000 5 $6,000 Investment C: Year: Cash...

Q:

Investment A: Year: Cash flow: 0 - $14,000 2 $4,000 3 $4,000 $4,000 $4,000 5 $4,000 Investment B: Year: 0 1 2 3 4 5 Cash flow: - $15,000 $7,000 $7,000 $7.000 $7,000 $7,000 Investment C: Year: 0 2 3...

Q:

Explain what business model innovation means. Provide an example of business model innovation other than the examples included. List at least three reasons that demonstrate why having a business...

Q:

Discuss the environmental, strategic, and organizational changes that occurred over the life of Andersen. Read the case study Arthur Andersen LLP and answer the following question:

Q:

A publicly owned facilty's financial goals often differ from those of a private individual or corporation. * 2 points True False

Q:

In computing the NPV of a capital budgeting project, one should NOT: A. estimate the cost of the project. B. discount the future cash flows over the project's expected life. C. ignore the salvage...

Q:

5. Analyze the group dynamics from five of your favorite television shows. See if you can identify the various social and antigroup role types in each of the groups.

Q:

Decision Making in Groups Leadership in Meetings

Q:

Have you ever been in a leadership role among a group of friends? Have you ever been subordinate to a friend in a group situation? Did any conflict arise, and if so, how did you resolve it?