Compute the npv and break-even level

Assignment Help Finance Basics
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.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Accounting issues of acquisitions

Mention and describe three accounting issues related to acquisitions. What role does the controller play in addressing these issues?

  Interest accrues during nine months

How much interest accrues during nine months in which you have short position.

  Compute sales to earn present level of profit

Compute. (i) New BEP (ii) Sales to earn present level of profit (iii) Sales to earn expected profit on proposed investment (iv) Maximum profit potential after tax and plant expansion

  Requirement for hardship distributions

Requirement for hardship distributions

  Establish a section 401(k) plan

Establish a Section 401(k) plan

  Explain why verizon has always had higher debt

Please describe the internet statement "Verizon has always had higher debt than some of its peers. There was some discussion about this inside the industry few years ago when they were deploying their IPTV services (FiOS).

  Computation of implicit interest of the bond

Computation of implicit interest of the bond and Suppose your company needs to raise $10 million by issuing 10-year zero coupon bonds

  Computation of present value of a liability

Computation of present value of a liability and Miner Industries develops an open pit uranium mine

  Computation of net present value

Computation of net present value and what is the NPV of this investment

  Time value of money-future present value

For below time value of money problems, complete by using formulas in Excel on each separate tab. List any assumptions and support each decision made.

  Qualified plan for a small employer

Select a qualified plan for a small employer.

  Statements concerning retirement plan service

Determine statements concerning retirement plan service requirements for qualified plans is NOT correct

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd