PROBLEM 1-Benefit-Cost Analysis Which is the better alternative given 9% discount rate? Alternative A Alternative B 1000 1000 1000 1000 1000 1750 1750 1750 1750 1750 1 1 3 4 5 3,000 4,500 Equation for Incremental Analysis: Better Alternative:_ - DROBLEM 2-Determine the External Rate of Return, i' Discount Rate=5% Year Cashflow PV-Cash PV-Cash Inflow Outflow (P27,500) 6,000 8,000 7,000 (4,000) 9,000 5,000 1 2 3 4 5 6. %3D %3D 65432 10

PROBLEM 1-Benefit-Cost Analysis Which is the better alternative given 9% discount rate? Alternative A Alternative B 1000 1000 1000 1000 1000 1750 1750 1750 1750 1750 1 1 3 4 5 3,000 4,500 Equation for Incremental Analysis: Better Alternative:_ - DROBLEM 2-Determine the External Rate of Return, i' Discount Rate=5% Year Cashflow PV-Cash PV-Cash Inflow Outflow (P27,500) 6,000 8,000 7,000 (4,000) 9,000 5,000 1 2 3 4 5 6. %3D %3D 65432 10

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

PROBLEM 2-Determine the External Rate of Return, i' Discount Rate=5% Cashflow PV-Cash Outflow PV-Cash Inflow Year (P27,500) 6,000 8,000 7,000 (4,000) 9,000 5,000 4 2 1 %3D O123456
st K Present value calculation Without referring to the preprogrammed function on your financial calculator, use the basic formula for present value, along with the given discount rate, r, and the number of periods, n, to calculate the present value of $1 in the case shown in the following table. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Opportunity cost, r 4% The present value of $1 is $ Number of periods, n 6 (Round to three decimal places.)
Q2 given below. Discount rate Year Costs . Refer to the formula given in the previous problem, complete the required data in the table 8% Benefits Cashflow Discount factor Present Net Value (NPV) Discounted costs ANSWER 0 140,000 O 40,000 200,000 160,000 Return on Investment (Rol) 2 40,000 200,000 160,000 Total
Solving for "Rate" Solution This formuala calculates the rate of return when the present value, future value, and number of periods is known Given Parameters Present Value Future Value Number of Periods Solution Excel Function -800 Solve Rate using Manula Formula 1,000 Method for Solving (Excel Formula Function "Rate") 4 1.Solve for "Rate" using the information provided above (use xcel Formula) 2.Solve for "Rate" using the information provided above (use Manual Formula)
Tasks/ calculation these questions are :- by 6 functions are : 1. Accumulative (future) money value 1/ Simple interest FV=PV*(1+* ? *N) 2/ Aggregate interest FV=PV (1+ ? )N 2. Present money value PV = FV * ^note N- total times of getting income^ R= ?????? ??? / N n- frequency of income generation per year 3. Present payment value PV = PMT * 4. Future payment value (PMT) FV = PMT * 5. Amortization payment PMT = PV * 6. Solatium fond factor (SFF) PMT = FV * Q1/ The investor wants to invest in the purchase of an office building. He suggests he can rent it out for 10 years at an annual rent of 1,850,000. At the end of the tenth year it is expected to sell the company for 18 million d.e. Income rate 20% What is the current value of the building?
2. Discounted Payback (DCPB) and IRR evaluations. Use the cash flow situation (table below) to answer. a. Determine the DCPB based on a MARR rate of 4.0% b. Determine the IRR Year Cash Flow (in $1000's) 0 -1250 1 +350 2 3 +300 +250 4 +200 5 +150 6 +100 7 +50
Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 -24,063 -24,063 1 10,320 12,063 2 10,900 9,360 3 10,800 10,400 Sketch the NPV profiles for X and Y over a range of discount rates from zero to 25 percent (take 0%, 5%, 10%, 15%, 20%, 25%). Calculate the IRR of the projects. What is the relationship between NPV and IRR for your values? What is the crossover rate for these two projects and what it indicates for your values? Note - answer all the parts of the question.
What is Project A’s modified internal rate of return (MIRR)? Use 5 decimal places for the factors 18.15% 12.15% 14.49% 7.40% 15.54%
Consider the following payoff table that represents the profits earned for each alternative (A, B, and C) under the states of nature S1, S2, and S3. Using the Laplace criterion, what would be the highest expected payoff? S1 S2 S3 A $100 145 120 B $75 125 110 C $95 85 60
Given: D0 = $1g = 3%P0 = $20 What is the required rate of return? a. 1.58%b. 8.51%c. 8.15%d. 5.18%
1- Find the internal rate using the method of Internal Rate of Return (IRR) if i= 15%, for the table shown below. If the initial cost is (220,000 U) Cost (U) 350 380 400 500 550 470 780 650 690 450 Revenue 0 0 500 1000 770 450 880 660 890 770 (U) 1 2 3 Year 4 5 6 7 8 9 10
Rate of interest = 10% Present its feasibility using 1. Rate or Return Method 2. Annual Worth Method 3. Present Worth Method 4. Future Worth Method 5. Payback Method All method should be presented with the cash flow diagram

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS