Write a vba script that calculate the payback period

Use Excel to do any financial calculations. You will be graded on correct financial analysis, proper use of technology, and business-like presentation.

Write a vba script that calculate the payback period

[BINGSNIPMIX-3

An income statement for and A balance sheet for and Operating cash flow for each year. Cash flow from assets for Cash flow to creditors for Cash flow to stockholders for Write a brief discussion. The meeting is to discuss the mortgage options available to the company to finance the new facility.

Christie begins the meeting by discussing a year mortgage. The loan would be repaid in equal monthly installments. Christie states that the APR of the loan would be 6.

Write a vba script that calculate the payback period

Todd asks if a shorter mortgage loan is available. Christie says that the bank does have a year mortgage available at the same APR. A smart loan works as follows: Every two weeks a mortgage payment is made that is exactly one-half of the traditional monthly mortgage payment.

Christie informs him that the bank does have smart loans. Mark nods his head. He then states this is the best mortgage option available to the company since it saves interest payments. Christie agrees with Mark, but then suggests that a bullet loan, or balloon payment, would result in the greatest interest savings.

The monthly payments of a bullet loan would be calculated using a year traditional mortgage. In this case, there would be a 5-year bullet. This would mean that the company would make the mortgage payments for the traditional year mortgage for the first five years, but immediately after the company makes the 60th payment, the bullet payment would be due.

The bullet payment is the remaining principal of the loan.

Pros and Cons of Payback Period

Chris then asks how the bullet payment is calculated.Write a VBA script that calculates the payback period for a project. 1Â We could, of course, calculate the average of the six book values directly.

In thousands, we would have ($ + + + + + 0)/6 = $ 2 The AAR is closely related to the return on assets, or ROA, discussed in Chapter 3. Jun 24,  · Hi, I am working on a Finance Mini Case and I am having trouble answering the question below.

I would greatly appreciate any help anyone can offer. Thanks so much! 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. When calculating the payback period, you will also need to calculate the fraction of the year. In our example it is a number between 4 and 5. If we had to do this on paper, we would calculate this as follows.

Write a VBA script that calculates the payback period for a project.

Usefull link

1 We could, of course, calculate the average of the six book values directly. In thousands, we would have ($ + + + + + 0)/6 = $ Businesses track the amount of time it takes to pay back expenditures for a project by calculating what is called the "payback period".

This calculation takes into account cash.. Around The Home. How to Calculate Payback on Excel; How to Calculate Payback on Excel. March 31, How to Calculate BMI in Excel.

BUSN Week 6 Case – BULLOCK GOLD MINING | Assignment Essays

Around The . Calculation of Payback Period with Microsoft Excel - Murali Subramanian 2. Introduction• Payback period is the time in which the initial cash outflow of investment is expected to be recovered from the cash inflows generated by the investment.•.

VBA script that calculates the payback period