Lab 11.xlsx - ApEc 3002 Assignment 11 Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Totals Keeneland-144,000 32,025 32,025 32,025 32,025 32,025 32,025

Lab 11.xlsx - ApEc 3002 Assignment 11 Year 0 1 2 3 4 5 6 7...

This preview shows page 1 out of 1 page.

ApEc 3002 Assignment 11: 9/2/2018 10:05 Net Cash Flows by Investment Year Keeneland Lexington Tates Creek Nicholasville Pine Meadows 0 -144,000 -297,000 -297,000.00 -297,000 -297,000 -111,975 -244,350 -189,000 -195,750 -290,250 1 32,025 52,650 108,000.00 101,250 6,750 -79,950 -191,700 -94,500 -108,000 -270,000 2 32,025 52,650 94,500.00 87,750 20,250 -47,925 -139,050 -13,500 -33,750 -236,250 3 32,025 52,650 81,000.00 74,250 33,750 -15,900 -86,400 54,000 27,000 -189,000 4 32,025 52,650 67,500.00 60,750 47,250 16,125 -33,750 108,000 74,250 -128,250 5 32,025 52,650 54,000.00 47,250 60,750 48,150 18,900 148,500 108,000 -54,000 6 32,025 52,650 40,500.00 33,750 74,250 80,175 71,550 175,500 128,250 33,750 7 32,025 52,650 27,000.00 20,250 87,750 112,200 124,200 121,500 135,000 135,000 8 32,025 52,650 -54,000.00 6,750 101,250 9 10 11 12 13 14 15 Totals Project Interest Rates (1) NPV (2) IRR (3) Payback Period Profitability based on (1) and (2) Profitability based on (3) 0.05 62,984.39 15% 4.50 Profitable Profitable 0.075 43,580.15 15% 4.50 Profitable Profitable Keeneland 0.1 26,851.01 15% 4.50 Profitable Profitable 0.125 12,347.50 15% 4.50 Profitable Profitable 0.15 -293.53 15% 4.50 Not Profitable Profitable 0.05 43,288.15 8% 5.64 Profitable Not Profitable
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes