Write a vba script that calculate the payback period

Treasury bonds is currently 8. The company would be responsible for making interest payments each month on the amount borrowed. Dan Dority, the company's geologist, has just finished his. Shenbang can provide the proper grinding measure to Based on your analysis, should the company open the mine.

In the past, the firm had used Be sure to show slack for noncritical activities.

BUSN379- all cases

You can copy the entire code from one of these sources and paste it into the VBA editor to create the script instead of coding the script from scratch. He felt that some of these decisions should be made internally. The bonds were issued 5 years ago with an original maturity of 20 years.

The payment for a loan repaid with equal payments is the annuity payment with the loan value as the PV of the annuity. Bethesda Mining is a midsized coal mining company with. No; the firm should exit immediately.

Assume the companys tax rate is 35 percent. A new window will open containing the VBA editor; the data and settings for your open workbook file will already be loaded into the editor so object entries will exist for each sheet of your workbook.

busn-379-week-2-4-and-6-cases-2015

She has also projected the expense of opening the mine and the annual operating expenses. This Workbook limits the macro to the Excel document you're currently editing.

For instance, I have the following cash flows: The issue makes semiannual payments and has an embedded cost of 6. Dan Dority, the companys geologist, has just finished his analysis of the mine site. Caesar is a famous mining equipment manufacturer well-known both at home and abroad, major in producing stone crushing equipment, mineral separation equipment, limestone grinding equipment, etc.

CourseHeroWriters

Why is this shorter than the time needed to pay off the traditional mortgage. Explain your experience utilizing or witnessing the use of OB in your work environment. 1 Answer to 1 Bonus Question: Most spreadsheets do not have a built-in formula to calculate the payback period Write a VBA script that calculate the payback, - Get Info Question: BULLOCK GOLD MINING Seth Bullock, the.

devry busn all weeks cases [ total 3 cases ] Question CASE 4 Case Case II is due at the end of this week.

bullock gold mining bonus question

For this assignment, prepare a memo in Word, which answers the questions in the Chapter 5 case, S & S Air’s Mortgage, on page of the textbook. You can copy the entire code from one of these sources and paste it into the VBA editor to create the script instead of coding the script from scratch.

Calculate Subnets With Microsoft Excel. Bullock gold mining case study, need to write a VBA script that calculates the payback period for project.

How Do I Create a Microsoft Excel Script?

- Answered by a verified Tutor. =payback(your investment amount,range of your future cash inflows) Test the code: Payback amount should always be equal to no. of periods it will take to equal investment without effect of interest or inflation. Aug 28,  · Seth Bullock, the owner of Bullock Gold Mining is evaluating a new gold mine in South Dakota.

Dan Dority, the company’s geologist, has just finished his anal.

Write a vba script that calculate the payback period
Rated 0/5 based on 65 review
How Do I Create a Microsoft Excel Script? | It Still Works