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

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

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

View Full Document Right Arrow Icon
Engineering Economics, Excel Cost of Loosing One Semester
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
Some Excel Financial Functions
Background image of page 5

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

View Full DocumentRight Arrow Icon
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
Background image of page 6
Some Excel Financial Functions
Background image of page 7

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

View Full DocumentRight Arrow Icon
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
Background image of page 8
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
Background image of page 9

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

View Full DocumentRight Arrow Icon
Image of page 10
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 Right Arrow Icon
Ask a homework question - tutors are online