Premium Essay

Cittic Tower Ii Excel

In: Business and Management

Submitted By stephencao2503
Words 1882
Pages 8
EXECUTIVE SUMMARY:

The company should decide whether to go ahead with the Citic Tower II project or not. The following alternatives can be used to address the problem: NPV: Net present value (NPV) is defined as the total present value (PV) of a time series of cash flows. It is a standard method for using the time value of money to appraise long-term projects. The method is used for capital budgeting, and widely throughout economics, it measures the excess or shortfall of cash flows, in present value terms, once financing charges are met.

OPTION PRICING: The buyer of a call option gets the right to buy the underlying the underlying asset at affixed price, where as the buyer of a put option obtains the right to sell the underlying asset at a fixed price. Alternatives to the binomial model In the binomial option pricing model, the underlying asset and risk free lending or borrowing are combined to create a portfolio that had the same cash flows as the option being valued; we called this portfolio the replicating portfolio. Although the binomial model provides the intuitive feel for the determinants of the option value, it requires a large number of inputs in terms of expected future prices at each node. As we can make time periods shorter in the binomial model, we can make assumptions about asset prices. We can assume that price changes becomes smaller as time periods approaches zero leading to continuous price process. THE BLACK – SCHOLES MODEL: When the price process is continuous, that is price changes become smaller as time period gets shorter, the binomial model for pricing options converges on the Black – Scholes model. The model allows us to estimate the value of any option using a small number of inputs, and it has shown to be remarkably robust in valuing many listed options. The Black-Scholes model is used to calculate a theoretical call price (ignoring…...

Similar Documents

Premium Essay

Excel

...additional charge of $ 50.00 for each returned check. The Landlord has the ight to require that all payments be made by money order, cashiers check or certiied check and that the entire payment be made by one instrument payable to □? Landlord OR^f-3 Managing Agent. 5. FAILURE TO PAY RENT. Failure to pay any installment of rent or additional fee when due is a default under this Lease. Tf Tenant does not pay rent within 5 days after receipt of written Nolice of non-paymenl and intention to terminate Lease, the Landlord may terminate this Lease. Unpaid rent for the entire remaining Lease Term shall become immediately due and payable. Upon termination, the Landlord shall be entitled to: A Possession of ihe Premises. 13. Any uiipuid ii-nt, .iJJiiiou.il iuii, .md ddniiniouuiiv. Ui.u_v.&, t :. AnvcfiiniJiofi |iwHim*'l PgeloT10 ;,,*•?!)■?*.*, Umio-.ntfutnnwvsn*.iAiHrCO(Mfacl"* vov/S(tw^o Ircm AytnKojmy. uC iiaovv Kiwwni* bitc )01 nt. IX /MiM. IHIHJCWMWH S l/\ CZ_1 \.^> Please tniita). Tenant. IV H L-eJ / r r* -..ikuo.u 7Li+_ X)% Ml\ - /OK/Ofll 1 Q •? UiAM (GMT-07 ' 0 0 )* Pg2Pg2 01/25/2011 11:51 FAX 7034555420 D. Court costs and reasonable attorney's fees, and E. All other remedies provided by law or equity. 6. MANAGEMENT. _/A Ofice Address: ......

Words: 1321 - Pages: 6

Premium Essay

Mereweather Tower

...Heritage Conservation of Merewether Tower & its impact on urban morphology Qurat-ul-Ain Rehman Abstract The past should never be forgotten as it constitutes an important part of the civilization of mankind. Historic monuments may contain some bitter and sweet memories therefore it should be preserved for future generations to know the life their ancestors were living. Although important, many historic sites are usually torn down in order to make room for development but there are people who believe that these sites should be saved from the hammer. Conserving these sites takes a lot of hard work and dedication from the local authorities but it can transform the morphology of the region and reward the developers for their hard work. Karachi was home to British troops in the 19th century and is therefore rich in Victorian era buildings. Most of these buildings are in a bad shape but the government is working to preserve them. Although the pace of redevelopment is slow, the fact that work is going on gives a person relief that the historic buildings of the city will be preserved. One such building is the Merewether tower; this iconic structure is one of few structures that are in a good condition, but sources claim that from the inside, it is slowly being degraded. Once the gateway to the city, it has been forgotten by many although its name is very common. The objective of this research is to document the existing conditions of the tower and the surroundings so that......

Words: 4143 - Pages: 17

Premium Essay

Excel

...ADVANCED EXCEL TRAINING Quality Management Objective  To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced  ® EXCEL Topics Working with Data Lists Naming Cells and Ranges   Conditional Functions Lookup Functions   Pivot Tables Data Validation  Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box  1. Select the cell or range you want to name.  2. Click the Name box on the formula bar.  3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.  4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional......

Words: 1579 - Pages: 7

Free Essay

Excel

...Project Description: You are an analyst for an art gallery that is an authorized Greenwich Workshop® fine art dealer. You prepared a list of artwork by James Christensen and need to organize the data using an outline, subtotals, PivotTables, and PivotCharts to aid you in analyzing the data, which you will do in this project. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the file named Exploring_e05_Grader_EOC.xlsx. 0 2 Sort the data on the Subtotals worksheet first by the Type column, then by the Art column, both in alphabetical order. 4 3 Subtotal the data at each change in Type. Identify the highest issue price, estimated value, and percent increase. 10 4 Add an automatic outline to the Subtotals worksheet. Group the first and last name columns. Collapse the names columns, and then collapse columns created by the outline (G, H, and I). 7 5 Create a PivotTable on a new worksheet using the data on the Christensen worksheet in the range A1:J19. Use the Type, Est. Value, and Issue Price fields and use the default locations in the PivotTable Layout. 8 6 Modify the Issue Price and Est. Value values to determine the average issue price and average estimated market value by type. 6 7 Insert a calculated field named % Change in Value to determine the percent change in values by type. Format the values in the new column as percentages......

Words: 312 - Pages: 2

Free Essay

The Stone Tower

...October 6, 2012 CRW150 - Introduction to Creative Writing - Class # 27071 Doris Patton Midterm Part 1: Creative Story The Stone Tower 1 “Can you get a clear shot Draz?” asked Tankus. “If he takes a step forward I can,” answered Draz. Daylight was disappearing in the forest as dusk began to set, but there was still enough light for the two friends to observe the movements of the tracker who had been silently tailing them for a good part of the day. “What kind of tracker is he?” said Tankus. “He looks like some kind of rat or something.” The tracker was hunched over now, trying to pick up their scent which he had lost several yards back in the brush. Skin like beaten old leather stretched over his long thin bones giving him a scare-crow like appearance, but it was the long, pointed nose set between black, beady eyes that made him look like a rat. He edged forward suddenly picking up their scent again. "Fwoooosh!" Draz’s laser arrow found its mark in the tracker’s temple. “Okay that’s cool,” said Tankus, “we know he’s been with us for several miles, so where do you suppose the rest of his entourage is? Where are the meat and the brains that sent out this dog?” “I don’t know,” said Draz, “I just hope we have enough fire power to keep them back. I don’t know how much more time Kalem needs to break into that old place.” Tankus raked his blonde goatee with his long nimble fingers, trying to add things up in his mind quickly. He was the planner of the group......

Words: 1037 - Pages: 5

Premium Essay

Excel

...Microsoft Excel 2010 Formulas & Functions  Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 5629 - Pages: 23

Free Essay

Towers

...Towers Committee Minutes- 9/05/11 Present: Matt Best, Ali, Gianni, James, KC, Mike, Dizzy, TJ, Callum, Hayley, Piers, Chelsea, David, Charlie, Fran, Jack. Apologies: Simon Matt Best: -Audit next week -Grills for the BBQ? Ali: -A White towers tiger mascot from china is now on its way!! -International Friday, unfortunately I’m not here…so massive push to get people involved to make sure we get hall of the world -Will sort out Towers Hall of the year application -Technically only 10 fresher Reps can be allowed in towers next year. If you email Matt with the no. of fresher reps we plan on having (WITH JUSTIFICATION!!) Gianni: -Bouncy castle + BBQ before Final Friday Fling -Storage room key given to Ali Jones, make sure he keeps a record/track of who has the key -Bottle Collection this Thursday which Fresher reps -Blackout on the 26th when we are at the summer ball Sports: -well done at IMS athletics, we got through to lots of finals! -upcoming events (rounder’s Tues, tennis Wed, men’s water polo soon, golf next Wednesday?) -IMS awards 25th June? Social: -Sponsorship meeting tonight -Good news for next year with Revs!! With both Luke and Rich both working there we can get priority and hopefully get sponsorship and good deals. -Start planning Final Friday Fling -Selling Tickets for summer ball (£25) PUSH people to purchase as places will fill up quickly. Sub wardens on sober duty? -Paintballing Cancelled due to lack of numbers -risk assessment...

Words: 475 - Pages: 2

Premium Essay

Excel

...New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal PROJECT DESCRIPTION Devon Hastings is the human resources director for Spring Software, a software development company in Cambridge, Massachusetts. He has created a workbook for employees to use in recording the hours they work. He would like your help finishing the timesheet. GETTING STARTED * Download the following file from the SAM website: * NP_Excel2013_T3_P1a_FirstLastName_1.xlsx * Open the file you just downloaded and save it with the name: * NP_Excel2013_T3_P1a_FirstLastName_2.xlsx * Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. * With the file NP_Excel2013_T3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. On the Employee List worksheet, select cells A1:B1 and then use the Format Painter copy the format only to the range A2:B9. 2. In cell B1 enter bs001, in cell B2 enter cg001, in cell B3 type dh001, and then use Flash......

Words: 790 - Pages: 4

Free Essay

Excel

...động kinh doanh tham gia hợp nhất chịu sự kiểm soát của cùng một bên hoặc một nhóm các bên cả trước và sau khi hợp nhất kinh doanh và sự kiểm soát đó là lâu dài. Nợ tiềm tàng: Theo Chuẩn mực kế toán số 18 “Các khoản dự phòng, tài sản và nợ tiềm tàng”, nợ tiềm tàng là: a) Nghĩa vụ nợ có khả năng phát sinh từ các sự kiện đã xảy ra và sự tồn tại của nghĩa vụ nợ này sẽ chỉ được xác nhận bởi khả năng hay xảy ra hoặc không hay xảy ra của một hoặc nhiều sự kiện không chắc chắn trong tương lai mà doanh nghiệp không kiểm soát được; hoặc b) Nghĩa vụ nợ hiện tại phát sinh từ các sự kiện đã xảy ra nhưng chưa được ghi nhận vì: i) Không chắc chắn có sự giảm sút về lợi ich kinh tế do việc phải thanh toán nghĩa vụ nợ; hoặc ii) Giá trị của nghĩa vụ nợ đó không được xác định một cách đáng tin cậy. Kiểm soát: Là quyền chi phối các chính sách tài chính và hoạt động của doanh nghiệp nhằm thu được lợi ích kinh tế từ các hoạt động của doanh nghiệp đó. Ngày trao đổi: Là ngày mua khi việc hợp nhất kinh doanh được thực hiện trong một giao dịch đơn lẻ. Khi việc hợp nhất kinh doanh liên quan đến nhiều giao dịch, ví dụ việc hợp nhất đạt được theo từng giai đoạn bằng việc mua cổ phần liên tiếp, ngày trao đổi là ngày mỗi khoản đầu tư đơn lẻ đó được ghi nhận trong báo cáo tài chính của bên mua. Giá trị hợp lý: Là giá trị tài sản có thể được trao đổi hoặc giá trị một khoản nợ được thanh toán một cách tự nguyện giữa các bên có đầy đủ hiểu biết......

Words: 10592 - Pages: 43

Premium Essay

Excel

...P rate and y = T P rate. Possible values range from (0, 0) to (1, 1). The “classification” that assigns “Test Negative” to every score has FP rate of 0 and TP rate of 0, represented as point (0, 0). The “classification” that assigns “Test Positive” to every value has FP rate of 1 and TP rate of 1, represented as the point (1, 1). Joining all known (x, y) points by straight lines, the area under the resulting empirical ROC curve is known as the Area Under the Curve or AUC. The AUC ranges from 0.5, for a test no better than chance, to 1, for a perfect test. The Area Under the Curve is calculated by the summation of the average height multiplied by the width, as follows: ! ! T P (n) + T P (n + 1) 1 2 (F P (n + 1) F P (n)) See Excel Spreadsheets for examples of calculating each point on an empirical ROC Curve. 2 2.1 2.1.1 Information Measures Probability Review Basic Probability Definitions Joint probability: p(X, Y ) The probability that both X and Y are true. Joint probability is commutative: p(X, Y ) = p(Y, X). Conditional probability: p(X|Y ) The probability that X is true, given that Y is true. Note that “Rates,” PPV and NPV are Conditional Probabilities: True Positive Rate = p(T P T est|+), 3 False Negative Rate = p(F N T est|+), False Positive Rate = p(F P T est| ), True Negative Rate = p(T N T est| ), Positive Predictive Value = p(+|T est P ositive), Negative Predictive Value = p( |T est N egative). Marginal probability:......

Words: 4475 - Pages: 18

Free Essay

Power Tower

...School of Engineering      Power Tower      12/11/2015  Engr 469  Fall Semester      Instructor: Professor A. S. (Ed) Cheng      Team:  Sanjeev Gupta  Abit Baral        Abstract:​  In this article different aspects of Power Tower has been investigated. Power Tower  or Heliostat power plant is one of the most promising and affordable Concentrated Solar Power  technology. Different parts of the Power tower namely heliostats, central receiver, heat transfer  fluid, turbine and storage tanks has been examined. Also current situation of Power Tower have  been researched and compared with other Solar technology.  Introduction:  Power towers have a potential of being one of the lowest cost and environmental friendly  solution to our power needs. Today power tower systems are often considered to be the most  promising Concentrating Solar Power (CSP) technology for the future. In power tower  concentrating solar power systems, numerous large, flat, sun­tracking mirrors, known as  heliostats, focus sunlight onto a receiver at the top of a tall tower. A heat­transfer fluid heated in  the receiver is used to generate steam, which, in turn, is used in a conventional turbine  generator to produce electricity. Some power towers use water/steam or molten salt as the heat  transfer fluid. Different part of these types of power plant are analyzed in detail below.  Components of CSP power tower.  1.       Heliostats  2.       Tower with receiver  3.   ......

Words: 1983 - Pages: 8

Premium Essay

Power Tower

...Power Tower in an Open Pit Mine: called a “Pit Power Tower” (PPT). | | By Jonathan Gwiazda and Francis A. DiBella | 1. Introduction1.2 Problem Statement The number of people and the amount of technology in the world are on the rise. People and technology both require energy. This rise in population and technology has led to a corresponding increase in energy demand. This trend is unlikely to change in the foreseeable future.The three primary methods of power production today are 1) fossil fuels, such as coal or natural gas, 2) hydroelectric dams, and 3) nuclear power. The undeveloped potential of each of these power methods is restricted by either the associated environmental impact or by the limits of the resource itself. Current methods of power production are in need of supplementation. An ideal source would be renewable and have minimal environmental impact. This paper presents one such method.1.3 Overview and Scope < A href="http://ljb.advertserve.com/servlet/click/zone?zid=29&pid=2&lookup=true&position=1" target="_top">< IMG src="http://ljb.advertserve.com/servlet/view/banner/image/zone?zid=29&pid=2&position=1" height="240" width="120" hspace="0" vspace="0" border="0" alt="Click Here!">< /A> | The paper begins with the background and description of the proposed power source, its advantages, and a tabular outline of three example sites. Concerns for each component of the system are briefly considered. The paper ends with......

Words: 4934 - Pages: 20

Premium Essay

Excel

...Applied Statistics Microsoft Excel Decomposition may reduce appeal emphasis on applications. Flow charts help make the analysis decision by identifying technique, computing statistics, and interpreting results. Associated data set accompanies the set purports to build a excel spreadsheet that discovers formula, illustrates the parameters, observes dynamic graphs and simulations that recodes, edits, validate, charts, and automatically links equations, data, and formulas to recalculate the data analysis. Excel recognizes statistical capability conjunction that carries out complex algorithms that implement correlated data columns. Excel quickly analyzes and interprets information filtered into a spreadsheet so the process is much easier then working out these formulas by hand. Excel spreadsheets create charts, graphs, and filters data all into one. Excel uses all of the basic mathematical operations such as addition, subtraction, division, and multiplication. Fractions and decimals are just as common for interpretation data into a excel spreadsheet. An advantage about excel is you can place any formula into the spreadsheet whether in ascending or descending order and using the same formula, it will automatically compute the answer for the next equation. Another advantage is if information is inaccurate, you can go back and check your work with just a click, unlike using y calculations or by hand you have to erase so much and start all over again, which could be time......

Words: 377 - Pages: 2

Premium Essay

Excel

...Operator: <= / Constraint entry: d9*32% 3. Laser Imaging machines (D7) should be greater than or equal to 28% of the total machines produced (d9*28%); also enter a constraint for less than or equal to 32% (d9*32%) 4. Magnes machines (D8) should be greater than or equal to 38% of the total machines produced (d9*38%); also enter a constraint for less than or equal to 42% 5. Number to make (D6:D8) must be whole units (use int) Verify that all parameters have been entered (set objective, changing cells and constraints), Solve and create an Answer Report. Resave your practice exam. This will still be a macro-enabled file. If you want feedback on your practice exam, please upload your file to Oncourse / Assignment 2 / Excel Case Practice link. On test day you will submit your completed exam to the Oncourse Assignment2 link....

Words: 1218 - Pages: 5

Premium Essay

Excel

...Terms Definitions The First step in creating an effective workseet is to make sure you __________. Understand what is required In Excel, a number can contain the charaters ________. 0 1 2 3 4 5 6 7 8 9 The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________. receiving range You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand. Format Pressing the _________ keyboard shorcut key(s) selects cell A1. CTRL + HOME How many chart types does Excel offer? 11 Which of the following keys is an alternative to double-clicking the cell to edit it? F2 Which of the following Opton buttons gives options for filling cells following a fill operation? Auto Fill Options A ________ cell in Excel has a numerical value of zero. Blank The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign. Formula The most popular background color is _______. White ________ text often provides a strong visual appeal. Underlined To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________. Dialog Box Launcher Which of the following is an extension of the fill patten Sunday, Tuesday? Thursday, Saturday, Monday Which of the following formula contains the absolute cell reference? =$B$4 A(n) _______ chart provides a simple way to show trends and variatons in a range of data...

Words: 423 - Pages: 2