Discounted Cash Flow Techniques Essay Example for Free

Discounted Cash Flow Techniques Essay A brief tutorial on Excel financial functions (problems to follow) You may find the following Excel, built-in financial functions helpful when analyzing the problems below. (To access these functions, select Insert, Functions, and choose Financial.) =PV(rate, nper, pmt, fv, type) returns the present value of a series of cash flows. =FV(rate, nper, pmt, pv, type) returns the future value of a series of cash flows. =PMT(rate, nper, pv, fv, type) calculates the periodic payment for a loan based on constant payments and a constant interest rate. =NPER(rate, pmt, pv, fv, type) returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. =NPV(rate, range) returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values). (Warning: By convention, NPV calculates the net present value one period before the first cash flow.) =IRR(range, guess) returns the internal rate of return for a series of cash flows. In these functions, rate = the discount, or interest rate. nper = number of periods. pmt = annual uniform payment. fv = future value, or future cash flow. type is a logical value allowing you to specify if cash flows occur at the end or the beginning of the period. A value of 1 indicates beginning of period, 0 or omitted indicates end of period. pv = present value. range = the cells on your spreadsheet containing the cash flows you want to analyze. For example, if the cash flows are in the first 10 rows of column A, the entry for range would be a1:a10. guess = your guess as to the internal rate of return. This helps the computer get started and may be left blank. An example Suppose you want to know the present value of $100 per year for 19 years and $500 at the end of the 19th year when the interest rate is 13 percent. Select a spreadsheet cell and enter =PV(0.13,19,100,500). Excel will return ($742.83). This is the amount one should be willing to pay today to receive the indicated stream of cash flows when the interest rate is 13 percent. Problems 1) An investment costing $50,000 promises an after tax cash flow of $18,000 per year for 6 years. a. Find the investments accounting rate of return and its payback period. b. Find the investments net present value at a 15 percent discount rate. c. Find the investments profitability index at a 15 percent discount rate. d. Find the investments internal rate of return. e. Assuming the required rate of return on the investment is 15 percent, which of the above figures of merit indicate the investment is attractive? Which indicate it is unattractive? 2) A $1,000 par value, 10 percent coupon bond matures in 20 years. If the price of the bond is $1,196.80, what is the yield to maturity on the bond? Assume interest is paid annually. 3) Ten years ago you invested $1,000 for 10 shares of Trublock common stock. You sold the shares recently for $2,000. While you owned the stock it paid $10.08 per share annual dividends. What was your rate of return on Trublock stock? 4) Having heard of your knowledge of present value techniques, you have been asked to testify as an expert witness in the following lawsuit. Several homeowners in a nearby community have organized to protest against alleged gouging on the part of a local lending institution. One resident presents his payment book as evidence. The resident has a 30-year, fixed rate loan at 6 percent interest for $200,000. He got the loan 10 years ago and has been making equal annual payments of $14,529.60 ever since. He observes that he has paid the lending company $145,296.00 yet his payment book indicates that the principal due on the loan has only declined by $33,345.40. He presents this as obvious proof of gouging on the part of the money changers. Do you agree? Why, why not? 5) In 1984, the city council of the town of Patterson agreed that their community badly in need of a modern hotel that would cost approximately $25 million. To finance construction members of the council organized the Patterson Hotel Corporation. Through strenuous promotion they raised $15 million by selling 15,000 shares of stock at $1,000 per share. They secured the other $10 million necessary to build the hotel as a loan provided by a local bank on a 10 year, 14 percent mortgage that called for uniform annual payments sufficient to pay interest and to extinguish the debt at the end of 10 years. Upon completion, the Patterson Hotel Corporation leased the hotel to a national company that operated a chain of hotels. The lease ran for 30 years and contained a clause permitting the lessee to purchase the hotel for $10 million at the end of the 30-year period. The lessee agreed to furnish the hotel and pay all taxes (including income taxes) and operating expenses, and was to meet the interest and repayment obligations on the mortgage during the first 10 years of the lease. During the last 20 years of the lease, the operating company agreed to make payments sufficient to permit annual dividends of $400 per share. No payments at all were to be made to the stockholders during the first 10 years. This was the most favorable operating contract that Patterson Hotel Company was able to negotiate. When stockholders, many of whom had bought stock under considerable pressure, learned that there was no prospect of dividends for 10 years, they were quite upset, and a number of them were anxious to sell their stock. Conrad Billings, a local businessmen in the original group that promoted the hotel, was reported to be buying stock from some of these disgruntled stockholders at $750 a share. Some locals were heard to comment that Conrad Billings was a clever old bastard who was taking advantage of his public-spirited neighbors. There were remarks regarding the fat dividends he would be receiving after the mortgage was paid off. One man was said to have declined Billings’ offer of $750 a share and to have commented publicly that nobody was going to get his stock unless they paid what it was worth. Make whatever assumptions and calculations you find necessary to estimate the fair value of the stock. Was $750 a share really too low a price? 6) You need four new tires for your car. You can buy cheap retread tires for $25 a piece and replace them every 20,000 miles or you can spend $40 per tire and replace them every 40,000 miles. If money has an opportunity cost of 10 percent to you, how many miles must you drive annually to warrant the more expensive tires?

Personal Narrative: My Favorite Noncompetitive Activities :: essays research papers

My Three Favorite Noncompetitive Activities The three different activities I like is bicycling, camping, and hiking. I got interested in camping because, you get to see the outdoors, and see the stars, and eat burnt marshmallows. This is very fun. Also, because this is a group activity. I also got interested in hiking because, it keeps you in shape, and its just plain fun and it is a dual activity. I got interested in bicycling because, you get to travel around in it, and it keeps you in shape, and it is very fun. And, because it is an individual activity. When I went to camp I got to fish, swim, and tell scary stories, and sleep in tents. It was a lot of fun. We got to pick our camp grounds. We got to make camp fires, so we can cook our food. We are also able to see the stars at night. We can?t really see the stars in the cities, because there is too much light. But anyways we had a lot of fun camping. Bicycling is also a lot of fun. You can travel anywhere on a bicycle. It keeps you in shape, and it is fun. But you have to be careful of glass or nails, or else your tires might become flat. But other than that, it can be a lot of fun. You can get a really strong workout with a bicycle. You can have races against other people. You can take it with you camping and to the beach. Hiking is a lot of fun. It keeps you in good shape. It exercises your body. It helps your brain to think and learn. You can also race against other people. You can see the great out doors if you are hiking in the woods. You can see different kinds of birds and trees and people. Well I can tell you this much, hiking is a lot of fun.

Observation Essay

Asian game was running in Inches. Since my friend from Hong Kong Is one of the representatives for Hong Kong girl squash team, and I wanted to watch any of the Aslant game matches, therefore, I chose to watch squash competition at last. It was on the 24th September. The competition was held in Hourly Squash Court. I took the wrong line of the subway since it was quite far from SHCOON and still, I was not too familiar with the subway system. As I interchanged station In Guru to Donnas of blue line 1, I saw a slight difference for people In the train from the milliamp green line 2.There were more elderly In the train. I was surprised to be asked to sit down by a kind lady. I felt like people have warmer hospitality than those from the city centre. After I entered the competition venue, I sit in front of the court that Hong Kong was playing with China. There were a few spectators as I expected. As know, squash is not a popular sport among all so it is really common to have a few spectat ors. There were 4 courts undergoing competitions In the venue. I looked around and I was shocked to see at the middle of the venue, there were full of people.I was wondering if the game was exciting so I walked towards that court. It was hard to get there because there were really a lot of people. Even the staffs heading there to see the game. I finally found a space. It was the women game which South Korea versus Japan and the score was even. I was really shocked by the full house spectators. Most of them are Korean and what surprised me most Is that many of them got banners or cheering tools. They yelled the cheering songs and slogans loudly to support the Korean team. At the same time, my Hong Kong friend had finished the game and came to me.She as also attracted by the loud cheering sound and was curious about the people. She said, â€Å"It would be so good If Hong Kong would ever have so many people supporting me. † I asked, † Would there ever be that many people w atching squash game In Hong Kong? ‘ she answered, † Even If there Is many spectators, they would never bring banners and cheer together loudly! † It was a tight game. Both Japanese and Korean players were well trained and passionate to win. I was amazed by Koreans passion to support the national team because when I went out of the venue to another venue, I could still hear their cheering sound.Korea finally won the game. After the game, there were so many questions pop-up In my mind. The first question is why is Korean so passionate to cheer for the team? I have come up with this question because squash is really not a popular sport and especially for women's match, it is not exciting as the men's. I have think of some possible answers. Firstly, since South Korea is the host country of the Asian game, people are proud and so they put their effort in supporting the team. Secondly, because the match was battling with Japan, which Is a country who always has rivalries with Korea, so Korean Observation essay I came across this situation between a Chills employee and a guest. I walked in through the to-go area, to pick up an order. As I approached the register I noticed a lady just standing there on her cell phone ignoring the to-go specialist. Since she was there before I was I kindly waited till she spoke to the young man. I heard him say repetitively welcome to chills† in the most friendliest tone ever. The lady was standing with her one hand on her hip and continued to have her conversation on her phone. The young man opened the register and began to count the money InsideIt. After he called her once again welcoming her, but at this point he was a bit agitated and you could tell within his voice. The women finally hung up her phone, yet still made no eye contact with the young man. She looked around the area grabbed a to-go menu, while glancing she said her name and was wondering why her order was taking so long. Already frustrated with the phone call she Just had, she just deci ded to take It out on the young man. Blaming him for getting her food late. According to her it was horrible service.Aggravatingly yelling â€Å"where Is your anger, I demand to speak to him! † with her hands in his face. He calmly said â€Å"yes ma'am, Ill go ahead and call him over here. † The manager approached both of them and asked what the problem was. The women went off saying he was rude because he ignored her presence, never welcomed her, nor asked for her name. Rolling her eyes claiming the employee was on his cell phone, testing people instead of doing his lob. The Chills manager apologized and to please the guest he gave the women a discount as well.After everything was taken care of she put on her black sunglasses ND as she was walking away she turned around and impolitely told the employee â€Å"thank for the horrible experience! † When I went up for my order I made sure I helped the young man clear his name. He did his Job, and he did it very well . The woman was obviously already in a bad mood as she walked into the restaurant, maybe she was having a bad day and that one phone call did not help. For her to take out her anger on a complete stranger is Just not right. Observation essay By bind lady Just standing there on her cell phone ignoring the to-go specialist.Since she was ere phone. The young man opened the register and began to count the money inside it. After he called her once again welcoming her, but at this point he was a bit she Just decided to take it out on the young man. Blaming him for getting her food late, according to her it was horrible service. Aggravatingly yelling â€Å"where is your ma'am, I'll go ahead and call him over here. † The manager approached both of them job. The Chills manager apologized and to please the guest he gave the women a â€Å"thank you for the horrible experience! † When I went up for my order I made sure I

A Brief Note On The Local Community Of Kilmaurs, East...

KILMAURS COMMUNITY Local Investigation Table of Contents Terms of Reference 2 Procedure 2 Findings 2 Facilities and Services 2 Education 3 Community Groups 4 Views of the Locals 4 Issues facing the community 5 Conclusion 5 Recommendations 6 Appendix 7 Bibliography 9 Terms of Reference On 24 September 2014, Helen Domigan was instructed by Ms Rachel Rae, Communities lecturer, to compile a formal report on my local community of Kilmaurs, East Ayrshire. The written report was to include recommendations and was to be submitted to Ms Rachel Rae on 17 December 2014. Kilmaurs is a village in East Ayrshire, around 2 miles north of Kilmarnock town. The village has a population of approximately 2601 residents. It has substantial history with many of the historic buildings still there to see in and around the village. It offers great travel links to Glasgow whether it be by bus, train or car. Throughout this report I hope to learn more about my local village and enjoy the opportunity to gather information through speaking with the locals. Procedure In order to gather the relevant information, the following procedures were adopted: A questionnaire (see appendix 1) was created which was handed out to 20 local residents on 8 October 2014 and were returned on 20 November 2014 Relevant material was researched online about the local services and facilities available to residents and visitors to Kilmaurs. Interviews with three local residents