Thứ Bảy, ngày 24 tháng 5 năm 2014

Master - Chapter 2: Skill building exercises


PV and FV
Skill-Building Problems.
1. A single cash flow of $1,673.48 will be received in 4 periods. For this cash flow, the appropriate
discount rate / period is 7.8%. What is the present value of this single cash flow?
2. A single cash flow of $932.47 is available now (in period 0). For this cash flow, the appropriate
discount rate / period is 3.9%. What is the period 4 future value of this single cash flow?
Annuity
Skill-Building Problems.
1. An annuity pays $142.38 each period for 6 periods. For these cash flows, the appropriate discount
rate / period is 4.5%. What is the present value of this annuity?
2. An annuity pays $63.92 each period for 4 periods. For these cash flows, the appropriate discount
rate / period is 9.1%. What is the period 5 future value of this annuity?
Net Present Value
Skill-Building Problems.
1. A project requires a current investment of $189.32 and yields future expected cash flows of
$45.19, $73.11, $98,54, $72.83, and $58.21 in periods 1 through 5, respectively. All figures are in
thousands of dollars. For these expected cash flows, the appropriate discount rate is 6.3%. What
is the net present value of this project?
2. A project requires a current investment of $54.39 and yields future expected cash flows of
$19.27, $27.33, $34.94, $41.76, and $32.49 in periods 1 through 5, respectively. All figures are in
thousands of dollars. For these expected cash flows, the appropriate discount rate starts at 6.4% in
period 1 and declines to 5.4% in period 5. What is the net present value of this project?

Skill-Building Problems.
1. A project requires a current investment of $117.39 and yields future expected cash flows of
$38.31, $48.53, $72.80, $96.31, and $52.18 in periods 1 through 5, respectively. All figures are in
thousands of dollars. The inflation rate is 2.7%. For these expected cash flows, the appropriate
Real Discount Rate is 8.6%. What is the net present value of this project?
2. A project requires a current investment of $328.47 and yields future expected cash flows of
$87.39, $134.97, $153.28, $174.99, and $86.41 in periods 1 through 5, respectively. All figures
are in thousands of dollars. The forecasted inflation rate starts at 3.4% in period 1 and increases to
4.7% in period 5. For these expected cash flows, the appropriate REAL discount rate starts at
7.8% in period 1 and decreases to 5.4% in period 5. What is the net present value of this project?


PMT and sensitivity EX
Skill-Building Problems.
1. To purchase a house, you take out a 30 year mortgage. The present value (loan amount) of the
mortgage is $217,832. The mortgage charges an interest rate / year of 9.27%. What is the annual
payment required by this mortgage? How much of each year's payment goes to paying interest
and how much reducing the principal balance?
2. In purchasing a house, you need to obtain a mortgage with a present value (loan amount) of
$175,000. You have a choice of: (A) a 30 year mortgage at an interest rate / year of 9.74% or (B)
a 15 year mortgage at an interest rate / year of 9.46%. What is the annual payment required by the
two alternative mortgages? How much of each year's payment goes to paying interest and how
much reducing the principal balance by the two alternative mortgages? Which mortgage would
you prefer?
3. Consider a 30 year mortgage for $442,264 as in the previous section. What would happen if the
interest rate / year dropped from 9.21% to 7.95%. How much of each year's payment goes to
paying interest vs. how much goes to reducing the principal under the two interest rates?
Evaluation Project
1.      Consider about investment project evaluation for the initial investment of $100.000 and the cash flow of $25.000 in each year in 5 years. The discount rate is 9%, and the require period of payback is 4 years. Use NPV, IRR, PBP and PI.
2.      Note the following information on the annual cash flows of two mutually exclusive projects under consideration by Wang Food Markets, Inc.
Year A B
0 $230,000 $260,000
1 10,000 20,000
2 10,000 20,000
3 10,000 20,000
4 10,000 20,000
5 10,000 20,000
Wang requires a 14 percent rate of return on projects of this nature.
a. Compute the NPV of both projects.
b. Compute the internal rate of return on both projects.
c. Compute the profitability index of both projects.
d. Compute the payback period on both projects.
e. Which of the two projects, if either, should Wang accept? Why?

Thứ Bảy, ngày 17 tháng 5 năm 2014

Master topic discussion

Link to download: http://www.mediafire.com/download/72d4khmlfdf9kl3/TOPICS+for+DISCUSSIONs.zip
This is files including theories and exercises for each group.

Thứ Ba, ngày 01 tháng 4 năm 2014

PTTKHT slides

Link to download: http://www.mediafire.com/download/87bkdu39b4lh5qy/lecture_PTTKHTSlides_In1.pdf

Thứ Sáu, ngày 07 tháng 3 năm 2014

BT SQL server 2005



Retrieve the required information using SQL language.
Part I. Give a database schema for a library management system as the following picture.





  1. How many copies of the book titled The Lost Tribe are owned by the library branch whose name is "Sharpstown"?
  2. How many copies of the book titled The Lost Tribe are owned by each library branch?
  3. Retrieve the names of all borrowers who do not have any books checked out .
  4. For each book that is loaned out from the "Sharpstown" branch and whose DueDate is today, retrieve the book title, the borrower's name, and the borrower's address.
  5. For each library branch, retrieve the branch name and the total number of books loaned out from that branch.
  6. Retrieve the names, addresses, and number of books checked out for all borrowers who have more than five books checked out.
  7. For each book authored (or co-authored) by "Stephen King", retrieve the title and the number of copies owned by the library branch whose name is "Central"

Part II Give a database schema of a company as the following picture.



 

 



  1. Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductX' project.
  2. For each project, list the project name and the total hours per week (by all employees) spent on that project.
  3. Retrieve the names of employees who work on every project.
  4. Retrieve the names of employees who do not work on any project.
  5. Find the names and addresses of employees who work on at least one project located in Houston but whose department has no location in Houston.
  6. List the last names of department managers who have no dependents.
  7. Find details of those employees whose salary is > the average salary for all employees. Output salary in descending order.
  8. Find details of those employees whose salary is > the average salary for all employees in his/her department. Output salary in ascending order.

Thứ Năm, ngày 27 tháng 2 năm 2014