MOR$ 23%D B Capital Budget Assignment.pdf (1 page) Present your results using an Excel spreadsheet. Use NPV, IRR and Payback to evaluate Mildred's proposed investment Compare the DCF methods to the payback method A kilowatt hour is 1000 watts per hour Mildred's 10% per annum target can be considered a hurdle rate 11-53 Discounted Cash Flow, Uneven Revenue Stream, Relevant Costs Mildred Driver, the owner of a nine-hole golf course on the outskirts of a large city, is considering proposal that the course be illuminated and operated at night. Ms. Driver purchased the course earl last year for $480,000. Her receipts from operations during the 28-week season were $135,000. Tota disbursements for the year, for all purposes, were $84.000. The required investment in lighting this course is estimated at $90,000. The system will require 300 lamps of 1,000 watts each. Electricity costs $.08 per kilowatt-hour. The expected average hours of operation per night is 5. Because of occasional bad weather and the probable curtailment of nigh operation at the beginning and end of the season, it is estimated that there will be only 130 nights of operation per year. Labor for keeping the course open at night will cost $75 per night. Light bulb cose is estimated at $1,500 per year, other maintenance and repairs, per year, will amount to 4% of the ini- tial cost of the lighting system. Annual property taxes on this equipment will be about 1.7% of its initial cost. It is estimated that the average revenue, per night of operation, will be $420 for the first 2 years Considering the probability of competition from the illumination of other golf courses, Ms. Driver decides that she will not make the investment unless she can make at least 10% per annum on her investment. Because of anticipated competition, revenue is expected to drop to $300 per night for years 3-5. It is estimated that the lighting equipment will have a salvage value of $35.000 at the end of the 5-year period. Using DCF techniques, determine whether Ms. Driver should install the lighting system. + 100% tv 4 MOR$ 23%D B Capital Budget Assignment.pdf (1 page) Present your results using an Excel spreadsheet. Use NPV, IRR and Payback to evaluate Mildred's proposed investment Compare the DCF methods to the payback method A kilowatt hour is 1000 watts per hour Mildred's 10% per annum target can be considered a hurdle rate 11-53 Discounted Cash Flow, Uneven Revenue Stream, Relevant Costs Mildred Driver, the owner of a nine-hole golf course on the outskirts of a large city, is considering proposal that the course be illuminated and operated at night. Ms. Driver purchased the course earl last year for $480,000. Her receipts from operations during the 28-week season were $135,000. Tota disbursements for the year, for all purposes, were $84.000. The required investment in lighting this course is estimated at $90,000. The system will require 300 lamps of 1,000 watts each. Electricity costs $.08 per kilowatt-hour. The expected average hours of operation per night is 5. Because of occasional bad weather and the probable curtailment of nigh operation at the beginning and end of the season, it is estimated that there will be only 130 nights of operation per year. Labor for keeping the course open at night will cost $75 per night. Light bulb cose is estimated at $1,500 per year, other maintenance and repairs, per year, will amount to 4% of the ini- tial cost of the lighting system. Annual property taxes on this equipment will be about 1.7% of its initial cost. It is estimated that the average revenue, per night of operation, will be $420 for the first 2 years Considering the probability of competition from the illumination of other golf courses, Ms. Driver decides that she will not make the investment unless she can make at least 10% per annum on her investment. Because of anticipated competition, revenue is expected to drop to $300 per night for years 3-5. It is estimated that the lighting equipment will have a salvage value of $35.000 at the end of the 5-year period. Using DCF techniques, determine whether Ms. Driver should install the lighting system. + 100% tv 4
