invest - INVEST.XLS A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

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

View Full Document Right Arrow Icon
INVEST.XLS Values Investment Problem (#7 on Handout) InvestmentMin % Max% Now Year 1 Year 2 Year 3 A 0% 30% ($1.00) $0.20 $1.25 B 25% 100% ($1.00) $0.10 $1.40 C 0% 40% ($1.00) $1.60 Initial Cash $1,000.00 Interest Rate 8.00% Amount Min Max Invest A $0.00 $0.00 $327.94 Invest B $655.87 $273.28 $1,093.12 Invest C $437.25 $0.00 $437.25 Total: $1,093 Now Year 1 Year 2 Year 3 Cash from last period $1,000.00 $371.66 $0.00 $991.68 Cash Balance $344.13 $0.00 $918.22 $1,691.27 A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Background image of page 1

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

View Full DocumentRight Arrow Icon
INVEST.XLS Formulas Investment Problem (#7 on Handout) InvestmentMin Max Now Year 1
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/17/2010 for the course MSIS 623:386 taught by Professor Markowitz during the Fall '09 term at Rutgers.

Page1 / 2

invest - INVEST.XLS A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

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

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