Compute the npv and break-even level

Reference no: EM1343962

1. Answer in Excel. NPV versus IRR: Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both Projects require an annual return of 14 percent.
Year____Deep water Fishing____New Submarine Ride
0_______-$950,000___________-$1,850,000
1________ 370,000______________900,000
2_______ _510,000______________ 800,000
3________ 420,000______________750,000
a. If your decision rule is to accept the project with the greater IRR, which project should you choose?
b. Because you are fully aware of the IRR rule's scale problem, you calculate the incremental IRR for the cash flows. Based on your computation, which project should you choose?
c. To be prudent, you compute the NPV for both projects. Which project should your choose? Is it consistent with the incremental IRR rule?

2. Capital budgeting with Inflation: Consider the following cash flows on two mutually exclusive projects:
Year_______Project A________Project B
0_________-$50,000_________-$65,000
1___________30,000__________29,000
2___________25,000__________38,000
3___________20,000__________41,000
The cash flows of project A are expressed in real terms, whereas those of project B are expressed in nominal terms. The appropriate nominal discount rate is 13 percent and the inflation rate is 4 percent.
a. Which project should you choose?

3. Calculating Break-even: In each of the following cases, find the unknown variable. Ignore taxes.
Accounting_____________Unit Vvariable____
Bread-even___Unit Price____Cost___________Fixed Costs____Depreciation
95,300_________$41_______$30____________$ 820,000________?______
143,806___________?_______56_____________ 2,750,000___$1,150,000
__7,835__________97________?_______________160,000_____ 150,000

Reference no: EM1343962

Questions Cloud

Keep a christian perspective in finances : Visit Crown Financial Ministries and go to Media - Keep a Christian perspective in finances

Entry for acquisition of property : Valdilla's Music Store acquired Land and old buildling in exchange for 50,000 shares of its common stock, par $0.50 and cash of $80,000.

Threat model to describe risk of attack vector : Construct a simple threat model that describes the risk this represents: attacker(s), attack vector, vulnerability, assets, and likelihood of occurrence, likely impact, and plausible mitigations.

How do you record goodwill : Measure each of these items and prepare the journal entry that should be made to record the purchase on Energy's books.

Compute the npv and break-even level : Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation company. Both Projects require an annual return of 14%.

Evaluate the yield to maturity on the bond : Evaluate the Yield to Maturity on the bond - this is a time value of money problem, so you need to use your financial calculator or Excel.

Differences among horizontal-vertical-conglomerate mergers : Write down the differences among horizontal, vertical, and conglomerate mergers.

How much life insurance do you need : Describe which health care plan you would choose. Looking at eHealth Insurance, enter your information and then pick three companies to compare

Effective address-addressing mode of instruction is direct : Evaluate the effective address if the addressing mode of the instruction is (a) direct; (b) immediate; (c) relative; (d) register indirect.

User Account

All Pages