Class Demo Excel - Deprec Deprec of Year Period Period...

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

View Full Document Right Arrow Icon
Discount Factor Calculations i = 10.00% Periods Find F Find P Find A Find A N Given P Given F Given P Given F 1 1.1000 0.9091 1.1000 2 1.2100 0.8264 0.5762 3 1.3310 0.7513 0.4021 4 1.4641 0.6830 0.3155 5 1.6105 0.6209 0.2638 6 1.7716 0.5645 0.2296 7 1.9487 0.5132 0.2054 8 2.1436 0.4665 0.1874 9 2.3579 0.4241 0.1736 10 2.5937 0.3855 0.1627 Net Present Value Example Rate: 5.00% 10.00% 15.00% Year Cash Flow 0 -50,000 1 6,000 2 6,000 3 6,000 4 6,000 5 6,000 6 8,000 7 8,000 8 8,000 9 8,000 10 8,000 NPW: $3,114.93 -$8,425.04 -$16,554.16 IRR Example
Background image of page 1

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

View Full DocumentRight Arrow Icon
Year 0 -15,000 1 5,000 2 5,000 3 5,000 4 5,000 5 5,000 6 5,000 7 5,000 IRR 27.12% IRR Example Year Cash Flow 0 -50,000 1 6,000 2 6,000 3 6,000 4 6,000 5 6,000 6 8,000 7 8,000 8 8,000 9 8,000 10 8,000 IRR 6.18% MACRS Example Beginning
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Deprec Deprec of Year Period Period Depreciation Year Book Value Start End Amount 1 40000 0.5 $4,000.00 2 36000 0.5 1.5 $7,200.00 3 28800 1.5 2.5 $5,760.00 4 23040 2.5 3.5 $4,608.00 5 18432 3.5 4.5 $3,686.40 6 14745.6 4.5 5.5 $2,949.12 7 11796.48 5.5 6.5 $2,621.44 8 9175.04 6.5 7.5 $2,621.44 9 6553.6 7.5 8.5 $2,621.44 10 3932.16 8.5 9.5 $2,621.44 11 1310.72 9.5 10 $1,310.72 End of Year Book Value $36,000.00 $28,800.00 $23,040.00 $18,432.00 $14,745.60 $11,796.48 $9,175.04 $6,553.60 $3,932.16 $1,310.72 $0.00...
View Full Document

This note was uploaded on 09/26/2008 for the course CE 395 taught by Professor Hitchcock during the Summer '05 term at University of Alabama at Birmingham.

Page1 / 6

Class Demo Excel - Deprec Deprec of Year Period Period...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online