You are valuing an investment that will pay you $26,000 per year for the first 14 years, $34,000 per year for the next 10 years, and $47,000 per year the following 11 years (payments are at the end of each year). Another similar risk investment alternative is an account with a quoted annual interest rate of 7.50% with MONTHLY compounding of interest. What is the value in today's dollars of the set of cash flows you have been offered?

(If possible please solve in excel) :)

Assume that the 1-year zero-coupon bond is sold at $89.78 and the yields to maturity for the coupon bonds selling at market prices equal to their face values are 11% and 13% for 1-year and 1.5-year issues respectively. Coupons are paid every 6 months and face values are $100 for all the bonds.

(a) Calculate the spot rate curve (s_0.5, s₁, s_1.5).

(Keep your answer in decimal format 4 decimal places, e.g. 0.1234. Do not give in percent format e.g. 12.34%.)

     s_0.5: _______________ s₁: ____________________ s_1.5 :__________________

(b) Compute the quasi-modified duration for each of these bonds. (Keep 2 decimal places, e.g. xx.12.)

     Zero-coupon bond: ______________

11% coupon bond: ______________

    13% coupon bond: ______________

(c)  Determine the current price of an 14% coupon bond with face value $100 and 18 months to maturity. (Keep 2 decimal places, e.g. xx.12.)

________________

DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations.

Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months:

Required:

1-a. Compute the throughput time for each month. (Round your answers to 1 decimal place.)

1-b. Compute the manufacturing cycle efficiency (MCE) for each month. (Round your answers to 1 decimal place.)

1-c. Compute the delivery cycle time for each month. (Round your answers to 1 decimal place.)

3-a. Refer to the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time, process time, and so forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the queue time during production. Compute the new throughput time and MCE. (Round your answers to 1 decimal place.)

3-b. Refer to the move time, process time, and so forth, given for month 4. Assume in month 6 that the move time, process time, and so forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during production and the inspection time. Compute the new throughput time and MCE. (Round your answers to 1 decimal place.)

FitcomCorp. is considering a three-year project that will require an initial investment of $41,000. If market demand is strong, FitcomCorp. thinks that the project will generate cash flows of $28,000 per year. However, if market demand is weak, the company believes that the project will generate cash flows of only $1,750 per year. The company thinks that there is a 50% chance that demand will be strong and a 50% chance that demand will be weak.

If the company uses a project cost of capital of 11%, what will be the expected net present value (NPV) of this project?

-$5,348

-$5,580

-$4,882

-$4,650

FitcomCorp. has the option to delay starting this project for one year so that analysts can gather more information about whether demand will be strong or weak. If the company chooses to delay the project, it will have to give up a year of cash flows, because the project will then be only a two-year project. However, the company will know for certain if the market demand will be strong or weak before deciding to invest in it.

What will be the expected NPV if FitcomCorp. delays starting the project?

$2,661

$3,131

$27,424

$7,781

What is the value of FitcomCorp.’s option to delay the start of the project?     

Shai Co. is considering a four-year project that will require an initial investment of $7,000. The base-case cash flows for this project are projected to be $14,000 per year. The best-case cash flows are projected to be $26,000 per year, and the worst-case cash flows are projected to be -$4,500 per year. The company’s analysts have estimated that there is a 50% probability that the project will generate the base-case cash flows. The analysts also think that there is a 25% probability of the project generating the best-case cash flows and a 25% probability of the project generating the worst-case cash flows.

What would be the expected net present value (NPV) of this project if the project’s cost of capital is 12%?

$30,587

$24,470

$29,058

$35,175

Shai now wants to take into account its ability to abandon the project at the end of year 2 if the project ends up generating the worst-case scenario cash flows. If it decides to abandon the project at the end of year 2, the company will receive a one-time net cash inflow of $4,750 (at the end of year 2). The $4,750 the company receives at the end of year 2 is the difference between the cash the company receives from selling off the project’s assets and the company’s -$4,500 cash outflow from operations. Additionally, if it abandons the project, the company will have no cash flows in years 3 and 4 of the project.

Using the information in the preceding problem, find the expected NPV of this project when taking the abandonment option into account.

$33,946

$30,551

$37,341

$42,433

What is the value of the option to abandon the project?     

What is the present value of an annuity that pays $8,500 per year for 13 years with a 8% interest rate with the first payment TODAY.

Please show how to calculate in excel!

23. Hurko, LP was formed in 2006 and adopted a calendar year. Here is a schedule of Hurko’s net Section 1231 gains and (losses) reported on its tax returns through 2011. 2006 2078 2008 2009 2010 2011 -0- (3,800) 9,040 (15,900) -0- -0- In 2012, Hurko recognized a $25,000 gain on the sale of business land. How is this gain characterized on Hurko's 2012 tax return? A. $25,000 Section 1231 gain. B. $9,100 ordinary gain and $15,900 Section 1231 gain. C. $15,900 ordinary gain and $9,100 Section 1231 gain. D. $25,000 ordinary gain. E. None of the above.

Respond to the following in a minimum of 175 words:

• The world's population grows each year. Does this mean that the mass of Earth increases each year? How old are atoms? Explain your answer with an example.

PLEASE TYPE RESPONSE DO NOT HAND WRITE!!

You are considering an investment that will pay you $1,200 in one year, $1,400 in two years, and $1,600 in three years, $1,800 in four years, and $11,000 in five years. All payments will be received at the end of the year. • Your opportunity cost of capital (r ) is 10.5% • Using the present value formula calculate the present value of each of the cash flows by 1. Discounting cash flows using annual compounding 2. Discounting cash flows using monthly compounding 3. Discounting cash flows using continuous compounding • How much would you be willing to pay for the investment using each of the three different compounding scenarios? That is, what is the present value of the cash flows from the investment using each of the three different compounding scenarios? • Which of the three present values is the largest (annual, monthly or continuously compounded returns)? Please explain why this is the case. do not use a calculator or excel to solve