ECN 5600_Chapter01 - -35,000.00 76,078.75 82,165.05 20...

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

View Full Document Right Arrow Icon
Profit and loss Sales 1,000 Cost of goods sold -500 Depreciation -100 Interest -35 Profit before taxes 365 #NAME? Taxes (40%) -146 #NAME? Profit after taxes 219 #NAME? USING SUM TO COMPUTE THE PROFIT AND LOSS A B C 1 2 3 4 5 6 7 8 9
Background image of page 1

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

View Full DocumentRight Arrow Icon
2313.88 2,313.88 $2,313.88 A 1 2 3 4
Background image of page 2
SAVING FOR COLLEGE Interest rate 8% Annual deposit 12,000.00 Annual cost of college 35,000 Birthday 10 0.00 12,000.00 12,000.00 12,960.00 11 12,960.00 12,000.00 24,960.00 26,956.80 12 26,956.80 12,000.00 38,956.80 42,073.34 13 42,073.34 12,000.00 54,073.34 58,399.21 14 58,399.21 12,000.00 70,399.21 76,031.15 15 76,031.15 12,000.00 88,031.15 95,073.64 16 95,073.64 12,000.00 107,073.64 115,639.53 17 115,639.53 12,000.00 127,639.53 137,850.69 18 137,850.69 -35,000.00 102,850.69 111,078.75 19 111,078.75
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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: -35,000.00 76,078.75 82,165.05 20 82,165.05-35,000.00 47,165.05 50,938.25 21 50,938.25-35,000.00 15,938.25 NPV of all payments 6,835.64 #NAME? PV of annuality due? In bank on birthday, before deposit/withdrawal Deposit or withdrawal at beginning of year End of year before interest End of year with interest Critical parameters (sometimes called "value drivers") are in the upper left-hand corner. The actual cost of saving for a college education is discussed in Chapter 2. A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Interest rate 6% A B C 1...
View Full Document

Page1 / 4

ECN 5600_Chapter01 - -35,000.00 76,078.75 82,165.05 20...

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

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