Question

In: Finance

Capital Budgeting The Recycled Paper Inc. corporation is considering a project with the following cash flows....

Capital Budgeting

The Recycled Paper Inc. corporation is considering a project with the following cash flows.

Year

Cash Flow

0

($75,000)

1

$18,500

2

$18,500

3

$18,500

4

$18,500

5

$12,500

6

$12,500

7

$12,500

8

$12,500

Refer to the Capital Budgeting narrative. What is the payback period of the proposed project?

A. 1.28 years

B. 2.28 years

C. 3.28 years

D. 4.08 years

Refer to the Capital Budgeting narrative. What is the net present value of the proposed project if the discount rate is 12.5%?

A. $4,059.4

B. $3,487.5

C. $4,625.3

D. -$3.984.6

Refer to the Capital Budgeting narrative. What is the profitability index of the proposed project if the discount rate is 12.5%?

A. 0.89

B. 1.05

C. 2.03

D. 3.03

Refer to the Capital Budgeting narrative. What is the IRR of the proposed project?

A. 13.57%

B. 18.35%

C. 12.74%

D. 14.20%

Solutions

Expert Solution

1. Using excel formula to calculate pay back period
Year   0   1   2   3   4   5   6   7   8
Cash Flow   -75000.00   18500.00   18500.00   18500.00   18500.00   12500.00   12500.00   12500.00   12500.00
Cumulative Cash flow    -75000.00   -56500.00   -38000.00   -19500.00   -1000.00   11500.00   24000.00   36500.00   49000.00
Payback Period   4.08 (4+1000/12500)                          
Option d is correct option

2. NPV of project =PV of Cash Flows -Investment =18500/1.125+18500/1.125^2+18500/1.125^3+18500/1.125^4+12500/1.125^5+12500/1.125^6+12500/1.125^7+12500/1.125^8-75000 =4059.40 (Option a is correct option)

3. Profitability Index(PI) =1+NPV/Investment =1+4059.40/75000 =1.05

4.   Using Financial Calculator
CF0 =-75000;CF1 =18500;CF2 =18500; CF3 =18500; CF4 =18500; CF5=12500; CF6=12500; CF7 =12500; CF8=12500;
CPT IRR =14.20%


Related Solutions

1. A corporation is evaluating the relevant cash flows for a capital budgeting project involving expansion...
1. A corporation is evaluating the relevant cash flows for a capital budgeting project involving expansion of the firm’s activities and must estimate the terminal cash flow for the project. The project will involve purchasing a machine for $120,000. The machine has a usable life of 6 years but would be disposed of after 5 years at an estimated sale price of $10,000. The machine will be depreciated under the prime cost (straight-line) method supposing a 6-year life. Net working...
Cuda Marine Engines, Inc. must develop the relevant cash flows for a replacement capital budgeting project....
Cuda Marine Engines, Inc. must develop the relevant cash flows for a replacement capital budgeting project. The proposed asset costs $50,000 and has installation costs of $3,000. The asset will be depreciated using the MACRS five year recovery schedule. The existing equipment was purchased three years ago which orginally cost $25,000, has been depreciated using MACRS 5-year period. The new equipment is expected to result in an incremental increases in revenue of $10,000 a year for five years and a...
Sigma Company is examining the cash flows of the capital budgeting project shown below. The project...
Sigma Company is examining the cash flows of the capital budgeting project shown below. The project is expected to cost $400,000. Sigma has a required rate of return of 12%, and a maximum acceptable payback period of 3 years. 0 1 2 3 4 5    ($400,000) $150,000 $150,000 $200,000 $100,000 $100,000 a. Calculate the NPV of the project. Based on the NPV analysis, should Sigma accept the project? Why or why not? b. Calculate the payback period of the...
You are considering the following project. Your cost of capital is 8%. The cash flows are...
You are considering the following project. Your cost of capital is 8%. The cash flows are as follow: Year 0 1 2 3 4 -1000 300 500 300 300 What is the NPV of the project? A. 165 B. 296 C. 400 D. 1400
The Franchise Corporation is considering an equity investment project with the following future cash flows at...
The Franchise Corporation is considering an equity investment project with the following future cash flows at a 10% opportunity capital cost. In relation to the capital budget decision: Year Cash Flows 0 ($255,000) 1 125,000 2 140,000 3 -50,000 4 100,000        the project must be accepted since MIRR = 10% and NPV = $5,074.45        the project should not be accepted since MIRR = 10% and NPV =$5074.45        the project should be accepted since IRR...
FIN 331 – Homework – Capital Budgeting and Cash Flows Your firm is considering replacing a...
FIN 331 – Homework – Capital Budgeting and Cash Flows Your firm is considering replacing a machine that originally cost $275,000 with a new machine costing $340,000. It will also cost $10,000 to install the new machine. The new machine has a much higher output and would increase sales by $110,000 each year. The new machine is also more efficient and will save $10,000 in operating costs annually. The new machine would take more floor space causing the firm to...
Capital Budgeting: Estimating Cash Flows for an Investment A company is considering replacement of manufacturing equipment...
Capital Budgeting: Estimating Cash Flows for an Investment A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of $500,000, replacing equipment with a scrap value of $50,000. This will reduce defect costs by $150,000 a year. At the end of 7 years, the equipment will be replaced and will have a scrap value of $100,000. The interest charges for financing the purchase will be $25,000 a year. The new system will be housed in...
You are considering a project with the following cash​ flows: YEAR                      PROJECT CASH FLOW    ...
You are considering a project with the following cash​ flows: YEAR                      PROJECT CASH FLOW     0                         -60,000     1                         25,000     2                         25,000     3                         25,000     4                         25,000 If the appropriate discount rate is 11 ​percent, what is the​ project's discounted payback​ period in years?
Robbins Inc. is considering a project that has the following cash flow and cost of capital...
Robbins Inc. is considering a project that has the following cash flow and cost of capital (r) data. What is the project's NPV? Note that if a project's expected NPV is negative, it should be rejected. r. 10.25% Year 0 1 2 3 4 5 Cash flows −$1,000 $300 $300 $300 $300 $300 a. $117.33 b. $105.89 c. $123.51 d. $130.01 e. $111.47 Reed Enterprises is considering a project that has the following cash flow and cost of capital (r)...
Robbins Inc. is considering a project that has the following cash flow and cost of capital...
Robbins Inc. is considering a project that has the following cash flow and cost of capital (r) data. What is the project's NPV? Note that if a project's expected NPV is negative, it should be rejected. r. 10.25% Year 0 1 2 3 4 5 Cash flows −$1,000 $300 $300 $300 $300 $300 a. $105.89 b. $111.47 c. $117.33 d. $123.51 e. $130.01 Reed Enterprises is considering a project that has the following cash flow and cost of capital (r)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT