Chapter 26 - UN-19J234Growth rate10%Discount...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: UN-19J234Growth rate10%Discount rate15%Year1234567Cash flow-1150.00234.00257.40283.14311.45342.60376.86414.55NPV101.46 <-- =+B6+NPV(B3,C6:I6)IRR17.60% <-- =IRR(B6:I6,0)=B8=B9NPVIRR-176.469.71%Growth5%-47.8213.67%rate10%101.4617.60%15%274.3521.50%=B8Discount rate101.467%10%12%Growth111.09-10.79-82.08rate5%297.62150.7465.1310%515.79339.09236.4415%770.34558.25435.41CF1=C6*(1+$B$2)=D6*(1+$B$2)ABCDEFGHIJK1234567891011121314151617181920212223242526UN-19J234Growth rate10%Discount rate15%Year1234567Cash flow-1150.00234.00257.40283.14311.45342.60376.86414.55NPV101.46 <-- =+B6+NPV(B3,C6:I6)IRR17.60% <-- =IRR(B6:I6,0)=B8=B9NPVIRR101.4617.60%Growth5%rate10%15%=B8Discount rate101.467%10%12%Growth111.09-10.79-82.08rate5%297.62150.7465.1310%515.79339.09236.4415%770.34558.25435.41for Section 19.6 art:NPVIRR-176.469.71%Growth5%-47.8213.67%rate10%101.4617.60%15%274.3521.50%CF1ABCDEFGHIJK123456789101112131415161718192021222324252627282930313233343536UN-19J234Growth rate10%Discount rate15%Year1234567Cash flow...
View Full Document

Page1 / 4

Chapter 26 - UN-19J234Growth rate10%Discount...

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