Question

Case Analysis 1: You work for a small, local telecommunications company. In five years, the company plans to undertake a major upgrade to its servers and other IT infrastructure. Management estimates that it will need up to $450,000 to cover all related costs; however, as a fairly young company, the goal is to pay for the upgrade with cash and not to take out loans. Right now, you have $300,000 in a bank account established for Capital Investments. This account pays 4% interest, compounded annually. A member of the finance department has approached you with an investment opportunity for the $300,000 that covers a five-year period and has the following projected after-tax cash flows:

Year Projected Cash Flow

1 $90,000

2 $115,000

3 $135,000

4 $110,000

5 $90,000

Based on this information, in an MS Word document, answer the following questions:

1) How much money will be in the bank account if you leave the $300,000 alone (earning 4% compounded interest) until you need it in five years?

2) If you undertake the investment opportunity, what is the Nominal Payback Period?

3) Using the Present Value factors for 7% (which can be found on any PV Factor table), what is the discounted Payback Period of the investment opportunity?

4) What is the Net Present Value at 7% of the investment opportunity?

5) Which option (make the investment or leave the money in a savings account) would you recommend to your CEO? Why? What additional factors/information might make you change your point of view?

Answer #1

As per rules I will answer the first 4 subparts of the question

1)Amount after 5 years= P*(1+r)^n

=300000*1.04^5

=$364995.87

2.Cumulative cash flow in 2 years = 90000+115000 = 205000

Nominal payback = 2 years + (Initial investment-Cumulative cash flow)/ CF in year 3

=(300000-205000)/135000

= 2.7 years

3. The discounted cash flows will be as under

Year | Cash flow | PV of cash flow | Cumulative cash flow |

1 | 90000 | 84112.14953 | 84112.14953 |

2 | 115000 | 100445.4538 | 184557.6033 |

3 | 135000 | 110200.2134 | 294757.8167 |

4 | 110000 | 83918.47333 | 378676.29 |

5 | 90000 | 64168.75615 | 442845.0461 |

Discounted payback= 3 years + (300000-294757.82)/

378676.29 |

= 3.0138 years

4. NPV= Sum of discounted cash flows- Initial cash flow

442845.0461- 300000

=142845.0461

WORKINGS

How do I solve this? Need to show work.
Questions:
#1 - #3: A small factory that makes electrical components is
considering a project which might generate future cash flows as
follows. The company will make a decision whether they
will undertake this project based on the Net Present Value
analysis/Payback period/IRR method.
Project:
Initial investment = $100 million
Net cash flows Year
1 Year
2 Year
3 Year
4
($million) 34 30 40 36
1. What is the payback period of this project? If the
hurdle period for the...

Today, you opened up a local bank account. Your plan is to make
five $1,000 contributions to this account. The first $1,000
contribution will occur today and then every 6 months you will
contribute another $1,000 to the account. The bank account
pays 6% nominal annual interest, and the interest is compounded
monthly. After 2 years, you plan to leave the money in the
account earning interest, but you will not make further
contributions to the account. How much will...

Consider the case of Cute Camel Woodcraft Company:
Cute Camel Woodcraft Company is a small firm, and several of its
managers are worried about how soon the firm will be able to
recover its initial investment from Project Alpha’s expected future
cash flows. To answer this question, Cute Camel’s CFO has asked
that you compute the project’s payback period using the following
expected net cash flows and assuming that the cash flows are
received evenly throughout each year.
Complete the...

a) At the end of five years you wish to purchase a car for
$25,000. You can invest your money at the rate of 5% compounded
annually. How much money must you deposit in your investment
account today in order to have enough funds to purchase your car?
Interest rate - Actual amount of the deposit is: Number of periods
- Table used - Factor from table used -
b) You want to buy a business with an annual cash...

ABC Company wants to have $82,761 in nine years. The company intends to
accumulate that amount by making equal semi-annual cash deposits at the
beginning of every six months for nine years into a bank account that
pays 10% interest compounded semi-annually.
Calculate the amount of each semi-annual deposit.
Use the time value of money factors posted in carmen to answer this question.
To access these factors, click modules and then scroll to week 12. Click on
the link labeled...

Suppose you are evaluating a project with the cash inflows shown
in the following table. Your boss has asked you to calculate the
project’s net present value (NPV). You don’t know the project’s
initial cost, but you do know the project’s regular, or
conventional, payback period is 2.50 years.
The project's annual cash flows are:
Year
Cash Flow
Year 1
$375,000
Year 2
550,000
Year 3
400,000
Year 4
300,000
If the project’s desired rate of return is 9.00%, the...

Bowman Corporation is considering an investment in
special-purpose equipment to enable the company to obtain a
five-year government contract for the manufacture of a special
item. The equipment costs $500,000 and would have no salvage value
when the contract expires at the end of the five years. Estimated
annual operating results of the project are as follows.
Revenue from contract sales
$
700,000
Expenses other than
depreciation
$
400,000
Depreciation (straight-line
basis)
100,000
500,000
Increase in net income from
contract...

You work for a local company that sells and manages data
security for small businesses in Minnesota and Wisconsin. This
company sells security software, hardware encryption, and hosts
secure servers for Internet transactions. Your company also stores
customer data including TAX-ID numbers and bank accounts. As your
company grows and tries to compete with the larger companies like
IBM or Microsoft, your boss asks you to discover new ways of
generating business. One idea you have is that you could...

ABC Company sold the rights to use one of their patented
processes that will result in them receiving cash payments of
$10,000 at the end of every six months for each of the next five
years and a lump sum payment of $20,000 at the end of the sixth
year. Calculate the total present value of these payments assuming
the interest rate is 10% compounded semi-annually. You will need to
use the time value of money table factors posted in...

3. ABC Company sold the rights to use one of their patented processes
that will result in them receiving cash payments of $10,000 at the
end of every six months for each of the next five years and a lump
sum payment of $20,000 at the end of the sixth year.
Calculate the total present value of these payments assuming the
interest rate is 10% compounded semi-annually.
You will need to use the time value of money table factors posted...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 5 minutes ago

asked 17 minutes ago

asked 28 minutes ago

asked 55 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago