 # FIN320 Excel Assignment

Satisfactory Essays
388 Words Grammar Plagiarism  Writing  Score FIN320 Excel Assignment FIN 320
EXCEL SHEET Problems
Please solve the problems below using an excel sheet and the excel functions.
1) (15 pts) A firm is considering a project with an initial investment of \$170,000 and required return of 12%. The following cash flows are expected over the 8­year life span of the project:
Year

Cash flows

1

35,300

2

46,200

3

50,000

4

22,620

5

15,100

6

5,200

7

11,740

8

89,300

a)
Calculate the Net Present Value (NPV) of the project. Should the firm accept or reject the project based on the NPV criteria? b)
Calculate the Internal Rate of Return (IRR) of the project. Should the firm accept or reject the project based on the IRR criteria?
c)
Calculate the Profitability Index (PI) of the project. Should the firm accept or reject the project based on the PI criteria? 2)(10 pts) You are considering the following two mutually exclusive projects. Both projects will be depreciated using straight­line depreciation to a zero book value over the life of the project.
Neither project has any salvage value. Required rate of return on Project A is 10% and on project B is 13%.
Project A

Project B

Year

CFs

Year

CFs

0

-75,000

0

-70,000

1

19,000

1

10,000

2

48,000

2

16,000

3

12,000

3

72,000

a)
Calculate the Net Present Value (NPV) of both projects. Which project should the firm choose based on the NPV criteria?
b)
Calculate the Internal Rate of Return (IRR) of both projects. Which project should the firm choose based on the IRR criteria? 3)(5 pts) The bonds issued by Stainless Tubs bear an 8 percent coupon, payable semiannually. The bonds mature in 11 years and have a \$1,000 face value. Currently, the bonds sell for \$952. What is the yield to maturity? 4)(5pts) Redesigned Computers has 6.5 percent coupon bonds outstanding with a maturity date of 8 years from now.

## You May Also Find These Documents Helpful

• Good Essays

2. Use the operating projections to compute a net present value (NPV) for each project. Which project…

• 787 Words
• 4 Pages
Good Essays
• Satisfactory Essays

3. The project is a slam-dunk for the corporation because they are yielding an internal rate of return of 80%. The NPV of the future cash flows is significantly larger than the purchase costs of the assets.…

• 346 Words
• 2 Pages
Satisfactory Essays
• Better Essays

The focus of EEC’s investment of the purchasing of the supplier is to cut down on the cost expenditures of the company. The primary board members and investors anticipate in the timeframe the fifth of to save financially in revenue \$600,000 per annum this will accumulate \$9 million in net in the timeframe of that 15 years. 14% of that investment and consumption cost will be attributed out of \$9 million net, which adds up to sum of \$3 million. The president of the company asked me to give an analysis in the possibilities foreseen in the investment what would be the Net Present Value, along with the Internal Rate of Return, and the payback of the investment.…

• 1228 Words
• 4 Pages
Better Essays
• Satisfactory Essays

A project has initial costs of \$3,000 and subsequent cash inflows in years 1 – 4 of \$1350, 275, 875, and 1525. The company 's cost of capital is 10%. Calculate NPV for this project.…

• 836 Words
• 4 Pages
Satisfactory Essays
• Good Essays

## Busn

• 1773 Words
• 8 Pages

Answer: Yes, I believe the company should accept this project. The company’s IRR is greater than the RRR and the NPV of \$450,866.74 is a positive. Whenever the Irr is greater than the RRR or the NPV is zero or greater, the investment will earn a return greater than the RRR.…

• 1773 Words
• 8 Pages
Good Essays
• Better Essays

The financial assistant received the important assignment by memorandum from the CEO. The memorandum stated that the company is considering the introduction of a new product (Keown, Martin, Perry, & Scott, 2005). Caradonia is currently at a 34% marginal tax bracket with a 15% required rate of return or cost of capital (Keown, Martin, Perry, & Scott, 2005). The new project is estimated to last five years and then be terminated because of being a fad project (Keown, Martin, Perry, & Scott, 2005). The financial assistant must analyze two mutually exclusive projects. Each project has an 11% rate of return and a life span of five years (Keown, Martin, Perry, & Scott, 2005). The following table (table one) shows the expected cash flows for each project.…

• 1388 Words
• 6 Pages
Better Essays
• Satisfactory Essays

Net present value (NPV) method is used to decide whether or not a company should take on a new project or acquisition. The formula for NPV is the difference between the present value of a project’s cash inflows and its cash outflows. To calculate the present values the future cash flows are discounted using the time value of money method. For the project to be accepted the NPV should be positive, because it means the return is greater than the required rate of return; or zero, because that means the return is equal to the required rate of return. However, if negative the project should be rejected, because its return is less than the required rate of return. This required rate of return is also referred to as the cost of capital.…

• 343 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

of Return (IRR) from this project is around 15.66%. Given the projected cash flow information…

• 305 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

The resulting NPV indicates that the project should be accepted and the investor should expect a return on equity of 38.87%. The NPV provides the investor with an expectation of what all future cash inflows will be worth in today’s dollars. The profitability index is closely related to the NPV. It evaluates the project’s feasibility based on future cash flows compared to initial costs. In general, a project is deemed a valid investment if this ratio is over 1. For this investment opportunity the profitability index indicates that it should be accepted.…

• 3248 Words
• 13 Pages
Powerful Essays
• Satisfactory Essays

A project has initial costs of \$3,000 and subsequent cash inflows in years 1 ? 4 of \$1350, 275, 875, and 1525. The company's cost of capital is 10%. Calculate NPV for this project.…

• 1062 Words
• 5 Pages
Satisfactory Essays
• Better Essays

We should accept the project because of the positive NPV and high IRR. We will gain \$532 million in wealth which is a big money on the scale like this. The company has a bond rating of AA that makes the risk relatively low. So we should definitely say yes.…

• 1113 Words
• 5 Pages
Better Essays
• Better Essays

a. Determine the range of the rates of return for each of the two projects.…

• 805 Words
• 4 Pages
Better Essays
• Good Essays

3. Calculate the proposed project’s IRR. Explain the rationale for using the IRR to evaluate capital investment projects. Could the IRR for this project differ for GP Manufacturing versus for another customer?…

• 2198 Words
• 9 Pages
Good Essays
• Good Essays

NPV (Net Present Value) measures the expected change in wealth from undertaking the project. The NPV of purchasing is \$60.34 million and \$93.23 million for developing the technologies. NPV is the most effective measurement since both IRR and MIRR have the project scale issues. In this case, developing the technologies gives a greater NPV and is the best choice.…

• 655 Words
• 3 Pages
Good Essays
• Powerful Essays

Project B requires an immediate investment of \$750 000, an investment of \$500 000 in five years…

• 1218 Words
• 6 Pages
Powerful Essays