Visual Basic for Applications and Function Essay

Therefore the annual interest rate is 8% and the effective annual rate compounded quarterly is 8.24%

A retail store gives each of its customers a maximum amount of credit. A customer’s available credit is determined by subtracting the amount of credit used by the customer from the customer’s maximum amount of credit. As you did in programming challenge 1, perform steps 1 through 6 of the programming process to design an application that determines a customer’s available credit.

In the above question, what is the remaining balance of the loan after 20 years’ payments?

•P a r a 9 . 7 . 1 4 - New para -Evaluation parameter technical as well as commercial(detailed technical evaluation matrix along with price format). •Para 9.7.15- PBG 10% but if there is a risk p u r c h a s e c l a u s e -5%(new feature). Wherever considered in high value contract/long gestation period(not mandatory). • PBG – standard format-DPM - 15. •Indian PSB / Private Sector Bank authorized by Govt. to conduct Govt. business –First class reputed International Bank to be confirmed by SBI in DPM -14 form. Para 12.12.1 relevant(New feature).

8th Project 6 7 8 1 4 5 2 3 Discounted Payback Period 1.00 2.70 6.84 7.84 9.09 13.15

* A corporation must decide whether to introduce a new product line. The new product will have startup costs, operational costs, and incoming cash flows over six years. This project will have an immediate (t=0) cash outflow of $100,000 (which might include machinery, and employee training costs). Other cash outflows for years 1–6 are expected to be $5,000 per year. Cash inflows are expected to be $30,000 each for years 1–6. All cash flows are after-tax, and there are no cash flows expected after year 6. The required rate of return is 10%. The present value (PV) can be calculated for each year:

d. Now rework parts a, b, and c assuming that payments are made at the beginning

=PMT(rate, nper, pv, fv, type) calculates the periodic payment for a loan based on constant payments and a constant interest rate.

If I denotes the interest on a principal P (in dollars) at an interest rate of r per year for t years, then we have

Enter the interest rate you think the investment should achieve (rate), divided by the number of times per year you expect to make deposits into the investment account. For example, if the market interest rate for a

the value of the loan 's collateral if it is in the process of foreclosure or otherwise collateral dependent; or

The functional requirement of the system is divided among the customer and the administrator of the application (travel Agent) and the

This is a basic calculation. The total one year in the future is derived from the present value today, plus the interest that will be earned over the course of the next year. The interest rate has been established at 5%. All that needs to be done is perform a little algebra and solve the problem for the present value. This leaves us with the formula of future value / interest rate = present value.

Left handside: pv of the amount that owe to the bank at the end of 10th year.

The NPV consists of the sum of all the present values of the cash flows of an investment, both incoming and outgoing, with a given “r” as the opportunity cost (discount rate). Once we have obtained the result: