TIRM.xlsx - Ao TIR 1 TIR 2 Tasa de Inversin Tasa de Prestmo...

Info icon This preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Año FE TASA 0 Q (4,000.00) 0% Q (500.00) 1 Q 3,500.00 2% Q (251.52) 2 Q 2,500.00 4% Q (58.56) 3 Q 1,500.00 6% Q 88.64 4 Q 500.00 8% Q 198.08 5 Q (500.00) 10% Q 276.35 6 Q (1,500.00) 12% Q 328.88 7 Q (2,500.00) 14% Q 360.18 16% Q 373.99 TIR 1 4.73% 18% Q 373.39 TIR 2 37.204% 20% Q 360.97 22% Q 338.88 Tasa de Inversión 15% 24% Q 308.91 Tasa de Prestámo 8% 26% Q 272.57 TIRM 13.64% 28% Q 231.11 30% Q 185.57 Si la TMAR es menor al TIRM Acepto 32% Q 136.83 Si la TMAR es mayor a la TIRM Rechazo 34% Q 85.64 36% Q 32.60 38% Q (21.77) 40% Q (77.03) 42% Q (132.84) 44% Q (188.88) 46% Q (244.92) 48% Q (300.75) 50% Q (356.20) 52% Q (411.12) 54% Q (465.41) 56% Q (518.97) 58% Q (571.74) 60% Q (623.66) 62% Q (674.67) 64% Q (724.76) 66% Q (773.89) 68% Q (822.05) 70% Q (869.23) 72% Q (915.43) 74% Q (960.66) 76% Q(1,004.91) 78% Q(1,048.19) 80% Q(1,090.52) 82% Q(1,131.90) 84% Q(1,172.37) 86% Q(1,211.92) 88% Q(1,250.58)
Image of page 1

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

View Full Document Right Arrow Icon
90% Q(1,288.36) 92% Q(1,325.29) 94% Q(1,361.38) 96% Q(1,396.66) 98% Q(1,431.14) 100% Q(1,464.84)
Image of page 2
0% 20% 40% 60% 80% 100% 120% Q(2,000.00) Q(1,500.00) Q(1,000.00) Q(500.00) Q- Q500.00 Chart Title
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
High Low High-Low Cost 13400 10310 -3090 Capacity 150 100 Benefit 4000/year 3330/ year 700 Life 5 5 5 TIR 15.03% 18.44% 4.302% HIGH LOW 0% Q6,600.00 Q6,340.00 1% Q6,013.72 Q5,851.93 2% Q5,453.84 Q5,385.82 3% Q4,918.83 Q4,940.42 4% Q4,407.29 Q4,514.57 5% Q3,917.91 Q4,107.16 6% Q3,449.46 Q3,717.17 7% Q3,000.79 Q3,343.66 8% Q2,570.84 Q2,985.72 9% Q2,158.61 Q2,642.54 10% Q1,763.15 Q2,313.32 11% Q1,383.59 Q1,997.34 12% Q1,019.10 Q1,693.90 13% Q668.93 Q1,402.38 14% Q332.32 Q1,122.16 15% Q8.62 Q852.68 16% (Q302.83) Q593.40 17% (Q602.62) Q343.82 18% (Q891.32) Q103.48 19% (Q1,169.46) (Q128.08) 20% (Q1,437.55)
Image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
Image of page 7

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

View Full Document Right Arrow Icon
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern