Question: How to make a vba for payback period from these case Cumulative Year Cash Flow Cash Flow DF 12,00% PV NPV 50.677.130 IRR 15,20% 13,25%

How to make a vba for payback period from these case

Cumulative Year Cash Flow Cash Flow DF 12,00% PV NPV 50.677.130 IRR 15,20% 13,25% MIRR Payback Period Calculation Last Negative Cashflow Years Last Negative Cashflow Net Cashflow in Next Year Payback Period Year 4,21

Step by Step Solution

★★★★★

3.46 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To calculate the payback period using VBA you can use the following steps 1 Create a new module in t... View full answer

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!

Aerospace engineers sometimes compute the trajectories of projectiles like rockets. A related problem deals with the trajectory of a thrown ball. The trajectory of a ball is defined by the (x, y)...

(a) How many ways to divided our class of 50 students into groups of size: 10, 15, 14, 11? (6) (b) How many ways to divide the 50 students into groups of size of 5?

11.50 per hour 10 per month Write the algebraic rules for the monthly price

7) The second financial statement to prepare is the statement of retained eamings. To determine the ending balance of retained earnings you need to start with the opening balance as reported in the...

I did the last excel sheet already. Having trouble with the others. Need guidance C Apache Airlines, A Privately Held X This case has the following road X M Inbox (936) - chelsea.collier.cc@ x +...

Please write a report on which project should Harris recommend or neither. In your report, you need to include quantitative analysis, including NPV, IRR, Payback and sensitivity analysis. You also...

Answer e-i our division is considering two projects. Its WACC is 10%, and the projects after-tax cash flows (in millions of dollars) would be as follows: Expected Cash Flows Time Project A Project B...

complete a business case Part I: WACC Use this information to answer questions 1-8 Suppose Intel wants to raise capital to start a new project to bring their manufacturing process back to the U.S....

Answer b, c, d our division is considering two projects. Its WACC is 10%, and the projects after-tax cash flows (in millions of dollars) would be as follows: Expected Cash Flows Time Project A...

please show formulas Your division is considering two projects. Its WACC is 12%, and the projects after-tax cash flows (in millions of dollars) would be as follows: 2 3 4 5 6 7 8 Time 0 1 2. 3 4...

please help! 1 2 3 Your division is considering two projects. Its WACC is 12%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: CON 4 5 6 7 8 Time 0 1 2 3 4...

Analyze the economic events in the US or any other country related to poverty. Recommend actions that should be done to prevent future impacts.

Consider an individual selected at random from a sample of 750 married women in answering each of the following questions. a. What is the probability that this woman does not work outside the home,...

Find the work ( in ft - lb ) required to pump all the water out of a cylinder that has a circular base of radius 4 ft and height 3 0 0 ft . Use the fact that the weight - density of water is \ ( 6 2...

Quartz is a. A variety of feldspar b. A variety of white mica c. Composed of calcium carbonate d. Composed of silicon dioxide

An advertisement for Ford trucks offered "2.9%" financing (for 48 months) or $4000 cash back." A truck buyer financed $40,000 at the low interest rate instead of paying $36,000 cash (after the $4000...

Visit https://www.osha.gov/dts/osta/oshasoft/index.html, choose an industry etool, then choose an application area/task, and identify a safety or ergonomic lesson for work design in that industry.

Rob Otics Ltd, a small business that specialises in manufacturing electronic-control equipment, has just received an inquiry from a potential customer for eight identical robotic units. These would...

Describe the least-squares method. Why is this method better than the highlow and scattergraph methods?

Can we put that she will be making weekly payroll deductions inthe amount of $52.75 to the housing equalling $211.00 monthly

The Simmons Company expects earnings of $30 million next year. Its dividend payout ratio is 40 percent, and its proportion of debt (debt/assets ratio) is 55 percent. Simmons uses no preferred stock....

HQ Company is considering a 1-for-3 reverse stock split. HQ's stock is currently selling for $3 per share. a. What will the price of the stock be after the stock split? b. HQ plans to pay a dividend...

Compute the IRR and the MIRR for each of the following capital budgeting projects. Assume that the firms required rate of return is 14 percent. Which project(s) should be purchased if they are...

As of Brices fifty-fourth birthday, he has accumulated $154,000 in his Registered Retirement Savings Plan (RRSP). What size of end-of-month payments in a 20-year annuity will these funds purchase at...

Cynthia currently has $31,000 in her RRSP. She plans to contribute $5000 at the end of each year for the next 17 years, and then use the accumulated funds to purchase a 20-year annuity making...

Mr. Parmar wants to retire in 20 years and purchase a 25-year annuity that will make equal payments at the end of every quarter. The first payment should have the purchasing power of $6000 in todays...