investing

A company is thinking of investing some surplus cash in 30 year $1000 face value Microsoft 6% annual coupon bonds. It plans to pay $925 each for 10,000 of them, now, and expects to SELL them for $1025 each at the end of 5 years.
Make a determination about the economic viability of the proposal using 3 capital budgeting methods

So how would we break this information down to figure out the simple payback, NPV and IRR using excel?

  1. 👍 0
  2. 👎 0
  3. 👁 103
asked by Mitch

Respond to this Question

First Name

Your Response

Similar Questions

  1. Finance

    A company is thinking of investing some surplus cash in 30 years $1000 face microsoft 6% coupon bonds. It plans to pay $925 each for 10,000 of them, now and expects to sell them for $1025 each at the end of 5 years. Make a

    asked by Linda on May 16, 2010
  2. Accounting

    Indicate how each of the following six different transactions a company would make would affect (i)cash and (ii) net working capital: a)Paying out a $2 million cash dividend. b)A customer paying a $2,500 bill resulting from a

    asked by pioneer2006 on November 8, 2007
  3. INB

    Last year Rattner Robotics had $5 million in operating income (EBIT). The company had net depreciation expense of $1 million and interest expense of $1 million; its corporate tax rate was 40 percent. The company has $14 million in

    asked by baby on July 29, 2007
  4. financial management

    Last year Rattner Robotics had $5 million in operating income (EBIT). The company had net depreciation expense of $1 million and interest expense of $1 million; its corporate tax rate was 40 percent. The company has $14 million in

    asked by marie on November 9, 2007
  5. accounting

    In its first year of operations, Bere Company earned $27,046 in service revenue, $6,667 of which was on account and still outstanding at year-end. The remaining $20,379 was received in cash from customers. The company incurred

    asked by jimmy on October 2, 2007
  6. accounting

    In its first year of operations, Bere Company earned $27,046 in service revenue, $6,667 of which was on account and still outstanding at year-end. The remaining $20,379 was received in cash from customers. The company incurred

    asked by jimmy HElp urgent on October 2, 2007
  7. college

    You are replacing an old piece of machinery with a new one that offers improved technology and efficiencies to your company. The new machine will cost you $50,000 and it will provide you with a cash inflow of $10,500 PER YEAR for

    asked by Fred on October 12, 2010
  8. Accounting

    What is the journal entry for a bounced check. For exemplar, on May 10, Mr. Smith pays his $1000 bill the a certain company, cash receipt #1. On May 12 the check is returned marked Not Sufficient Funds. Would the journal entry

    asked by Jill on June 16, 2010
  9. accounting

    Recently Boeing has maintained a cash balance of over $6 billion. At an annual inflation rate of about 2 percent, does cash have more or less purchasing power at the end of a given year than at the beginning? By how much? Is such

    asked by Jackie on February 3, 2012
  10. financial accounting

    Recently Boeing has maintained a cash balance of over $6 billion. At an annual inflation rate of about 2 percent, does cash have more or less purchasing power at the end of a given year than at the beginning? By how much? Is such

    asked by Wanda on August 7, 2009

More Similar Questions