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?

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

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

* 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:

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

Using Microsoft Excel to calculate the present value of a potential investment is a simple task once you learn the syntax of the required formula. Follow these easy steps and you can calculate present value using Microsoft Excel easily and quickly.

•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).

PV = FV / (1+d)^t where d = discount rate and t = number of time periods. The three PV values

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

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

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: