Engineering_Economocs and Excel-Cost of loosing one semester-full-formulas

# Engineering_Economocs and Excel-Cost of loosing one semester-full-formulas

This preview shows pages 1–10. Sign up to view the full content.

Engineering Economics, Excel Cost of Loosing One Semester

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Some Excel Financial Functions Type = 0 or not entered E Set type equal to If payments are due 0 or omitted At the end of the period 1 At the beginning of the period
Present Value Example Cost today of a loan for five terms where you are paying 250 at the end of each period The formula was preceded with a minus to compensate for the negative sign of excel i 0.12 PV \$901.19 n 5 A 250

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Present Value Example Cost today of a loan for five terms where you are paying 250 at the beginning of each period The formula was preceded with a minus to compensate for the negative sign of excel i 0.12 PV \$1,009.34 n 5 A 250
Some Excel Financial Functions

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Future Value Example Cost at the end of a loan for five terms where you are paying 250 at the end of each period The formula was preceded with a minus to compensate for the negative sign of excel i 0.12 PV \$1,588.21 n 5 A 250
Some Excel Financial Functions

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Payment Payment of a loan for five terms where the present value is 901.19 The formula was preceded with a minus to compensate for the negative sign of excel i 0.12 PV \$250.00 n 5 PV 901.19
Try this old example with excel A new widget twister, with a life of six years, would save \$2,000 in production costs each year. Using a 12% interest rate, determine the highest price that could be justified for the machine. Although the savings occur

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This document was uploaded on 12/28/2011.

### Page1 / 15

Engineering_Economocs and Excel-Cost of loosing one semester-full-formulas

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online