ACCT 2001> Use the PV table.
Capital Investments - Discounted cash flows Brook Sorenson, the owner of a nine-hole golf course on the outskirts of Ottawa, Ontario, is considering the proposal that the course be illuminated and operated at night. Ms. Sorenson purchased the golf course four years ago for $90,000. Last year's revenue for the 28-week season was $24,000 and total expenses were $16,500 The required investment in lighting the course is $20,000 consisting of 150 lamps and a generator Ongoing costs are as follows. 1. The 150 lamps consumed 1000 watts each. There are 1000 watts per one kilowatt 2. Electricity to power the 150 lamps cost $0.032 per kilowatt-hour 3. Expected average hours of operation per night are five. 4. Because of occasional bad weather it is estimated that the total number of nights in a year that golf will be offered is 130. 5. Labour for keeping the course open at night is $50 per night 6. Lamp replacements are estimated at $300 per year. 7. Other annual maintenance costs to bperate the night golf are estimated at 4% of the initial investment for years 182 and increasing to 5% of the initial investment for years 3,4,5. 8. Annual property taxes will increase due to the addition of night golf and this is estimated at 2% of the initial investment for years 182 and increasing to 3% of the initial investment for years 3.4&5. 9. Revenue from night golf is expected to be $140 per night of operation for Years 1 & 2 dropping to $110 per night for years 3,4 & 5. 10. The lighting equipment (lamps) has a salvage value of $7.000 at the end of year 11. Ms. Sorenson's desires a 10% rate of return (discount rate) five Required: You have been hired as an outside consultant to write a report to Brook Sorenson recommending whether she should proceed with the illumination of the golf course for night use. Your report should analyze the relevant quantitative (Net Present Value) and qualitative aspects of the decision and also consider any issues that will impact the decision. Note: a) Use the Present Value tables found on pages 756, 757 of your text for the Net Present Value calculations. b) Recreate the "Answer" form found at the end of the exam in excel (preferably) or Word for the quantitative portion of your answer. Table B: Present Value of Annuity of $1 Present Value of Annuity of 1 Perinds 19 2 10% STI 14% 204 1 1970 TH HNT MIRE EL . CH WINNER INT 1 DE E ||||| INIT 085 SEL TIT IT ZIPS 9 SC WWF 19 SIS Witte TEET DET FIAT 102 4 7 9 TIRE MA TEVE NET MV SO NE TE . DON 10 YTI 0.25 0.0 0.0 0.0 0.0 0.0 LAM 1147 114 1.52 2778 2.720 2673 2.7 2.461 2. 4413 16 1411 3.27 1.127 491 6473 C 4. 4 4 RA 776 70 1933 7. 7 9113 119 495 . 4.99 74 141 12.11 34 w711 11.12411470 YA HAN 4 19.821 3 2 0 46 19.122 123 124 5:31 27 28 1929 1719 16 1995 . SH 10 ES Us LAY IN 1 11 IS HE TC UN SIEN LINE 1 VARO THE PEN 11 NOT DEI NII! HII I HINS FHN P 9 TIF 1 29. vo WS HIE HITI ET IN PENI TOTE II NI HIE HICH I'S W ** V DE 3012 HE A Present Value and Future Value Tables Table A: Present Value of $1 Pro Vahe of 51 Porin 15 1 N 10% 12% 14% 16% 1320 990 WO Three IN THOM WE 471 475 000 19) 14.41 . TI 22.02.09 ONS. AR A. 00751 KAN 04 . 11 BATT NE 1 ITU ONE LE we INT 21 WA ORN Vio re 11 11 13 TE 4 RE M TER NI 16 THE 11 SIE IN w BI . SO IN HE w IND IN S 0.00 00 1000 TER TOT MOTE The
